SqlDataReader and DataSet

Question

Hi all I have some problem. I have one table and have data over 700 record when i write code for select some data in table it very late for show in textbox. I used SqlDataReader for select it. I don't know how to make it faster. If all of friend know it please tell me about the way for make it faster when select data. send code to me too. Thank

Sam Hobbs · Answer

Are you sure it is the select that is taking time to do? If most of the time is spent opening the database then there is probably not much that can be done to make it faster.

Hirendra Sisodiya · Answer

hello Manath try dataset instead of datareaderyou can use this code sample: SqlConnection Conn = new SqlConnection (ConnectionString); Conn.Open(); string SQLStatement = Query; SqlDataAdapter SQLDataAdapter = new SqlDataAdapter (SQLStatement Conn); DataTable dt = new DataTable (); SQLDataAdapter.Fill(dt); if (dt.Rows.Count > 0) { textBox1.Text = dt.Rows[0][ columnName ].ToString(); } thanks Please mark as answere if it helps