Hi all.....
I have created one application In JQgrid which working good....
Bur while testing i enter one record With inserting State name as
'UP&' its get inserted properly.....
But its not displaying in grid....
While Select query its throwing an exception of type
'System.InvalidOperationException'.....
My code for select query is
DataReader sdrState = db.getDR("udsp_SelectState", prmPage, prmLimit, prmSidx, prmSord);
if (sdrState.HasRows)
{
int i = 1,j=0;
xml += "='1.0'='utf-8'<rows>";
while (sdrState.Read())
{
if (i == 1)
{
if (page == 0)
{
page = 1;
}
xml += "<page>" + page + "</page>";// +"<records>" + sdrState["totalRecords"] + "</records>";
i++;
}
//context.Response.Write(ds.Tables[0].Rows[j]["StateName"].ToString()+"<br>");
xml += "<row id='" + sdrState["StateId"] + "'>";
xml += "<cell>" + sdrState["StateName"] + "</cell>";
xml += "<cell>" + sdrState["CountryName"] + "</cell>";
xml += "</row>";
j++;
}
xml += "</rows>";
}
Its throwing an exception in while fetching statename coz state name is like 'UP&'
i dont knw wat is wrong
I will appreciate any help......