Select one row with C# from MySQL?

Question

I tried MySqlDataReader and any variation of mycmd.ExecuteScalar() but still there is no success. At last I am using MySqlDataAdapter and Fill method and use some if cases and select one row from there. but this makes the code uglier. Here is the example:

DataSet tmpDs = new DataSet();
myda.Fill(tmpDs);
if (tmpDs.Tables.Count > 0)
   if (tmpDs.Tables[0].Rows.Count > 0)
      sonuc = tmpDs.Tables[0].Rows[0];

Is there a better way to select one row from MySQL?

Raj More · Accepted Answer · 2009-10-30 17:12:25Z

2

Fill your DS with the following SQL instead of bringing the whole table back.

SELECT * FROM MyTable WHERE SomeKey='3' LIMIT 1

answered Oct 30, 2009 at 17:12

Raj More

48.2k34 gold badges139 silver badges199 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Raj More Over a year ago

Yes it is. The question is about MySQL as well.

cllpse Over a year ago

Aye. I missed that last line :)

ozkanpakdil Over a year ago

I am looking for c# way not sql. but sure that does the job at db side.

Raj More Over a year ago

depending on the table size, it would be highly inefficient to bring the entire table back to c# and then choose the row. The optimum was is to select what you want at the source.

Collectives™ on Stack Overflow

Select one row with C# from MySQL?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related