Solved

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

Posted on 2013-02-05
5
2,043 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.

831 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