|
I am wondering how to accomplish the folowing goal using C#.net 2010 as a desktop/console application?
Basically I receive a workbook from my company's main customer to extract data from one of the tabs and load the data into sql server. I am told by my company that the way I obtain the data from the customer is going to stay the way it is and I need to work with the data in that format.
Basically the data comes in one of the middle tabs of the workbook. When I get to the tab I need to work with, I manually have to do the following:
1. unhide some columns,
2. remove links to external files
3. and possibly change the column headers.
Most of the time I just copy the data I need to a new worksheet in a new workbook.
Would you tell me or point me to a reference that will show me how to use a C#.net 2010 to accomplish this goal?
|
|
|
|
|
Does this[^] link help?
/ravi
|
|
|
|
|
I am working on a windows app and I am trying to log information using Trace.Lsitener
This the code I am using in my app.config file:
<trace autoflush="false" indentsize="4">
<listeners >
<add name="myListener" type="System.Diagnostics.TextWriterTraceListener"
initializeData="C:\logFile.txt" />
<remove name="Default" />
</listeners>
</trace>
After installing my .exe file, when I run the app in any Windows 7 system, the logfile.txt gets generated in Desktop by default instead of C drive, unlike the path mentioned in the app.config file. Where as it works absolutely fine in Windows XP machine.
If anyone has faced similar kind of issue, please update me on this as early as possible,
Thanks,
Shouvik
-- modified 21-Mar-12 11:18am.
|
|
|
|
|
Applications running under a normal user-account don't have permission to write to the root of a drive. Why not save the logfile in the same location as the executable?
Bastard Programmer from Hell 
|
|
|
|
|
Eddy Vluggen wrote: Why not save the logfile in the same location as the executable?
Do users have write access to C:\Program Files on Windows 7?!
%appdata%\CompanyName\ProductName is an adequate place for a log file.
|
|
|
|
|
Bernhard Hiller wrote: Do users have write access to C:\Program Files on Windows 7?!
They don't; hence I'd suggest the executable location, usually located in a subfolder of the "program files" folder. The installer can give the user write-rights there - that's not something you usually do with the entire "Program Files" folder. That's under the assumption that this engineer wants his log in a folder that's under his control and always in the same location (which is often a problem for writeable paths in different versions of Windows)
I think that the EventLog would be sufficient for everybody, allowing remote access and the like. Seems some people still prefer a flat text file.
Bastard Programmer from Hell
|
|
|
|
|
Once the exe is provided to the customer, How is someone supposed to track where an user is saving the exe file and how can we dynamically mention the logfile path?
|
|
|
|
|
Member 8429333 wrote: How is someone supposed to track where an user is saving the exe file
The first parameter of your application contains the folder from where it's launched. Alternatively;
Assembly.GetExecutingAssembly().Location
Member 8429333 wrote: and how can we dynamically mention the logfile path?
Prefix the logfile-name with the location that you received from the function mentioned above.
If the app is "installed" into the "Program Files" folder, you'll have a problem again. Why not simply write to the EventLog?
Bastard Programmer from Hell
|
|
|
|
|
Please, I want to design virual tour with c#, but I Not Found not any refrence about progrmming Virtual tour with c#.
help me.
thanks a lot.
|
|
|
|
|
You'll need to provide more in the form of requirements in order for someone to comment. The term "virtual tour" is quite vague.
/ravi
|
|
|
|
|
|
The link you provided is a Java implementation. See this[^] link for a WPF example.
/ravi
|
|
|
|
|
you give me a sample of project with virtual tour wpf that is open source on web.
thanks a lot.
|
|
|
|
|
I assume you know that Silverlight supports a large subset of WPF's functionality? Or were you being sarcastic?
/ravi
|
|
|
|
|
i want to write a virtual tour project with wpf or c# . i no have sarcastic at all.
|
|
|
|
|
Did you read Tao Liang's answer?
/ravi
|
|
|
|
|
|
Read his reply. It explains an approach to the problem. If you have specific questions or run into specific problems, we'd be happy to try and help. But don't expect someone to write your code for you.
/ravi
|
|
|
|
|
i write my code myself.i dislike that someone to write my code.
thanks a lot.
|
|
|
|
|
Try on your own and if you run into any issues post them here.
|
|
|
|
|
a.fateme wrote: help me.
Based on your other replies...
1. Learn basic C# (or java)
2. Learn basic GUI coding.
3. Learn the basics of virtual reality programming.
4. Define the requirements of what you want to create.
5. Learn/research specifics virtual reality based on 3.
6. Learn/reserch specific virtual reality APIs that exist to support 5.
7. Implement something.
Steps 1, 2 and 7 are the only ones that have anything specific to general programming.
Note that if 6 does not turn up a specific API then you are going to need to need to learn more than just a basic understanding of programming language (and GUIs) to write your own.
|
|
|
|
|
Hi
This code here below allows only numbers and one decimal point to be typed on a textbox.
It does not prevent you from:
1. Saving nulls in the database
2. From pasting any other character(words, asterisks,numbers etc) to the textbox.
What do i have to add to the code to prevent the two problems from occurring??
Here is my code:
private void txtBalance_TextChanged(object sender, EventArgs e)
{
txtBalance.KeyPress += new KeyPressEventHandler(numbercheck_KeyPress);
}
private void numbercheck_KeyPress(object sender, KeyPressEventArgs e)
{
if (!char.IsControl(e.KeyChar) && !char.IsDigit(e.KeyChar) && e.KeyChar != '.')
{
e.Handled = true;
}
if (e.KeyChar == '.'
&& (sender as TextBox).Text.IndexOf('.') > -1)
{
e.Handled = true;
}
}
Please help me figure out
Thanks
|
|
|
|
|
First, you don't want to add the KeyPressEventHandler in the in the TextChanged event. Every time this event is fired it will add a new event handler, you only need it added once in your form load or in it method, or declaratively in the markup.
Before saving to the database you should validate the input, KeyPressEventHandler has nothing to do with this.
Failure is not an option; it's the default selection.
|
|
|
|
|
A simple example please?? 
|
|
|
|
|
You need an example of string.IsNullOrEmpty? Or how to validate a string 
if so then you need more help than can be given here.
Failure is not an option; it's the default selection.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
