/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); this.label1 = new System.Windows.Forms.Label(); this.StoresComboBox = new System.Windows.Forms.ComboBox(); this.dataGrid1 = new System.Windows.Forms.DataGrid(); this.StoreSalesDataSet1 = new PopulatingAndUpdateingDataSets.StoreSalesDataSet(); this.UpdateButton = new System.Windows.Forms.Button(); this.SalesSQLDataAdapter = new System.Data.SqlClient.SqlDataAdapter(); this.SalesSQLDeleteCommand = new System.Data.SqlClient.SqlCommand(); this.sqlConnection1 = new System.Data.SqlClient.SqlConnection(); this.SalesSQLInsertCommand = new System.Data.SqlClient.SqlCommand(); this.SalesSQLSelectCommand = new System.Data.SqlClient.SqlCommand(); this.SalesSQLUpdateCommand = new System.Data.SqlClient.SqlCommand(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.StoreSalesDataSet1)).BeginInit(); this.SuspendLayout(); // // label1 // this.label1.AutoSize = true; this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label1.Location = new System.Drawing.Point(28, 16); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(43, 13); this.label1.TabIndex = 0; this.label1.Text = "Stores"; // // StoresComboBox // this.StoresComboBox.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; this.StoresComboBox.Location = new System.Drawing.Point(28, 32); this.StoresComboBox.Name = "StoresComboBox"; this.StoresComboBox.Size = new System.Drawing.Size(148, 21); this.StoresComboBox.TabIndex = 1; // // dataGrid1 // this.dataGrid1.DataMember = "sales"; this.dataGrid1.DataSource = this.StoreSalesDataSet1; this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGrid1.Location = new System.Drawing.Point(28, 64); this.dataGrid1.Name = "dataGrid1"; this.dataGrid1.Size = new System.Drawing.Size(488, 176); this.dataGrid1.TabIndex = 2; // // StoreSalesDataSet1 // this.StoreSalesDataSet1.DataSetName = "StoreSalesDataSet"; this.StoreSalesDataSet1.Locale = new System.Globalization.CultureInfo("en-US"); this.StoreSalesDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // UpdateButton // this.UpdateButton.Location = new System.Drawing.Point(441, 256); this.UpdateButton.Name = "UpdateButton"; this.UpdateButton.Size = new System.Drawing.Size(75, 23); this.UpdateButton.TabIndex = 3; this.UpdateButton.Text = "Update"; this.UpdateButton.Click += new System.EventHandler(this.UpdateButton_Click); // // SalesSQLDataAdapter // this.SalesSQLDataAdapter.DeleteCommand = this.SalesSQLDeleteCommand; this.SalesSQLDataAdapter.InsertCommand = this.SalesSQLInsertCommand; this.SalesSQLDataAdapter.SelectCommand = this.SalesSQLSelectCommand; this.SalesSQLDataAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "sales", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("stor_id", "stor_id"), new System.Data.Common.DataColumnMapping("ord_num", "ord_num"), new System.Data.Common.DataColumnMapping("qty", "qty"), new System.Data.Common.DataColumnMapping("ord_date", "ord_date"), new System.Data.Common.DataColumnMapping("payterms", "payterms"), new System.Data.Common.DataColumnMapping("title_id", "title_id")})}); this.SalesSQLDataAdapter.UpdateCommand = this.SalesSQLUpdateCommand; // // SalesSQLDeleteCommand // this.SalesSQLDeleteCommand.CommandText = resources.GetString("SalesSQLDeleteCommand.CommandText"); this.SalesSQLDeleteCommand.Connection = this.sqlConnection1; this.SalesSQLDeleteCommand.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_ord_num", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ord_num", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_stor_id", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "stor_id", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_title_id", System.Data.SqlDbType.VarChar, 6, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "title_id", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ord_date", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ord_date", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_payterms", System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "payterms", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_qty", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "qty", System.Data.DataRowVersion.Original, null)}); // // sqlConnection1 // this.sqlConnection1.ConnectionString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=C:\\Users\\NikLubz\\Source\\Repos\\School" + "Work\\3350Y\\Lab11\\Databases\\pubs.mdf;Integrated Security=True;Connect Timeout=30"; this.sqlConnection1.FireInfoMessageEventOnUserErrors = false; // // SalesSQLInsertCommand // this.SalesSQLInsertCommand.CommandText = resources.GetString("SalesSQLInsertCommand.CommandText"); this.SalesSQLInsertCommand.Connection = this.sqlConnection1; this.SalesSQLInsertCommand.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@stor_id", System.Data.SqlDbType.VarChar, 4, "stor_id"), new System.Data.SqlClient.SqlParameter("@ord_num", System.Data.SqlDbType.VarChar, 20, "ord_num"), new System.Data.SqlClient.SqlParameter("@qty", System.Data.SqlDbType.SmallInt, 2, "qty"), new System.Data.SqlClient.SqlParameter("@ord_date", System.Data.SqlDbType.DateTime, 8, "ord_date"), new System.Data.SqlClient.SqlParameter("@payterms", System.Data.SqlDbType.VarChar, 12, "payterms"), new System.Data.SqlClient.SqlParameter("@title_id", System.Data.SqlDbType.VarChar, 6, "title_id")}); // // SalesSQLSelectCommand // this.SalesSQLSelectCommand.CommandText = "SELECT stor_id, ord_num, qty, ord_date, payterms, title_id FROM sales WHERE (stor" + "_id = @stor_id)"; this.SalesSQLSelectCommand.Connection = this.sqlConnection1; this.SalesSQLSelectCommand.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@stor_id", System.Data.SqlDbType.VarChar, 4, "stor_id")}); // // SalesSQLUpdateCommand // this.SalesSQLUpdateCommand.CommandText = resources.GetString("SalesSQLUpdateCommand.CommandText"); this.SalesSQLUpdateCommand.Connection = this.sqlConnection1; this.SalesSQLUpdateCommand.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Param1", System.Data.SqlDbType.VarChar, 4, "stor_id"), new System.Data.SqlClient.SqlParameter("@ord_num", System.Data.SqlDbType.VarChar, 20, "ord_num"), new System.Data.SqlClient.SqlParameter("@qty", System.Data.SqlDbType.SmallInt, 2, "qty"), new System.Data.SqlClient.SqlParameter("@ord_date", System.Data.SqlDbType.DateTime, 8, "ord_date"), new System.Data.SqlClient.SqlParameter("@payterms", System.Data.SqlDbType.VarChar, 12, "payterms"), new System.Data.SqlClient.SqlParameter("@title_id", System.Data.SqlDbType.VarChar, 6, "title_id"), new System.Data.SqlClient.SqlParameter("@Original_ord_num", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ord_num", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_stor_id", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "stor_id", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_title_id", System.Data.SqlDbType.VarChar, 6, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "title_id", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ord_date", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ord_date", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_payterms", System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "payterms", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_qty", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "qty", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@stor_id", System.Data.SqlDbType.VarChar, 4, "stor_id")}); // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(544, 294); this.Controls.Add(this.UpdateButton); this.Controls.Add(this.dataGrid1); this.Controls.Add(this.StoresComboBox); this.Controls.Add(this.label1); this.Name = "Form1"; this.Text = "Store Orders"; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.StoreSalesDataSet1)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); this.label1 = new System.Windows.Forms.Label(); this.StoresComboBox = new System.Windows.Forms.ComboBox(); this.dataGrid1 = new System.Windows.Forms.DataGrid(); this.StoreSalesDataSet1 = new PopulatingAndUpdateingDataSets.StoreSalesDataSet(); this.SalesSQLDataAdapter = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConnection1 = new System.Data.SqlClient.SqlConnection(); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.StateLabel = new System.Windows.Forms.Label(); this.CityLabel = new System.Windows.Forms.Label(); this.CompanyNameLabel = new System.Windows.Forms.Label(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.StoreSalesDataSet1)).BeginInit(); this.groupBox1.SuspendLayout(); this.SuspendLayout(); // // label1 // this.label1.AutoSize = true; this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label1.Location = new System.Drawing.Point(28, 16); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(43, 13); this.label1.TabIndex = 0; this.label1.Text = "Stores"; // // StoresComboBox // this.StoresComboBox.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; this.StoresComboBox.Location = new System.Drawing.Point(28, 32); this.StoresComboBox.Name = "StoresComboBox"; this.StoresComboBox.Size = new System.Drawing.Size(148, 21); this.StoresComboBox.TabIndex = 1; // // dataGrid1 // this.dataGrid1.DataMember = "sales"; this.dataGrid1.DataSource = this.StoreSalesDataSet1; this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGrid1.Location = new System.Drawing.Point(28, 64); this.dataGrid1.Name = "dataGrid1"; this.dataGrid1.Size = new System.Drawing.Size(488, 176); this.dataGrid1.TabIndex = 2; // // StoreSalesDataSet1 // this.StoreSalesDataSet1.DataSetName = "StoreSalesDataSet"; this.StoreSalesDataSet1.Locale = new System.Globalization.CultureInfo("en-US"); this.StoreSalesDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // SalesSQLDataAdapter // this.SalesSQLDataAdapter.SelectCommand = this.sqlSelectCommand1; this.SalesSQLDataAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "sales", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("stor_id", "stor_id"), new System.Data.Common.DataColumnMapping("ord_num", "ord_num"), new System.Data.Common.DataColumnMapping("qty", "qty"), new System.Data.Common.DataColumnMapping("ord_date", "ord_date"), new System.Data.Common.DataColumnMapping("payterms", "payterms"), new System.Data.Common.DataColumnMapping("title_id", "title_id"), new System.Data.Common.DataColumnMapping("Expr1", "Expr1"), new System.Data.Common.DataColumnMapping("stor_name", "stor_name"), new System.Data.Common.DataColumnMapping("city", "city"), new System.Data.Common.DataColumnMapping("state", "state")})}); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = resources.GetString("sqlSelectCommand1.CommandText"); this.sqlSelectCommand1.Connection = this.sqlConnection1; this.sqlSelectCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@stor_id", System.Data.SqlDbType.VarChar, 4, "stor_id")}); // // sqlConnection1 // this.sqlConnection1.ConnectionString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=C:\\Users\\NikLubz\\Source\\Repos\\School" + "Work\\3350Y\\Lab11\\Databases\\pubs.mdf;Integrated Security=True;Connect Timeout=30"; this.sqlConnection1.FireInfoMessageEventOnUserErrors = false; // // groupBox1 // this.groupBox1.Controls.Add(this.StateLabel); this.groupBox1.Controls.Add(this.CityLabel); this.groupBox1.Controls.Add(this.CompanyNameLabel); this.groupBox1.Location = new System.Drawing.Point(32, 256); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(232, 72); this.groupBox1.TabIndex = 3; this.groupBox1.TabStop = false; this.groupBox1.Text = "Company Information"; // // StateLabel // this.StateLabel.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.StoreSalesDataSet1, "sales.state", true)); this.StateLabel.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.StateLabel.Location = new System.Drawing.Point(96, 48); this.StateLabel.Name = "StateLabel"; this.StateLabel.Size = new System.Drawing.Size(32, 13); this.StateLabel.TabIndex = 2; this.StateLabel.Text = "State"; // // CityLabel // this.CityLabel.AutoSize = true; this.CityLabel.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.CityLabel.Location = new System.Drawing.Point(8, 48); this.CityLabel.Name = "CityLabel"; this.CityLabel.Size = new System.Drawing.Size(28, 13); this.CityLabel.TabIndex = 1; this.CityLabel.Text = "City"; // // CompanyNameLabel // this.CompanyNameLabel.AutoSize = true; this.CompanyNameLabel.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.StoreSalesDataSet1, "sales.stor_name", true)); this.CompanyNameLabel.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.CompanyNameLabel.Location = new System.Drawing.Point(8, 24); this.CompanyNameLabel.Name = "CompanyNameLabel"; this.CompanyNameLabel.Size = new System.Drawing.Size(94, 13); this.CompanyNameLabel.TabIndex = 0; this.CompanyNameLabel.Text = "Company Name"; // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(560, 342); this.Controls.Add(this.groupBox1); this.Controls.Add(this.dataGrid1); this.Controls.Add(this.StoresComboBox); this.Controls.Add(this.label1); this.Name = "Form1"; this.Text = "Store Orders"; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.StoreSalesDataSet1)).EndInit(); this.groupBox1.ResumeLayout(false); this.groupBox1.PerformLayout(); this.ResumeLayout(false); this.PerformLayout(); }