I would like to bind the value returned from a SQL Query to a Text Box:
protected void cmbPujaName_SelectedIndexChanged(object sender, EventArgs e)
{
string pujaselectedid = null;
pujaselectedid = cmbPujaName.DataValueField;
SqlConnection con2 = null;
con2 = new SqlConnection(ConfigurationManager.ConnectionStrings["SRKBSDB"].ConnectionString);
SqlDataAdapter pamt = new SqlDataAdapter("select Amount from PoojaDietyMaster where PoojaDietyMasterID =" + cmbPujaName.DataValueField, con2);
DataSet pamtds= new DataSet();
pamt.Fill(pamtds);
//cmbPujaName.DataSource = pamtds;
txtAmount.Text= pamtds -- Not sure what to add here
txtAmount.DataBind();
}
Please help
SqlCommand c = new SqlCommand("select Amount from PoojaDietyMaster where PoojaDietyMasterID =" + cmbPujaName.DataValueField,con2);Since you are just getting one value. Theres no need to load it to a Datatabledouble c1 = (double)c.ExecuteScalar();
txtAmount.Text = c1.ToString();