Posted on: 1/9/2014 9:37:58 AM | Views : 655

hello
i am having a problem 
this is my web method
[System.Web.Services.WebMethod]
protected void LoadCompanies() { SqlConnection xConnection; xConnection = MyConn.getCon(); xConnection.Open(); SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM Company WHERE (ISNULL('" + DDLCompany.SelectedValue + "','')='' OR CID = '" + DDLCompany.SelectedValue + "')", xConnection); DataTable dt = new DataTable(); adapter.Fill(dt); string selectedCity = Request.Form.Get("city_id");
selectedCity.DataTextField = "CName"; selectedCity.DataValueField = "CID"; selectedCity.DataSource = dt; selectedCity.DataBind(); }
i ...

Go to the complete details ...