Solved

Insert data from VB.NET datagridview to SQL-server stored procedure.

Posted on 2013-02-05
5
2,100 Views
1 Endorsement
Last Modified: 2013-04-26
I have a pos receipt UI form VB.NET I need to insert the receipt date and total to sales master table and my datagridview data to salesdetail table.
I need to pass all my data straight from the sales form to the SQL server stored procedure.
I want to achieve concurrency pos program with 5 tills (concurrent sales points) and 1 server(back office)
1
Comment
Question by:josanni2002
5 Comments
 
LVL 10

Accepted Solution

by:
Monica P earned 500 total points
ID: 38858928
Do you mean to store Data from Datagridview to Sqlserver through storedprocedure
If so refer below link for example

http://vbcity.com/forums/t/156452.aspx

http://www.dreamincode.net/forums/topic/285103-how-to-save-data-from-datagridview-to-sql-server-2008-in-vbnet/
0
 

Author Comment

by:josanni2002
ID: 38859497
i need to pass my values to the store procedure then the store procedure will execute the insert statement for me.
0
 
LVL 26

Expert Comment

by:Alan Warren
ID: 38862527
Does the datagridview have a datasource, how do you populate it?
Does the stored procedure have a name, expect input parameters, if so what are the parameters (types and size)?

Alan
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that undeā€¦
When we want to run, execute or repeat a statement multiple times, a loop is necessary. This article covers the two types of loops in Python: the while loop and the for loop.
The viewer will learn how to pass data into a function in C++. This is one step further in using functions. Instead of only printing text onto the console, the function will be able to perform calculations with argumentents given by the user.
The viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question