Update statement in sql server timedout

[dinesh goel]

i m using vb.net2010

am facing a problem in update statement as timeout

the following is the code

if rs.state=1 then rs.close()

rs.open("select abc from xyz where def=1",con,1,3,1)
rs.fields(0).value=1
rs.update

these statements works fine in another portion of the program.

if needed i can send both codes where these are working and where they are not working

[ck9663]

It could be anything. Why not not create an SP, pass the value you need to apply and let the SP update it.

Good Luck!!!


~~ CK