Dropdownlist

Vivek Joy

How can i upload country name from database to dropdownlist using countryid.Here for same Country Name can be more than twice .Therefore how can i do it?

Can anyone help me?

11 Replies

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

Raja T11y ago
Hi, Checkout more details about raddropdownlist

http://demos.telerik.com/aspnet-ajax/dropdownlist/examples/declarativedatasources/defaultcs.aspx
Raja T11y ago
Hi, Are you using telerick please checkout bellow code

In ASPX

UniqueName="packageID" DataField="packageID">

<%# Eval("offername")%>

DataTextField="offername" DataSourceID="SqlDataSource2">

IN Codebehide.CS

SqlDataSource2.SelectCommand = "select offerId,offername from PSP_Proposal_Offers_MST where offerId between 1 and 4";
Vivek Joy11y ago
yes but same error
Upendra Pratap Shahi11y ago
Have you write as like this-

DropDownList1.DataTextField = "Country_Name";//text field
DropDownList1.DataValueField = "Country_ID";//value field
if you don't have write like this then it may give an error.
Vivek Joy11y ago
it's long error.

Error 2 'Telerik.WinControls.UI.RadDropDownList' does not contain a definition for 'datatextfield' and no extension method 'datatextfield' accepting a first argument of type 'Telerik.WinControls.UI.RadDropDownList' could be found (are you missing a using directive or an assembly reference?)
Upendra Pratap Shahi11y ago
What error have you got here?
Do you share here?
Vivek Joy11y ago
hello sir i cannot use DataTextField and DataValueField because it shows error .
Upendra Pratap Shahi11y ago
protected void BindDropDownCountry() {

SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"select Country_ID,Country_Name from Country_master order by Country_Name";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
con.Open();
da.Fill(ds);
con.Close();
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "Country_Name";//text field
DropDownList1.DataValueField = "Country_ID";//value field
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, new ListItem(" --Select-- ", "0"));

}
Vivek Joy11y ago
hi sir i cannot write DataTextField and DataValueField.It shows error.How can i fix it?
Shishu Singh11y ago
hii Vivek,
Use this code to Bind DropDownlist

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select Country_ID,Country_Name from Country_master order by Country_Name";
DataSet objDs = new DataSet();
SqlDataAdapter dAdapter = new SqlDataAdapter();
dAdapter.SelectCommand = cmd;
con.Open();
dAdapter.Fill(objDs);
con.Close();
DropDownList1.DataSource = objDs;
DropDownList1.DataTextField = "Country_Name";
DropDownList1.DataValueField = "Country_ID";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, new ListItem(" --Select-- ", "0"));
}
}
Ravi Kumar11y ago
hi
try the fallowing
select distinct(countryname) from country