اريد مساعده

هذا مثــــــــال لكود الحفظ عندي

هل اغير ال insert into

واكتب delet

ولاايش

OleDbConnection zz = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\SONY\\Desktop\\إن شاء الله خير\\Employee1.mdb");

zz.Open();

String ff = "insert into Emp(e_no,e_f_name,e_m_name,e_l_name,d_no,e_cert,e_c_date,e_c_stat,e_nation,e_id,
e_id_loc,e_id_date,e_birthdate,e_hiredate,e_com,e_sal,a_trans,a_comdation,a_exp,e
_sex,e_state,e_emil,e_mobil,e_tel,e_box,e_postal,e_city,e_street,e_alhi) values (" + textBox1.Text + ",'" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text +"'," + comboBox1.Text + ",'" + comboBox2.Text + "'," + textBox9.Text + ",'" + comboBox3.Text + "','" + textBox10.Text + "'," + textBox11.Text + ",'" + textBox12.Text + "'," + textBox13.Text + "," + textBox14.Text + "," + textBox15.Text + "," + textBox16.Text + "," + textBox17.Text + "," + textBox26.Text + "," + textBox27.Text + "," + textBox28.Text + ",'" + comboBox4.Text + "','" + comboBox5.Text + "','" + textBox18.Text + "'," + textBox19.Text + "," + textBox20.Text + "," + textBox21.Text + "," + textBox22.Text + ",'" + textBox23.Text + "','" + textBox24.Text + "','" + textBox25.Text + "')";



OleDbCommand aa = new OleDbCommand(ff, zz);







int h = aa.ExecuteNonQuery();



MessageBox.Show(" تم حـفظ البــيانات");

..................

وكيف طريقة تغير الازره البوتوم

ارجو الرد السريع لاني اشتغل مشروع

:)

السلام عليكــم ورحمـة الله وبركاتــه

OleDbConnection zz = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\SONY\\Desktop\\إن شاء الله خير\\Employee1.mdb");
zz.Open();
لحذف سجل محدد 
string ff = "delete FROM Emp where(اي شرط هنا') "
لحذف كل بيانات الجدول
string ff = "delete FROM Emp"
OleDbCommand aa = new OleDbCommand(ff, zz);
int h = aa.ExecuteNonQuery();
MessageBox.Show(" تم حذف البــيانات");

جزاااااااك الله كل خير

بس باقي كيف تغير ازرة البوتوم :rolleyes:

:cash: