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
//////////////////////////////////////////////////////////////////////////////////////
近期下载者:
相关文件:
收藏者: