Grid view to sql and also sql to grid view and finally to sql

Question

3.00/5 (1 vote)

See more:

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..:-)

Posted 1-Jan-12 10:06am

karthikh87

Updated 4-Jan-12 4:53am

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 1-Jan-12 16:11pm

What exactly do you mean by GridView? Do you think there is only one type in the word?
Please tag UI library, language and application type...

Yes, I can see WPF and C# in the question, but you also want to tag it.
--SA

karthikh87 2-Jan-12 6:07am

datagridview which is used in windows forms and i dono about how many there in the world or in visual studio 2008 ha ha.. i was speaking about datagridview.

thankyou for asking specification as i am new to this

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

dickysum · Answer 1 · 2012-01-02T14:07:00

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[^]