April 25, 2011

To Bind Data in Dropdown in ASP.Net

SqlConnection conDisp = new SqlConnection(ConfigurationManager.ConnectionStrings["MPDB"].ConnectionString);

SqlCommand cmdDisp = new SqlCommand("spGetAllDispositionList", conDisp);
cmdDisp.CommandType = CommandType.StoredProcedure;

SqlDataAdapter daDisp = new SqlDataAdapter(cmdDisp);

DataSet dsDisp = new DataSet();

daDisp.Fill(dsDisp);

ddlPriDisp.DataSource = dsDisp;
ddlPriDisp.DataTextField = "Name";
ddlPriDisp.DataValueField = "DID";
ddlPriDisp.DataBind();

ddlPriDisp.Items.Insert(0, new ListItem("<---Select--->", "-1"));

No comments:

Post a Comment