hello i want to bind dropdown using ajax jquery but it is not working , when my function is called it is hitting my web method but data is not shown in drop down. plz help me
see my code :
public static ClsCountry[] BindCountry()
{
string con = ConfigurationSettings.AppSettings["connectionstring"];
DataSet ds = new DataSet();
using (SqlConnection cont = new SqlConnection(con))
{
using (SqlCommand cmd = new SqlCommand("usp_FetchCountry", cont))
{
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(ds);
}
}
}
DataTable dt1 = ds.Tables[0];
List details = new List();
foreach (DataRow dr in dt1.Rows)
{
ClsCountry Obj = new ClsCountry();
Obj.CountryID = Convert.ToInt32(dr["CountryId"]);
Obj.CountryName = dr["CountryName"].ToString();
details.Add(Obj);
}
return details.ToArray();
}
Manav PandyaPosted Jun 7, 2018, 2:30 AM