>Can some one give me the correct syntax for the third line in
>sql2 = "UPDATE TRPSites SET "
>sql2 += "[AWS]= '" + oReader("AWS") + "' "
>sql2 += ",[FlexSched]= '" + oReader("FlexSched").ToString + "' "
>sql2 += "WHERE keyID = " + GridView1.DataKeys(i).Value.ToString()
>Where FlexSched is a boolean field?
>Thanks
You're missing comma before FlexSched.
However, don't do it this way, you're opening yourself to SQL injection attacks. Use parameterized approach instead.
Read carefully this thread
http://forums.asp.net/t/1254125.aspx
If it's not broken, fix it until it is.
My Blog