DynamicallyBuildLambdaExpression

所属分类:C#编程
开发工具:C#
文件大小:711KB
下载次数:13
上传日期:2011-04-08 09:51:00
上 传 者orichisonic
说明:  动态生成LINQ TO SQL 并且显示在datagridview中
(This sample demonstrates how to dynamically build lambda expression and show data into DataGridView Control.)

文件列表:
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\ConditionBuilder.Designer.cs (2514, 2011-04-04)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\Condition.cs (12919, 2011-04-07)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\ConditionBuilderDesigner.cs (3709, 2011-04-07)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\ConditionBuilder.cs (5688, 2011-04-07)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\DynamicCondition.xml (10389, 2011-04-08)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\SimulateVal.cs (2151, 2011-04-07)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\DynamicCondition.csproj (7256, 2011-04-07)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\DynamicCondition.csproj.user (478, 2011-04-07)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\ConditionBuilder.resx (5814, 2011-04-04)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\ConditionLine.resx (5814, 2011-04-04)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\ConditionLine.Designer.cs (6602, 2011-04-04)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\ConditionLine.cs (7997, 2011-04-07)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\Properties\Application.Designer.cs (688, 2011-04-04)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\Properties\AssemblyInfo.cs (1571, 2011-04-04)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\Properties\Resources.Designer.cs (2856, 2011-04-07)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\Properties\Settings.Designer.cs (1070, 2011-04-07)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\Properties\Resources.resx (5350, 2011-04-04)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\Properties\Application.myapp (481, 2007-07-13)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\Properties\Settings.settings (279, 2007-07-13)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\bin\Debug\DynamicCondition.dll (26624, 2011-04-08)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\bin\Debug\DynamicCondition.pdb (58880, 2011-04-08)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\bin\Debug\DynamicCondition.xml (10389, 2011-04-08)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\obj\Debug\DynamicCondition.ConditionBuilder.resources (180, 2011-04-08)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\obj\Debug\DynamicCondition.ConditionLine.resources (180, 2011-04-08)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\obj\Debug\DynamicCondition.Properties.Resources.resources (180, 2011-04-08)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\obj\Debug\DynamicCondition.csproj.GenerateResource.Cache (924, 2011-04-07)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\obj\Debug\GenerateResource-ResGen.read.1.tlog (1014, 2011-04-08)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\obj\Debug\DynamicCondition.csproj.FileListAbsolute.txt (5894, 2011-04-08)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\obj\Debug\TempPE\Properties.Resources.Designer.cs.dll (4608, 2011-04-07)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache (6409, 2011-04-08)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\obj\Debug\GenerateResource-ResGen.write.1.tlog (1624, 2011-04-08)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\obj\Debug\DynamicCondition.pdb (58880, 2011-04-08)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\DynamicCondition\obj\Debug\DynamicCondition.dll (26624, 2011-04-08)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\NorthwindApp\NorthwindApp.csproj (7694, 2011-04-08)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\NorthwindApp\NorthwindApp.csproj.user (601, 2011-04-07)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\NorthwindApp\Northwind.dbml.layout (757, 2011-04-07)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\NorthwindApp\Northwind.dbml (1856, 2011-04-07)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\NorthwindApp\Northwind.sdf (1597440, 2011-04-04)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\NorthwindApp\Settings.cs (1242, 2011-04-04)
DynamicallyBuildLambdaExpression\CSDynamiicallyBuildLambdaExpression\NorthwindApp\Northwind.designer.cs (11658, 2011-04-07)
... ...

====================================================================================== Windows APPLICATION: CSDynamicallyBuildLambdaExpression Overview ====================================================================================== ////////////////////////////////////////////////////////////////////////////////////// Summary: This sample demonstrates how to dynamically build lambda expression and show data into DataGridView Control. This sample shows up multiple conditions jointing together and dynamically generate LINQ TO SQL. LINQ is a great way to declaratively filter and query data in a Type_Safe, Intuitive, and very expressive way. This sample achieve it. For example, the search feature in this application allow the customer to find all records that meet criteria defined on multiple columns. ////////////////////////////////////////////////////////////////////////////////////// Demo: Step1. Build this project in VS2010. Step2. Download SQL2000SampleDb.msi according to access the website mentioned as follow: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&displaylang=en Step3. Install it into your system catalog and startup your SQL Server Management Studio. Step4. Right click the Treenode written as "Databases" and left click "Attach...". Step5. Make sure just Northwind.MDF and Northwind.LDF installed in the system catalog, which have complete access control privileges. Under the above condition, Select the button written as "Add..." inside Attach Databases Dialog to attach Northwind database. Step6. Select app.config inside the NorthwindApp project to modify connections string or double click Settings.settings under the NorthwindApp project and modify column written as "value". Step7. Right click the NorthwindApp project and click the Menuitem written as "Set as Startup Project". Step8. Click F5 shortcut key and select condition field ,condition operator and condition value. Step9. Click the button written as "Search" and view the result parsed by LINQ TO SQL. ////////////////////////////////////////////////////////////////////////////////////// References: Implementing Dynamic Searching Using LINQ http://blogs.msdn.com/b/vbteam/archive/2007/08/29/implementing-dynamic-searching-using-linq.aspx LINQ to SQL (Part 9 - Using a Custom LINQ Expression with the control) http://weblogs.asp.net/scottgu/archive/2007/09/07/linq-to-sql-part-9-using-a-custom-linq-expression-with-the-lt-asp-linqdatasource-gt-control.aspx //////////////////////////////////////////////////////////////////////////////////////

近期下载者

相关文件


收藏者