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