Insertion of Data From form to database in window app

[EDN Admin]

Dear
I create a form with 13 text bax and a date time picker .
i use sql data base in back end .
i would like to code a insertion in data base table name "newuser".
My code is as follow
<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small
private

<span style="font-size:small <span style="font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small void<span style="font-size:small <span style="font-size:small
button1_Click(<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small object<span style="font-size:small <span style="font-size:small sender,
<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small EventArgs<span style="font-size:small <span style="font-size:small e)<span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small
{


<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small SqlConnection<span style="font-size:small <span style="font-size:small con =
<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small new<span style="font-size:small <span style="font-size:small
<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small SqlConnection<span style="font-size:small <span style="font-size:small (<span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small "provider=microsoft.jet.oledb.12.0;Data
Source=DITS-PC;Initial Catalog=sms;Persist Security Info=True;User ID=sa"<span style="font-size:small <span style="font-size:small );<span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small
con.Open();


<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small String<span style="font-size:small <span style="font-size:small s =
<span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small " insert into newuser (Fname,Mname,Lname,gender,Mobile1,mobile2,address1,address2,address3,state,country,email1,email2,dob)
values ("<span style="font-size:small <span style="font-size:small + textBox1.Text +
<span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small ","<span style="font-size:small <span style="font-size:small + textBox2.Text
+ <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small ","<span style="font-size:small <span style="font-size:small +
textBox3.Text + <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small ","<span style="font-size:small <span style="font-size:small
+ textBox4.Text + <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small ","<span style="font-size:small <span style="font-size:small
+ textBox5.Text + <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small ","<span style="font-size:small <span style="font-size:small
+ textBox6.Text + <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small ","<span style="font-size:small <span style="font-size:small
+ textBox7.Text + <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small ","<span style="font-size:small <span style="font-size:small
+ textBox8.Text + <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small ","<span style="font-size:small <span style="font-size:small
+ textBox9.Text + <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small ","<span style="font-size:small <span style="font-size:small
+ textBox10.Text + <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small ","<span style="font-size:small <span style="font-size:small
+ textBox11.Text + <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small ","<span style="font-size:small <span style="font-size:small
+ textBox12.Text + <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small ","<span style="font-size:small <span style="font-size:small
+ textBox13.Text + <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small ","<span style="font-size:small <span style="font-size:small
+ textBox14.Text + <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small ")"<span style="font-size:small <span style="font-size:small ;<span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small


<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small SqlCommand<span style="font-size:small <span style="font-size:small cmd =
<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small new<span style="font-size:small <span style="font-size:small
<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small SqlCommand<span style="font-size:small <span style="font-size:small (s, con);<span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small
cmd.ExecuteNonQuery();
}











<a>
<
Shubham

View the full article