Bind different column values of dataset table to a dropdownlist in asp.net
private void fill_cardDropDown()
{
OleDbDataAdapter Oda3 = new OleDbDataAdapter();
DataSet ds3 = new DataSet();
Oda3.Fill(ds3, rsPaymentTerm, "MyTable");
while (rowCount < ds3.Tables[0].Rows.Count)
{
if (ds3.Tables[0].Rows[rowCount]["SERVICE"].ToString() != "")
{
val1 = ds3.Tables[0].Rows[rowCount]["SERVICE"].ToString();
}
else
{
val1 = "0" + "*" + ds3.Tables[0].Rows[rowCount]["REAL_TIME"].ToString() + "*";
}
string val3 = ds3.Tables[0].Rows[rowCount]["PT_TYPE"].ToString() + "*" + ds3.Tables[0].Rows[rowCount]["METHOD_CODE"].ToString() + "*" + ds3.Tables[0].Rows[rowCount]["TERM_TYPE"].ToString() + "*" + ds3.Tables[0].Rows[rowCount]["ORDER_TERM_CODE"].ToString() + "*0*0*0*0*0*0*0" + ds3.Tables[0].Rows[rowCount]["SHIPPAGE_TERM_DESC"].ToString();
//ddl_payUsing.DataTextField=ds3.Tables[0].Columns["PT_TYPE"].ToString() + "*" + ds3.Tables[0].Columns["METHOD_CODE"].ToString() + "*" + ds3.Tables[0].Columns["TERM_TYPE"].ToString() + "*" + ds3.Tables[0].Columns["ORDER_TERM_CODE"].ToString()+"*0*0*0*0*0*0*0"+ds3.Tables[0].Columns["SHIPPAGE_TERM_DESC"].ToString();
ddl_payUsing.Items.Add(new ListItem(ds3.Tables[0].Rows[rowCount]["SHIPPAGE_TERM_DESC"].ToString(), val3));
rowCount++;
}
}
}
0 comments:
Post a Comment