now i get another error.
Exception caught.System.InvalidOperationException: Update requires a
valid InsertCommand when passed DataRow collection with new rows.
not sure what is wrong now.
On Nov 9, 3:30 am, Cerebrus <[EMAIL PROTECTED]> wrote:
> Most common ADO.NET error of all time :
>
> - Remove the line that calls AcceptChanges on the DataTable.
>
> Another Tip: You don't need to manually open and close connections
> when using a DataAdapter.
>
> On Nov 9, 7:00 am, Dickery1 <[EMAIL PROTECTED]> wrote:
>
>
>
> > i dont know why this code is not saving the data that i am trying to
> > insert. appreciate any help
> > MySqlConnection myConnection = new MySqlConnection(CONN);
> > MySqlDataAdapter myDataAdapter = new
> > MySqlDataAdapter(QUERY, myConnection);
> > DataTable dt = new DataTable();
>
> > //Open connection
> > myConnection.Open();
>
> > try
> > {
> > //Fill dataset
> > myDataAdapter.Fill(dt);
>
> > //Close connection
> > myConnection.Close();
> > DataTable dtPortfolios = dt;
> > DataRow newRow = dtPortfolios.NewRow();
> > newRow["symbol"] = "errwerew";
> > newRow["quantity"] = 2;
> > newRow["cost"] = 4;
> > newRow["created_at"] = DateTime.Now;
> > dtPortfolios.Rows.Add(newRow);
> > dtPortfolios.AcceptChanges();
> > myDataAdapter.Update(dt);
>
> > }
> > catch (Exception ex)
> > {
>
> > //Close connection
> > myConnection.Close();
>
> > throw ex;
>
> > }- Hide quoted text -
>
> - Show quoted text -
