hi guy i have a problem that i try every way to make Posting search results to textbox but always return nothing this is my code
private void btnNamesearch_Click(object sender, EventArgs e)
{
bool temp = false;
SqlConnection con = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Educational System;Data Source=DREAMS");
con.Open();
SqlCommand cmd = new SqlCommand("SELECT EmpName, ExcutionOrder FROM Employee WHERE EmpName ='" + txtusernameSearch.Text.Trim() + "'", con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
txtemployee.Text = dr["EmpName"].ToString();
txtExcutionOrder.Text = dr["ExcutionOrder"].ToString();
temp = true;
}
if (temp == false)
MessageBox.Show("not found");
con.Close();
dr.Close();
}
its work and when i make breakpoints it gets date but nothing display
and i have another problem that i have got 4 com boxes which fill in form load
suppose when i make search it should display the value of selected from search and this will make problem because it loads with form load ?? plz help really i think more but still need experiences through windows form thanks a lot