dropdownlist and database

Ramya S

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

4 Replies

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

Karthik Elumalai10y ago
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 Singh10y ago
check below this may give you little help
jQuery Ajax Cascaded DropdownList in Asp.net MVC Using C#.Net
Ramya S10y ago
Hi,
can i write code in asp.net,coz i have not idea on Ajax.
Vasanth Natarajan10y ago
Use the Ajax Webmethod and write the update code in *.cs page