/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Form1));
this.c1TrueDBGrid1 = new C1.Win.C1TrueDBGrid.C1TrueDBGrid();
this.dsContacts1 = new Tutorial18.dsContacts();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbDeleteCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.oleDbInsertCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand2 = new System.Data.OleDb.OleDbCommand();
this.c1TrueDBDropdown1 = new C1.Win.C1TrueDBGrid.C1TrueDBDropdown();
this.dsCustType1 = new Tutorial18.dsCustType();
this.oleDbDataAdapter2 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBGrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsContacts1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBDropdown1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsCustType1)).BeginInit();
this.SuspendLayout();
//
// c1TrueDBGrid1
//
this.c1TrueDBGrid1.AllowAddNew = true;
this.c1TrueDBGrid1.Caption = "C1TrueDBGrid.Net";
this.c1TrueDBGrid1.CaptionHeight = 17;
this.c1TrueDBGrid1.DataMember = "Customer";
this.c1TrueDBGrid1.DataSource = this.dsContacts1;
this.c1TrueDBGrid1.GroupByCaption = "Drag a column header here to group by that column";
this.c1TrueDBGrid1.Images.Add(((System.Drawing.Bitmap)(resources.GetObject("resource.Images"))));
this.c1TrueDBGrid1.Location = new System.Drawing.Point(8, 8);
this.c1TrueDBGrid1.MarqueeStyle = C1.Win.C1TrueDBGrid.MarqueeEnum.DottedCellBorder;
this.c1TrueDBGrid1.Name = "c1TrueDBGrid1";
this.c1TrueDBGrid1.PreviewInfo.Location = new System.Drawing.Point(0, 0);
this.c1TrueDBGrid1.PreviewInfo.Size = new System.Drawing.Size(0, 0);
this.c1TrueDBGrid1.PreviewInfo.ZoomFactor = 75;
this.c1TrueDBGrid1.RecordSelectorWidth = 17;
this.c1TrueDBGrid1.RowDivider.Color = System.Drawing.Color.DarkGray;
this.c1TrueDBGrid1.RowDivider.Style = C1.Win.C1TrueDBGrid.LineStyleEnum.Single;
this.c1TrueDBGrid1.RowHeight = 15;
this.c1TrueDBGrid1.RowSubDividerColor = System.Drawing.Color.DarkGray;
this.c1TrueDBGrid1.Size = new System.Drawing.Size(504, 272);
this.c1TrueDBGrid1.TabIndex = 0;
this.c1TrueDBGrid1.Text = "c1TrueDBGrid1";
this.c1TrueDBGrid1.UnboundColumnFetch += new C1.Win.C1TrueDBGrid.UnboundColumnFetchEventHandler(this.c1TrueDBGrid1_UnboundColumnFetch);
this.c1TrueDBGrid1.PropBag = "<?xml version=\"1.0\"?><Blob><DataCols><C1DataColumn Level=\"0\" Caption=\"Company\" Da" +
"taField=\"Company\"><ValueItems /><GroupInfo /></C1DataColumn><C1DataColumn Level=" +
"\"0\" Caption=\"Contacted\" DataField=\"Contacted\"><ValueItems /><GroupInfo /></C1Dat" +
"aColumn><C1DataColumn Level=\"0\" Caption=\"CustType\" DataField=\"CustType\"><ValueIt" +
"ems /><GroupInfo /></C1DataColumn><C1DataColumn Level=\"0\" Caption=\"FirstName\" Da" +
"taField=\"FirstName\"><ValueItems /><GroupInfo /></C1DataColumn><C1DataColumn Leve" +
"l=\"0\" Caption=\"LastName\" DataField=\"LastName\"><ValueItems /><GroupInfo /></C1Dat" +
"aColumn><C1DataColumn Level=\"0\" Caption=\"Phone\" DataField=\"Phone\"><ValueItems />" +
"<GroupInfo /></C1DataColumn><C1DataColumn Level=\"0\" Caption=\"UserCode\" DataField" +
"=\"UserCode\"><ValueItems /><GroupInfo /></C1DataColumn></DataCols><Styles type=\"C" +
"1.Win.C1TrueDBGrid.Design.ContextWrapper\"><Data>Style195{}Style161{AlignHorz:Far" +
";}Style166{AlignHorz:Far;}Style185{AlignHorz:Far;}Style186{}Style50{}Style51{}St" +
"yle157{}Caption{AlignHorz:Center;}Style179{AlignHorz:Near;}Normal{Font:Tahoma, 1" +
"1world;}Style194{}Selected{ForeColor:HighlightText;BackColor:Highlight;}Style173" +
"{AlignHorz:Near;}Editor{}Style171{}Style170{}Style177{}Style176{}Style175{}Style" +
"174{}Style10{AlignHorz:Near;}Style11{}Style12{}Style13{}EvenRow{BackColor:Aqua;}" +
"Style191{AlignHorz:Near;}Style190{AlignHorz:Near;}Style193{}Style192{}Group{Alig" +
"nVert:Center;Border:None,,0, 0, 0, 0;BackColor:ControlDark;}Style168{}Style169{}" +
"Style162{}Style163{}Style160{AlignHorz:Far;}Style159{}Style158{}Style167{AlignHo" +
"rz:Far;}Style164{}Style165{}HighlightRow{ForeColor:HighlightText;BackColor:Highl" +
"ight;}RecordSelector{AlignImage:Center;}Footer{}Style178{AlignHorz:Near;}Style18" +
"4{AlignHorz:Far;}Style155{AlignHorz:Near;}Style154{AlignHorz:Near;}Style187{}Sty" +
"le156{}Style172{AlignHorz:Near;}Style182{}Style183{}Heading{Wrap:True;BackColor:" +
"Control;Border:Raised,,1, 1, 1, 1;ForeColor:ControlText;AlignVert:Center;}Style1" +
"88{}Style189{}Style180{}Inactive{ForeColor:InactiveCaptionText;BackColor:Inactiv" +
"eCaption;}FilterBar{}Style9{}Style8{}OddRow{}Style5{}Style4{}Style7{}Style6{}Sty" +
"le1{}Style181{}Style3{}Style2{}</Data></Styles><Splits><C1.Win.C1TrueDBGrid.Merg" +
"eView Name=\"\" CaptionHeight=\"17\" ColumnCaptionHeight=\"17\" ColumnFooterHeight=\"17" +
"\" MarqueeStyle=\"DottedCellBorder\" RecordSelectorWidth=\"17\" DefRecSelWidth=\"17\" V" +
"erticalScrollGroup=\"1\" HorizontalScrollGroup=\"1\"><ClientRect>0, 17, 500, 251</Cl" +
"ientRect><BorderSide>0</BorderSide><CaptionStyle parent=\"Style2\" me=\"Style10\" />" +
"<EditorStyle parent=\"Editor\" me=\"Style5\" /><EvenRowStyle parent=\"EvenRow\" me=\"St" +
"yle8\" /><FilterBarStyle parent=\"FilterBar\" me=\"Style13\" /><FooterStyle parent=\"F" +
"ooter\" me=\"Style3\" /><GroupStyle parent=\"Group\" me=\"Style12\" /><HeadingStyle par" +
"ent=\"Heading\" me=\"Style2\" /><HighLightRowStyle parent=\"HighlightRow\" me=\"Style7\"" +
" /><InactiveStyle parent=\"Inactive\" me=\"Style4\" /><OddRowStyle parent=\"OddRow\" m" +
"e=\"Style9\" /><RecordSelectorStyle parent=\"RecordSelector\" me=\"Style11\" /><Select" +
"edStyle parent=\"Selected\" me=\"Style6\" /><Style parent=\"Normal\" me=\"Style1\" /><in" +
"ternalCols><C1DisplayColumn><HeadingStyle parent=\"Style2\" me=\"Style154\" /><Style" +
" parent=\"Style1\" me=\"Style155\" /><FooterStyle parent=\"Style3\" me=\"Style156\" /><E" +
"ditorStyle parent=\"Style5\" me=\"Style157\" /><GroupHeaderStyle parent=\"Style1\" me=" +
"\"Style159\" /><GroupFooterStyle parent=\"Style1\" me=\"Style158\" /><Visible>True</Vi" +
"sible><ColumnDivider>DarkGray,Single</ColumnDivider><Height>15</Height><DCIdx>0<" +
"/DCIdx></C1DisplayColumn><C1DisplayColumn><HeadingStyle parent=\"Style2\" me=\"Styl" +
"e160\" /><Style parent=\"Style1\" me=\"Style161\" /><FooterStyle parent=\"Style3\" me=\"" +
"Style162\" /><EditorStyle parent=\"Style5\" me=\"Style163\" /><GroupHeaderStyle paren" +
"t=\"Style1\" me=\"Style165\" /><GroupFooterStyle parent=\"Style1\" me=\"Style164\" /><Vi" +
"sible>True</Visible><ColumnDivider>DarkGray,Single</ColumnDivider><Height>15</He" +
"ight><DCIdx>1</DCIdx></C1DisplayColumn><C1DisplayColumn><HeadingStyle parent=\"St" +
"yle2\" me=\"Style166\" /><Style parent=\"Style1\" me=\"Style167\" /><FooterStyle parent" +
"=\"Style3\" me=\"Style168\" /><EditorStyle parent=\"Style5\" me=\"Style169\" /><GroupHea" +
"derStyle parent=\"Style1\" me=\"Style171\" /><GroupFooterStyle parent=\"Style1\" me=\"S" +
"tyle170\" /><Visible>True</Visible><ColumnDivider>DarkGray,Single</ColumnDivider>" +
"<Width>66</Width><Height>15</Height><DCIdx>2</DCIdx></C1DisplayColumn><C1Display" +
"Column><HeadingStyle parent=\"Style2\" me=\"Style172\" /><Style parent=\"Style1\" me=\"" +
"Style173\" /><FooterStyle parent=\"Style3\" me=\"Style174\" /><EditorStyle parent=\"St" +
"yle5\" me=\"Style175\" /><GroupHeaderStyle parent=\"Style1\" me=\"Style177\" /><GroupFo" +
"oterStyle parent=\"Style1\" me=\"Style176\" /><Visible>True</Visible><ColumnDivider>" +
"DarkGray,Single</ColumnDivider><Height>15</Height><DCIdx>3</DCIdx></C1DisplayCol" +
"umn><C1DisplayColumn><HeadingStyle parent=\"Style2\" me=\"Style178\" /><Style parent" +
"=\"Style1\" me=\"Style179\" /><FooterStyle parent=\"Style3\" me=\"Style180\" /><EditorSt" +
"yle parent=\"Style5\" me=\"Style181\" /><GroupHeaderStyle parent=\"Style1\" me=\"Style1" +
"83\" /><GroupFooterStyle parent=\"Style1\" me=\"Style182\" /><Visible>True</Visible><" +
"ColumnDivider>DarkGray,Single</ColumnDivider><Height>15</Height><DCIdx>4</DCIdx>" +
"</C1DisplayColumn><C1DisplayColumn><HeadingStyle parent=\"Style2\" me=\"Style184\" /" +
"><Style parent=\"Style1\" me=\"Style185\" /><FooterStyle parent=\"Style3\" me=\"Style18" +
"6\" /><EditorStyle parent=\"Style5\" me=\"Style187\" /><GroupHeaderStyle parent=\"Styl" +
"e1\" me=\"Style189\" /><GroupFooterStyle parent=\"Style1\" me=\"Style188\" /><Visible>T" +
"rue</Visible><ColumnDivider>DarkGray,Single</ColumnDivider><Height>15</Height><D" +
"CIdx>5</DCIdx></C1DisplayColumn><C1DisplayColumn><HeadingStyle parent=\"Style2\" m" +
"e=\"Style190\" /><Style parent=\"Style1\" me=\"Style191\" /><FooterStyle parent=\"Style" +
"3\" me=\"Style192\" /><EditorStyle parent=\"Style5\" me=\"Style193\" /><GroupHeaderStyl" +
"e parent=\"Style1\" me=\"Style195\" /><GroupFooterStyle parent=\"Style1\" me=\"Style194" +
"\" /><Visible>True</Visible><ColumnDivider>DarkGray,Single</ColumnDivider><Height" +
">15</Height><DCIdx>6</DCIdx></C1DisplayColumn></internalCols></C1.Win.C1TrueDBGr" +
"id.MergeView></Splits><NamedStyles><Style parent=\"\" me=\"Normal\" /><Style parent=" +
"\"Normal\" me=\"Heading\" /><Style parent=\"Heading\" me=\"Footer\" /><Style parent=\"Hea" +
"ding\" me=\"Caption\" /><Style parent=\"Heading\" me=\"Inactive\" /><Style parent=\"Norm" +
"al\" me=\"Selected\" /><Style parent=\"Normal\" me=\"Editor\" /><Style parent=\"Normal\" " +
"me=\"HighlightRow\" /><Style parent=\"Normal\" me=\"EvenRow\" /><Style parent=\"Normal\"" +
" me=\"OddRow\" /><Style parent=\"Heading\" me=\"RecordSelector\" /><Style parent=\"Norm" +
"al\" me=\"FilterBar\" /><Style parent=\"Caption\" me=\"Group\" /></NamedStyles><vertSpl" +
"its>1</vertSplits><horzSplits>1</horzSplits><Layout>Modified</Layout><DefaultRec" +
"SelWidth>17</DefaultRecSelWidth><ClientArea>0, 0, 500, 268</ClientArea><PrintPag" +
"eHeaderStyle parent=\"\" me=\"Style50\" /><PrintPageFooterStyle parent=\"\" me=\"Style5" +
"1\" /></Blob>";
//
// dsContacts1
//
this.dsContacts1.DataSetName = "dsContacts";
this.dsContacts1.Locale = new System.Globalization.CultureInfo("en-US");
this.dsContacts1.Namespace = "http://www.tempuri.org/dsContacts.xsd";
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand2;
this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand2;
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Customer", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("Company", "Company"),
new System.Data.Common.DataColumnMapping("Contacted", "Contacted"),
new System.Data.Common.DataColumnMapping("CustType", "CustType"),
new System.Data.Common.DataColumnMapping("FirstName", "FirstName"),
new System.Data.Common.DataColumnMapping("LastName", "LastName"),
new System.Data.Common.DataColumnMapping("Phone", "Phone"),
new System.Data.Common.DataColumnMapping("UserCode", "UserCode")
})
});
this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand2;
//
// oleDbDeleteCommand2
//
this.oleDbDeleteCommand2.CommandText = @"DELETE FROM Customer WHERE (UserCode = ?) AND (Company = ? OR ? IS NULL AND Company IS NULL) AND (Contacted = ? OR ? IS NULL AND Contacted IS NULL) AND (CustType = ? OR ? IS NULL AND CustType IS NULL) AND (FirstName = ? OR ? IS NULL AND FirstName IS NULL) AND (LastName = ? OR ? IS NULL AND LastName IS NULL) AND (Phone = ? OR ? IS NULL AND Phone IS NULL)";
this.oleDbDeleteCommand2.Connection = this.oleDbConnection1;
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_UserCode", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserCode", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Company", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Company", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Company1", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Company", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Contacted", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Contacted", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Contacted1", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Contacted", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CustType", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(0)), "CustType", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CustType1", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(0)), "CustType", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FirstName", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FirstName", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FirstName1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FirstName", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_LastName", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "LastName", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_LastName1", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "LastName", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Phone", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "Phone", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Phone1", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "Phone", System.Data.DataRowVersion.Original, null));
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=C:\Program Files\ComponentOne Studio.NET 2.0\Common\TDBGDemo.mdb;Mode=Share Deny None;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False";
//
// oleDbInsertCommand2
//
this.oleDbInsertCommand2.CommandText = "INSERT INTO Customer(Company, Contacted, CustType, FirstName, LastName, Phone, U" +
"serCode) VALUES (?, ?, ?, ?, ?, ?, ?)";
this.oleDbInsertCommand2.Connection = this.oleDbConnection1;
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Company", System.Data.OleDb.OleDbType.VarWChar, 30, "Company"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Contacted", System.Data.OleDb.OleDbType.DBDate, 0, "Contacted"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("CustType", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(0)), "CustType", System.Data.DataRowVersion.Current, null));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("FirstName", System.Data.OleDb.OleDbType.VarWChar, 10, "FirstName"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("LastName", System.Data.OleDb.OleDbType.VarWChar, 15, "LastName"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Phone", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "Phone", System.Data.DataRowVersion.Current, null));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("UserCode", System.Data.OleDb.OleDbType.VarWChar, 4, "UserCode"));
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT Company, Contacted, CustType, FirstName, LastName, Phone, UserCode FROM Cu" +
"stomer";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbUpdateCommand2
//
this.oleDbUpdateCommand2.CommandText = @"UPDATE Customer SET Company = ?, Contacted = ?, CustType = ?, FirstName = ?, LastName = ?, Phone = ?, UserCode = ? WHERE (UserCode = ?) AND (Company = ? OR ? IS NULL AND Company IS NULL) AND (Contacted = ? OR ? IS NULL AND Contacted IS NULL) AND (CustType = ? OR ? IS NULL AND CustType IS NULL) AND (FirstName = ? OR ? IS NULL AND FirstName IS NULL) AND (LastName = ? OR ? IS NULL AND LastName IS NULL) AND (Phone = ? OR ? IS NULL AND Phone IS NULL)";
this.oleDbUpdateCommand2.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Company", System.Data.OleDb.OleDbType.VarWChar, 30, "Company"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Contacted", System.Data.OleDb.OleDbType.DBDate, 0, "Contacted"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("CustType", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(0)), "CustType", System.Data.DataRowVersion.Current, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("FirstName", System.Data.OleDb.OleDbType.VarWChar, 10, "FirstName"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("LastName", System.Data.OleDb.OleDbType.VarWChar, 15, "LastName"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Phone", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "Phone", System.Data.DataRowVersion.Current, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("UserCode", System.Data.OleDb.OleDbType.VarWChar, 4, "UserCode"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_UserCode", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserCode", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Company", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Company", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Company1", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Company", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Contacted", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Contacted", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Contacted1", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Contacted", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CustType", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(0)), "CustType", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CustType1", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(0)), "CustType", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FirstName", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FirstName", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FirstName1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FirstName", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_LastName", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "LastName", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_LastName1", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "LastName", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Phone", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "Phone", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Phone1", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "Phone", System.Data.DataRowVersion.Original, null));
//
// c1TrueDBDropdown1
//
this.c1TrueDBDropdown1.AllowColMove = true;
this.c1TrueDBDropdown1.AllowColSelect = true;
this.c1TrueDBDropdown1.AllowRowSizing = C1.Win.C1TrueDBGrid.RowSizingEnum.AllRows;
this.c1TrueDBDropdown1.AlternatingRows = false;
this.c1TrueDBDropdown1.CaptionHeight = 17;
this.c1TrueDBDropdown1.ColumnCaptionHeight = 17;
this.c1TrueDBDropdown1.ColumnFooterHeight = 17;
this.c1TrueDBDropdown1.ValueMember = "CustType.TypeId";
this.c1TrueDBDropdown1.DataMember = "CustType";
this.c1TrueDBDropdown1.DataSource = this.dsCustType1;
this.c1TrueDBDropdown1.FetchRowStyles = false;
this.c1TrueDBDropdown1.Images.Add(((System.Drawing.Bitmap)(resources.GetObject("resource.Images1"))));
this.c1TrueDBDropdown1.LayoutFileName = "";
this.c1TrueDBDropdown1.LayoutName = "";
this.c1TrueDBDropdown1.LayoutURL = "";
this.c1TrueDBDropdown1.DisplayMember = "CustType.TypeDesc";
this.c1TrueDBDropdown1.Location = new System.Drawing.Point(264, 136);
this.c1TrueDBDropdown1.Name = "c1TrueDBDropdown1";
this.c1TrueDBDropdown1.RowDivider.Color = System.Drawing.Color.DarkGray;
this.c1TrueDBDropdown1.RowDivider.Style = C1.Win.C1TrueDBGrid.LineStyleEnum.Single;
this.c1TrueDBDropdown1.RowHeight = 15;
this.c1TrueDBDropdown1.RowSubDividerColor = System.Drawing.Color.DarkGray;
this.c1TrueDBDropdown1.ScrollTips = false;
this.c1TrueDBDropdown1.Size = new System.Drawing.Size(192, 120);
this.c1TrueDBDropdown1.TabIndex = 1;
this.c1TrueDBDropdown1.Text = "c1TrueDBDropdown1";
this.c1TrueDBDropdown1.ValueTranslate = true;
this.c1TrueDBDropdown1.Visible = false;
this.c1TrueDBDropdown1.PropBag = "<?xml version=\"1.0\"?><Blob><DataCols><C1DataColumn Level=\"0\" Caption=\"TypeDesc\" D" +
"ataField=\"TypeDesc\"><ValueItems /><GroupInfo /></C1DataColumn><C1DataColumn Leve" +
"l=\"0\" Caption=\"TypeId\" DataField=\"TypeId\"><ValueItems /><GroupInfo /></C1DataCol" +
"umn></DataCols><Styles type=\"C1.Win.C1TrueDBGrid.Design.ContextWrapper\"><Data>Ca" +
"ption{AlignHorz:Center;}Normal{}Selected{ForeColor:HighlightText;BackColor:Highl" +
"ight;}Editor{}Style10{AlignHorz:Near;}Style11{}Style12{}Style13{}Style140{AlignH" +
"orz:Near;}Style139{}Style138{}Style137{}Style136{}Style135{AlignHorz:Near;}Style" +
"134{AlignHorz:Near;}OddRow{}HighlightRow{ForeColor:HighlightText;BackColor:Highl" +
"ight;}RecordSelector{AlignImage:Center;}Footer{}Inactive{ForeColor:InactiveCapti" +
"onText;BackColor:InactiveCaption;}EvenRow{BackColor:Aqua;}Heading{Wrap:True;Back" +
"Color:Control;Border:Raised,,1, 1, 1, 1;ForeColor:ControlText;AlignVert:Center;}" +
"Style7{}Style6{}FilterBar{}Style3{}Style4{}Style9{}Style8{}Style1{}Style5{}Group" +
"{AlignVert:Center;Border:None,,0, 0, 0, 0;BackColor:ControlDark;}Style141{AlignH" +
"orz:Near;}Style142{}Style143{}Style144{}Style145{}Style2{}</Data></Styles><Split" +
"s><C1.Win.C1TrueDBGrid.DropdownView Name=\"\" CaptionHeight=\"17\" ColumnCaptionHeig" +
"ht=\"17\" ColumnFooterHeight=\"17\" MarqueeStyle=\"DottedCellBorder\" RecordSelectorWi" +
"dth=\"16\" RecordSelectors=\"False\" VerticalScrollGroup=\"1\" HorizontalScrollGroup=\"" +
"1\"><ClientRect>0, 0, 188, 116</ClientRect><internalCols><C1DropDisplayColumn><DC" +
"Idx>0</DCIdx><HeadingStyle parent=\"Style2\" me=\"Style134\" /><Style parent=\"Style1" +
"\" me=\"Style135\" /><FooterStyle parent=\"Style3\" me=\"Style136\" /><EditorStyle pare" +
"nt=\"Style5\" me=\"Style137\" /><GroupHeaderStyle parent=\"Style1\" me=\"Style139\" /><G" +
"roupFooterStyle parent=\"Style1\" me=\"Style138\" /><Visible>True</Visible><ColumnDi" +
"vider>DarkGray,Single</ColumnDivider><Height>15</Height></C1DropDisplayColumn><C" +
"1DropDisplayColumn><DCIdx>1</DCIdx><HeadingStyle parent=\"Style2\" me=\"Style140\" /" +
"><Style parent=\"Style1\" me=\"Style141\" /><FooterStyle parent=\"Style3\" me=\"Style14" +
"2\" /><EditorStyle parent=\"Style5\" me=\"Style143\" /><GroupHeaderStyle parent=\"Styl" +
"e1\" me=\"Style145\" /><GroupFooterStyle parent=\"Style1\" me=\"Style144\" /><Visible>T" +
"rue</Visible><ColumnDivider>DarkGray,Single</ColumnDivider><Height>15</Height></" +
"C1DropDisplayColumn></internalCols><CaptionStyle parent=\"Style2\" me=\"Style10\" />" +
"<EditorStyle parent=\"Editor\" me=\"Style5\" /><EvenRowStyle parent=\"EvenRow\" me=\"St" +
"yle8\" /><FilterBarStyle parent=\"FilterBar\" me=\"Style13\" /><FooterStyle parent=\"F" +
"ooter\" me=\"Style3\" /><GroupStyle parent=\"Group\" me=\"Style12\" /><HeadingStyle par" +
"ent=\"Heading\" me=\"Style2\" /><HighLightRowStyle parent=\"HighlightRow\" me=\"Style7\"" +
" /><InactiveStyle parent=\"Inactive\" me=\"Style4\" /><OddRowStyle parent=\"OddRow\" m" +
"e=\"Style9\" /><RecordSelectorStyle parent=\"RecordSelector\" me=\"Style11\" /><Select" +
"edStyle parent=\"Selected\" me=\"Style6\" /><Style parent=\"Normal\" me=\"Style1\" /></C" +
"1.Win.C1TrueDBGrid.DropdownView></Splits><NamedStyles><Style parent=\"\" me=\"Norma" +
"l\" /><Style parent=\"Normal\" me=\"Heading\" /><Style parent=\"Heading\" me=\"Footer\" /" +
"><Style parent=\"Heading\" me=\"Caption\" /><Style parent=\"Heading\" me=\"Inactive\" />" +
"<Style parent=\"Normal\" me=\"Selected\" /><Style parent=\"Normal\" me=\"Editor\" /><Sty" +
"le parent=\"Normal\" me=\"HighlightRow\" /><Style parent=\"Normal\" me=\"EvenRow\" /><St" +
"yle parent=\"Normal\" me=\"OddRow\" /><Style parent=\"Heading\" me=\"RecordSelector\" />" +
"<Style parent=\"Normal\" me=\"FilterBar\" /><Style parent=\"Caption\" me=\"Group\" /></N" +
"amedStyles><vertSplits>1</vertSplits><horzSplits>1</horzSplits><Layout>Modified<" +
"/Layout><DefaultRecSelWidth>17</DefaultRecSelWidth><ClientArea>0, 0, 188, 116</C" +
"lientArea></Blob>";
//
// dsCustType1
//
this.dsCustType1.DataSetName = "dsCustType";
this.dsCustType1.Locale = new System.Globalization.CultureInfo("en-US");
this.dsCustType1.Namespace = "http://www.tempuri.org/dsCustType.xsd";
//
// oleDbDataAdapter2
//
this.oleDbDataAdapter2.DeleteCommand = this.oleDbDeleteCommand1;
this.oleDbDataAdapter2.InsertCommand = this.oleDbInsertCommand1;
this.oleDbDataAdapter2.SelectCommand = this.oleDbSelectCommand2;
this.oleDbDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "CustType", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("TypeDesc", "TypeDesc"),
new System.Data.Common.DataColumnMapping("TypeId", "TypeId")
})
});
this.oleDbDataAdapter2.UpdateCommand = this.oleDbUpdateCommand1;
//
// oleDbDeleteCommand1
//
this.oleDbDeleteCommand1.CommandText = "DELETE FROM CustType WHERE (TypeId = ?) AND (TypeDesc = ? OR ? IS NULL AND TypeDe" +
"sc IS NULL)";
this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_TypeId", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TypeId", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_TypeDesc", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TypeDesc", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_TypeDesc1", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TypeDesc", System.Data.DataRowVersion.Original, null));
//
// oleDbInsertCommand1
//
this.oleDbInsertCommand1.CommandText = "INSERT INTO CustType(TypeDesc, TypeId) VALUES (?, ?)";
this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("TypeDesc", System.Data.OleDb.OleDbType.VarWChar, 15, "TypeDesc"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("TypeId", System.Data.OleDb.OleDbType.VarWChar, 1, "TypeId"));
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = "SELECT TypeDesc, TypeId FROM CustType";
this.oleDbSelectCommand2.Connection = this.oleDbConnection1;
//
// oleDbUpdateCommand1
//
this.oleDbUpdateCommand1.CommandText = "UPDATE CustType SET TypeDesc = ?, TypeId = ? WHERE (TypeId = ?) AND (TypeDesc = ?" +
" OR ? IS NULL AND TypeDesc IS NULL)";
this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("TypeDesc", System.Data.OleDb.OleDbType.VarWChar, 15, "TypeDesc"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("TypeId", System.Data.OleDb.OleDbType.VarWChar, 1, "TypeId"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_TypeId", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TypeId", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_TypeDesc", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TypeDesc", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_TypeDesc1", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TypeDesc", System.Data.DataRowVersion.Original, null));
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(536, 294);
this.Controls.AddRange(new System.Windows.Forms.Control[] {
this.c1TrueDBDropdown1,
this.c1TrueDBGrid1
});
this.Name = "Form1";
this.Text = "Tutorial 18";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsContacts1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBDropdown1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsCustType1)).EndInit();
this.ResumeLayout(false);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Form1));
this.c1TrueDBGrid1 = new C1.Win.C1TrueDBGrid.C1TrueDBGrid();
this.dsContacts1 = new Tutorial08.DsContacts();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection2 = new System.Data.OleDb.OleDbConnection();
this.c1TrueDBDropdown1 = new C1.Win.C1TrueDBGrid.C1TrueDBDropdown();
this.dsCustType1 = new Tutorial08.DsCustType();
this.oleDbDataAdapter2 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBGrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsContacts1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBDropdown1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsCustType1)).BeginInit();
this.SuspendLayout();
//
// c1TrueDBGrid1
//
this.c1TrueDBGrid1.AllowAddNew = true;
this.c1TrueDBGrid1.Caption = "C1True DBGrid .Net";
this.c1TrueDBGrid1.CaptionHeight = 17;
this.c1TrueDBGrid1.DataMember = "Contacts";
this.c1TrueDBGrid1.DataSource = this.dsContacts1;
this.c1TrueDBGrid1.GroupByCaption = "Drag a column header here to group by that column";
this.c1TrueDBGrid1.Images.Add(((System.Drawing.Bitmap)(resources.GetObject("resource.Images"))));
this.c1TrueDBGrid1.Location = new System.Drawing.Point(16, 8);
this.c1TrueDBGrid1.MarqueeStyle = C1.Win.C1TrueDBGrid.MarqueeEnum.DottedCellBorder;
this.c1TrueDBGrid1.Name = "c1TrueDBGrid1";
this.c1TrueDBGrid1.PreviewInfo.Location = new System.Drawing.Point(0, 0);
this.c1TrueDBGrid1.PreviewInfo.Size = new System.Drawing.Size(0, 0);
this.c1TrueDBGrid1.PreviewInfo.ZoomFactor = 75;
this.c1TrueDBGrid1.RecordSelectorWidth = 17;
this.c1TrueDBGrid1.RowDivider.Color = System.Drawing.Color.DarkGray;
this.c1TrueDBGrid1.RowDivider.Style = C1.Win.C1TrueDBGrid.LineStyleEnum.Single;
this.c1TrueDBGrid1.RowHeight = 15;
this.c1TrueDBGrid1.RowSubDividerColor = System.Drawing.Color.DarkGray;
this.c1TrueDBGrid1.Size = new System.Drawing.Size(480, 208);
this.c1TrueDBGrid1.TabIndex = 0;
this.c1TrueDBGrid1.Text = "c1TrueDBGrid1";
this.c1TrueDBGrid1.UnboundColumnFetch += new C1.Win.C1TrueDBGrid.UnboundColumnFetchEventHandler(this.c1TrueDBGrid1_UnboundColumnFetch);
this.c1TrueDBGrid1.PropBag = "<?xml version=\"1.0\"?><Blob><DataCols><C1DataColumn Level=\"0\" Caption=\"Name\" DataF" +
"ield=\"\"><ValueItems /><GroupInfo /></C1DataColumn><C1DataColumn Level=\"0\" Captio" +
"n=\"FirstName\" DataField=\"FirstName\"><ValueItems /><GroupInfo /></C1DataColumn><C" +
"1DataColumn Level=\"0\" Caption=\"LastName\" DataField=\"LastName\"><ValueItems /><Gro" +
"upInfo /></C1DataColumn><C1DataColumn Level=\"0\" Caption=\"CustType\" DataField=\"Cu" +
"stType\"><ValueItems /><GroupInfo /></C1DataColumn><C1DataColumn Level=\"0\" Captio" +
"n=\"ContactType\" DataField=\"ContactType\"><ValueItems /><GroupInfo /></C1DataColum" +
"n><C1DataColumn Level=\"0\" Caption=\"Callback\" DataField=\"Callback\"><ValueItems />" +
"<GroupInfo /></C1DataColumn><C1DataColumn Level=\"0\" Caption=\"ContactDate\" DataFi" +
"eld=\"ContactDate\"><ValueItems /><GroupInfo /></C1DataColumn><C1DataColumn Level=" +
"\"0\" Caption=\"UserCode\" DataField=\"UserCode\"><ValueItems /><GroupInfo /></C1DataC" +
"olumn><C1DataColumn Level=\"0\" Caption=\"Expr1\" DataField=\"Expr1\"><ValueItems /><G" +
"roupInfo /></C1DataColumn></DataCols><Styles type=\"C1.Win.C1TrueDBGrid.Design.Co" +
"ntextWrapper\"><Data>HighlightRow{ForeColor:HighlightText;BackColor:Highlight;}In" +
"active{ForeColor:InactiveCaptionText;BackColor:InactiveCaption;}Selected{ForeCol" +
"or:HighlightText;BackColor:Highlight;}Editor{}FilterBar{}Heading{Wrap:True;BackC" +
"olor:Control;Border:Raised,,1, 1, 1, 1;ForeColor:ControlText;AlignVert:Center;}S" +
"tyle18{AlignHorz:Near;}Style19{AlignHorz:Near;}Style14{AlignHorz:Near;}Style15{A" +
"lignHorz:Near;}Style16{}Style17{}Style10{AlignHorz:Near;}Style11{}Style12{}Style" +
"13{}Style27{AlignHorz:Far;}Style29{}Style28{}Style26{AlignHorz:Far;}Style25{}Sty" +
"le9{}Style8{}Style24{}Style23{AlignHorz:Far;}Style5{}Style4{}Style7{}Style6{}Sty" +
"le1{}Style22{AlignHorz:Far;}Style3{}Style2{}Style21{}Style20{}OddRow{}Style38{Al" +
"ignHorz:Near;}Style39{AlignHorz:Near;}Style36{}Style37{}Style34{AlignHorz:Far;}S" +
"tyle35{AlignHorz:Far;}Style32{}Style33{}Style30{AlignHorz:Center;}Style49{}Style" +
"48{}Style31{AlignHorz:Center;}Normal{}Style41{}Style40{}Style43{AlignHorz:Near;}" +
"Style42{AlignHorz:Near;}Style45{}Style44{}Style47{AlignHorz:Near;}Style46{AlignH" +
"orz:Near;}EvenRow{BackColor:Aqua;}Style59{}Style58{}RecordSelector{AlignImage:Ce" +
"nter;}Style51{}Style50{}Footer{}Style52{}Style53{}Style54{}Style55{}Style56{}Sty" +
"le57{}Caption{AlignHorz:Center;}Style69{}Style68{}Style63{}Style62{}Style61{}Sty" +
"le60{}Style67{}Style66{}Style65{}Style64{}Group{AlignVert:Center;Border:None,,0," +
" 0, 0, 0;BackColor:ControlDark;}</Data></Styles><Splits><C1.Win.C1TrueDBGrid.Mer" +
"geView Name=\"\" CaptionHeight=\"17\" ColumnCaptionHeight=\"17\" ColumnFooterHeight=\"1" +
"7\" MarqueeStyle=\"DottedCellBorder\" RecordSelectorWidth=\"17\" DefRecSelWidth=\"17\" " +
"VerticalScrollGroup=\"1\" HorizontalScrollGroup=\"1\"><ClientRect>0, 17, 476, 187</C" +
"lientRect><BorderSide>0</BorderSide><CaptionStyle parent=\"Style2\" me=\"Style10\" /" +
"><EditorStyle parent=\"Editor\" me=\"Style5\" /><EvenRowStyle parent=\"EvenRow\" me=\"S" +
"tyle8\" /><FilterBarStyle parent=\"FilterBar\" me=\"Style13\" /><FooterStyle parent=\"" +
"Footer\" me=\"Style3\" /><GroupStyle parent=\"Group\" me=\"Style12\" /><HeadingStyle pa" +
"rent=\"Heading\" me=\"Style2\" /><HighLightRowStyle parent=\"HighlightRow\" me=\"Style7" +
"\" /><InactiveStyle parent=\"Inactive\" me=\"Style4\" /><OddRowStyle parent=\"OddRow\" " +
"me=\"Style9\" /><RecordSelectorStyle parent=\"RecordSelector\" me=\"Style11\" /><Selec" +
"tedStyle parent=\"Selected\" me=\"Style6\" /><Style parent=\"Normal\" me=\"Style1\" /><i" +
"nternalCols><C1DisplayColumn><HeadingStyle parent=\"Style2\" me=\"Style46\" /><Style" +
" parent=\"Style1\" me=\"Style47\" /><FooterStyle parent=\"Style3\" me=\"Style48\" /><Edi" +
"torStyle parent=\"Style5\" me=\"Style49\" /><GroupHeaderStyle parent=\"Style1\" me=\"St" +
"yle53\" /><GroupFooterStyle parent=\"Style1\" me=\"Style52\" /><ColumnDivider>DarkGra" +
"y,Single</ColumnDivider><Height>15</Height><DCIdx>0</DCIdx></C1DisplayColumn><C1" +
"DisplayColumn><HeadingStyle parent=\"Style2\" me=\"Style14\" /><Style parent=\"Style1" +
"\" me=\"Style15\" /><FooterStyle parent=\"Style3\" me=\"Style16\" /><EditorStyle parent" +
"=\"Style5\" me=\"Style17\" /><GroupHeaderStyle parent=\"Style1\" me=\"Style55\" /><Group" +
"FooterStyle parent=\"Style1\" me=\"Style54\" /><Visible>True</Visible><ColumnDivider" +
">DarkGray,Single</ColumnDivider><Height>15</Height><DCIdx>1</DCIdx></C1DisplayCo" +
"lumn><C1DisplayColumn><HeadingStyle parent=\"Style2\" me=\"Style18\" /><Style parent" +
"=\"Style1\" me=\"Style19\" /><FooterStyle parent=\"Style3\" me=\"Style20\" /><EditorStyl" +
"e parent=\"Style5\" me=\"Style21\" /><GroupHeaderStyle parent=\"Style1\" me=\"Style57\" " +
"/><GroupFooterStyle parent=\"Style1\" me=\"Style56\" /><Visible>True</Visible><Colum" +
"nDivider>DarkGray,Single</ColumnDivider><Height>15</Height><DCIdx>2</DCIdx></C1D" +
"isplayColumn><C1DisplayColumn><HeadingStyle parent=\"Style2\" me=\"Style22\" /><Styl" +
"e parent=\"Style1\" me=\"Style23\" /><FooterStyle parent=\"Style3\" me=\"Style24\" /><Ed" +
"itorStyle parent=\"Style5\" me=\"Style25\" /><GroupHeaderStyle parent=\"Style1\" me=\"S" +
"tyle59\" /><GroupFooterStyle parent=\"Style1\" me=\"Style58\" /><Visible>True</Visibl" +
"e><ColumnDivider>DarkGray,Single</ColumnDivider><Height>15</Height><DCIdx>3</DCI" +
"dx></C1DisplayColumn><C1DisplayColumn><HeadingStyle parent=\"Style2\" me=\"Style30\"" +
" /><Style parent=\"Style1\" me=\"Style31\" /><FooterStyle parent=\"Style3\" me=\"Style3" +
"2\" /><EditorStyle parent=\"Style5\" me=\"Style33\" /><GroupHeaderStyle parent=\"Style" +
"1\" me=\"Style63\" /><GroupFooterStyle parent=\"Style1\" me=\"Style62\" /><Visible>True" +
"</Visible><ColumnDivider>DarkGray,Single</ColumnDivider><Height>15</Height><DCId" +
"x>5</DCIdx></C1DisplayColumn><C1DisplayColumn><HeadingStyle parent=\"Style2\" me=\"" +
"Style34\" /><Style parent=\"Style1\" me=\"Style35\" /><FooterStyle parent=\"Style3\" me" +
"=\"Style36\" /><EditorStyle parent=\"Style5\" me=\"Style37\" /><GroupHeaderStyle paren" +
"t=\"Style1\" me=\"Style65\" /><GroupFooterStyle parent=\"Style1\" me=\"Style64\" /><Visi" +
"ble>True</Visible><ColumnDivider>DarkGray,Single</ColumnDivider><Height>15</Heig" +
"ht><DCIdx>6</DCIdx></C1DisplayColumn><C1DisplayColumn><HeadingStyle parent=\"Styl" +
"e2\" me=\"Style26\" /><Style parent=\"Style1\" me=\"Style27\" /><FooterStyle parent=\"St" +
"yle3\" me=\"Style28\" /><EditorStyle parent=\"Style5\" me=\"Style29\" /><GroupHeaderSty" +
"le parent=\"Style1\" me=\"Style61\" /><GroupFooterStyle parent=\"Style1\" me=\"Style60\"" +
" /><Visible>True</Visible><ColumnDivider>DarkGray,Single</ColumnDivider><Height>" +
"15</Height><DCIdx>4</DCIdx></C1DisplayColumn><C1DisplayColumn><HeadingStyle pare" +
"nt=\"Style2\" me=\"Style42\" /><Style parent=\"Style1\" me=\"Style43\" /><FooterStyle pa" +
"rent=\"Style3\" me=\"Style44\" /><EditorStyle parent=\"Style5\" me=\"Style45\" /><GroupH" +
"eaderStyle parent=\"Style1\" me=\"Style69\" /><GroupFooterStyle parent=\"Style1\" me=\"" +
"Style68\" /><Visible>True</Visible><ColumnDivider>DarkGray,Single</ColumnDivider>" +
"<Height>15</Height><DCIdx>8</DCIdx></C1DisplayColumn><C1DisplayColumn><HeadingSt" +
"yle parent=\"Style2\" me=\"Style38\" /><Style parent=\"Style1\" me=\"Style39\" /><Footer" +
"Style parent=\"Style3\" me=\"Style40\" /><EditorStyle parent=\"Style5\" me=\"Style41\" /" +
"><GroupHeaderStyle parent=\"Style1\" me=\"Style67\" /><GroupFooterStyle parent=\"Styl" +
"e1\" me=\"Style66\" /><Visible>True</Visible><ColumnDivider>DarkGray,Single</Column" +
"Divider><Height>15</Height><DCIdx>7</DCIdx></C1DisplayColumn></internalCols></C1" +
".Win.C1TrueDBGrid.MergeView></Splits><NamedStyles><Style parent=\"\" me=\"Normal\" /" +
"><Style parent=\"Normal\" me=\"Heading\" /><Style parent=\"Heading\" me=\"Footer\" /><St" +
"yle parent=\"Heading\" me=\"Caption\" /><Style parent=\"Heading\" me=\"Inactive\" /><Sty" +
"le parent=\"Normal\" me=\"Selected\" /><Style parent=\"Normal\" me=\"Editor\" /><Style p" +
"arent=\"Normal\" me=\"HighlightRow\" /><Style parent=\"Normal\" me=\"EvenRow\" /><Style " +
"parent=\"Normal\" me=\"OddRow\" /><Style parent=\"Heading\" me=\"RecordSelector\" /><Sty" +
"le parent=\"Normal\" me=\"FilterBar\" /><Style parent=\"Caption\" me=\"Group\" /></Named" +
"Styles><vertSplits>1</vertSplits><horzSplits>1</horzSplits><Layout>Modified</Lay" +
"out><DefaultRecSelWidth>17</DefaultRecSelWidth><ClientArea>0, 0, 476, 204</Clien" +
"tArea><PrintPageHeaderStyle parent=\"\" me=\"Style50\" /><PrintPageFooterStyle paren" +
"t=\"\" me=\"Style51\" /></Blob>";
//
// dsContacts1
//
this.dsContacts1.DataSetName = "DsContacts";
this.dsContacts1.Locale = new System.Globalization.CultureInfo("en-US");
this.dsContacts1.Namespace = "http://www.tempuri.org/DsContacts.xsd";
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Contacts", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("FirstName", "FirstName"),
new System.Data.Common.DataColumnMapping("LastName", "LastName"),
new System.Data.Common.DataColumnMapping("CustType", "CustType"),
new System.Data.Common.DataColumnMapping("ContactType", "ContactType"),
new System.Data.Common.DataColumnMapping("Callback", "Callback"),
new System.Data.Common.DataColumnMapping("ContactDate", "ContactDate"),
new System.Data.Common.DataColumnMapping("UserCode", "UserCode"),
new System.Data.Common.DataColumnMapping("Expr1", "Expr1")
})
});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT Customer.FirstName, Customer.LastName, Customer.CustType, Contacts.Cont" +
"actType, Contacts.Callback, Contacts.ContactDate, Contacts.UserCode, Customer.U" +
"serCode AS Expr1 FROM Contacts INNER JOIN Customer ON Contacts.UserCode = Custo" +
"mer.UserCode";
this.oleDbSelectCommand1.Connection = this.oleDbConnection2;
//
// oleDbConnection2
//
this.oleDbConnection2.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=C:\Program Files\ComponentOne Studio.NET 2.0\Common\TDBGDemo.mdb;Mode=Share Deny None;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False";
//
// c1TrueDBDropdown1
//
this.c1TrueDBDropdown1.AllowColMove = true;
this.c1TrueDBDropdown1.AllowColSelect = true;
this.c1TrueDBDropdown1.AllowRowSizing = C1.Win.C1TrueDBGrid.RowSizingEnum.AllRows;
this.c1TrueDBDropdown1.AlternatingRows = false;
this.c1TrueDBDropdown1.CaptionHeight = 17;
this.c1TrueDBDropdown1.ColumnCaptionHeight = 17;
this.c1TrueDBDropdown1.ColumnFooterHeight = 17;
this.c1TrueDBDropdown1.DataMember = "CustType";
this.c1TrueDBDropdown1.DataSource = this.dsCustType1;
this.c1TrueDBDropdown1.FetchRowStyles = false;
this.c1TrueDBDropdown1.Images.Add(((System.Drawing.Bitmap)(resources.GetObject("resource.Images1"))));
this.c1TrueDBDropdown1.LayoutFileName = "";
this.c1TrueDBDropdown1.LayoutName = "";
this.c1TrueDBDropdown1.LayoutURL = "";
this.c1TrueDBDropdown1.DisplayMember = "CustType.TypeId";
this.c1TrueDBDropdown1.Location = new System.Drawing.Point(272, 56);
this.c1TrueDBDropdown1.Name = "c1TrueDBDropdown1";
this.c1TrueDBDropdown1.RowDivider.Color = System.Drawing.Color.DarkGray;
this.c1TrueDBDropdown1.RowDivider.Style = C1.Win.C1TrueDBGrid.LineStyleEnum.Single;
this.c1TrueDBDropdown1.RowHeight = 15;
this.c1TrueDBDropdown1.RowSubDividerColor = System.Drawing.Color.DarkGray;
this.c1TrueDBDropdown1.ScrollTips = false;
this.c1TrueDBDropdown1.Size = new System.Drawing.Size(192, 136);
this.c1TrueDBDropdown1.TabIndex = 1;
this.c1TrueDBDropdown1.Text = "c1TrueDBDropdown1";
this.c1TrueDBDropdown1.Visible = false;
this.c1TrueDBDropdown1.PropBag = "<?xml version=\"1.0\"?><Blob><DataCols><C1DataColumn Level=\"0\" Caption=\"TypeDesc\" D" +
"ataField=\"TypeDesc\"><ValueItems /><GroupInfo /></C1DataColumn><C1DataColumn Leve" +
"l=\"0\" Caption=\"TypeId\" DataField=\"TypeId\"><ValueItems /><GroupInfo /></C1DataCol" +
"umn></DataCols><Styles type=\"C1.Win.C1TrueDBGrid.Design.ContextWrapper\"><Data>Ca" +
"ption{AlignHorz:Center;}Normal{}Style25{}Selected{ForeColor:HighlightText;BackCo" +
"lor:Highlight;}Editor{}Style18{AlignHorz:Near;}Style19{AlignHorz:Near;}Style14{A" +
"lignHorz:Near;}Style15{AlignHorz:Near;}Style16{}Style17{}Style10{AlignHorz:Near;" +
"}Style11{}OddRow{}Style13{}Style12{}Footer{}HighlightRow{ForeColor:HighlightText" +
";BackColor:Highlight;}RecordSelector{AlignImage:Center;}Style24{}Style23{}Style2" +
"2{}Style21{}Style20{}Inactive{ForeColor:InactiveCaptionText;BackColor:InactiveCa" +
"ption;}EvenRow{BackColor:Aqua;}Heading{Wrap:True;BackColor:Control;Border:Raised" +
",,1, 1, 1, 1;ForeColor:ControlText;AlignVert:Center;}FilterBar{}Style4{}Style9{}" +
"Style8{}Style5{}Group{AlignVert:Center;Border:None,,0, 0, 0, 0;BackColor:Control" +
"Dark;}Style7{}Style6{}Style1{}Style3{}Style2{}</Data></Styles><Splits><C1.Win.C1" +
"TrueDBGrid.DropdownView Name=\"\" CaptionHeight=\"17\" ColumnCaptionHeight=\"17\" Colu" +
"mnFooterHeight=\"17\" MarqueeStyle=\"DottedCellBorder\" RecordSelectorWidth=\"16\" Rec" +
"ordSelectors=\"False\" VerticalScrollGroup=\"1\" HorizontalScrollGroup=\"1\"><ClientRe" +
"ct>0, 0, 188, 132</ClientRect><internalCols><C1DropDisplayColumn><DCIdx>0</DCIdx" +
"><HeadingStyle parent=\"Style2\" me=\"Style14\" /><Style parent=\"Style1\" me=\"Style15" +
"\" /><FooterStyle parent=\"Style3\" me=\"Style16\" /><EditorStyle parent=\"Style5\" me=" +
"\"Style17\" /><GroupHeaderStyle parent=\"Style1\" me=\"Style23\" /><GroupFooterStyle p" +
"arent=\"Style1\" me=\"Style22\" /><Visible>True</Visible><ColumnDivider>DarkGray,Sin" +
"gle</ColumnDivider><Height>15</Height></C1DropDisplayColumn><C1DropDisplayColumn" +
"><DCIdx>1</DCIdx><HeadingStyle parent=\"Style2\" me=\"Style18\" /><Style parent=\"Sty" +
"le1\" me=\"Style19\" /><FooterStyle parent=\"Style3\" me=\"Style20\" /><EditorStyle par" +
"ent=\"Style5\" me=\"Style21\" /><GroupHeaderStyle parent=\"Style1\" me=\"Style25\" /><Gr" +
"oupFooterStyle parent=\"Style1\" me=\"Style24\" /><Visible>True</Visible><ColumnDivi" +
"der>DarkGray,Single</ColumnDivider><Height>15</Height></C1DropDisplayColumn></in" +
"ternalCols><CaptionStyle parent=\"Style2\" me=\"Style10\" /><EditorStyle parent=\"Edi" +
"tor\" me=\"Style5\" /><EvenRowStyle parent=\"EvenRow\" me=\"Style8\" /><FilterBarStyle " +
"parent=\"FilterBar\" me=\"Style13\" /><FooterStyle parent=\"Footer\" me=\"Style3\" /><Gr" +
"oupStyle parent=\"Group\" me=\"Style12\" /><HeadingStyle parent=\"Heading\" me=\"Style2" +
"\" /><HighLightRowStyle parent=\"HighlightRow\" me=\"Style7\" /><InactiveStyle parent" +
"=\"Inactive\" me=\"Style4\" /><OddRowStyle parent=\"OddRow\" me=\"Style9\" /><RecordSele" +
"ctorStyle parent=\"RecordSelector\" me=\"Style11\" /><SelectedStyle parent=\"Selected" +
"\" me=\"Style6\" /><Style parent=\"Normal\" me=\"Style1\" /></C1.Win.C1TrueDBGrid.Dropd" +
"ownView></Splits><NamedStyles><Style parent=\"\" me=\"Normal\" /><Style parent=\"Norm" +
"al\" me=\"Heading\" /><Style parent=\"Heading\" me=\"Footer\" /><Style parent=\"Heading\"" +
" me=\"Caption\" /><Style parent=\"Heading\" me=\"Inactive\" /><Style parent=\"Normal\" m" +
"e=\"Selected\" /><Style parent=\"Normal\" me=\"Editor\" /><Style parent=\"Normal\" me=\"H" +
"ighlightRow\" /><Style parent=\"Normal\" me=\"EvenRow\" /><Style parent=\"Normal\" me=\"" +
"OddRow\" /><Style parent=\"Heading\" me=\"RecordSelector\" /><Style parent=\"Normal\" m" +
"e=\"FilterBar\" /><Style parent=\"Caption\" me=\"Group\" /></NamedStyles><vertSplits>1" +
"</vertSplits><horzSplits>1</horzSplits><Layout>Modified</Layout><DefaultRecSelWi" +
"dth>17</DefaultRecSelWidth><ClientArea>0, 0, 188, 132</ClientArea></Blob>";
//
// dsCustType1
//
this.dsCustType1.DataSetName = "DsCustType";
this.dsCustType1.Locale = new System.Globalization.CultureInfo("en-US");
this.dsCustType1.Namespace = "http://www.tempuri.org/DsCustType.xsd";
//
// oleDbDataAdapter2
//
this.oleDbDataAdapter2.DeleteCommand = this.oleDbDeleteCommand1;
this.oleDbDataAdapter2.InsertCommand = this.oleDbInsertCommand1;
this.oleDbDataAdapter2.SelectCommand = this.oleDbSelectCommand2;
this.oleDbDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "CustType", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("TypeDesc", "TypeDesc"),
new System.Data.Common.DataColumnMapping("TypeId", "TypeId")
})
});
this.oleDbDataAdapter2.UpdateCommand = this.oleDbUpdateCommand1;
//
// oleDbDeleteCommand1
//
this.oleDbDeleteCommand1.CommandText = "DELETE FROM CustType WHERE (TypeId = ?) AND (TypeDesc = ? OR ? IS NULL AND TypeDe" +
"sc IS NULL)";
this.oleDbDeleteCommand1.Connection = this.oleDbConnection2;
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_TypeId", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TypeId", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_TypeDesc", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TypeDesc", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_TypeDesc1", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TypeDesc", System.Data.DataRowVersion.Original, null));
//
// oleDbInsertCommand1
//
this.oleDbInsertCommand1.CommandText = "INSERT INTO CustType(TypeDesc, TypeId) VALUES (?, ?)";
this.oleDbInsertCommand1.Connection = this.oleDbConnection2;
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("TypeDesc", System.Data.OleDb.OleDbType.VarWChar, 15, "TypeDesc"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("TypeId", System.Data.OleDb.OleDbType.VarWChar, 1, "TypeId"));
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = "SELECT TypeDesc, TypeId FROM CustType";
this.oleDbSelectCommand2.Connection = this.oleDbConnection2;
//
// oleDbUpdateCommand1
//
this.oleDbUpdateCommand1.CommandText = "UPDATE CustType SET TypeDesc = ?, TypeId = ? WHERE (TypeId = ?) AND (TypeDesc = ?" +
" OR ? IS NULL AND TypeDesc IS NULL)";
this.oleDbUpdateCommand1.Connection = this.oleDbConnection2;
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("TypeDesc", System.Data.OleDb.OleDbType.VarWChar, 15, "TypeDesc"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("TypeId", System.Data.OleDb.OleDbType.VarWChar, 1, "TypeId"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_TypeId", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TypeId", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_TypeDesc", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TypeDesc", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_TypeDesc1", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TypeDesc", System.Data.DataRowVersion.Original, null));
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(504, 222);
this.Controls.AddRange(new System.Windows.Forms.Control[] {
this.c1TrueDBDropdown1,
this.c1TrueDBGrid1
});
this.Name = "Form1";
this.Text = "Form1";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsContacts1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBDropdown1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsCustType1)).EndInit();
this.ResumeLayout(false);
}
/// <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));
C1.Win.C1TrueDBGrid.Style style1 = new C1.Win.C1TrueDBGrid.Style();
C1.Win.C1TrueDBGrid.Style style2 = new C1.Win.C1TrueDBGrid.Style();
C1.Win.C1TrueDBGrid.Style style3 = new C1.Win.C1TrueDBGrid.Style();
C1.Win.C1TrueDBGrid.Style style4 = new C1.Win.C1TrueDBGrid.Style();
C1.Win.C1TrueDBGrid.Style style5 = new C1.Win.C1TrueDBGrid.Style();
C1.Win.C1TrueDBGrid.Style style6 = new C1.Win.C1TrueDBGrid.Style();
C1.Win.C1TrueDBGrid.Style style7 = new C1.Win.C1TrueDBGrid.Style();
C1.Win.C1TrueDBGrid.Style style8 = new C1.Win.C1TrueDBGrid.Style();
this.c1TrueDBGrid1 = new C1.Win.C1TrueDBGrid.C1TrueDBGrid();
this.dataSet11 = new UsingC1TDBDropdown.DataSet1();
this.c1TrueDBDropdown1 = new C1.Win.C1TrueDBGrid.C1TrueDBDropdown();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbDataAdapter2 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbInsertCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBGrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBDropdown1)).BeginInit();
this.SuspendLayout();
//
// c1TrueDBGrid1
//
this.c1TrueDBGrid1.Caption = "Products Table";
this.c1TrueDBGrid1.DataSource = this.dataSet11.Products;
this.c1TrueDBGrid1.Images.Add(((System.Drawing.Image)(resources.GetObject("c1TrueDBGrid1.Images"))));
this.c1TrueDBGrid1.Location = new System.Drawing.Point(16, 16);
this.c1TrueDBGrid1.Name = "c1TrueDBGrid1";
this.c1TrueDBGrid1.PreviewInfo.Location = new System.Drawing.Point(0, 0);
this.c1TrueDBGrid1.PreviewInfo.Size = new System.Drawing.Size(0, 0);
this.c1TrueDBGrid1.PreviewInfo.ZoomFactor = 75;
this.c1TrueDBGrid1.PrintInfo.PageSettings = ((System.Drawing.Printing.PageSettings)(resources.GetObject("c1TrueDBGrid1.PrintInfo.PageSettings")));
this.c1TrueDBGrid1.Size = new System.Drawing.Size(400, 216);
this.c1TrueDBGrid1.TabIndex = 0;
this.c1TrueDBGrid1.Text = "c1TrueDBGrid1";
this.c1TrueDBGrid1.PropBag = resources.GetString("c1TrueDBGrid1.PropBag");
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("en-US");
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// c1TrueDBDropdown1
//
this.c1TrueDBDropdown1.AllowColMove = true;
this.c1TrueDBDropdown1.AllowColSelect = true;
this.c1TrueDBDropdown1.AllowRowSizing = C1.Win.C1TrueDBGrid.RowSizingEnum.AllRows;
this.c1TrueDBDropdown1.AlternatingRows = false;
this.c1TrueDBDropdown1.CaptionStyle = style1;
this.c1TrueDBDropdown1.ColumnCaptionHeight = 17;
this.c1TrueDBDropdown1.ColumnFooterHeight = 17;
this.c1TrueDBDropdown1.DataSource = this.dataSet11.Categories;
this.c1TrueDBDropdown1.EvenRowStyle = style2;
this.c1TrueDBDropdown1.FetchRowStyles = false;
this.c1TrueDBDropdown1.FooterStyle = style3;
this.c1TrueDBDropdown1.HeadingStyle = style4;
this.c1TrueDBDropdown1.HighLightRowStyle = style5;
this.c1TrueDBDropdown1.Images.Add(((System.Drawing.Image)(resources.GetObject("c1TrueDBDropdown1.Images"))));
this.c1TrueDBDropdown1.Location = new System.Drawing.Point(120, 104);
this.c1TrueDBDropdown1.Name = "c1TrueDBDropdown1";
this.c1TrueDBDropdown1.OddRowStyle = style6;
this.c1TrueDBDropdown1.RecordSelectorStyle = style7;
this.c1TrueDBDropdown1.RowDivider.Color = System.Drawing.Color.DarkGray;
this.c1TrueDBDropdown1.RowDivider.Style = C1.Win.C1TrueDBGrid.LineStyleEnum.Single;
this.c1TrueDBDropdown1.RowSubDividerColor = System.Drawing.Color.DarkGray;
this.c1TrueDBDropdown1.ScrollTips = false;
this.c1TrueDBDropdown1.Size = new System.Drawing.Size(192, 104);
this.c1TrueDBDropdown1.Style = style8;
this.c1TrueDBDropdown1.TabIndex = 1;
this.c1TrueDBDropdown1.Text = "c1TrueDBDropdown1";
this.c1TrueDBDropdown1.Visible = false;
this.c1TrueDBDropdown1.PropBag = resources.GetString("c1TrueDBDropdown1.PropBag");
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.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")
})
});
//
// oleDbInsertCommand1
//
this.oleDbInsertCommand1.CommandText = "INSERT INTO Categories(CategoryID, CategoryName, Description, Picture) VALUES (?," +
" ?, ?, ?)";
this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
this.oleDbInsertCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] {
new System.Data.OleDb.OleDbParameter("CategoryID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "CategoryID", System.Data.DataRowVersion.Current, null),
new System.Data.OleDb.OleDbParameter("CategoryName", System.Data.OleDb.OleDbType.VarWChar, 15, "CategoryName"),
new System.Data.OleDb.OleDbParameter("Description", System.Data.OleDb.OleDbType.VarWChar, 0, "Description"),
new System.Data.OleDb.OleDbParameter("Picture", System.Data.OleDb.OleDbType.VarBinary, 0, "Picture")
});
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\ComponentOne Studi" +
@"o.NET 2.0\Common\C1Nwind.mdb;";
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT CategoryID, CategoryName, Description, Picture FROM Categories";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbDataAdapter2
//
this.oleDbDataAdapter2.InsertCommand = this.oleDbInsertCommand2;
this.oleDbDataAdapter2.SelectCommand = this.oleDbSelectCommand2;
this.oleDbDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Products", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ProductID", "ProductID"),
new System.Data.Common.DataColumnMapping("ProductName", "ProductName"),
new System.Data.Common.DataColumnMapping("SupplierID", "SupplierID"),
new System.Data.Common.DataColumnMapping("CategoryID", "CategoryID"),
new System.Data.Common.DataColumnMapping("QuantityPerUnit", "QuantityPerUnit"),
new System.Data.Common.DataColumnMapping("UnitPrice", "UnitPrice"),
new System.Data.Common.DataColumnMapping("UnitsInStock", "UnitsInStock"),
new System.Data.Common.DataColumnMapping("UnitsOnOrder", "UnitsOnOrder"),
new System.Data.Common.DataColumnMapping("ReorderLevel", "ReorderLevel"),
new System.Data.Common.DataColumnMapping("Discontinued", "Discontinued")
})
});
//
// oleDbInsertCommand2
//
this.oleDbInsertCommand2.CommandText = "INSERT INTO Products(CategoryID, Discontinued, ProductID, ProductName, QuantityPe" +
"rUnit, ReorderLevel, SupplierID, UnitPrice, UnitsInStock, UnitsOnOrder) VALUES (" +
"?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
this.oleDbInsertCommand2.Connection = this.oleDbConnection1;
this.oleDbInsertCommand2.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] {
new System.Data.OleDb.OleDbParameter("CategoryID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "CategoryID", System.Data.DataRowVersion.Current, null),
new System.Data.OleDb.OleDbParameter("Discontinued", System.Data.OleDb.OleDbType.Boolean, 2, "Discontinued"),
new System.Data.OleDb.OleDbParameter("ProductID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "ProductID", System.Data.DataRowVersion.Current, null),
new System.Data.OleDb.OleDbParameter("ProductName", System.Data.OleDb.OleDbType.VarWChar, 40, "ProductName"),
new System.Data.OleDb.OleDbParameter("QuantityPerUnit", System.Data.OleDb.OleDbType.VarWChar, 20, "QuantityPerUnit"),
new System.Data.OleDb.OleDbParameter("ReorderLevel", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(0)), "ReorderLevel", System.Data.DataRowVersion.Current, null),
new System.Data.OleDb.OleDbParameter("SupplierID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "SupplierID", System.Data.DataRowVersion.Current, null),
new System.Data.OleDb.OleDbParameter("UnitPrice", System.Data.OleDb.OleDbType.Currency, 0, System.Data.ParameterDirection.Input, false, ((byte)(19)), ((byte)(0)), "UnitPrice", System.Data.DataRowVersion.Current, null),
new System.Data.OleDb.OleDbParameter("UnitsInStock", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(0)), "UnitsInStock", System.Data.DataRowVersion.Current, null),
new System.Data.OleDb.OleDbParameter("UnitsOnOrder", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(0)), "UnitsOnOrder", System.Data.DataRowVersion.Current, null)
});
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = "SELECT CategoryID, Discontinued, ProductID, ProductName, QuantityPerUnit, Reorder" +
"Level, SupplierID, UnitPrice, UnitsInStock, UnitsOnOrder FROM Products";
this.oleDbSelectCommand2.Connection = this.oleDbConnection1;
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(432, 270);
this.Controls.Add(this.c1TrueDBDropdown1);
this.Controls.Add(this.c1TrueDBGrid1);
this.Name = "Form1";
this.Text = "Form1";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBDropdown1)).EndInit();
this.ResumeLayout(false);
}
/// <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));
C1.Win.C1TrueDBGrid.Style style9 = new C1.Win.C1TrueDBGrid.Style();
C1.Win.C1TrueDBGrid.Style style10 = new C1.Win.C1TrueDBGrid.Style();
C1.Win.C1TrueDBGrid.Style style11 = new C1.Win.C1TrueDBGrid.Style();
C1.Win.C1TrueDBGrid.Style style12 = new C1.Win.C1TrueDBGrid.Style();
C1.Win.C1TrueDBGrid.Style style13 = new C1.Win.C1TrueDBGrid.Style();
C1.Win.C1TrueDBGrid.Style style14 = new C1.Win.C1TrueDBGrid.Style();
C1.Win.C1TrueDBGrid.Style style15 = new C1.Win.C1TrueDBGrid.Style();
C1.Win.C1TrueDBGrid.Style style16 = new C1.Win.C1TrueDBGrid.Style();
this.dataSet11 = new FilterMultiEdit.DataSet1();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbDataAdapter2 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbInsertCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
this.panel1 = new System.Windows.Forms.Panel();
this.label1 = new System.Windows.Forms.Label();
this.checkedListBox1 = new System.Windows.Forms.CheckedListBox();
this.c1TrueDBDropdown1 = new C1.Win.C1TrueDBGrid.C1TrueDBDropdown();
this.c1TrueDBGrid1 = new C1.Win.C1TrueDBGrid.C1TrueDBGrid();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
this.panel1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBDropdown1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBGrid1)).BeginInit();
this.SuspendLayout();
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("en-US");
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Orders", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("OrderID", "OrderID"),
new System.Data.Common.DataColumnMapping("CustomerID", "CustomerID"),
new System.Data.Common.DataColumnMapping("EmployeeID", "EmployeeID"),
new System.Data.Common.DataColumnMapping("OrderDate", "OrderDate"),
new System.Data.Common.DataColumnMapping("RequiredDate", "RequiredDate"),
new System.Data.Common.DataColumnMapping("ShippedDate", "ShippedDate"),
new System.Data.Common.DataColumnMapping("ShipVia", "ShipVia"),
new System.Data.Common.DataColumnMapping("Freight", "Freight"),
new System.Data.Common.DataColumnMapping("ShipName", "ShipName"),
new System.Data.Common.DataColumnMapping("ShipAddress", "ShipAddress"),
new System.Data.Common.DataColumnMapping("ShipCity", "ShipCity"),
new System.Data.Common.DataColumnMapping("ShipRegion", "ShipRegion"),
new System.Data.Common.DataColumnMapping("ShipPostalCode", "ShipPostalCode"),
new System.Data.Common.DataColumnMapping("ShipCountry", "ShipCountry")
})
});
//
// oleDbInsertCommand1
//
this.oleDbInsertCommand1.CommandText = resources.GetString("oleDbInsertCommand1.CommandText");
this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
this.oleDbInsertCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] {
new System.Data.OleDb.OleDbParameter("CustomerID", System.Data.OleDb.OleDbType.VarWChar, 5, "CustomerID"),
new System.Data.OleDb.OleDbParameter("EmployeeID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "EmployeeID", System.Data.DataRowVersion.Current, null),
new System.Data.OleDb.OleDbParameter("Freight", System.Data.OleDb.OleDbType.Currency, 0, System.Data.ParameterDirection.Input, false, ((byte)(19)), ((byte)(0)), "Freight", System.Data.DataRowVersion.Current, null),
new System.Data.OleDb.OleDbParameter("OrderDate", System.Data.OleDb.OleDbType.DBDate, 0, "OrderDate"),
new System.Data.OleDb.OleDbParameter("OrderID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "OrderID", System.Data.DataRowVersion.Current, null),
new System.Data.OleDb.OleDbParameter("RequiredDate", System.Data.OleDb.OleDbType.DBDate, 0, "RequiredDate"),
new System.Data.OleDb.OleDbParameter("ShipAddress", System.Data.OleDb.OleDbType.VarWChar, 60, "ShipAddress"),
new System.Data.OleDb.OleDbParameter("ShipCity", System.Data.OleDb.OleDbType.VarWChar, 15, "ShipCity"),
new System.Data.OleDb.OleDbParameter("ShipCountry", System.Data.OleDb.OleDbType.VarWChar, 15, "ShipCountry"),
new System.Data.OleDb.OleDbParameter("ShipName", System.Data.OleDb.OleDbType.VarWChar, 40, "ShipName"),
new System.Data.OleDb.OleDbParameter("ShippedDate", System.Data.OleDb.OleDbType.DBDate, 0, "ShippedDate"),
new System.Data.OleDb.OleDbParameter("ShipPostalCode", System.Data.OleDb.OleDbType.VarWChar, 10, "ShipPostalCode"),
new System.Data.OleDb.OleDbParameter("ShipRegion", System.Data.OleDb.OleDbType.VarWChar, 15, "ShipRegion"),
new System.Data.OleDb.OleDbParameter("ShipVia", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "ShipVia", System.Data.DataRowVersion.Current, null)
});
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\ComponentOne Studio" +
".NET 2.0\\Common\\C1Nwind.mdb;";
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT CustomerID, EmployeeID, Freight, OrderDate, OrderID, RequiredDate, ShipAdd" +
"ress, ShipCity, ShipCountry, ShipName, ShippedDate, ShipPostalCode, ShipRegion, " +
"ShipVia FROM Orders";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbDataAdapter2
//
this.oleDbDataAdapter2.InsertCommand = this.oleDbInsertCommand2;
this.oleDbDataAdapter2.SelectCommand = this.oleDbSelectCommand2;
this.oleDbDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Customers", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("CustomerID", "CustomerID")
})
});
//
// oleDbInsertCommand2
//
this.oleDbInsertCommand2.CommandText = "INSERT INTO Customers(CustomerID) VALUES (?)";
this.oleDbInsertCommand2.Connection = this.oleDbConnection1;
this.oleDbInsertCommand2.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] {
new System.Data.OleDb.OleDbParameter("CustomerID", System.Data.OleDb.OleDbType.VarWChar, 5, "CustomerID")
});
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = "SELECT CustomerID FROM Customers";
this.oleDbSelectCommand2.Connection = this.oleDbConnection1;
//
// panel1
//
this.panel1.Controls.Add(this.label1);
this.panel1.Controls.Add(this.checkedListBox1);
this.panel1.Dock = System.Windows.Forms.DockStyle.Left;
this.panel1.Location = new System.Drawing.Point(0, 0);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(131, 424);
this.panel1.TabIndex = 2;
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(4, 13);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(106, 13);
this.label1.TabIndex = 1;
this.label1.Text = "Multiple Selections in";
//
// checkedListBox1
//
this.checkedListBox1.FormattingEnabled = true;
this.checkedListBox1.Items.AddRange(new object[] {
"CustomerID",
"EmployeeID",
"OrderDate",
"ShipCity",
"ShipCountry",
"Freight"
});
this.checkedListBox1.Location = new System.Drawing.Point(4, 28);
this.checkedListBox1.Name = "checkedListBox1";
this.checkedListBox1.Size = new System.Drawing.Size(115, 379);
this.checkedListBox1.TabIndex = 0;
this.checkedListBox1.ItemCheck += new System.Windows.Forms.ItemCheckEventHandler(this.checkedListBox1_ItemCheck);
//
// c1TrueDBDropdown1
//
this.c1TrueDBDropdown1.AllowColMove = true;
this.c1TrueDBDropdown1.AllowColSelect = true;
this.c1TrueDBDropdown1.AllowRowSizing = C1.Win.C1TrueDBGrid.RowSizingEnum.AllRows;
this.c1TrueDBDropdown1.AlternatingRows = false;
this.c1TrueDBDropdown1.CaptionStyle = style9;
this.c1TrueDBDropdown1.ColumnCaptionHeight = 17;
this.c1TrueDBDropdown1.ColumnFooterHeight = 17;
this.c1TrueDBDropdown1.DataMember = "Customers";
this.c1TrueDBDropdown1.DataSource = this.dataSet11;
this.c1TrueDBDropdown1.EvenRowStyle = style10;
this.c1TrueDBDropdown1.ExtendRightColumn = true;
this.c1TrueDBDropdown1.FetchRowStyles = false;
this.c1TrueDBDropdown1.FooterStyle = style11;
this.c1TrueDBDropdown1.HeadingStyle = style12;
this.c1TrueDBDropdown1.HighLightRowStyle = style13;
this.c1TrueDBDropdown1.Images.Add(((System.Drawing.Image)(resources.GetObject("c1TrueDBDropdown1.Images"))));
this.c1TrueDBDropdown1.Location = new System.Drawing.Point(232, 168);
this.c1TrueDBDropdown1.Name = "c1TrueDBDropdown1";
this.c1TrueDBDropdown1.OddRowStyle = style14;
this.c1TrueDBDropdown1.RecordSelectorStyle = style15;
this.c1TrueDBDropdown1.RowDivider.Color = System.Drawing.Color.DarkGray;
this.c1TrueDBDropdown1.RowDivider.Style = C1.Win.C1TrueDBGrid.LineStyleEnum.Single;
this.c1TrueDBDropdown1.RowSubDividerColor = System.Drawing.Color.DarkGray;
this.c1TrueDBDropdown1.ScrollTips = false;
this.c1TrueDBDropdown1.Size = new System.Drawing.Size(100, 104);
this.c1TrueDBDropdown1.Style = style16;
this.c1TrueDBDropdown1.TabIndex = 1;
this.c1TrueDBDropdown1.TabStop = false;
this.c1TrueDBDropdown1.Text = "c1TrueDBDropdown1";
this.c1TrueDBDropdown1.Visible = false;
this.c1TrueDBDropdown1.PropBag = resources.GetString("c1TrueDBDropdown1.PropBag");
//
// c1TrueDBGrid1
//
this.c1TrueDBGrid1.DataMember = "Orders";
this.c1TrueDBGrid1.DataSource = this.dataSet11;
this.c1TrueDBGrid1.Dock = System.Windows.Forms.DockStyle.Fill;
this.c1TrueDBGrid1.FilterBar = true;
this.c1TrueDBGrid1.Images.Add(((System.Drawing.Image)(resources.GetObject("c1TrueDBGrid1.Images"))));
this.c1TrueDBGrid1.Location = new System.Drawing.Point(131, 0);
this.c1TrueDBGrid1.Name = "c1TrueDBGrid1";
this.c1TrueDBGrid1.PreviewInfo.Location = new System.Drawing.Point(0, 0);
this.c1TrueDBGrid1.PreviewInfo.Size = new System.Drawing.Size(0, 0);
this.c1TrueDBGrid1.PreviewInfo.ZoomFactor = 75;
this.c1TrueDBGrid1.PrintInfo.PageSettings = ((System.Drawing.Printing.PageSettings)(resources.GetObject("c1TrueDBGrid1.PrintInfo.PageSettings")));
this.c1TrueDBGrid1.Size = new System.Drawing.Size(708, 424);
this.c1TrueDBGrid1.TabIndex = 3;
this.c1TrueDBGrid1.Text = "c1TrueDBGrid1";
this.c1TrueDBGrid1.PropBag = resources.GetString("c1TrueDBGrid1.PropBag");
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(839, 424);
this.Controls.Add(this.c1TrueDBGrid1);
this.Controls.Add(this.panel1);
this.Controls.Add(this.c1TrueDBDropdown1);
this.Name = "Form1";
this.Text = "Form1";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
this.panel1.ResumeLayout(false);
this.panel1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBDropdown1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.c1TrueDBGrid1)).EndInit();
this.ResumeLayout(false);
}