performing search on dataset windows from using c#

Question

hi

i need to perform a search on a table in the dataset, my code performs the search for the first time only and diplay the result in couple of text boxes placed on the form, but when i try to repeat the search if does not responding at all and nothing happens,

it does not even got stuck..

my code is

string str_search = "SELECT * FROM EMPDETAILS WHERE EMPID= '" + txtItemSearch.Text + "'";

            da.SelectCommand = new SqlCommand(str_search, conn);
            da.Fill(payRullDataSet, "EmpDetails");
            DataTable dt = payRullDataSet.Tables["EmpDetails"];
            txtID.Text = dt.Rows[0]["EMPID"].ToString();

this is it ..

any ideas can help ?..:)

Kirtan Patel · Answer

Hi Here is What you want tested Working Correctly on my Machine :) .csharpcode .csharpcode pre { font-size: small; color: black; font-family: Consolas Courier New Courier Monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: #006080; } .csharpcode .op { color: #0000c0; } .csharpcode .preproc { color: #cc6633; } .csharpcode .asp { background-color: #ffff00; } .csharpcode .html { color: #800000; } .csharpcode .attr { color: #ff0000; } .csharpcode .alt { background-color: #f4f4f4; width: 100%; margin: 0em; } .csharpcode .lnum { color: #606060; } private void SearchButton_Click( object sender EventArgs e) { SqlConnection con = new SqlConnection( @Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True ); con.Open(); SqlCommand comm = new SqlCommand( Select * from Users where username = ' +textBox1.Text.Trim()+ '  con); SqlDataAdapter da = new SqlDataAdapter(comm); DataSet ds = new DataSet(); da.Fill(ds vtable ); con.Close(); string username = ds.Tables[0].Rows[0][ Username ].ToString(); string password = ds.Tables[0].Rows[0][ Password ].ToString(); txtUsername.Text = username; txtPassword.Text = password; } Happy Coding :)

sayed mahdi · Answer

i need to use the data set to perform the search which suppose to be faster than connecting to the database the other thing i need to use dataadapter instead of data reader  that gives me mor than reading from the table thanks for your try but that wasn't my need :)

Kirtan Patel · Answer

Hi Use DataReader to Perform Search As you want to Search only One Record . private void SearchButton_Click( object sender EventArgs e) { SqlConnection con = new SqlConnection( @Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True ); con.Open(); SqlCommand comm = new SqlCommand( select * from Users where Username = ' + txtSearch.Text.Trim() + ' con); SqlDataReader dr = comm.ExecuteReader(); while (dr.Read()) { txtUsername.Text = dr[ Username ].ToString(); txtPassword.Text = dr[ Password ].ToString(); } dr.Close(); con.Close(); } Happy Coding :)