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