protected void Fetch_Click(object sender, EventArgs e) { string name = txtName.Text; int id = Convert.ToInt32(ddlDocID.SelectedValue); DataSet ds = new DataSet(); if (txtName.Text == "") { ds = doctorObj.getInfoID(id); } else { ds = doctorObj.getInfoNameID(id, name); } if (ds.Tables[0].Rows.Count > 0) { txtName.Text = ds.Tables[0].Rows[0]["name"].ToString(); tbSalary.Text = ds.Tables[0].Rows[0]["Salary"].ToString(); cbxAvailable.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["Available"]); } else { lblMessage.Text = "No match found"; lblMessage.ForeColor = System.Drawing.Color.Red; tbSalary.Text = ""; } }