partial void Deleteold_album_photo_record(old_album_photo_record instance);
partial void Insertold_album_photo_record(old_album_photo_record instance);
partial void Updateold_album_photo_record(old_album_photo_record instance);
private void btn_mysql_record_Click(object sender, EventArgs e) { mysql_connection.Open(); String selectString_count = "SELECT * FROM hkspa.album_view"; MySqlCommand Count_Command = mysql_connection.CreateCommand(); Count_Command.CommandText = selectString_count; MySqlDataReader count_Reader = null; count_Reader = Count_Command.ExecuteReader(); DataTable count_view = new DataTable(); count_view.Load(count_Reader); //find photo from album_view foreach (DataRow count_row in count_view.Rows) { old_album_photo_record insert_new_photo_record = new old_album_photo_record(); insert_new_photo_record.main_categoryName = count_row["main_categoryName"].ToString(); insert_new_photo_record.Cate_FolderName = count_row["Cate_FolderName"].ToString(); insert_new_photo_record.sub_CategoryName = count_row["sub_CategoryName"].ToString(); insert_new_photo_record.Sub_FolderName = count_row["Sub_FolderName"].ToString(); insert_new_photo_record.album_name = count_row["album_name"].ToString(); insert_new_photo_record.Album_FolderName = count_row["Album_FolderName"].ToString(); insert_new_photo_record.AlbumID = Convert.ToInt32(count_row["AlbumID"].ToString()); insert_new_photo_record.FileNo = count_row["FileNo"].ToString(); insert_new_photo_record.fileName = count_row["fileName"].ToString(); insert_new_photo_record.FileCam = count_row["FileCam"].ToString(); insert_new_photo_record.PhotoW = count_row["PhotoW"].ToString(); insert_new_photo_record.PhotoH = count_row["PhotoH"].ToString(); // Add the new object to the Orders collection. HKSPA_ms_db.old_album_photo_records.InsertOnSubmit(insert_new_photo_record); // Submit the change to the database. try { HKSPA_ms_db.SubmitChanges(); } catch (Exception ex) { txt_result.Text += string.Format("Error of {0}. RowID: {1} \r\n", ex.Message.ToString(), rowID); // Make some adjustments. // ... // Try again. HKSPA_ms_db.SubmitChanges(); } } //txt_result.Text += string.Format("{0} \r\n", "Finish insert from mysql."); mysql_connection.Close(); }