Dropdownlist

Question

hi 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?

Raja T · Answer

Hi, Checkout more details about raddropdownlist http://demos.telerik.com/aspnet-ajax/dropdownlist/examples/declarativedatasources/defaultcs.aspx

Raja T · Answer

Hi, Are you using telerick please checkout bellow code In ASPX UniqueName="packageID" DataField="packageID"> DataTextField="offername" DataSourceID="SqlDataSource2"> "> IN Codebehide.CS SqlDataSource2.SelectCommand = "select offerId,offername from PSP_Proposal_Offers_MST where offerId between 1 and 4";

Vivek Joy · Answer

yes but same error

Upendra Pratap Shahi · Answer

Have you write as like this- DropDownList1.DataTextField = "Country_Name" ; //text field D ropDownList1.DataValueField = "Country_ID" ; //value field if you don't have write like this then it may give an error.

Vivek Joy · Answer

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 Shahi · Answer

What error have you got here? Do you share here?

Vivek Joy · Answer

hello sir i cannot use DataTextField and DataValueField because it shows error .

Upendra Pratap Shahi · Answer

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 Joy · Answer

hi sir i cannot write DataTextField and DataValueField.It shows error.How can i fix it?

Shishu Singh · Answer

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 Kumar · Answer

hi try the fallowing select distinct(countryname) from country

Dropdownlist

Answers (11)