G
Guest
I want to Store the String value with Single Quotes in the Field of
Database where if i try to Store the String value with Single Quotes
(as it is) then it is throwing the error as SQL String Truncated.
so we need a solution to store and retrieve user Entered value along
with single quotes into the Database.
i am using the String variable to frame the Qry(that is then passed
to Database for execution) which is as follows
StrSql="Insert into tblname values('" & txtfieldname.Text & "')"
for eg. if txtfieldName.text is "Mani's Test"
i want to store "Mani's Test" in the Field of Database
and on the same time i want to retrieve it as same
So let me know if u have any solutions / suggestions
thanks in advance
Database where if i try to Store the String value with Single Quotes
(as it is) then it is throwing the error as SQL String Truncated.
so we need a solution to store and retrieve user Entered value along
with single quotes into the Database.
i am using the String variable to frame the Qry(that is then passed
to Database for execution) which is as follows
StrSql="Insert into tblname values('" & txtfieldname.Text & "')"
for eg. if txtfieldName.text is "Mani's Test"
i want to store "Mani's Test" in the Field of Database
and on the same time i want to retrieve it as same
So let me know if u have any solutions / suggestions
thanks in advance