Solved

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

Posted on 2013-02-05
5
2,153 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Turn Insights Into Action

You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.

With xMatters, you'll never miss a beat.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.

696 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