why this code doesnt work?
the error is:Code:string ConStr = "Provider=Microsoft.Jet.OleDB.4.0; Data Source =" + Application.StartupPath + "\\Employee.mdb"; OleDbConnection Conn = new OleDbConnection(ConStr); Conn.Open(); OleDbCommand Cmd = new OleDbCommand("Select * from Employee", Conn); OleDbDataAdapter dAdapter = new OleDbDataAdapter(Cmd); DataSet dDataSet = new DataSet(); dAdapter.Fill(dDataSet, "Employee"); DataRow AddNewRow = dDataSet.Tables["Employee"].NewRow(); AddNewRow["EmployeeID"] = textBox1.Text; AddNewRow["EmployeeName"] = textBox2.Text; dDataSet.Tables["Employee"].Rows.Add(AddNewRow); dAdapter.Update(dDataSet, "Employee"); Conn.Close();
"Update requires a valid InsertCommand when passed DataRow collection with new rows"




Reply With Quote