update

niki_nilu

in my code i write update query like this string strSqlCmdText; strSqlCmdText = "update tUser1 set Count = "+Convert.ToInt32(txtCount.Text)+" where UserId = '"+txtUserId.Text; objClsDllSql.funSqlCmd(strSqlCmdText); but i have error ie input string is not in correct format. pls i want to update query. pls help me urgently. gayatri Gayatri

SHatchard

strSqlCmdText = "update tUser1 set Count = "+Convert.ToInt32(txtCount.Text)+" where UserId = '"+txtUserId.Text; Change to strSqlCmdText = "update tUser1 set Count = "+Convert.ToInt32(txtCount.Text).ToString+" where UserId = '"+txtUserId.Text; Also, I should note that you are wide open to SQL injection attacks with that particular implementation. More about SQL injection attacks[^]

niki_nilu

hello again same error. pls urgently give me reply Gayatri

SHatchard

Can you put a watch on the sql command being executed and paste it in so i can see what command is being executed on the server?

Nisar Inamdar

:)Hi, Try this one.............. strSqlCmdText = "update tUser1 set Count = Convert.ToInt32 (txtCount.Text.trim().ToString()) where UserId = '"+txtUserId.Text; I think it will run properly............. Nisar Inamdar.

leckey 0

1. Please do not use text speak. 2. Please do not use 'urgent' anywhere in your message. It's urgent for most people.

_____________________________________________ Flea Market! It's just like...it's just like...A MINI-MALL!

peacefulmember

I guess you are missing closing quote for UserID field value, probably a text field. With toString change also try to change WHERE clause from

where UserId = '"+txtUserId.Text

; To

where UserId = '"+txtUserId.Text + "'";

Paul Conrad

Shucks, do you have these "The rules" sitting on the clipboard somewheres :-D

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Paul Conrad

You could do so, but you are open to SQL injection attacks. I'd use parameters instead...

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus