本文介绍了请帮助我LINQ to DATASET !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

<! - / *字体定义* / @ font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; MSO的字体字符集:0; MSO的仿制FONT-FAMILY:瑞士; MSO的字体间距:可变的; mso-font-signature:-1610611985 1073750139 0 0 159 0;} / *样式定义* / p.MsoNormal,li.MsoNormal,div.MsoNormal {mso-style-parent:"" ;;边距:0厘米;保证金右:0厘米;边距:10.0pt;利润率左:0厘米;行高:115%; MSO的分页:寡妇,孤儿;字体大小:11.0pt; FONT-FAMILY:宋体; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman"; mso-fareast-language:EN-US;} @page Section1 {size:612.0pt 792.0pt;保证金:70.85pt 70.85pt 70.85pt 70.85pt; MSO头利润率:36.0pt; MSO英尺利润率:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} - >

你好,

<!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin-top:0cm; margin-right:0cm; margin-bottom:10.0pt; margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:Calibri; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman"; mso-fareast-language:EN-US;} @page Section1 {size:612.0pt 792.0pt; margin:70.85pt 70.85pt 70.85pt 70.85pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} -->

Hello,

我建了一个相当的包含复杂性的简单数据库,我的表大致如下客户端:Customer,Customerorder,lineCustomerorder,Produced;然后购买:购买者,供应商,供应商,(取决于表买方和供应商)Linesupplierorder,Product(与Customers表中的Produced 相同)生成的表连接到两个表Mouvements (进/出)和这些Mouvements表连接到Stock表和Emplacement表。

I built a rather simple data base which contains a complexity, approximately my tables are as follows the Customer side: Customer, Customerorder, lineCustomerorder, Produced;    and then side Purchase : Purchaser, Supplier, Supplierorder,  (which depends on the tables Purchaser and Supplier)  Linesupplierorder,  Product (same table as Produced  in the Customers tables) the table produced is connected to two table Mouvements (In/Out) and These Mouvements tables are connected to a Stock table and an Emplacement table.

然后我的问题是如下所示我希望在每次输入产品后动态管理站点 我希望表站点中的列可用性更改值(在:更改传递给0和Out的值:更改传递给的值) 1)除了在这个要求之外还有另一个限制因素是研究的限制因素(在表格中我有一些标准,例如我们在表格中找到的重量和尺寸,表明每个地点的重量和面对并根据这些标准和基本的一个"av产品的可用性"也。在完成Out之后,程序必须将表单"MOVEMENT IN"中的listBox中的站点翻转过来,并验证站点的值传递给0的站点,将其排除在下一个In中并在Out中同样的东西离开分配地点的产品通过1,以便再次使用。)

Then my question is as follows I want to manage the sites dynamically   after each entry of product I want that the column availability in the table site changes value ( In: change the value passed to 0 and Out: change the value passed to 1) except that on this request there is another constraint which is the constraint of research ( in the table produced I have criteria such as the weight and the size that we find also in the table site which indicates the capacity of each site in weight and the face  and according to these criterions and the  basic one "the availability of the products" also. After having done the Out, the program must turn over me the sites in a listBox in the Form "MOVEMENT IN" and validation of the sites the value of the site pass to 0 what excluded it form the next In and the same thing at Out the products which left the sites where they were allotted pass to 1 so that they can be used again).

大概是非常复杂的,我想知道我是否必须使用VB.net或SQL,或者同时使用LINQ或者三个

  Approximately it is very Complexes and I wonder if I must do it with VB.net or SQL or from the LINQ or the Three at the same time

我可以在LINQ数据集中做什么来解决这个问题,以便采用搜索一个表的标准,然后在光标已经错误的情况下,在特定的冒号行中获取表中的CODE_SItes。

What can i do in LINQ to dataset to resolve this problem to take criteria of search for ones table and then fitered take the CODE_SItes in the table mouvement in specific colonne for the row when the cursor has foucused ?????

我还有一个关于表的主键的问题,我们可以个性化吗?它们或输入数据(例如导入具有相同类型和相同字段的另一个数据库的数据:来自Sybase的数据库,这是相同的 语言T- SQL作为SQL Server)

I have one more question about the Primary keys of the tables, Could we personalize them or make an importation of data (as for example to import the data of another data base with the same types and the same the fields ex: from the data base of Sybase which is the same   language T-SQL as SQL Server)

信息软件:Visual Studio 2008 Pro SP1和SQL Server Express train 2008

技能信息:关于创建类或个性化对象的知识很少。

亲切,

谢谢

Pleaseeeeeeeeeeeee help meeeeeeee !!!!!!!!!!!!!!!!!!

推荐答案


这篇关于请帮助我LINQ to DATASET !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-23 21:20