How to bind database data to DropdownList inside Repeater

Greetings mates,

This is my first time here. Please take it easy on me.

I have been trying for the past two days to try to bind a data from the database to DropDownList in Repeater control but no luck so far.

I have the following:

private void SetInitialRow2(string registerNumber, string bregisterNumber)
{
DataTable dt;
if (ViewState["CurrentTable"] == null)
{
dt = new DataTable();
DataRow dr = null;
//Create DataTable columns
dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));
dt.Columns.Add(new DataColumn("PrevOnwerName", typeof(string)));
dt.Columns.Add(new DataColumn("prevAddr", typeof(string)));
dt.Columns.Add(new DataColumn("prevCity", typeof(string)));
dt.Columns.Add(new DataColumn("PrevState", typeof(string)));
dt.Columns.Add(new DataColumn("prevzip", typeof(string)));
//Create Row for each columns
dr = dt.NewRow();
dr["RowNumber"] = 1;
dr["PrevOnwerName"] = string.Empty;
dr["prevAddr"] = string.Empty;
dr["prevCity"] = string.Empty;
dr["PrevState"] = string.Empty;
dr["prevzip"] = string.Empty;
dt.Rows.Add(dr);
}
else
{
dt = (DataTable)ViewState["CurrentTable"];
}
//Store the DataTable in ViewState for future reference
ViewState["CurrentTable"] = dt;
if (dt.Rows.Count > 0)
{
//Bind the Repeater with the DataTable
Repeater2.DataSource = dt;
Repeater2.DataBind();
}
}

Then I have a stored procedure that pulls these records from the database.

The SP is called like this:

private void getRecs(int pin)
{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("sp_AllRecs", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p1 = new SqlParameter("@pin", pin);
cmd.Parameters.Add(p1);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dtPrevRecs = new DataTable();
sda.Fill(dtPrevRecs);
if (dtPrevRecs.Rows.Count > 0)
{
Repeater2.DataSource = dtPrevRecs;
Repeater2.DataBind();
ViewState["CurrentTable"] = dtPrevRecs;
}
}

I am also populating State DropDownList with the following:

con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());
string sSQL = "Select sID,sName from states ORDER By sName ASC";
// Response.Write(sSQL);
//Response.End();
SqlCommand cmd3 = new SqlCommand(sSQL, con);
con.Open();
cstable = new DataTable();
able.Load(cmd3.ExecuteReader());

Finally, my markup:

"ddlPrevState" cssClass="disabledcss" runat="server" AppendDataBoundItems="True">
"" Selected="True">

My question is when a user enters an account number, all records associated with that account populates the repeater form except the State dropdownlist.

Any ideas how to bind the data to the State dropdownlist?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Puneet Kankar9y ago
try this type of code
// aspx code


"form1" runat="server">


        "Repeater1" runat="server">

            "myLiteral" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Column1") %>'>
            "DropDownList1" runat="server" DataSource='<%# FilterDropDownData((string)DataBinder.Eval(Container.DataItem, "Column1")) %>' DataTextField="Column2">
// aspx.cs code
public partial class _Default : System.Web.UI.Page
{
DataTable myRepeaterData;
DataTable myDropDownData;
protected void Page_Load(object sender, EventArgs e)
{
myDropDownData = PopulateDropDownData();
myRepeaterData = PopulateRepeaterData();
Repeater1.DataSource = myRepeaterData;
Repeater1.DataBind();
}
public DataTable PopulateRepeaterData()
{
DataTable myTable = new DataTable();
DataRow myRow;
myTable.Columns.Add("Column1", typeof(String));
myRow = myTable.NewRow();
myRow["Column1"] = "Value11";
myTable.Rows.Add(myRow);
myRow = myTable.NewRow();
myRow["Column1"] = "Value12";
myTable.Rows.Add(myRow);
return myTable;
}
public DataView FilterDropDownData(string id)
{
DataView myView = new DataView(myDropDownData);
myView.RowFilter = "Column1 = '" + id + "'";
return myView;
}
public DataTable PopulateDropDownData()
{
DataTable myTable = new DataTable();
DataRow myRow;
myTable.Columns.Add("Column1", typeof(String));
myTable.Columns.Add("Column2", typeof(String));
myRow = myTable.NewRow();
myRow["Column1"] = "Value11";
myRow["Column2"] = "Value1111";
myTable.Rows.Add(myRow);
myRow = myTable.NewRow();
myRow["Column1"] = "Value11";
myRow["Column2"] = "Value1112";
myTable.Rows.Add(myRow);
myRow = myTable.NewRow();
myRow["Column1"] = "Value12";
myRow["Column2"] = "Value1211";
myTable.Rows.Add(myRow);
myRow = myTable.NewRow();
myRow["Column1"] = "Value12";
myRow["Column2"] = "Value1212";
myTable.Rows.Add(myRow);
return myTable;
}
}