public void fillDLL_QualificationV1() { string str = "select qualificationId,qualificationName from UserQualification"; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(str, con); da.Fill(ds); DDDLQualificationV1.DataSource = ds; DDDLQualificationV1.DataTextField = "qualificationName"; DDDLQualificationV1.DataValueField = "qualificationId"; DDDLQualificationV1.DataBind(); DDDLQualificationV1.Items.Add("Custom"); DDDLQualificationV1.Items.Insert(0, new ListItem("--Select--", "0")); }
public void txtChangeV1(DropDownList ddl, TextBox tx) { string str1 = "insert into UserQualification(qualificationName)values('" + DDDLQualification.SelectedValue + "')"; int row1 = cc.ExecuteNonQuery(str1); string str2 = "select qualificationId,qualificationName from UserQualification "; ds = cc.ExecuteDataset(str2); DDDLQualificationV1.DataSource = ds; DDDLQualificationV1.DataTextField = "qualificationName"; DDDLQualificationV1.DataValueField = "qualificationId"; DDDLQualificationV1.DataBind(); DDDLQualificationV1.Items.Add("Custom"); DDDLQualificationV1.Items.Insert(0, new ListItem("--Select--", "0")); }