Problem In Inserting Data To SQL Server

Hi,

Just look at my Code:protected void Button1_Click(object sender, EventArgs e)

{SqlConnection Conn = new SqlConnection("MyConnectionString");

SqlCommand Cmd = new SqlCommand();string linktext,headline, quote, para1, para2, para3;

linktext = this.TextBox1.Text;headline = this.TextBox1.Text;

quote = this.TextBox2.Text;para1 = this.TextBox3.Text;

para2 = this.TextBox4.Text;para3 = this.TextBox5.Text;Cmd.CommandText = "insert into desieyenews(linktext,newsheadline,quote,para1,para2,para3) values ("+linktext+","+headline+","+quote+","+para1+","+para2+","+para3+")";

Cmd.Connection = Conn;

Conn.Open();

Cmd.ExecuteNonQuery();

Conn.Close();

 

}

 

Details: In the above code I am inserting data from 5 textbox to my databse. It works fine but when I am trying to insert text like Tom's..., problem occurs. Whenever I am trying to insert some text with a single quote, the problem arises. Although the datatype of my database is text in MS SQL Server 2005.

Please give me some solution so that I can get rid of this problem....

Thanks in advance.

 

Tapas