C# DataRow from DataTable not reading first value

Question

I'm new to StackOverflow and I have a question here.

When I'm reading my Rows from a DataTable, the first time the result is empty (the app crash) and after if I'm in debug mode, I can see that the first row is read but its too late.

Here is the code.

MySqlDataAdapter da = new MySqlDataAdapter(query, conn);
                DataSet ds = new DataSet();
                da.Fill(ds);
                foreach (DataTable table in ds.Tables)
                {
                    foreach (DataRow myrow in table.Rows)
                    {

                        Number.Text = Convert.ToString(myrow[0]);
                        Text.Text = Convert.ToString(myrow[1]);

What do you mean by "the first time"? What's the exception and which line is throwing it? — devcrp, May 16 '20 at 13:06
Basically it's receiving the first value empty.. I can't have an empty value. — micro75, May 16 '20 at 13:12
After that, I can see that the second value showing up it's supposed to be the first value from the DB. — micro75, May 16 '20 at 13:12
Check your connection string. If Excel are you using HDR = YES/NO — jdweng, May 16 '20 at 13:17
Its a windows form application connecting to mysql database retrieving some data. — micro75, May 16 '20 at 13:20
And sanding it over serial connection to a gsm modem, but if the value is empty is not going to send anything over. — micro75, May 16 '20 at 13:22

score 0 · Answer 1 · answered May 18 '20 at 14:50

0

I changed the query, shoing the same thing but in a fifferent way and now its working.

answered May 18 '20 at 14:50

micro75

1
2

C# DataRow from DataTable not reading first value

1 Answers1