C#

<br />
		// Database Variables<br />
		private string connectionStr = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=""C:\data.mdb"";Jet OLEDB:Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";<br />
		private string selectStr = "Select id, date, day, time, comments, timeout, status, process from data";<br />
<br />
		private System.Data.DataSet myDataSet;<br />
		private System.Data.OleDb.OleDbConnection myConnection;<br />
		private System.Data.OleDb.OleDbDataAdapter myDataAdapter;<br />
		private System.Data.OleDb.OleDbCommandBuilder myCmdBuilder;<br />
		<br />
		private System.Data.OleDb.OleDbCommand mySelectCmd;<br />
<br />
		public Schedule()<br />
		{          <br />
			this.InitilizeDb();<br />
			this.PopulateDataSet();<br />
		}<br />
<br />
		private OleDbConnection ConnectDb()<br />
		{<br />
			return new OleDbConnection(connectionStr);<br />
		}<br />
<br />
		public void InitilizeDb()<br />
		{<br />
			myDataAdapter = new OleDbDataAdapter();<br />
			myCmdBuilder = new OleDbCommandBuilder(myDataAdapter);<br />
			myDataSet = new DataSet();<br />
		}<br />
<br />
		private void PopulateDataSet()<br />
		{<br />
			// get the connection object<br />
			myConnection = (OleDbConnection) this.ConnectDb();<br />
<br />
			// Initilize the Select Command<br />
			mySelectCmd = new OleDbCommand(selectStr, myConnection);<br />
<br />
			// Define that the Select Command is an SQL statement<br />
			mySelectCmd.CommandType = CommandType.Text;<br />
<br />
			try<br />
			{<br />
				myConnection.Open();<br />
<br />
				myDataAdapter.SelectCommand = mySelectCmd;<br />
<br />
				// Populate the DataSet from the "data" table<br />
				myDataAdapter.Fill(myDataSet,"data");<br />
			}<br />
			finally<br />
			{<br />
				myConnection.Close();<br />
			}<br />
		}<br />
<br />
		public string InsertSchedule(string date, string day, string time, string process,<br />
			string comments, string timeout, string status)<br />
		{<br />
			// get the connection object<br />
			myConnection = (OleDbConnection) this.ConnectDb();<br />
<br />
			try<br />
			{<br />
				myConnection.Open();<br />
<br />
				// create a new row to insert the data into<br />
				DataRow newRow = myDataSet.Tables["data"].NewRow();<br />
<br />
				// initilize the new row<br />
				newRow["id"] = 3;<br />
				newRow["date"] = date;<br />
				newRow["day"] = day;<br />
				newRow["time"] = time;<br />
				newRow["process"] = process;<br />
				newRow["comments"] = comments;<br />
				newRow["timeout"] = timeout;<br />
				newRow["status"] = status;<br />
<br />
				// add the new row into the dataset<br />
				myDataSet.Tables["data"].Rows.Add(newRow);<br />
<br />
				myDataAdapter.Update(myDataSet, "data");<br />
<br />
				return "true";<br />
			}<br />
			catch(Exception e)<br />
			{<br />
				return e.Message + "\n\n" + e.StackTrace + "\n\n" + e.InnerException;<br />
			}<br />
			finally<br />
			{<br />
				myConnection.Close();<br />
			}<br />
		}<br />

Syntax error in INSERT INTO statement.<br />
<br />
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)<br />
   at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)<br />
   at ShutdownMgr.Schedule.InsertSchedule(String date, String day, String time, String process, String comments, String timeout, String status) in c:\documents and settings\azel\my documents\visual studio projects\shutdownmgr\schedule.cs:line 99<br />