can i use "" in my address textbox?

Hi,

Can you explain your question clear?

Regards,
V. Santhi

Thanks & Regards,
Santhi .V

Rajupatil, if this helps please login to Mark As Answer. | Alert Moderator

HI,
Please explain your Question....
I think, You want like this in the Text Box at Run time.
10,"P.H" Road,

Regards,
Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
http://abaprocker.blogspot.com/

Rajupatil, if this helps please login to Mark As Answer. | Alert Moderator

yes i want same bt i ha error on thse plz give an idea..........

Rajupatil, if this helps please login to Mark As Answer. | Alert Moderator

Hi,
Could you paste your code ?. we will try.

Regards,
Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
http://abaprocker.blogspot.com/

Rajupatil, if this helps please login to Mark As Answer. | Alert Moderator

when i m use singal qote like e.g. 'ramvihar' then error occure Incorrect syntax near 'ramvihar'. tere is no problem of duoble qote...............plz give any idea about hw single qote use...... following query i use to insert record in database.

con.Open();
SqlCommand cmd = new SqlCommand("insert into clientinfo values('" + txtcname.Text + "','" + txtaddress.Text + "','" + txtcperson.Text + "','" + txtmob.Text + "','" + txtcmpyno.Text + "','" + txtdomain.Text + "','"+datet+"','" + datet2 + "','" + datet3 + "','" + datet4 + "','" + txtmaint.Text + "','" + txtmdetails.Text + "','" + txtnote.Text + "','" + DateTime.Now.ToShortDateString() + "','" + datet5 + "','" + datet6 + "','" + datet7 + "')", con);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
con.Close();
lblmesg.Text = "Record Save successfully.......";

Rajupatil, if this helps please login to Mark As Answer. | Alert Moderator

hi..

try to pass these values in parameters.......like @address, @name, @mobile, @domain etc.

If again, error will occur.. then use stored procedure for this.

I think, it will be resolved after passing these textbox values in parameters.

Eg:

SqlCommand cmd = new SqlCommand("insert into clientinfo values(@mobile,@domain)");        cmd.Parameters.AddWithValue("@mobile", txtMobile.Text);

Sourabh07

Rajupatil, if this helps please login to Mark As Answer. | Alert Moderator