hai everyone,

       while i am adding a username with single quote "'" from a Form in asp.net page to the database it fails. can anyone suggest the best possible way to insert it in to the databse and get it from database to the asp.net page.

thanks in advance
Madhu

__________________
Regards,
P.Madhusudhana Rao

These characters will cause your SQL statement to crash: ' and , so call the replace function.

Dim strName as string = "Kevin O'Grady"
strName = strName.Replace("'","''")
strName = strName.Replace(",", "',") 'With the above string this does nothing
INSERT INTO Logins(Name) VALUES('" & strName &"')

"The one language all programmers understand is profanity."

hai dparsons,

    i am very thankfull to u as u have given the right and good sugesstion which had worked.

Madhu

Glad I could help.

"The one language all programmers understand is profanity."