public override System.Data.DataSet Clone() {
DataSet1 cln = ((DataSet1)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return cln;
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1));
Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor2 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor3 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor4 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
this.dataSet11 = new XMLSerialization.DataSet1();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
this.reset = new Syncfusion.Windows.Forms.ButtonAdv();
this.btnLoadXmlSchema = new Syncfusion.Windows.Forms.ButtonAdv();
this.btnSaveXmlSchema = new Syncfusion.Windows.Forms.ButtonAdv();
this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl();
this.propertyGrid1 = new System.Windows.Forms.PropertyGrid();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit();
this.SuspendLayout();
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("en-US");
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT CategoryID, CategoryName, Description, Picture FROM Categories";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "data source=(local)\\NETSDK;initial catalog=Northwind;integrated security=SSPI;per" +
"sist security info=True;workstation id=localhost;packet size=4096";
this.sqlConnection1.FireInfoMessageEventOnUserErrors = false;
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = resources.GetString("sqlInsertCommand1.CommandText");
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@CategoryName", System.Data.SqlDbType.NVarChar, 15, "CategoryName"),
new System.Data.SqlClient.SqlParameter("@Description", System.Data.SqlDbType.NVarChar, 1073741823, "Description"),
new System.Data.SqlClient.SqlParameter("@Picture", System.Data.SqlDbType.VarBinary, 2147483647, "Picture")
});
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = resources.GetString("sqlUpdateCommand1.CommandText");
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@CategoryName", System.Data.SqlDbType.NVarChar, 15, "CategoryName"),
new System.Data.SqlClient.SqlParameter("@Description", System.Data.SqlDbType.NVarChar, 1073741823, "Description"),
new System.Data.SqlClient.SqlParameter("@Picture", System.Data.SqlDbType.VarBinary, 2147483647, "Picture"),
new System.Data.SqlClient.SqlParameter("@Original_CategoryID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CategoryID", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_CategoryName", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CategoryName", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@CategoryID", System.Data.SqlDbType.Int, 4, "CategoryID")
});
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM Categories WHERE (CategoryID = @Original_CategoryID) AND (CategoryNam" +
"e = @Original_CategoryName)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Original_CategoryID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CategoryID", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_CategoryName", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CategoryName", System.Data.DataRowVersion.Original, null)
});
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Categories", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("CategoryID", "CategoryID"),
new System.Data.Common.DataColumnMapping("CategoryName", "CategoryName"),
new System.Data.Common.DataColumnMapping("Description", "Description"),
new System.Data.Common.DataColumnMapping("Picture", "Picture")
})
});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// reset
//
this.reset.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
this.reset.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro;
this.reset.FlatStyle = FlatStyle.Flat;
this.reset.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220)))));
this.reset.BeforeTouchSize = new System.Drawing.Size(130, 28);
this.reset.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner;
this.reset.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.reset.ForeColor = System.Drawing.Color.White;
this.reset.IsBackStageButton = false;
this.reset.Location = new System.Drawing.Point(340, 615);
this.reset.Name = "reset";
this.reset.Size = new System.Drawing.Size(130, 28);
this.reset.TabIndex = 12;
this.reset.Text = "Reset Schema";
this.reset.Click += new System.EventHandler(this.reset_Click);
//
// btnLoadXmlSchema
//
this.btnLoadXmlSchema.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
this.btnLoadXmlSchema.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro;
this.btnLoadXmlSchema.FlatStyle = FlatStyle.Flat;
this.btnLoadXmlSchema.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220)))));
this.btnLoadXmlSchema.BeforeTouchSize = new System.Drawing.Size(130, 28);
this.btnLoadXmlSchema.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner;
this.btnLoadXmlSchema.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.btnLoadXmlSchema.ForeColor = System.Drawing.Color.White;
this.btnLoadXmlSchema.IsBackStageButton = false;
this.btnLoadXmlSchema.Location = new System.Drawing.Point(199, 615);
this.btnLoadXmlSchema.Name = "btnLoadXmlSchema";
this.btnLoadXmlSchema.Size = new System.Drawing.Size(130, 28);
this.btnLoadXmlSchema.TabIndex = 11;
this.btnLoadXmlSchema.Text = "Load Xml Schema";
this.btnLoadXmlSchema.Click += new System.EventHandler(this.btnLoadXmlSchema_Click);
//
// btnSaveXmlSchema
//
this.btnSaveXmlSchema.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
this.btnSaveXmlSchema.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro;
this.btnSaveXmlSchema.FlatStyle = FlatStyle.Flat;
this.btnSaveXmlSchema.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220)))));
this.btnSaveXmlSchema.BeforeTouchSize = new System.Drawing.Size(130, 28);
this.btnSaveXmlSchema.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner;
this.btnSaveXmlSchema.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.btnSaveXmlSchema.ForeColor = System.Drawing.Color.White;
this.btnSaveXmlSchema.IsBackStageButton = false;
this.btnSaveXmlSchema.Location = new System.Drawing.Point(60, 615);
this.btnSaveXmlSchema.Name = "btnSaveXmlSchema";
this.btnSaveXmlSchema.Size = new System.Drawing.Size(130, 28);
this.btnSaveXmlSchema.TabIndex = 10;
this.btnSaveXmlSchema.Text = "Save Xml Schema";
this.btnSaveXmlSchema.Click += new System.EventHandler(this.btnSaveXmlSchema_Click);
//
// gridGroupingControl1
//
this.gridGroupingControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.gridGroupingControl1.BackColor = System.Drawing.SystemColors.Window;
this.gridGroupingControl1.DataSource = this.dataSet11.Categories;
this.gridGroupingControl1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.gridGroupingControl1.FreezeCaption = false;
this.gridGroupingControl1.Location = new System.Drawing.Point(15, 16);
this.gridGroupingControl1.Name = "gridGroupingControl1";
this.gridGroupingControl1.Size = new System.Drawing.Size(697, 589);
this.gridGroupingControl1.TabIndex = 9;
gridColumnDescriptor1.HeaderImage = null;
gridColumnDescriptor1.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
gridColumnDescriptor1.MappingName = "CategoryID";
gridColumnDescriptor1.SerializedImageArray = "";
gridColumnDescriptor1.Width = 80;
gridColumnDescriptor2.HeaderImage = null;
gridColumnDescriptor2.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
gridColumnDescriptor2.MappingName = "CategoryName";
gridColumnDescriptor2.SerializedImageArray = "";
gridColumnDescriptor3.HeaderImage = null;
gridColumnDescriptor3.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
gridColumnDescriptor3.MappingName = "Description";
gridColumnDescriptor3.SerializedImageArray = "";
gridColumnDescriptor3.Width = 250;
gridColumnDescriptor4.HeaderImage = null;
gridColumnDescriptor4.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
gridColumnDescriptor4.MappingName = "Picture";
gridColumnDescriptor4.SerializedImageArray = "";
this.gridGroupingControl1.TableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] {
gridColumnDescriptor1,
gridColumnDescriptor2,
gridColumnDescriptor3,
gridColumnDescriptor4
});
this.gridGroupingControl1.TableOptions.RecordRowHeight = 57;
this.gridGroupingControl1.Text = "gridGroupingControl1";
//
// propertyGrid1
//
this.propertyGrid1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Right)));
this.propertyGrid1.BackColor = System.Drawing.Color.White;
this.propertyGrid1.CommandsBackColor = System.Drawing.Color.White;
this.propertyGrid1.CommandsDisabledLinkColor = System.Drawing.Color.White;
this.propertyGrid1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.propertyGrid1.HelpBackColor = System.Drawing.Color.White;
this.propertyGrid1.LineColor = System.Drawing.Color.White;
this.propertyGrid1.Location = new System.Drawing.Point(720, 16);
this.propertyGrid1.Name = "propertyGrid1";
this.propertyGrid1.Size = new System.Drawing.Size(276, 589);
this.propertyGrid1.TabIndex = 13;
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.ClientSize = new System.Drawing.Size(1012, 653);
this.Controls.Add(this.propertyGrid1);
this.Controls.Add(this.reset);
this.Controls.Add(this.btnLoadXmlSchema);
this.Controls.Add(this.btnSaveXmlSchema);
this.Controls.Add(this.gridGroupingControl1);
this.MinimumSize = new System.Drawing.Size(800, 400);
this.Name = "Form1";
this.Text = "XML Serialization";
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit();
this.ResumeLayout(false);
}
