نوشتن کد جستجو، حذف و اضافه کردن رکورد در بانک

[popo69]

63973
دوستان ببینید دستوراتی که من برای درج در پایگاه استفاده کردم به شکل زیر هست اگه ممکنه برام کد جستجو و حذف و اپدیت رو به این شکل بنویسید و راهنماییم کنید ممنون می شم.
63974

63975

[ahrimaneahurai]

آپدیت

int Affected = 0;
OleDbConnection connection = new OleDbConnection(ConnectionString);
OleDbCommand command = connection.CreateCommand();
command.CommandText = "UPDATE DDB_Tbl_Words SET DDB_Tbl_Words.Word = '" + Word + "',DDB_Tbl_Words.Synonym='" + Synonym + "',DDB_Tbl_Words.Sample='" + Sample + "' WHERE ID=" + ID;

try
{
connection.Open();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("Cann't connect to database\n" + ex.ToString(), "Error!", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
}
try
{
Affected = command.ExecuteNonQuery();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("Cann't Update word \n" + ex.ToString(), "Error!", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
}
connection.Close();
return Affected;

حذف


int Affected = 0;
OleDbConnection connection = new OleDbConnection(ConnectionString);
OleDbCommand command = connection.CreateCommand();
command.CommandText = "DELETE FROM DDB_Tbl_Words where ID=" + ID;

try
{
connection.Open();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("Cann't connect to database\n" + ex.ToString(), "Error!", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
}
try
{
Affected = command.ExecuteNonQuery();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("Cann't Update word \n" + ex.ToString(), "Error!", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
}
connection.Close();
return Affected;

جستجو


string Search = "SELECT ID, Word, Synonym, Sample FROM DDB_Tbl_Words ";
if (Word.Trim() != string.Empty || Synonym.Trim() != string.Empty)
{
Search += " WHERE ";
if (Word.Trim() != string.Empty)
Search += " Word LIKE '" + Word + "'+'%'";

if (Synonym.Trim() != string.Empty)
Search += " Synonym LIKE '%'+'" + Synonym + "'+'%'";
}
OleDbConnection connection = new OleDbConnection(ConnectionString);
OleDbCommand command = connection.CreateCommand();
command.CommandText = Search;
OleDbDataAdapter adapt = new OleDbDataAdapter(command);
DataTable dt = new DataTable();
adapt.Fill(dt);
return dt;

[popo69]

میشه دستورات حذف و درج و جستجو و آپدیت در بانک رو به شکل زیر بزارین؟
ببیندی همون راهی که گفتین ( با استفاده از dataset - oledbAdabpter -oledbConnection و ... که توی toolbox هست ) تورو خدا دستوراتشو به این شکل بنویسید- خسته شدم مخم پوکیید

این دستور درج اطلاعاته :




DataRow dr = bank1DataSet1.Student.NewRow();
dr["S"] = txtsh.Text;
dr["shmeli"] = txtshmeli.Text;
dr["fname"] = txtfname.Text;
dr["lname"] = txtlname.Text;
dr["mozo"] = txtmozo.Text;
dr["maghta"] = cboxmaghta.Text;
dr["reshte"] = cboxreshte.Text;
dr["ostadname"] = cboxostad.Text;
dr["city"] = cboxcity.Text;

string temp1 = cboxtsyear.Text.ToString() + "/" + cboxtsmonth.Text.ToString() + "/" + cboxtsday.Text.ToString();
dr["tarikhs"] = temp1;
string temp2 = cboxttyear.Text.ToString() + "/" + cboxttmonth.Text.ToString() + "/" + cboxttday.Text.ToString();
dr["tarikht"] = temp2;


dr["nomre"] = txtnomre.Text;
dr["address"] = txtaddress.Text;

bank1DataSet1.Student.Rows.Add(dr);
oleDbDataAdapter1.Update(bank1DataSet1);
studentBindingSource.EndEdit();

MessageBox.Show("etelaat sabt shod");