True NorthWind Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Stimulsoft Reports.Net 2008.2 Trial\Bin\Data\NWIND.MDB;Persist Security Info=False NorthWind False Categories CategoryID,System.Int32 CategoryName,System.String Description,System.String Picture,System.Byte[] 30 Categories NorthWind SELECT Categories.* FROM Categories Products ProductID,System.Int32 ProductName,System.String SupplierID,System.Int32 CategoryID,System.Int32 QuantityPerUnit,System.String UnitPrice,System.Decimal UnitsInStock,System.Int16 UnitsOnOrder,System.Int16 ReorderLevel,System.Int16 Discontinued,System.Boolean 30 False Products NorthWind _x0040_CategoryID,,3,0 SELECT Products.* FROM Products where Products.CategoryID = @CategoryID EngineV1 Control Window 240,32,192,20 Microsoft Sans Serif,8 Black 240, 32 0,0 0,0 t1 192, 20 Control 240,8,136,16 Microsoft Sans Serif,8 Black 240, 8 0,0 0,0 LabelControl1 136, 16 SelectedItem property int myVar; int.TryParse(Categories.GetData("CategoriesID", ComboBox1.SelectedIndex).ToString(),out myVar); Products.Parameters["@CategoryID"].ParameterValue = myVar; Products.Connect(); 312,72,96,24 OK Microsoft Sans Serif,8 Black 312, 72 0,0 0,0 ButtonControl2 96, 24 Ok Window 0,32,216,20 Microsoft Sans Serif,8 Black 1 2 3 Categories.CategoryName 0, 32 0,0 0,0 ComboBox1 t1.Text = ComboBox1.SelectedItem.ToString(); if (ComboBox1.SelectedIndex >= 0) { t2.Text = Categories.GetData("CategoriesID", ComboBox1.SelectedIndex).ToString(); } Categories.CategoryName 216, 20 ComboBox Control 0,8,144,16 Microsoft Sans Serif,8 Black 0, 8 0,0 0,0 Label1 144, 16 Combobox Component Control 448,8,264,24 Microsoft Sans Serif,8 Black 448, 8 0,0 0,0 Label2 264, 24 'CategoriesID' from the Categories DataSource Window 448,32,264,20 Microsoft Sans Serif,8 Black 448, 32 0,0 0,0 t2 264, 20 Microsoft Sans Serif,8 738cb1c16af549b5ac921e70864a8884 0, 0 Form1 736, 136 Form None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,1.6 All;Black;1;Solid;False;4;Black Transparent 0.4,0,16.8,1.2 Arial,9,Bold None 0,0,0,0 0,0 0,0 Text9 Products.Parameters["@CategoryID"].ParameterValue = {Products.Parameters["@CategoryID"].ParameterValue} ComboBox1.SelectedItem = {ComboBox1.SelectedItem.ToString()} CategoriesID = {ComboBox1.SelectedIndex == -1?"":Categories.GetData("CategoriesID", ComboBox1.SelectedIndex).ToString()} DarkBlue Expression 0 0 ReportTitle1 Transparent 0,2.8,19,0.8 All;Black;1;Solid;False;4;Black Transparent True 0,0,2.4,0.8 Arial,12,Bold True 13cca43f29064b2fb0fcdf43245a661d None 0,0,0,0 0,0 0,0 Text1 CategoryID Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center All;Black;1;Solid;False;4;Black Transparent True 2.4,0,3.4,0.8 Arial,12,Bold True 71a3fa81dc80421986fae16fbcc3f5de None 0,0,0,0 0,0 0,0 Text2 ProductID Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center All;Black;1;Solid;False;4;Black Transparent True 5.8,0,8.6,0.8 Arial,12,Bold True c023f448110e4081963136a558cc5a7d None 0,0,0,0 0,0 0,0 Text3 ProductName Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center All;Black;1;Solid;False;4;Black Transparent True 14.4,0,4.6,0.8 Arial,12,Bold True 075be510b6304cabbdf36054a9273d5c None 0,0,0,0 0,0 0,0 Text4 UnitPrice Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center 0 0 Header1 Transparent 0,4.4,19,0.8 All;Black;1;Solid;False;4;Black Transparent True 2.4,0,3.4,0.8 Arial,8 None 0,0,0,0 0,0 0,0 DataProducts_ProductID {Products.ProductID} Black Center All;Black;1;Solid;False;4;Black Transparent True 5.8,0,8.6,0.8 Arial,8 None 0,0,0,0 0,0 0,0 DataProducts_ProductName {Products.ProductName} Black Center All;Black;1;Solid;False;4;Black Transparent True 14.4,0,4.6,0.8 Arial,8 None 0,0,0,0 0,0 0,0 DataProducts_UnitPrice {Products.UnitPrice} Black Center All;Black;1;Solid;False;4;Black Transparent True 0,0,2.4,0.8 Arial,8 90f28da9b9394785b37b6f4d01d73580 None 0,0,0,0 0,0 0,0 Text5 {Products.CategoryID} Black Expression Center Products 0 0 DataProducts b606f9829d4546b09736bcdc6a2edbd3 1,1,1,1 Page1 29.7 21 Arial,100,Bold [50:0:0:0] StandardAndDotMatrix 33538047 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Base.Dll Stimulsoft.Controls.Dll Stimulsoft.Report.Dll Simple List 10/28/2008 1:37:09 AM 5/29/2004 10:59:00 AM bd70a51b61e4499ebdd508f9a07da834 Report Centimeters 2008.2.300 CSharp PapayaWhip Arial,8 Odd Black