performing search on dataset windows from using c#

sayed mahdi

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 ?..:)

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel17y ago

Hi Here is What you want tested Working Correctly on my Machine :)



 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 mahdi17y ago
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 Patel17y ago

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 :)