سلام دوست عزيز كد هاي زير رو امتحان كن
private void SetBindings(DataSet ds)
{
bsCategories.DataSource = ds;
bsCategories.DataMember = "Table1";
bsCategories.ResetBindings(false);
}
private ADODB.Connection CreateConnection()
{
string dsStr;
string dsCn;
ADODB.Connection cn;
cn = new ADODB.Connection();
dsStr = "F:\\myProject\\DataBase\\DB1.mdb";
dsCn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dsStr + ";";
cn.ConnectionString = dsCn;
return cn;
}
private void btnOpen_Click(object sender, EventArgs e)
{
ADODB.Recordset rs;
ADODB.Connection cnADO;
OleDbDataAdapter daTemp;
rs = new ADODB.Recordset();
cnADO = CreateConnection();
daTemp = new OleDbDataAdapter();
cnADO.Open("", "", "", 0);
rs.Open("SELECT * FROM Table1", cnADO,
ADODB.CursorTypeEnum.adOpenForwardOnly, ADODB.LockTypeEnum.adLockReadOnly, 0);
daTemp.Fill(dsCategories.Table1, rs);
cnADO.Close();
SetBindings(dsCategories);
}
واسه ذخيره كردن
private void btnUpdate_Click(object sender, EventArgs e)
{
ADODB.Recordset rsADO;
ADODB.Connection cnADO;
rsADO = new ADODB.Recordset();
cnADO = CreateConnection();
cnADO.Open("", "", "", 0);
rsADO.ActiveConnection = cnADO;
rsADO.Open("Select * From Table1", cnADO,
ADODB.CursorTypeEnum.adOpenDynamic,
ADODB.LockTypeEnum.adLockOptimistic, 0);
rsADO.AddNew(Type.Missing, Type.Missing);
rsADO.Fields["FirstName"].Value = "Test";
rsADO.Fields["LastName"].Value = "Description";
rsADO.Update(Type.Missing, Type.Missing);
MessageBox.Show("Finished", "DataBase Update");
rsADO.Delete(ADODB.AffectEnum.adAffectCurrent);
rsADO.Close();
cnADO.Close();
}