网格视图到sql，还有sql到网格视图，最后到sql [英] Grid view to sql and also sql to grid view and finally to sql

问题描述

对于我的英语不好，我感到抱歉，我的问题是:(项目与Windows窗体中的计费系统有关)
我想放置gridview，在那位销售人员输入itemno(在第一列中)和itemquantity(在第二列中)，然后它将在数据库中获取itemname(在第三列中)，price(在第四列中)，price(在第五列中) )，之后必须将其插入其他数据库..

后端数据库:itemno，itemname，itemprice，itemdisc.
要插入其他数据库中:itemno，itemquantity，itemname，itemprice，itemdisc和total.




先生，我想开发一个计费系统，我必须放置一个网格视图才能输入
itemno itemname itemprice itemtotal，所以我希望尽快输入itemno，必须显示其名称价格总计，以后必须将所有数据发送到sql server.

很抱歉，如果这根本不是开发程序，请告诉我该怎么做，因为我对此感到困惑，对这些开发中的人来说我很陌生

我是C#.net学习者，也是WPF学习者，请帮助我如何处理代码，请为这个可怜的编码器花些时间..:-)

i am sorry for my poor English and my prob is that: (PROJECT IS ABOUT BILLING SYSTEM in windows forms)
i want to place gridview, in that sales person enters itemno(in 1st column)and itemquantity(in 2nd column) then it will fetch in database for itemname(in 3rd column), itemprice(in 4th column), itemdisc(in 5th column) later it has to be inserted into other database..

Backend Database: itemno, itemname, itemprice, itemdisc.
To be inserted in other Database: itemno, itemquantity, itemname, itemprice, itemdisc and total.




sir i want to develop billing system where i have to place a grid view to enter
itemno itemname itemprice itemtotal so i want as soon itemno is entered its name price total has to be display and later all the data has to be sent to sql server.

i am sorry if this is not at all a procedure to develop please tell me how can i do as i got stuckup with this and i am very new to these developing

i am C#.net learner and also WPF learner please help me how can i do with code and please spare little time for this poor coder..:-)

推荐答案

我还没有完全按照你的要求去做.但是在WinForm中，我要做的是创建一个WinForm网格，将其数据绑定到DataTable，然后为DataSet设置SQLAdaptor.

DataTable(.NET 2.0)是一种较旧的.NET技术，因此，如果您只是在学习，则可能要尝试使用诸如Entity Framework之类的其他工具.

此外，本文还可以为您提供帮助.他们的示例说明了如何将WPF网格数据盲化到DataTable，并且使用SQL查询填充了DataTable.它还包括有关如何保存数据的代码.


http://msdn.microsoft.com/en-us/library/aa480226.aspx [ ^ ]

I haven''t done exactly what you asking. But in WinForm, what I would do is I would create a WinForm Grid, databind it to a DataTable, and setup the SQLAdaptor for the DataSet.

DataTable (.NET 2.0) is an older .NET technology, so you may want to try something else like Entity Framework if you are just learning.

In addition, this article may help you. Their examples show how to datablind a WPF Grid to a DataTable, and the DataTable is populated with SQL query. It also includes code on how to save the data.


http://msdn.microsoft.com/en-us/library/aa480226.aspx[^]

这篇关于网格视图到sql，还有sql到网格视图，最后到sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！