ok.... im tired... the error is
the error line isCode:"unable to find mapping name or table"tablname"
Code:da.Update(ds, "tblTasks");
using visualstudio.net2003 C#
oledb database 2003
heres the portion of my code i find relavent
Code:private void Page_Load(object sender, System.EventArgs e) { System.Data.OleDb.OleDbConnection odc = new OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;data source=Tasks.mdb"); string sc; sc = "SELECT tblTasks.strTask, tblTasks.memInstructions, tblTasks.dtmDuedate, tblTasks.strContact, tblTasks.strLocation FROM tblTasks"; System.Data.OleDb.OleDbDataAdapter da = new OleDbDataAdapter(sc, odc); System.Data.DataSet ds = new DataSet(); da.Fill(ds, "TblTasks"); DataGrid1.DataSource = ds.Tables["tblTasks"]; DataGrid1.DataBind(); Label1.Text="Unfinished Tasks"; } private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { DataGrid1.EditItemIndex = e.Item.ItemIndex; DataGrid1.DataBind(); } private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { DataGrid1.EditItemIndex = -1; DataGrid1.DataBind(); } private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) {string sc; sc = "SELECT tblTasks.strTask, tblTasks.memInstructions, tblTasks.dtmDuedate, tblTasks.strContact, tblTasks.strLocation FROM tblTasks"; DataSet ds = new DataSet(); System.Data.OleDb.OleDbConnection odc = new OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;data source=Tasks.mdb"); System.Data.OleDb.OleDbDataAdapter da = new OleDbDataAdapter(sc, odc); System.Data.OleDb.OleDbCommandBuilder cb = new OleDbCommandBuilder(); DataGrid1.DataSource = ds.Tables["tblTasks"]; // // TextBox tb, tb2, tb3, tb4, tb5; string strTask, memInstructions, dtmDuedate, strContact, strLocation; //string key = (DataGrid1.DataKeys[e.Item.ItemIndex]); string key is not used yet so it is commented out. tb = ((TextBox)(e.Item.Cells[1].Controls[0])); strTask = tb.Text; tb2 = ((TextBox)(e.Item.Cells[2].Controls[0])); memInstructions = tb2.Text; tb3 = ((TextBox)(e.Item.Cells[3].Controls[0])); dtmDuedate = tb3.Text; tb4 = ((TextBox)(e.Item.Cells[4].Controls[0])); strContact = tb4.Text; tb5 = ((TextBox)(e.Item.Cells[5].Controls[0])); strLocation = tb5.Text; da.Update(ds, "tblTasks"); DataGrid1.EditItemIndex = -1; DataGrid1.DataBind(); } }





Reply With Quote