dropdownlist and database

Question

I have two dropdownlists  which interrelated with one other and i have one text box which have to update quantity based on two dropdownlists,Here i wrote binding code js in aspx page how to write update code in aspx.cs

Karthik Elumalai · Answer

Hi Ramya, yeah can write in Asp.net itself as a webservice like the below webmethod: [WebMethod] public CascadingDropDownNameValue[] BindCountry(string knownCategoryValues, string category) { DataSet ds = new DataSet(); conn.Open(); SqlCommand cmd = new SqlCommand("select * from SelectCountry", conn); SqlDataAdapter adp = new SqlDataAdapter(cmd); cmd.ExecuteNonQuery(); adp.Fill(ds); conn.Close(); List CountryDetails = new List (); foreach (DataRow DR in ds.Tables[0].Rows) { string CountryID = DR["CountryId"].ToString(); string CountryName = DR["County"].ToString(); CountryDetails.Add(new CascadingDropDownNameValue(CountryName, CountryID)); } return CountryDetails.ToArray(); } kindly let me know if it was useful thanks karthik

Vinay Singh · Answer

check below this may give you little help jQuery Ajax Cascaded DropdownList in Asp.net MVC Using C#.Net

Ramya S · Answer

Hi, can i write code in asp.net,coz i have not idea on Ajax.

Vasanth Natarajan · Answer

Use the Ajax Webmethod and write the update code in *.cs page

dropdownlist and database

Answers (4)