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";
}