public void Populate() { SqlCommand cmd = new SqlCommand("SELECT * FROM Questions", new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString)); cmd.Connection.Open(); SqlCommand cmd2 = new SqlCommand("SELECT Question FROM Questions", new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString)); SqlDataReader ddlValues; ddlValues = cmd.ExecuteReader(); cmd2.Connection.Open(); Question.Text = cmd2.ExecuteScalar().ToString(); cmd2.Connection.Close(); DDL1.DataSource = ddlValues; DDL1.DataValueField = "A1"; DDL1.DataTextField = "A2"; DDL1.DataBind(); cmd.Connection.Close(); cmd.Connection.Dispose(); }
protected void FillLBField() { DataTable dts1 = selectdynamic(" select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + DDLLiceTableName.SelectedItem.Text + "'"); DDL1.DataSource = dts1; DDL1.DataValueField = "column_name"; DDL1.DataTextField = "column_name"; DDL1.DataBind(); DDL1.Items.Insert(0, "--Select--"); DDL1.Items[0].Value = "0"; DDL2.DataSource = dts1; DDL2.DataValueField = "column_name"; DDL2.DataTextField = "column_name"; DDL2.DataBind(); DDL2.Items.Insert(0, "--Select--"); DDL2.Items[0].Value = "0"; DDL3.DataSource = dts1; DDL3.DataValueField = "column_name"; DDL3.DataTextField = "column_name"; DDL3.DataBind(); DDL3.Items.Insert(0, "--Select--"); DDL3.Items[0].Value = "0"; DDL4.DataSource = dts1; DDL4.DataValueField = "column_name"; DDL4.DataTextField = "column_name"; DDL4.DataBind(); DDL4.Items.Insert(0, "--Select--"); DDL4.Items[0].Value = "0"; DDLNotCopied.DataSource = dts1; DDLNotCopied.DataValueField = "column_name"; DDLNotCopied.DataTextField = "column_name"; DDLNotCopied.DataBind(); DDLNotCopied.Items.Insert(0, "--Select--"); DDLNotCopied.Items[0].Value = "0"; }