Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Other Office > Visual Studio Tools for Office
Password Reminder
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Visual Studio Tools for Office Be sure to specify which version you are working with.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Studio Tools for Office section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Display Modes
  #1 (permalink)  
Old July 14th, 2006, 11:29 AM
Registered User
Join Date: May 2006
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Using excel as front end for data entry

I am thinking of using VSTO 2005 to program Excel as a front to enter data to a sql server or access database. I have not been able to find any examples from books or the web. Can someone give me some pointers as to how I can proceed? I have seen quite a few examples on how to pull data out. But I have yet to come across an example to put data in!
Can VSTO 2005 use ADO.NET?
Thanks for the help.
Reply With Quote
  #2 (permalink)  
Old July 21st, 2006, 04:42 PM
Authorized User
Join Date: Apr 2006
Location: , , .
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts

The process is fairly straightforward. Build your front end with your client as a spreadsheet and add a submit or update button. In the click event handler, retrieve the contents of the range object in the spreadsheet and build a query. The book, Professional VSTO 2005, contains sample code to show you how to retrieve data from the range object.

As far as binding directly to the database, VSTO doesn't currently support this.

>Can VSTO 2005 use ADO.NET?
ADO.NET is platform agnostic. Any managed code, to include VSTO can access the ADO.NET layer.

Reply With Quote
  #3 (permalink)  
Old July 25th, 2006, 01:54 PM
Registered User
Join Date: May 2006
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts

I can bind an Excel spread sheet to a database and 'browse' through the data using VSTO
I just don't know how to enter data from the same spreadsheet to the database that I was able to bind.
Do I have to create a rangename to accept the input and use it as a parameter to a stored procedure to insert?

Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Forms or a solution for end user data entry? Scott B SQL Server 2005 0 October 19th, 2007 04:21 AM
Ms Access front End with Oracle 10g Back End rahul123 Oracle 1 July 9th, 2007 01:03 AM
Oracle back-end MS-Access 2003 client front-end Corey Access 2 February 16th, 2007 07:31 AM
Oracle Back End - MS Access Front End - Multi User ckaliveas Oracle 1 February 1st, 2007 05:00 AM
SQL server with excel as front-end Stanny SQL Server 2000 0 February 12th, 2005 06:05 AM

All times are GMT -4. The time now is 05:20 PM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.