How to insert datas with comma in sql ???
-
hi, i have multi line text(ie..address) for example, insert into Db(address) values('" + txtaddress.text + "') this address contain :- Mr.Krish, NH Road, India. its show error in comma operator. so How to insert datas with comma operator ??? plz give solution for this..
Yours, KaNNaN ----------------------------------------------------------------- "Success is When Ur Signature Becomes An Autograph" Mail To : foreverkans@gmail.com
-
hi, i have multi line text(ie..address) for example, insert into Db(address) values('" + txtaddress.text + "') this address contain :- Mr.Krish, NH Road, India. its show error in comma operator. so How to insert datas with comma operator ??? plz give solution for this..
Yours, KaNNaN ----------------------------------------------------------------- "Success is When Ur Signature Becomes An Autograph" Mail To : foreverkans@gmail.com
user insert quary in stored procedure or use the insert command following like this ; cmd.Parameters.AddWithValue("@RegFirstAddress", txtFirstAddress.Text); cmd.CommandText = "insert into Tbl_Registration(RegFirstAddress) values (@RegFirstAddress)"; cmd.ExecuteNonQuery();