SibGeth

25-Apr-09 13:22

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 )

Re: 4 bits Array

fly90425-Apr-09 12:33

fly904

25-Apr-09 12:33

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!

Re: [Message Deleted]

Christian Graus25-Apr-09 22:59

How to handle null values when reading array

25-Apr-09 22:59

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 ?

onetreeup25-Apr-09 10:23

onetreeup

25-Apr-09 10:23

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?

Christian Graus25-Apr-09 11:27

25-Apr-09 11:27

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.

onetreeup25-Apr-09 12:47

onetreeup

25-Apr-09 12:47

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. Cry | :((

Christian Graus25-Apr-09 13:24

25-Apr-09 13:24

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.

Luc Pattyn25-Apr-09 13:08

25-Apr-09 13:08

impossible to answer: you hardly described the input and didn't say a thing about the output.
explain more, AND give some examples.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in

Cannot read .xls file - microsoft jet database engine could not find the object error

Sibugathulla25-Apr-09 17:52

Sibugathulla

25-Apr-09 17:52

Please Don't Worry You can Solve NullException problem Using one of the two methods Smile | :)

.

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]);

SibGeth

Something Different™
www.SibGeth.net

dariusUK25-Apr-09 10:15

Re: Cannot read .xls file - microsoft jet database engine could not find the object error

25-Apr-09 10:15

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:

//opens file and fills the DataGridView with data from file
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();

//clears data table and dataGridView before creating a new one
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,

Luc Pattyn25-Apr-09 10:29

Re: Cannot read .xls file - microsoft jet database engine could not find the object error

25-Apr-09 10:29

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?

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in

dariusUK26-Apr-09 7:15

Re: Cannot read .xls file - microsoft jet database engine could not find the object error

26-Apr-09 7:15

Hi,

1. No, just one file is being opened at the time
2. No, I'm not closing the connection Smile | :)

I am a newbie, so I'm just learning Smile | :)

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

Luc Pattyn26-Apr-09 11:07

Re: Cannot read .xls file - microsoft jet database engine could not find the object error

26-Apr-09 11:07

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:\ ).

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in

dariusUK27-Apr-09 11:11

Re: Cannot read .xls file - microsoft jet database engine could not find the object error

27-Apr-09 11:11

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 Smile | :)

I hope now I answered your question Smile | :)

In your trial have you used your own code?

Cheers, Darius

dariusUK27-Apr-09 11:25

Re: Cannot read .xls file - microsoft jet database engine could not find the object error

27-Apr-09 11:25

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

dariusUK27-Apr-09 11:29

Re: Cannot read .xls file - microsoft jet database engine could not find the object error

27-Apr-09 11:29

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

Luc Pattyn27-Apr-09 11:51

Re: Cannot read .xls file - microsoft jet database engine could not find the object error

27-Apr-09 11:51

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.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in

dariusUK28-Apr-09 10:59

setting height and width of controls in form

28-Apr-09 10:59

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

mist_psycho25-Apr-09 6:34

mist_psycho

25-Apr-09 6:34

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------

Re: setting height and width of controls in form

fly90425-Apr-09 7:01

fly904

25-Apr-09 7:01

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!

Re: setting height and width of controls in form

Luc Pattyn25-Apr-09 7:07

How to make a program like Paint with C#

25-Apr-09 7:07

A second grade astronaut might consider a TableLayoutPanel, I haven't used it so far.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in

MohammedMahmoud25-Apr-09 6:06

MohammedMahmoud

25-Apr-09 6:06

hi everyone iam a C# programmer iam not profrssional

i want to make a program like MS paint , i will use C#

i need this program

i tried to make but when i draw any thing on the picture box all what i drawed cleared when i move the form

please reply me

thanks
Mohammed Mahmoud

Re: How to make a program like Paint with C#

Luc Pattyn25-Apr-09 6:23