Asp.Net TextBox

Sathish Pabbathi

13y2.1k.NET

Hi All,

how to save (") Double Quotes,,in Sql Server Database in asp.Net Database through asp.Net TextBox?

Thanx In Advance,

Regards,
Sathish Pababthi

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pankaj Pandey13y ago
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("@str",str);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

and result is

9899454545
9899454545
hello"test
0
Rekha Singh13y ago
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();
0
Sathish Pabbathi13y ago
Hi, Can u Elaborate it plz.. Do I Need to replace " with '\'? plz give little explanation ?
0
Pankaj Pandey13y ago
hello

try this

string str= TextBox1.Text.Replace('"', '\"');

and use str.
0
Sathish Pabbathi13y ago
Hi, Actually My Requirement is to store Double Quotes in SQl Server through textBox
0