|
did you read my Question well,I doubt
what this means:
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
!!!!!!
Mohammed Ibrahim
|
|
|
|
|
Mohamed Ibrahim Omar wrote: what this means:
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
!!!!!!
Do you mean that you don't understand what it actually means or don't understand that it's his signiture?
Either way it's the funniest thing I've read all day!
My failometer is detecting vast quantities of FAIL!
|
|
|
|
|
Mohamed Ibrahim Omar wrote: what this means:
It means that you are not very good at English. Perhaps this is why your questions are confusing, and you don't get the answers you want.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
you always (Christian Graus)give me bad answer
Mohammed Ibrahim
modified on Saturday, April 25, 2009 6:17 PM
|
|
|
|
|
Your question is kind of stupid. You want to make a byte equal to four bits ? You can't. There's no type that is four bits.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Mohamed Ibrahim Omar wrote: byte[]
And you wonder why it's a byte?
Not sure if this will help or not but have a look at BitArray[^]
My failometer is detecting vast quantities of FAIL!
|
|
|
|
|
Seriously, everyone here wants to help you, you should try to make your question more clear, not delete it. I wasn't being insulting, if English is not your first language, that's not meant as an insult, but, if we can't understand what you mean, we can't help, that's all I was trying to say. Provide more detail and perhaps when we can better understand your need, we can offer better help ?
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
I have an array that I am converting values from. It is a comma delimited file, and has some null values in it. While I am reading the file to convert, how can I handle the null values?
|
|
|
|
|
with code ? I don't see what the question is. If you are writing code to convert values, can't you check for null first ? It's up to you if you skip a null, or insert a default value in it's place.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
I apologize if my question seemed stupid. I am looking for assistance with the code, which is why I am in the C# message board.
|
|
|
|
|
If you posted some code, then perhaps we could assist you with your code. As it stands, we're struggling to understand what the hell you're talking about. If you have null values coming in ( we don't even know where from ), then you can check for them, surely ? Perhaps not, in your situation, but you've not come close to making that clear.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
impossible to answer: you hardly described the input and didn't say a thing about the output.
explain more, AND give some examples.
|
|
|
|
|
Please Don't Worry You can Solve NullException problem Using one of the two methods .
1) If you create Your own Array Please Initalize it.
List<String> strArray= new List<String>();
strArray.Add("Code Project");
Here new List<String>(); is important
2) If you get the list from any where else You can check for null as follows
if(strArray != null)
if(strArray.Count >0)
MessageBox.Show(strArray[0]);
|
|
|
|
|
Hi there,
I'm trying to read .xls file using OleDb connection. I have two .xls files generated from SAP (actually these are Unicode text files saved as .xls) with two different names. When I execute my code I can only open one file, the second one gives an error:
System.Data.OleDb.OleDbException: The Microsoft Jet database engine could not find the object 'sheetName$'. Make sure the object exists and that you spell its name and the path name correctly.
Both files contains only one sheet which has the same name as the file itself. I've checked the spelling several times and even changed it manually but it doesn't work on one file. Even when I saved the file as proper Excel file. Here's the code I'm using:
string fileNameWithExt;
string fileNameWithoutExt;
int fileNameLength = 0;
int cutExtension = 4;
fileNameWithExt = openFileDialog1.SafeFileName;
fileNameLength = fileNameWithExt.Length;
fileNameWithoutExt = fileNameWithExt.Remove(fileNameLength - cutExtension);
OleDbConnection aConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\" + fileNameWithExt + ";Extended Properties=Excel 8.0");
aConnection.Open();
DataTable sampleDataTable = new DataTable();
dataGridView1.DataSource = null;
sampleDataTable.Clear();
sampleDataTable.Columns.Clear();
OleDbDataAdapter oleDbCommand = new OleDbDataAdapter("Select * from ["+fileNameWithoutExt+"$]", aConnection);
oleDbCommand.Fill(sampleDataTable);
I hope somebody can point me in the right direction as I checked plenty of posts and know that something is wrong with the sheet name but can find the issue.
Regards,
|
|
|
|
|
some questions:
1. are you having both xls files open at the same time?
2. are you closing aConnection when done with each file?
3. what is the full and exact content of fileNameWithExt in both cases?
4. in exactly which line does the exception occur?
|
|
|
|
|
Hi,
1. No, just one file is being opened at the time
2. No, I'm not closing the connection I am a newbie, so I'm just learning but I think it's not the case as when I run my code for the first time and trying to open the "failing" file it can't be opened anyway
3. Full content of the fileNameWithExt contains a file name with extension i.e. someXlsFile.xls. As you can see in the code it use openFileDialog property SafeFileName:
fileNameWithExt = openFileDialog1.SafeFileName;
My files names are: wipasianew.xls (can be opened) and wipasia.xls (cannot be opened)
4. Exception occurs in this line:
oleDbCommand.Fill(sampleDataTable);
Hope you'll have any ideas. Thanks, Darius
|
|
|
|
|
Hi,
my guess is you have a problem in path names, as I already hinted at in 3. what is the full and exact content of fileNameWithExt in both cases? which you did not answer accurately.
I ran a successful test with a full file spec in the connection string (and no constant C:\ ).
|
|
|
|
|
Hi Luc,
I have copied the file which I'm able to open to several locations on my hard drive (like c drive, my documents etc.) and the program opened the file without any problems, however fileNameWithExt uses openFileDialog SafeFileName property which doesn't contain the path I hope now I answered your question
In your trial have you used your own code?
Cheers, Darius
|
|
|
|
|
Hi again,
I just changed the code and tried it. But now I'm getting an exception "System.Data.OleDb.OleDbException: External table is not in the expected format". It's in the line which opens an OleDb connection.
Could you please advise on this one?
Regards, D
|
|
|
|
|
It's me again. I think the problem is that my files are Unicode text with .xls extension. Is there any way to open such files?
Darius
|
|
|
|
|
Hi,
1.
if you reply to yourself, you get an e-mail notification and I don't.
2.
who would be so smart as to create text files with .xls extension?
those cannot be opened by database code at all.
assuming you have Excel installed, if double-clicking fails, so will your app.
|
|
|
|
|
Hi,
1. Ok, didn't know
2. As I've written in my first post these are files generated by SAP application. I'm trying to automate what I'm doing at my job by my application that's why I want to use those. Actually Excel recognizes these files and opens them normally, but when you trying to save the file then you are asked whether you want to save the file as Unicode text (but with .xls extension) and then you get a message that some features may not be supported. Such files can be opened in OpenOffice as well as I tried it.
Any advice?
Regards, Darius
|
|
|
|
|
I have a windows form. I set the "window state" property to "maximize". But in this form i have 2 controls: a picture box and a windows media player tool. They are placed side by side.
How can i set the height and width of the picture box tool and windows media player tool, so tat their size (width and height)is 1/2 the size of the form, after the form is maximized....
plz help------
|
|
|
|
|
Ever thought of working for NASA? Because this is ground breaking stuff.
Here's a little hint:
this.pictureBox1.Width = this.ClientSize.Width / 2;
and
this.Resize += new EventHandler(ResizeForm);<br />
private void ResizeForm(object obj, EventArgs e)
My failometer is detecting vast quantities of FAIL!
|
|
|
|
|
A second grade astronaut might consider a TableLayoutPanel, I haven't used it so far.
|
|
|
|