i have problems here. i have two textbox: textbox1 and textbox2 : Order and Buyer. i want to make if user type order in textbox1 and they click enter or using mouse click, the buyer based on order will appear in textbox2. how to achieve this in asp.net webpage using c# ? because it does not have keypress or something that i want to write code. i dont want to use any button because i have any other requirements must enter before click button submit. just those two textbox ? someone help ?
protected void TextBoxJO_TextChanged(object sender, EventArgs e)
{
DataTable dt=new DataTable();
query = "select cusfname from mescomm..CustomerLib a, mestrans..JobOrder_HD b where a.cuscode = b.customer_cd and po_no ='" + TextBoxJO.Text + "'";
cmd = new SqlCommand(query);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
TextBoxBuyer.Text = reader["cusfname"].ToString();
reader.Close();
con.Close();
}
}