Sir, I have an id named Docket no. When it Enter the Docketno the details in that table corresponding to that table comes to the textBox. Suppose , I have To get the entry in 5 text boxes. in the 5 textbox it will again get an id from where it will fill 2 text boxes.This should be done without Button.I have Done this Using Buttons
I will Be happy If this can be done using Java Script.
Thanks If Some One helps me with Code
protected void Page_Load(object sender, EventArgs e)
{
{
String DocketNo = Docket_No.Text;
String Branch= From_STN.Text;
String Date = Date_Time.Text;
SqlConnection conn;
SqlCommand comm;
SqlDataReader reader;
string connnectionString = ConfigurationManager.ConnectionStrings["amitpandeyConnectionString"].ConnectionString;
conn = new SqlConnection(connnectionString);
if (Docket_No.Text == "") // IF match the scan ID
{
comm = new SqlCommand(@"SELECT Branch,Date,DocketNo Where Branch = @Branch and Date =@date and DocketNo = @DocketNo", conn);
}
conn.Open();
comm.Parameters.AddWithValue("@Branch", To_STN.Text);
comm.Parameters.AddWithValue("@date", Date_Time.Text);
comm.Parameters.AddWithValue(" @DocketNo", Docket_No.Text);
reader = comm.ExecuteReader();
reader.Close();
conn.Close();
}
}