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
Loading
Sam HobbsPosted Apr 12, 2010, 2:11 PM
Hirendra SisodiyaPosted Apr 12, 2010, 7:11 AM
try dataset instead of datareader,you 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