将DataGrid数据存放到MYSQL中

注意：DataGrid中数据序号从0开始，MYSQL数据表序号从1开始

            string connStr2 = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;

            using (MySqlConnection connect2 = new MySqlConnection(connStr2))
            {
                int m = Convert.ToInt32(flute_num.Text);

                connect2.Open();

                string[] cell_data = new string[m];

                for (int i=0;i<m;i++)
                {
                    cell_data[i]=(dg_EE.Columns[1].GetCellContent(dg_EE.Items[i]) as TextBlock).Text;

                    MySqlCommand cmd2 = new MySqlCommand("update flute_divideangle set divideAngle=@divideAngle where flute_divideAngleID= "+(i+1), connect2);

                    cmd2.Parameters.AddWithValue("@divideAngle", cell_data[i]);

                    cmd2.ExecuteNonQuery();

                }
                
                connect2.Close();

            }