hi..I use sqlserver2005 as backend in my C# application i write following query

[Surajrepe7]

"insert into stud_Exam_Record(PRN,Roll_no,First_name,Last_Name, UN1_Total,UN2_Total,Final_total,Final_Outof,Percen tage)values('" + textBox1.Text + "','" + textBox2.Text + "'," + textBox3.Text + "," + textBox4.Text + ",'" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox8.Text + "','" + textBox9.Text + "') ";
but i face error "The name "fsdgf" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted." data type of First_name is ntext ,please help me

[Rabbit]

You need to enclose all text fields in single quotes. For some reason, you do it for all your fields except first and last name. So it's obvious you know you have to do so, but you probably just missed those two.