Asp.Net TextBox

Question

Hi All how to save () Double Quotesin Sql Server Database in asp.Net Database through asp.Net TextBox? Thanx In Advance Regards Sathish Pababthi

Pankaj Pandey · Answer

hello you do not need to replace it again see here string str= TextBox1.Text.Replace('' '\'); SqlConnection conn = new SqlConnection(@Server=.\SQL;User Id=sa;Password=abc@123;Initial Catalog=pankaj); SqlCommand cmd=new SqlCommand(insert into table(xyz) values(@str)conn); cmd.Parameters.AddWithValue(@strstr); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); and result is 9899454545 9899454545 hellotest

Rekha Singh · Answer

string db1 = textBox1.Text; string str =  +  + ; SqlConnection conn = new SqlConnection(str); conn.Open(); string insertquery = insert into table(dbfield1) values(@dbfield1); SqlCommand cmd = new SqlCommand(insertquery conn); string value = ; if (db1 != null) { cmd.Parameters.AddWithValue(@dbfield1 db1); } else { cmd.Parameters.AddWithValue(@dbfield1 value); } cmd.ExecuteNonQuery();

Sathish Pabbathi · Answer

Hi Can u Elaborate it plz.. Do I Need to replace  with '\'? plz give little explanation ?

Pankaj Pandey · Answer

hello try this string str= TextBox1.Text.Replace('' '\'); and use str.

Sathish Pabbathi · Answer

Hi Actually My Requirement is to store Double Quotes in SQl Server through textBox