Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
purushotham216
Starting Member
14 Posts |
 Posted - 2008-05-09 : 06:22:34
|
| hi to all ,thanks in advance i want to execute this query at run time.. int i = 1; SqlCommand cmd = new SqlCommand("update dbcheck set st[i]='False' where bid='A0001' ", sqlCon); sqlCon.Open(); cmd.ExecuteNonQuery(); sqlCon.Close();it is giving error ...this query means update status=false where bid ='A0001' |
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
Posted - 2008-05-09 : 08:47:21
|
| What's the error? What's the name of the status column? What version of SQL? 2000 or 2005?Ryan Randall Solutions are easy. Understanding the problem, now, that's the hard part. |
 |
|
|
ayamas
Aged Yak Warrior
552 Posts |
Posted - 2008-05-09 : 10:13:20
|
| Why you want to use an inline query in a page?Thumb rule never ever use inline query. |
|
|
|
|
|
|
updation