>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