Creating on change function

Question

How to write a on change function selected dropdownlist values and Gridvalue one column

my select Query is string strSQL = "Select a.facreceiptitemid ,a.itemid,a.batchno,to_char(a.mfgdate,'mm/yyyy') as mfgdate,to_char(a.expdate,'mm/yyyy') as expdate,a.MRP,a.SingleUnitPrice,a.marginPercentage,a.sellingprice,a.saletaxid," +

"a.TaxPercentage,a.SaleTaxPercentage,a.SaleTaxType,a.sellingpricesku from tbfacilityreceiptitems a " +

"inner join masitems it on (it.itemid = a.itemid)" +

"inner join masitemcategories cat on (cat.categoryid = it.categoryid)" +

"where cat.categoryid =" + ddlCategory;
Please help..How to write a onchange function for this query

Manoj Bhoir · Answer

Hi You can call your query by adding it in a function and call that function using ajax call. Please check this code snippet you will get some idea. //Server side code public string GetQueryOutput(string param1) { // your query execution part return string.Empty; } //Client side script code $('#ddlCategory').change(function () { $.ajax({ type: POST url: ../GetQueryOutput contentType: application/json; charset=utf-8 dataType: json data: JSON.stringify({ 'param1': $('#ddlCategory').val() }) success: function (data) { // Success } error: function (err) { //Error } }); });

ramya bharath · Answer

1. Create a onchange event for the control 2. Write the function calling ajax script to call the server side function