The error tells you everything you need to know.
On Nov 9, 5:39 pm, Dickery1 <[EMAIL PROTECTED]> wrote:
> 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 -- Hide quoted text -
>
> - Show quoted text -
