Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
OfMartin
Starting Member
11 Posts |
 Posted - 2005-04-14 : 15:53:32
|
| I've designed a Windows-based form in VB.Net that tracks damaged or theft of equipment. I have one textbox for the user to input barcode & an 'Upgrade' button that executes a SP to update a record in the 'equipment' table to be marked as unavailable('Available'= '0') and add a record into the 'LossReport' table. I've also added a listview property that is designed to display the added Loss Report(Columns are Barcode, LossDate, & ReasonOfLoss).My problem is that I need to provide database access to a Microsoft SQL Server 2000 database. I've created all my SP's and my user interface. I only know how to access databases with ADO.Net. Could anyone offer me any instruction in how to do this? I know it starts with "Imports System.Data.SqlClient". Thats where I'm stuck. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-04-14 : 16:27:04
|
| I'm confused. Wouldn't you be using ADO.NET to connect to SQL Server in your VB.NET application? You say you know ADO.NET, so use it. Do yourself a favor: go buy a book that deals with ADO.NET and SQL Server.Tara |
 |
|
|
OfMartin
Starting Member
11 Posts |
Posted - 2005-04-14 : 16:51:49
|
| You can? Thanks for letting me know. That will save me a lot of time.OfMartin890@aol.com |
|
|
|
|
|
|
Opening to a SQL Server 2000 Database