Exception of type System.InvalidOperationException

See more:

SQL-Server

SQL-Server-2008

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 += "<?xml version='1.0' encoding='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......