Hi ,
i'm using access database with asp.net - and i wrote query that worked excellent - it inserted/updated text in textbox - but when i insert in the text the following character :
'
Then this throws exception - and i understand the reason for it (because the last character closes statement and it gets error) - but i don't know how to solve it . Anybody has some ideas?

use this code in Vb.NET
***********************

strSQL = "Insert Into TableName VALUES('" & txt1.Text.Replace("'","''") & "')"

cmd.ExecuteNonQuery(strSQL)

i hope this will ur problem

Ashu

Solve*