Creating on change function

aravinth kandasamy

11y1.2k

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

2 Replies

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

Manoj Bhoir11y ago
Accepted 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 bharath11y ago
1. Create a onchange event for the control
2. Write the function calling ajax script to call the server side function