C# Code : Implementing MS-ACCESS Database
try
{
OleDbConnection thisConnection = new OleDbConnection(@”Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Hash-Tech\Hash Reminder Setup\Hash Reminder.mdb”);
thisConnection.Open();
OleDbDataAdapter adp = new OleDbDataAdapter(”Select * from ReminderTable”, thisConnection);
OleDbCommandBuilder cmd = new OleDbCommandBuilder(adp);
DataSet ds = new DataSet(”ReminderTable”);
adp.Fill(ds, “ReminderTable”);
DataRow dr = ds.Tables["ReminderTable"].NewRow();
dr["SetDate"] = setdateinp;
dr["SetTime"] = settimeinp;
dr["ReminderType"] = remtypeinp;
dr["ReminderHead"] = remheadinp;
dr["ReminderText"] = remtextinp;
dr["EndDate"] = enddateinp;
dr["EndTime"] = endtimeinp;
dr["Status"] = “Progress”;
ds.Tables["ReminderTable"].Rows.Add(dr);
adp.Update(ds, “ReminderTable”);
thisConnection.Close();
}
catch (Exception z)
{
MessageBox.Show(”Error” + z.ToString(), “Hash Reminder Database Alert.”, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
try
{
OleDbConnection thisConnection = new OleDbConnection(@”Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Hash-Tech\Hash Reminder Setup\Hash Reminder.mdb”);
thisConnection.Open();
OleDbCommand thisCommand = thisConnection.CreateCommand();
thisCommand.CommandText = “UPDATE ReminderTable SET ReminderHead = ‘” + reminderheadingtextBox.Text.ToString() + “‘, ReminderText = ‘” + remindertextBox.Text.ToString() + “‘, EndDate = ‘” + datePicker.Value.ToShortDateString() + “‘ , EndTime = ‘” + TimePicker.Value.ToLongTimeString() + “‘ WHERE ReminderText =’” + remtext + “‘”;
int x = thisCommand.ExecuteNonQuery();
MessageBox.Show(”Reminder has Been Updated.” , ” Hash Reminder Alert”);
thisConnection.Close();
}
catch (Exception z)
{
MessageBox.Show(z.ToString());
}
Close();
}
Just change the SQL Query for insert and delete command
Click here if you need a Website
Leave a Reply