کل کدی که اجرا میشه بعد از زدن یک دکمه است:
OleDbConnection aaa = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0 ;Data Source=|DataDirectory|\\Office_Assistant.accdb");
OleDbCommand command = new OleDbCommand();
command.Connection = aaa;
int Engineer_File_NO = 5;
int Engineer_Base = 5;
string Engineer_Field = "aa";
string Engineer_Name = "qqqq";
string Engineer_Family = "qqqqq";
int Engineer_Phone = 9;
int Engineer_BankAccount = 9;
string sql = "INSERT INTO engineers(Engineer_File_NO, Engineer_Base,Engineer_Field,Engineer_Name,Enginee r_Family,Engineer_Phone, Engineer_BankAccount)" +
" values ({0},{1},'{2}','{3}','{4}',{5},{6})";
sql = string.Format(sql,
Engineer_File_NO, Engineer_Base, Engineer_Field, Engineer_Name, Engineer_Family, Engineer_Phone, Engineer_BankAccount);
command.CommandText = sql;
aaa.Open();
command.ExecuteNonQuery();
aaa.Close();
این تغییرات بعد از یک بار زدن دکمه ی دیگه توی گریدویو نشون داده میشن. ولی روی دیتا بیس اعمال نمیشن.
کد کلید دوم:
OleDbConnection aaa = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0 ;Data Source=|DataDirectory|\\Office_Assistant.accdb");
aaa.Open();
string query = "select * from Engineers";
OleDbCommand command = new OleDbCommand();
command.CommandText = query;
command.Connection = aaa;
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = command;
DataTable objDataTable = new DataTable();
adapter.Fill(objDataTable);
aaa.Close();
dataGridView1.DataSource = objDataTable;
اینم عکس دیتابیس:
Capture.JPG