private void FormProduct_Load(object sender, EventArgs e)
{
string conn_str = "Server=.;Database=MiniMart;Integrated Security=true;";
SqlConnection conn = new SqlConnection(conn_str);
cate_adapter = new CategoryTableAdapter();
cate_adapter.Connection = conn;
cate_adapter.Fill(invent.Category);
unit_adapter = new UnitTypeTableAdapter();
unit_adapter.Connection = conn;
unit_adapter.Fill(invent.UnitType);
pro_adapter = new ProductTableAdapter();
pro_adapter.Connection = conn;
pro_adapter.Fill(invent.Product);
//bind to controls
cboCategory.DisplayMember = invent.Category.NameColumn.ColumnName;
cboCategory.ValueMember = invent.Category.IDColumn.ColumnName;
cboCategory.DataSource = invent.Category;
cboUnitType.DisplayMember = invent.UnitType.NameColumn.ColumnName;
cboUnitType.ValueMember = invent.UnitType.IDColumn.ColumnName;
cboUnitType.DataSource = invent.UnitType;
dataGridView1.DataSource = invent.Product;
(dataGridView1.Columns[invent.Product.ImageColumn.ColumnName] as DataGridViewImageColumn).ImageLayout = DataGridViewImageCellLayout.Zoom;
lblTotal.Text = "Total: " + invent.Product.Rows.Count.ToString();
}
private void btnCatsFromLocal_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
string connectionPrefix = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
string client = new Uri(dmc.origUrl).Host;
string filename = client + ".mdb";
string app_data = Path.GetDirectoryName(Application.ExecutablePath) + @"\App_data\";
string dest = app_data + filename;
if (!File.Exists(dest))
{
MessageBox.Show("Cannot find data file");
return;
}
string connection = connectionPrefix + dest;
using (CategoryTableAdapter catsda = new CategoryTableAdapter())
{
catsda.SetConnection(new OleDbConnection(connection));
LocalCats.CategoryDataTable cats = new LocalCats.CategoryDataTable();
catsda.Fill(cats);
catsGrid.DataSource = cats;
}
Cursor.Current = Cursors.Default;
return;
}
private void CategoryDetailForm_Load(object sender, EventArgs e)
{
try
{
LocalizedCategoryNameTableAdapter localizedCategoryNameAdapter = new LocalizedCategoryNameTableAdapter();
localizedCategoryNameAdapter.Fill(this.categoryDetailDataSet.LocalizedCategoryName, categoryId, cultureName);
if (categoryId > 0)
{
CategoryTableAdapter categoryAdapter = new CategoryTableAdapter();
categoryAdapter.Fill(this.categoryDetailDataSet.Category, categoryId);
}
byte[] image = this.categoryDetailDataSet.Category.Rows[0]["Image"] as byte[];
if (image != null)
{
this.pictureBoxImage.Image = ImageEngine.Resize(ImageEngine.FromArray(image), this.pictureBoxImage.Size);
}
EnableButtons();
}
catch (Exception ex)
{
ReportError(ex.Message.ToString());
this.DialogResult = DialogResult.Abort;
this.Close();
}
}
public void DataViewDemo()
{
DataSet1.CategoryDataTable Category = new DataSet1.CategoryDataTable();
CategoryTableAdapter catAdap = new CategoryTableAdapter();
catAdap.Fill(Category);
DataSet1.ProductsDataTable Products = new DataSet1.ProductsDataTable();
ProductsTableAdapter prodAdap = new ProductsTableAdapter();
prodAdap.Fill(Products);
var result = from item in Products
select item;
DataView view = result.AsDataView();
view.Sort = "ProductName desc";
view.RowFilter = "CategoryID = 65985";
GridView7.DataSource = view;
GridView7.DataBind();
DataSet1.ProductsRow row = null;
List <DataSet1.ProductsRow> myList = new List <DataSet1.ProductsRow>();
foreach (DataRowView item in view)
{
row = (DataSet1.ProductsRow)item.Row;
myList.Add(row);
}
GridView8.DataSource = myList;
GridView8.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet1.CategoryDataTable Category = new DataSet1.CategoryDataTable();
CategoryTableAdapter catAdap = new CategoryTableAdapter();
DataSet1.ProductsDataTable Products = new DataSet1.ProductsDataTable();
ProductsTableAdapter prodAdap = new ProductsTableAdapter();
catAdap.Fill(Category);
prodAdap.Fill(Products);
var result = from item in Products
select item;
DataTable queriedProducts = result.CopyToDataTable <DataSet1.ProductsRow>();
queriedProducts.TableName = "queriedProducts";
DataSet1 ds = new DataSet1();
ds.Tables.Add(queriedProducts);
//DataView view = result.AsDataView<DataSet1.ProductsRow>();
//view.RowFilter = "CategoryID = 65985";
GridView1.DataSource = ds.Tables["queriedProducts"];
GridView1.DataBind();
}
private void FillList()
{
tableDialogs.TableModel.Rows.Clear();
CategoryTableAdapter kategorieTableAdapter = new CategoryTableAdapter(dataBase);
CategoryDataSet ds = new CategoryDataSet();
kategorieTableAdapter.Fill(ds.Category);
// Zuerst der Standard-Dialog
string[] newRow = new string[2];
newRow[0] = "<" + StringTable.Default + ">";
newRow[1] = HasDialog(0) ? StringTable.Yes : StringTable.No;
XPTable.Models.Row newTableRow = new XPTable.Models.Row(newRow);
newTableRow.Tag = null;
tableDialogs.TableModel.Rows.Add(newTableRow);
foreach (CategoryDataSet.CategoryRow row in ds.Category.Rows)
{
newRow[0] = row.Name;
newRow[1] = HasDialog(row.CategoryID) ? StringTable.Yes : StringTable.No;
newTableRow = new XPTable.Models.Row(newRow);
newTableRow.Tag = row;
tableDialogs.TableModel.Rows.Add(newTableRow);
}
}
// this class is used to create objects from the data in the database, using the dataset
private DatabaseController()
{
this.DataSet = new KantoorInrichtingDataSet();
this.TableAdapterManager = new KantoorInrichtingDataSetTableAdapters.TableAdapterManager();
this.CategoryTableAdapter = new KantoorInrichtingDataSetTableAdapters.categoryTableAdapter();
this.ProductTableAdapter = new KantoorInrichtingDataSetTableAdapters.productTableAdapter();
this.PlacementTableAdapter = new KantoorInrichtingDataSetTableAdapters.placementTableAdapter();
this.RoleTableAdapter = new KantoorInrichtingDataSetTableAdapters.roleTableAdapter();
this.SpaceTableAdapter = new KantoorInrichtingDataSetTableAdapters.spaceTableAdapter();
this.StaticPlacementTableAdapter = new KantoorInrichtingDataSetTableAdapters.static_placementTableAdapter();
this.StaticProductTableAdapter = new KantoorInrichtingDataSetTableAdapters.static_productTableAdapter();
this.UserTableAdapter = new KantoorInrichtingDataSetTableAdapters.userTableAdapter();
CategoryTableAdapter.Fill(DataSet.category);
ProductTableAdapter.Fill(DataSet.product);
PlacementTableAdapter.Fill(DataSet.placement);
RoleTableAdapter.Fill(DataSet.role);
SpaceTableAdapter.Fill(DataSet.space);
StaticPlacementTableAdapter.Fill(DataSet.static_placement);
StaticProductTableAdapter.Fill(DataSet.static_product);
UserTableAdapter.Fill(DataSet.user);
GetCategories_FromDatabase();
GetProducts_FromDatabase();
GetStaticProducts_FromDatabase();
GetSpaces_FromDatabase();
}
private void FormSaveDialog_Load(object sender, EventArgs e)
{
CategoryTableAdapter kategorieTableAdapter = new CategoryTableAdapter(dataBase);
CategoryDataSet ds = new CategoryDataSet();
kategorieTableAdapter.Fill(ds.Category);
foreach (CategoryDataSet.CategoryRow row in ds.Category.Rows)
{
listBoxCategories.Items.Add(new ListBoxItem(row.CategoryID, row.Name));
}
}
private void Form1_Load(object sender, EventArgs e)
{
BalanceTableAdapter.Fill(stockDataSet.Остатки);
TaxingTableAdapter.Fill(stockDataSet.Таксировка);
TaxTableAdapter.Fill(stockDataSet.Налоги);
BankTableAdapter.Fill(stockDataSet.Банк);
OrganizationTableAdapter.Fill(stockDataSet.Организация);
InvoiceTableAdapter.Fill(stockDataSet.Накладные);
MoveProductTableAdapter.Fill(stockDataSet.Движение_товара);
DivisionsTableAdapter.Fill(stockDataSet.Подразделения);
ProductTableAdapter.Fill(stockDataSet.Товар);
CategoryTableAdapter.Fill(stockDataSet.Категории_товара);
}
private void FormSale_Load(object sender, EventArgs e)
{
txtCashier.Text = $"{Program.StaffID} : {Program.KHName} : {Program.ENGName}";
//Customer
CustomerTableAdapter cust_adpater = new CustomerTableAdapter();
cust_adpater.Connection = Program.Connection;
cust_adpater.Fill(dataset.Customer);
cboCustomer.DisplayMember = "Name";
cboCustomer.ValueMember = "ID";
cboCustomer.DataSource = dataset.Customer;
cboCustomer.SelectedIndex = -1;
//Category
CategoryTableAdapter cate_adapter = new CategoryTableAdapter();
cate_adapter.Connection = Program.Connection;
cate_adapter.Fill(dataset.Category);
foreach (var cate in dataset.Category)
{
Button btnCategory = new Button();
btnCategory.Text = cate.Name;
btnCategory.Tag = cate.ID;
btnCategory.Width = flowLayoutPanel_Category.Width;
btnCategory.Height = 30;
btnCategory.Click += BtnCategory_Click;
flowLayoutPanel_Category.Controls.Add(btnCategory);
}
//
dataGridView_Purchasing_Items.DataSource = dataset.PurchasingItems;
dataGridView_Purchasing_Items.Columns[0].Visible = false;//ProductID
//add
DataGridViewImageColumn plus = new DataGridViewImageColumn();
//plus.HeaderText = "";
plus.ImageLayout = DataGridViewImageCellLayout.Zoom;
plus.Image = Properties.Resources.Plus_32px;
DataGridViewImageColumn delete = new DataGridViewImageColumn();
//delete.HeaderText = "";
delete.ImageLayout = DataGridViewImageCellLayout.Zoom;
delete.Image = Properties.Resources.Cancel_16px1;
dataGridView_Purchasing_Items.Columns.Add(plus);
dataGridView_Purchasing_Items.Columns.Add(delete);
}
/*public StateReport resultReport;
*
* public enum StateReport
* {
* Close,
* GoReport
* }*/
private void ReportDataForm_Load(object sender, EventArgs e)
{
// TODO: данная строка кода позволяет загрузить данные в таблицу "stockDataSet.Отчет_накладные". При необходимости она может быть перемещена или удалена.
this.WaybillReportTableAdapter.Fill(this.stockDataSet.Отчет_накладные);
// TODO: данная строка кода позволяет загрузить данные в таблицу "stockDataSet.Накладные". При необходимости она может быть перемещена или удалена.
this.WaybillTableAdapter.Fill(this.stockDataSet.Накладные);
// TODO: данная строка кода позволяет загрузить данные в таблицу "stockDataSet.Отчет_остатки_товаров". При необходимости она может быть перемещена или удалена.
this.BalanceReportTableAdapter.Fill(this.stockDataSet.Отчет_остатки_товаров);
TrafficReportTableAdapter.Fill(stockDataSet.Отчет_по_движению_товаров);
ListOrganizationsTableAdapter.Fill(stockDataSet.Организации_поставившие_товар);
TOOTableAdapter.Fill(stockDataSet.ТОО_поставившая_товар);
DivisionsTableAdapter.Fill(stockDataSet.Подразделения);
ShippedTableAdapter.Fill(stockDataSet.Отгруженные_товары);
WealthTableAdapter.Fill(stockDataSet.Материальные_ценности);
ListProductsTableAdapter.Fill(stockDataSet.Пречень_товаров);
CategoryTableAdapter.Fill(stockDataSet.Категории_товара);
}
public void StronglyTypedDataSet()
{
DataSet1.CategoryDataTable CategoryDT = new DataSet1.CategoryDataTable();
CategoryTableAdapter CategoryTBAdapter = new CategoryTableAdapter();
DataSet1.ProductsDataTable ProductsDT = new DataSet1.ProductsDataTable();
ProductsTableAdapter ProductsTBAdapter = new ProductsTableAdapter();
CategoryTBAdapter.Fill(CategoryDT);
ProductsTBAdapter.Fill(ProductsDT);
var result = from cat in CategoryDT
join prod in ProductsDT
on cat.CategoryID equals prod.CategoryID
where cat.CategoryID == 65985
select new { CategoryName = cat.CategoryName, ProductName = prod.ProductName, UnitPrice = prod.UnitPrice };
GridView6.DataSource = result;
GridView6.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet1.CategoryDataTable Category = new DataSet1.CategoryDataTable();
CategoryTableAdapter catAdap = new CategoryTableAdapter();
DataSet1.ProductsDataTable Products = new DataSet1.ProductsDataTable();
ProductsTableAdapter prodAdap = new ProductsTableAdapter();
catAdap.Fill(Category);
prodAdap.Fill(Products);
var result = from item in Products
select item;
DataTable queriedProducts = result.CopyToDataTable<DataSet1.ProductsRow>();
queriedProducts.TableName = "queriedProducts";
DataSet1 ds = new DataSet1();
ds.Tables.Add(queriedProducts);
//DataView view = result.AsDataView<DataSet1.ProductsRow>();
//view.RowFilter = "CategoryID = 65985";
GridView1.DataSource = ds.Tables["queriedProducts"];
GridView1.DataBind();
}
private void Convert()
{
string sql;
formConvertProgress.MaximumValue = 15;
formConvertProgress.CurrentTable = "Master";
ConvertMasterTable();
#region CD
formConvertProgress.CurrentTable = "CD";
formConvertProgress.Value++;
List <FieldConvert> fieldsCD = new List <FieldConvert>();
fieldsCD.Add(new FieldConvert("IDCD", "CDID"));
fieldsCD.Add(new FieldConvert("dwGesamtlaenge", "Length"));
fieldsCD.Add(new FieldConvert("cAnzahlLieder", "NumberOfTracks"));
fieldsCD.Add(new FieldConvert("bCDSampler", "IsSampler"));
fieldsCD.Add(new FieldConvert("wNummerImSet", "SetNumber"));
fieldsCD.Add(new FieldConvert("IDCDSet", "SetID"));
fieldsCD.Add(new FieldConvert("IDArtist", "ArtistID"));
fieldsCD.Add(new FieldConvert("IDKategorie", "CategoryID"));
fieldsCD.Add(new FieldConvert("IDMedium", "MediumID"));
fieldsCD.Add(new FieldConvert("szTitel", "Title"));
fieldsCD.Add(new FieldConvert("szDatum", "Date"));
fieldsCD.Add(new FieldConvert("szArchivNummer", "ArchiveNumber"));
fieldsCD.Add(new FieldConvert("szPfadBitmap", "FrontCover"));
fieldsCD.Add(new FieldConvert("szKennzeichen", "Codes"));
fieldsCD.Add(new FieldConvert("szKommentar", "Comment"));
fieldsCD.Add(new FieldConvert("szFeld1", "User1"));
fieldsCD.Add(new FieldConvert("szFeld2", "User2"));
fieldsCD.Add(new FieldConvert("szFeld3", "User3"));
fieldsCD.Add(new FieldConvert("szFeld4", "User4"));
fieldsCD.Add(new FieldConvert("szFeld5", "User5"));
fieldsCD.Add(new FieldConvert("C_Type", "Type"));
fieldsCD.Add(new FieldConvert("C_YearRecorded", "YearRecorded"));
fieldsCD.Add(new FieldConvert("C_Copyright", "Copyright"));
fieldsCD.Add(new FieldConvert("C_BackCoverBitmap", "BackCover"));
fieldsCD.Add(new FieldConvert("C_CDLabelBitmap", "CDLabelCover"));
fieldsCD.Add(new FieldConvert("C_Rating", "Rating"));
fieldsCD.Add(new FieldConvert("C_Label", "Label"));
fieldsCD.Add(new FieldConvert("C_URL", "URL"));
fieldsCD.Add(new FieldConvert("C_Price", "Price"));
fieldsCD.Add(new FieldConvert("C_UPC", "UPC"));
fieldsCD.Add(new FieldConvert("C_Original", "IsOriginal"));
fieldsCD.Add(new FieldConvert("C_IDComposer", "ComposerID"));
fieldsCD.Add(new FieldConvert("C_Location", "Location"));
fieldsCD.Add(new FieldConvert("C_Language", "Language"));
CDTableAdapter cdAdap = new CDTableAdapter(sdfDatabase);
ConvertDataSet.CDDataTable cd = new ConvertDataSet.CDDataTable();
cdAdap.Fill(cd);
// Alle Identities einlesen
Dictionary <int, string> identites = ReadIdentities();
CopyData("CD", fieldsCD, cd, identites);
SqlCeCommand cmd = new SqlCeCommand("SET IDENTITY_INSERT CD ON", sdfDatabase.Connection);
cmd.ExecuteNonQuery();
int count = 0;
foreach (DataRow row in cd.Rows)
{
try
{
cdAdap.Update(row);
}
catch (Exception e)
{
FormUnhandledException formUnhandledException = new FormUnhandledException(e);
formUnhandledException.ShowDialog();
}
if ((count % 100) == 0)
{
formConvertProgress.CurrentTable = string.Format("{0} ({1} Einträge)", "Track", count);
formConvertProgress.Refresh();
Application.DoEvents();
}
count++;
}
cmd = new SqlCeCommand("SET IDENTITY_INSERT CD OFF", sdfDatabase.Connection);
cmd.ExecuteNonQuery();
cmd = new SqlCeCommand("SELECT MAX(CDID) FROM CD", sdfDatabase.Connection);
int maxId = (int)cmd.ExecuteScalar() + 1;
cmd = new SqlCeCommand(string.Format("ALTER TABLE CD ALTER COLUMN CDID IDENTITY({0},1)", maxId), sdfDatabase.Connection);
cmd.ExecuteNonQuery();
#endregion
#region Track
formConvertProgress.CurrentTable = "Track";
formConvertProgress.Value++;
List <FieldConvert> fieldsTrack = new List <FieldConvert>();
fieldsTrack.Add(new FieldConvert("IDLied", "TrackID"));
fieldsTrack.Add(new FieldConvert("IDCD", "CDID"));
fieldsTrack.Add(new FieldConvert("IDArtist", "ArtistID"));
fieldsTrack.Add(new FieldConvert("wLiedNummer", "TrackNumber"));
fieldsTrack.Add(new FieldConvert("szTitel", "Title"));
fieldsTrack.Add(new FieldConvert("dwLaenge", "Length"));
fieldsTrack.Add(new FieldConvert("wBpm", "Bpm"));
fieldsTrack.Add(new FieldConvert("szNameRecDatei", "SoundFile"));
fieldsTrack.Add(new FieldConvert("szKennzeichen", "Codes"));
fieldsTrack.Add(new FieldConvert("szKommentar", "Comment"));
fieldsTrack.Add(new FieldConvert("szLiedtext", "Lyrics"));
fieldsTrack.Add(new FieldConvert("szFeld1", "User1"));
fieldsTrack.Add(new FieldConvert("szFeld2", "User2"));
fieldsTrack.Add(new FieldConvert("szFeld3", "User3"));
fieldsTrack.Add(new FieldConvert("szFeld4", "User4"));
fieldsTrack.Add(new FieldConvert("szFeld5", "User5"));
fieldsTrack.Add(new FieldConvert("L_TrackFormat", "TrackFormat"));
fieldsTrack.Add(new FieldConvert("L_BitRate", "BitRate"));
fieldsTrack.Add(new FieldConvert("L_SampleRate", "SampleRate"));
fieldsTrack.Add(new FieldConvert("L_Channels", "Channels"));
fieldsTrack.Add(new FieldConvert("L_YearRecorded", "YearRecorded"));
fieldsTrack.Add(new FieldConvert("L_Checksum", "Checksum"));
fieldsTrack.Add(new FieldConvert("L_Rating", "Rating"));
fieldsTrack.Add(new FieldConvert("L_IDCategory", "CategoryID"));
fieldsTrack.Add(new FieldConvert("L_IDComposer", "ComposerID"));
fieldsTrack.Add(new FieldConvert("L_Language", "Language"));
TrackTableAdapter trackAdap = new TrackTableAdapter(sdfDatabase);
ConvertDataSet.TrackDataTable track = new ConvertDataSet.TrackDataTable();
trackAdap.Fill(track);
CopyData("Lied", fieldsTrack, track);
sql = string.Format("SET IDENTITY_INSERT Track ON");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
count = 0;
foreach (DataRow row in track.Rows)
{
try
{
trackAdap.Update(row);
}
catch (Exception e)
{
FormUnhandledException formUnhandledException = new FormUnhandledException(e);
formUnhandledException.ShowDialog();
}
if ((count % 100) == 0)
{
formConvertProgress.CurrentTable = string.Format("{0} ({1} Einträge)", "Track", count);
formConvertProgress.Refresh();
Application.DoEvents();
}
count++;
}
sql = string.Format("SET IDENTITY_INSERT Track OFF");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
cmd = new SqlCeCommand("SELECT MAX(TrackID) FROM Track", sdfDatabase.Connection);
maxId = (int)cmd.ExecuteScalar() + 1;
cmd = new SqlCeCommand(string.Format("ALTER TABLE Track ALTER COLUMN TrackID IDENTITY({0},1)", maxId), sdfDatabase.Connection);
cmd.ExecuteNonQuery();
#endregion
#region Artist
formConvertProgress.CurrentTable = "Artist";
formConvertProgress.Value++;
List <FieldConvert> fieldsPersonGroup = new List <FieldConvert>();
fieldsPersonGroup.Add(new FieldConvert("IDArtist", "PersonGroupID"));
fieldsPersonGroup.Add(new FieldConvert("szArtistName", "Name"));
fieldsPersonGroup.Add(new FieldConvert("sSortKey", "SaveAs"));
fieldsPersonGroup.Add(new FieldConvert("nGroup", "Type"));
fieldsPersonGroup.Add(new FieldConvert("nSex", "Sex"));
fieldsPersonGroup.Add(new FieldConvert("sComment", "Comment"));
fieldsPersonGroup.Add(new FieldConvert("A_URL", "URL"));
fieldsPersonGroup.Add(new FieldConvert("A_Country", "Country"));
fieldsPersonGroup.Add(new FieldConvert("A_BirthDay", "BirthDay", true));
fieldsPersonGroup.Add(new FieldConvert("A_DayOfDeath", "DayOfDeath", true));
fieldsPersonGroup.Add(new FieldConvert("A_ImageFilename", "ImageFilename"));
PersonGroupTableAdapter personGroupAdap = new PersonGroupTableAdapter(sdfDatabase);
ConvertDataSet.PersonGroupDataTable personGroup = new ConvertDataSet.PersonGroupDataTable();
personGroupAdap.Fill(personGroup);
CopyData("Artist", fieldsPersonGroup, personGroup);
sql = string.Format("SET IDENTITY_INSERT PersonGroup ON");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
count = 0;
foreach (DataRow row in personGroup.Rows)
{
try
{
personGroupAdap.Update(row);
}
catch (Exception e)
{
FormUnhandledException formUnhandledException = new FormUnhandledException(e);
formUnhandledException.ShowDialog();
}
if ((count % 100) == 0)
{
formConvertProgress.CurrentTable = string.Format("{0} ({1} Einträge)", "Artist", count);
formConvertProgress.Refresh();
Application.DoEvents();
}
count++;
}
sql = string.Format("SET IDENTITY_INSERT PersonGroup OFF");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
cmd = new SqlCeCommand("SELECT MAX(PersonGroupID) FROM PersonGroup", sdfDatabase.Connection);
maxId = (int)cmd.ExecuteScalar() + 1;
cmd = new SqlCeCommand(string.Format("ALTER TABLE PersonGroup ALTER COLUMN PersonGroupID IDENTITY({0},1)", maxId), sdfDatabase.Connection);
cmd.ExecuteNonQuery();
#endregion
#region Category
formConvertProgress.CurrentTable = "Category";
formConvertProgress.Value++;
List <FieldConvert> fieldsCategory = new List <FieldConvert>();
fieldsCategory.Add(new FieldConvert("IDKategorie", "CategoryID"));
fieldsCategory.Add(new FieldConvert("szKategorieName", "Name"));
fieldsCategory.Add(new FieldConvert("wOrder", "Order"));
CategoryTableAdapter categoryAdap = new CategoryTableAdapter(sdfDatabase);
ConvertDataSet.CategoryDataTable categories = new ConvertDataSet.CategoryDataTable();
categoryAdap.Fill(categories);
CopyData("Kategorie", fieldsCategory, categories);
sql = string.Format("SET IDENTITY_INSERT Category ON");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
categoryAdap.Update(categories);
sql = string.Format("SET IDENTITY_INSERT Category OFF");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
cmd = new SqlCeCommand("SELECT MAX(CategoryID) FROM Category", sdfDatabase.Connection);
maxId = (int)cmd.ExecuteScalar() + 1;
cmd = new SqlCeCommand(string.Format("ALTER TABLE Category ALTER COLUMN CategoryID IDENTITY({0},1)", maxId), sdfDatabase.Connection);
cmd.ExecuteNonQuery();
#endregion
#region Medium
formConvertProgress.CurrentTable = "Medium";
formConvertProgress.Value++;
List <FieldConvert> fieldsMedium = new List <FieldConvert>();
fieldsMedium.Add(new FieldConvert("IDMedium", "MediumID"));
fieldsMedium.Add(new FieldConvert("szMedium", "Name"));
fieldsMedium.Add(new FieldConvert("wOrder", "Order"));
MediumTableAdapter mediumAdap = new MediumTableAdapter(sdfDatabase);
ConvertDataSet.MediumDataTable mediums = new ConvertDataSet.MediumDataTable();
mediumAdap.Fill(mediums);
CopyData("Medium", fieldsMedium, mediums);
sql = string.Format("SET IDENTITY_INSERT Medium ON");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
mediumAdap.Update(mediums);
sql = string.Format("SET IDENTITY_INSERT Medium OFF");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
cmd = new SqlCeCommand("SELECT MAX(MediumID) FROM Medium", sdfDatabase.Connection);
maxId = (int)cmd.ExecuteScalar() + 1;
cmd = new SqlCeCommand(string.Format("ALTER TABLE Medium ALTER COLUMN MediumID IDENTITY({0},1)", maxId), sdfDatabase.Connection);
cmd.ExecuteNonQuery();
#endregion
#region CDSet
formConvertProgress.CurrentTable = "CDSet";
formConvertProgress.Value++;
List <FieldConvert> fieldsSet = new List <FieldConvert>();
fieldsSet.Add(new FieldConvert("IDCDSet", "SetID"));
fieldsSet.Add(new FieldConvert("szCDSetName", "Name"));
SetTableAdapter setAdap = new SetTableAdapter(sdfDatabase);
ConvertDataSet.SetDataTable sets = new ConvertDataSet.SetDataTable();
setAdap.Fill(sets);
CopyData("CDSet", fieldsSet, sets);
sql = string.Format("SET IDENTITY_INSERT [Set] ON");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
setAdap.Update(sets);
sql = string.Format("SET IDENTITY_INSERT [Set] OFF");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
cmd = new SqlCeCommand("SELECT MAX(SetID) FROM [Set]", sdfDatabase.Connection);
object maxSetID = cmd.ExecuteScalar();
if (maxSetID is DBNull)
{
maxId = 1;
}
else
{
maxId = (int)maxSetID + 1;
}
cmd = new SqlCeCommand(string.Format("ALTER TABLE [Set] ALTER COLUMN SetID IDENTITY({0},1)", maxId), sdfDatabase.Connection);
cmd.ExecuteNonQuery();
#endregion
#region Program
formConvertProgress.CurrentTable = "Program";
formConvertProgress.Value++;
List <FieldConvert> fieldsProgram = new List <FieldConvert>();
fieldsProgram.Add(new FieldConvert("IDCD", "CDID"));
fieldsProgram.Add(new FieldConvert("szName", "Name"));
fieldsProgram.Add(new FieldConvert("szLieder", "Tracks"));
fieldsProgram.Add(new FieldConvert("bStandard", "IsStandard"));
ProgramTableAdapter programAdap = new ProgramTableAdapter(sdfDatabase);
ConvertDataSet.ProgramDataTable programs = new ConvertDataSet.ProgramDataTable();
programAdap.Fill(programs);
CopyData("Programme", fieldsProgram, programs);
programAdap.Update(programs);
#endregion
#region Index
formConvertProgress.CurrentTable = "Index";
formConvertProgress.Value++;
List <FieldConvert> fieldsIndex = new List <FieldConvert>();
fieldsIndex.Add(new FieldConvert("IDCD", "CDID"));
fieldsIndex.Add(new FieldConvert("szIndexName", "Name"));
fieldsIndex.Add(new FieldConvert("dwPosition", "Position"));
IndexTableAdapter indexAdap = new IndexTableAdapter(sdfDatabase);
ConvertDataSet.IndexDataTable indexes = new ConvertDataSet.IndexDataTable();
indexAdap.Fill(indexes);
CopyData("Index", fieldsIndex, indexes);
indexAdap.Update(indexes);
#endregion
#region Codes
formConvertProgress.CurrentTable = "Codes";
formConvertProgress.Value++;
List <FieldConvert> fieldsCode = new List <FieldConvert>();
fieldsCode.Add(new FieldConvert("cBuchstabe", "Letter"));
fieldsCode.Add(new FieldConvert("szBedeutung", "Description"));
CodeTableAdapter codeAdap = new CodeTableAdapter(sdfDatabase);
ConvertDataSet.CodeDataTable codes = new ConvertDataSet.CodeDataTable();
codeAdap.Fill(codes);
CopyData("Kennzeichen", fieldsCode, codes);
codeAdap.Update(codes);
#endregion
#region Queue
formConvertProgress.CurrentTable = "Queue";
formConvertProgress.Value++;
List <FieldConvert> fieldsQueue = new List <FieldConvert>();
fieldsQueue.Add(new FieldConvert("Q_lIDCD", "CDID"));
fieldsQueue.Add(new FieldConvert("Q_lAction", "Action"));
fieldsQueue.Add(new FieldConvert("Q_sIdentity", "Identity"));
fieldsQueue.Add(new FieldConvert("Q_sIdentityCDDB", "IdentityCDDB"));
QueueTableAdapter queueAdap = new QueueTableAdapter(sdfDatabase);
ConvertDataSet.QueueDataTable queues = new ConvertDataSet.QueueDataTable();
queueAdap.Fill(queues);
CopyData("Queue", fieldsQueue, queues);
queueAdap.Update(queues);
#endregion
#region LoanedCDs
formConvertProgress.CurrentTable = "LoanedCDs";
formConvertProgress.Value++;
List <FieldConvert> fieldsLoanedCD = new List <FieldConvert>();
fieldsLoanedCD.Add(new FieldConvert("IDCD", "CDID"));
fieldsLoanedCD.Add(new FieldConvert("Kommentar", "Comment"));
fieldsLoanedCD.Add(new FieldConvert("VerliehenAm", "LoanedDate"));
fieldsLoanedCD.Add(new FieldConvert("VerliehenAn", "LoanedTo"));
fieldsLoanedCD.Add(new FieldConvert("RueckgabeTermin", "ReturnDate"));
LoanedCDTableAdapter loanedCDAdap = new LoanedCDTableAdapter(sdfDatabase);
ConvertDataSet.LoanedCDDataTable loanedCDs = new ConvertDataSet.LoanedCDDataTable();
loanedCDAdap.Fill(loanedCDs);
CopyData("VerlieheneCDs", fieldsLoanedCD, loanedCDs);
loanedCDAdap.Update(loanedCDs);
#endregion
#region Dialog
formConvertProgress.CurrentTable = "Dialog";
formConvertProgress.Value++;
List <FieldConvert> fieldsDialog = new List <FieldConvert>();
fieldsDialog.Add(new FieldConvert("D_IDDialog", "DialogID"));
fieldsDialog.Add(new FieldConvert("D_IDCategory", "CategoryID"));
fieldsDialog.Add(new FieldConvert("D_DialogXML", "DialogXML"));
DialogTableAdapter dialogAdap = new DialogTableAdapter(sdfDatabase);
ConvertDataSet.DialogDataTable dialogs = new ConvertDataSet.DialogDataTable();
dialogAdap.Fill(dialogs);
CopyData("Dialog", fieldsDialog, dialogs);
sql = string.Format("SET IDENTITY_INSERT [Dialog] ON");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
dialogAdap.Update(dialogs);
sql = string.Format("SET IDENTITY_INSERT [Dialog] OFF");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
cmd = new SqlCeCommand("SELECT MAX(DialogID) FROM [Dialog]", sdfDatabase.Connection);
maxSetID = cmd.ExecuteScalar();
if (maxSetID is DBNull)
{
maxId = 1;
}
else
{
maxId = (int)maxSetID + 1;
}
cmd = new SqlCeCommand(string.Format("ALTER TABLE [Dialog] ALTER COLUMN DialogID IDENTITY({0},1)", maxId), sdfDatabase.Connection);
cmd.ExecuteNonQuery();
#endregion
#region Role
formConvertProgress.CurrentTable = "Role";
formConvertProgress.Value++;
List <FieldConvert> fieldsRole = new List <FieldConvert>();
fieldsRole.Add(new FieldConvert("R_ID", "RoleID"));
fieldsRole.Add(new FieldConvert("R_Role", "Name"));
RoleTableAdapter roleAdap = new RoleTableAdapter(sdfDatabase);
ConvertDataSet.RoleDataTable roles = new ConvertDataSet.RoleDataTable();
roleAdap.Fill(roles);
CopyData("Role", fieldsRole, roles);
sql = string.Format("SET IDENTITY_INSERT [Role] ON");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
roleAdap.Update(roles);
sql = string.Format("SET IDENTITY_INSERT [Role] OFF");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
cmd = new SqlCeCommand("SELECT MAX(RoleID) FROM [Role]", sdfDatabase.Connection);
maxSetID = cmd.ExecuteScalar();
if (maxSetID is DBNull)
{
maxId = 1;
}
else
{
maxId = (int)maxSetID + 1;
}
cmd = new SqlCeCommand(string.Format("ALTER TABLE [Role] ALTER COLUMN RoleID IDENTITY({0},1)", maxId), sdfDatabase.Connection);
cmd.ExecuteNonQuery();
#endregion
#region Participant
formConvertProgress.CurrentTable = "Participant";
formConvertProgress.Value++;
List <FieldConvert> fieldsParticipant = new List <FieldConvert>();
fieldsParticipant.Add(new FieldConvert("P_ID", "ParticipantID"));
fieldsParticipant.Add(new FieldConvert("P_IDArtist", "PersonGroupID"));
fieldsParticipant.Add(new FieldConvert("P_IDRole", "RoleID"));
fieldsParticipant.Add(new FieldConvert("P_IDCD", "CDID"));
fieldsParticipant.Add(new FieldConvert("P_TrackNumber", "TrackNumber"));
fieldsParticipant.Add(new FieldConvert("P_Comment", "Comment"));
ParticipantTableAdapter participantAdap = new ParticipantTableAdapter(sdfDatabase);
ConvertDataSet.ParticipantDataTable participants = new ConvertDataSet.ParticipantDataTable();
participantAdap.Fill(participants);
CopyData("Participant", fieldsParticipant, participants);
sql = string.Format("SET IDENTITY_INSERT [Participant] ON");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
participantAdap.Update(participants);
sql = string.Format("SET IDENTITY_INSERT [Participant] OFF");
cmd = new SqlCeCommand(sql, sdfDatabase.Connection);
cmd.ExecuteNonQuery();
cmd = new SqlCeCommand("SELECT MAX(ParticipantID) FROM [Participant]", sdfDatabase.Connection);
maxSetID = cmd.ExecuteScalar();
if (maxSetID is DBNull)
{
maxId = 1;
}
else
{
maxId = (int)maxSetID + 1;
}
cmd = new SqlCeCommand(string.Format("ALTER TABLE [Participant] ALTER COLUMN ParticipantID IDENTITY({0},1)", maxId), sdfDatabase.Connection);
cmd.ExecuteNonQuery();
#endregion
}
public void StronglyTypedDataSet()
{
DataSet1.CategoryDataTable CategoryDT = new DataSet1.CategoryDataTable();
CategoryTableAdapter CategoryTBAdapter = new CategoryTableAdapter();
DataSet1.ProductsDataTable ProductsDT = new DataSet1.ProductsDataTable();
ProductsTableAdapter ProductsTBAdapter = new ProductsTableAdapter();
CategoryTBAdapter.Fill(CategoryDT);
ProductsTBAdapter.Fill(ProductsDT);
var result = from cat in CategoryDT
join prod in ProductsDT
on cat.CategoryID equals prod.CategoryID
where cat.CategoryID == 65985
select new { CategoryName = cat.CategoryName, ProductName = prod.ProductName, UnitPrice = prod.UnitPrice };
GridView6.DataSource = result;
GridView6.DataBind();
}
public void DataViewDemo()
{
DataSet1.CategoryDataTable Category = new DataSet1.CategoryDataTable();
CategoryTableAdapter catAdap = new CategoryTableAdapter();
catAdap.Fill(Category);
DataSet1.ProductsDataTable Products = new DataSet1.ProductsDataTable();
ProductsTableAdapter prodAdap = new ProductsTableAdapter();
prodAdap.Fill(Products);
var result = from item in Products
select item;
DataView view = result.AsDataView();
view.Sort = "ProductName desc";
view.RowFilter = "CategoryID = 65985";
GridView7.DataSource = view;
GridView7.DataBind();
DataSet1.ProductsRow row = null;
List<DataSet1.ProductsRow> myList = new List<DataSet1.ProductsRow>();
foreach (DataRowView item in view)
{
row = (DataSet1.ProductsRow)item.Row;
myList.Add(row);
}
GridView8.DataSource = myList;
GridView8.DataBind();
}