Dataset problem while reading excel sheet

Question

1.40/5 (2 votes)

See more:

Hi,

I am reading the data from excel sheet and using OLEDB command to fill the adapter with excel data.

I am using the following code to check whether 3rd column message names are starting with GW or not.

It is working fine. But here I am using Rows in the code for checking columns in excel

foreach (DataRow row in lstDS[0].Tables[0].Rows)<br />
           {<br />
<br />
               string fieldFromDB = row[2].ToString();<br />
               if (fieldFromDB.StartsWith("GW"))

I am confused, Is the dataset stores the values of excel in reverse order(like interchanging of columns and rows)

Now I need to do something like, if the message name in 3rd column starts with GW, then I need to copy the corresponding message ID in 2nd column of the same row

Can anyone please explain me how this can be done.

Thanks
John

Posted 5-Dec-13 4:21am

Member 10408451

Add a Solution

Comments

Sergey Alexandrovich Kryukov 5-Dec-13 12:05pm

You don't show anything filling in any data...
—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Adam Zgagacz · Answer 1 · 2013-12-05T06:59:00

I added some comments to your code and added few lines. Perhaps it will help. If I correctly understand your intention you want to examine every row of the table and copy contents of the third column to the second column if it begins with "GW" string, correct?

foreach (DataRow row in lstDS[0].Tables[0].Rows)
{

string fieldFromDB = row[2].ToString();

//The following line is checking if content of the third column starts with "GW"
if (fieldFromDB.StartsWith("GW"))
{
   //If above condition is 'true', assign value of third column to the second column 
   row[1]=row[2];
}
}

And to answer another part of your question. DataSet doesn’t switch columns with rows.

If your Excel sheet looks like blow you will end up with DataTable containing 3 columns and 2 rows.

Column#1     Column#2  Column #3
abc              def             gh
axx              cc              GWa