این هم کدها:لبخند:
objconnection.Open();
com.Connection = objconnection;
com.CommandText = "Insert INTO nametbl " +
"(id,name, lname, fname) " +
"VALUES(@id, @name, @lname, @fname);" +
"Insert INTO numtbl " +
"(id, shnum, mnum, birthday) " +
"VALUES(@id, @shnum, @mnum, @birthday);" +
"Insert INTO phonetbl " +
"(id, phonenum, mobilenum) " +
"VALUES(@id, @phonenum, @mobilenum);" +
"Insert INTO informationtbl " +
"(id, job, education, army) " +
"VALUES(@id, @job, @education, @army);" +
"Insert INTO addresstbl " +
"(id, address) " +
"VALUES(@id, @address);" +
"Insert INTO membertbl " +
"(id, dateozv, hozename, paygahname, filenum) " +
"VALUES(@id, @dateozv, @hozename, @paygahname, @filenum);" +
"Insert INTO maintbl " +
"(id, datesave) " +
"VALUES(@id, @nameid, @numid, @phoneid, @informationid, @addressid, @memberid, @codeid, @shandcmid, @frm1id, @frm2id, @datesave)";
com.Parameters.AddWithValue("@id", biyganinum.Text);
com.Parameters.AddWithValue("@name", nametxt.Text);
com.Parameters.AddWithValue("@lname", lnametxt.Text);
com.Parameters.AddWithValue("@fname", fnametxt.Text);
//Insert into NUMTBL
com.Parameters.AddWithValue("@shnum", shnumtxt.Text);
com.Parameters.AddWithValue("@mnum", mnumtxt.Text);
com.Parameters.AddWithValue("@birthday", yearbirthtxt.Text + '/' + monthbirthtxt.Text + '/' + datebirthtxt.Text);
//Insert into phonenum
com.Parameters.AddWithValue("@phonenum", phonenumtxt.Text);
com.Parameters.AddWithValue("@mobilenum", mobilenumtxt.Text);
//Insert into informationtbl
com.Parameters.AddWithValue("@job", jobtxt.Text);
com.Parameters.AddWithValue("@education", educationtxt.Text);
com.Parameters.AddWithValue("@army", armytxt.Text);
//Insert into addresstbl
com.Parameters.AddWithValue("@address", addresstxt.Text);
//Insert into membertbl
com.Parameters.AddWithValue("@dateozv", yearozvtxt.Text + '/' + monthozvtxt.Text + '/' + dateozvtxt.Text);
com.Parameters.AddWithValue("@hozename", hozenametxt.Text);
com.Parameters.AddWithValue("@paygahname", paygahnametxt.Text);
com.Parameters.AddWithValue("@filenum", filenumtxt.Text);
//Insert into membertbl
com.Parameters.AddWithValue("@nameid", biyganinum.Text);
com.Parameters.AddWithValue("@numid", biyganinum.Text);
com.Parameters.AddWithValue("@phoneid", biyganinum.Text);
com.Parameters.AddWithValue("@informationid", biyganinum.Text);
com.Parameters.AddWithValue("@addressid", biyganinum.Text);
com.Parameters.AddWithValue("@memberid", biyganinum.Text);
com.Parameters.AddWithValue("@codeid", biyganinum.Text);
com.Parameters.AddWithValue("@shandcmid", biyganinum.Text);
com.Parameters.AddWithValue("@frm1id", biyganinum.Text);
com.Parameters.AddWithValue("@frm2id", biyganinum.Text);
com.Parameters.AddWithValue("@datesave", labelX1.Text);
try
{
com.ExecuteNonQuery();
MessageBox.Show("اطلاعات با موفقیت ثبت شد.");
nametxt.Clear();
lnametxt.Clear();
fnametxt.Clear();
shnumtxt.Clear();
mnumtxt.Clear();
yearbirthtxt.Clear();
monthbirthtxt.Clear();
datebirthtxt.Clear();
phonenumtxt.Clear();
mobilenumtxt.Clear();
jobtxt.Clear();
addresstxt.Clear();
yearozvtxt.Clear();
monthozvtxt.Clear();
dateozvtxt.Clear();
hozenametxt.Clear();
paygahnametxt.Clear();
filenumtxt.Clear();
biyganinum.Clear();
}
catch (SqlException sqlERR)
{
MessageBox.Show(sqlERR.Message);
}
