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();
}
