این کد را برای درج در بانک sql اکسپرس نوشتم ولی نمیدونم چرا در قسمت اینزررت وقتی روی باتن کلیک میکنم ارور میده البته اگه کسی کار با دیتا ست هم تو این درج قرار بده ممنون میشم .


privatevoid button1_Click(object sender, EventArgs e)

{

SqlConnection conn = newSqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=" + Application.StartupPath + "\\Database1.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");

SqlCommand cmd = newSqlCommand();

SqlDataAdapter da = newSqlDataAdapter();

DataTable dt = newDataTable();

DataSet ds =newDataSet();



if (txtfname.Text == "" || txtlname.Text == "" || txtcodozv.Text == "")

{

MessageBox.Show("error");

}

conn.Open(); 

cmd.CommandText = ("INSERT INTO Database1(" + "codeozviat," + "fname," + "lname," + "namepedar," + "tarikhtavalod," + "shomaremeli," + "telephon," + "address," + "tarikhozviat," + "tarikhengheza" + ") VALUSE(" + txtcodozv.Text + "," + txtfname.Text + "," + txtlname.Text + "," + txtnamepedar.Text + "," + mtxttarikhtavalod.Text + "," + Convert.ToInt16(txtmeli.Text) + "," + Convert.ToInt16(txttelephon.Text ) + "," + txtaddress.Text + "," + mtxttarikhozviat.Text + "," + mtxttarikhengheza.Text);

cmd.Connection = conn;

cmd.ExecuteNonQuery();

conn.Close();



}