dear narav
not working .not shown any value in dropdownlist
could you please change in my jquery code
<script type="text/javascript">
$(function () {
$.ajax({
type: "POST",
url: "bindcategoryvaluetodropdown.aspx/binddatachecklistbox",
data: '{}',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (r) {
var ddlcategory = $("[id*=ddlcategory]");
ddlcategory.empty().append('<option selected="selected" value="0">Please select</option>');
$.each(r.d, function () {
// ddlcategory.append($("<option ></option>").val(this['Value']).html(this['Text']));
$('ddlcategory').val('someval').prop('selected', true);
});
}
});
});
</script>
----------------webmethod--------
[WebMethod]
public static List<ListItem> binddatachecklistbox()
{
string query = "SELECT CategoryId,CategoryName FROM Category ";
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(query))
{
List<ListItem> customers = new List<ListItem>();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
customers.Add(new ListItem
{
Value = sdr["CategoryName"].ToString(),
Text = sdr["CategoryName"].ToString()
});
}
}
con.Close();
return customers;
}
}
}
thank you in advance
