I need help using SQL Update command in an ASP.NET web application. I am using sql server2000. please tell me the correct syntax for it. secondly, i want to use a data grid.to display data. can anyone refer me to a sample code?? :)
I need help using SQL Update command in an ASP.NET web application. I am using sql server2000. please tell me the correct syntax for it. secondly, i want to use a data grid.to display data. can anyone refer me to a sample code?? :)
An update sql query normally looks like this: UPDATE tableName SET variable2String = 'newvalue', variable5Int = 10 WHERE MyIdentifier = 23 This will update record with id 23 with the two variables stated above.
