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;

            }


Reply via email to