Entry

Visual Studio: SQL: Procedure: Stored: Create: How let SqlAdapter wizard create stored procedure?

Dec 29th, 2003 17:21
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 30 December 2003 - 02:16 am -------------------

Visual Studio: SQL: Procedure: Stored: Create: How let SqlAdapter 
wizard create stored procedure?

---

Steps: Overview:

 1. -Run the SqlAdapter wizard to connect to the database

     1. -You are then asked if you want to create a stored procedure

 3. -If you confirm, this will create automatically a:

       -select

       -insert

       -update

       -delete

      stored procedure in Microsoft SQL server

 4. -This will e.g. create in Microsoft SQL server the following stored
     procedure:

      +---------------------------------------------------+
      |CREATE PROCEDURE dbo.NewSelectCommand29December2003|
      |AS                                                 |
      | SET NOCOUNT ON;                                   |
      | SELECT * FROM Emaillist                           |
      |GO                                                 |
      +---------------------------------------------------+

---
---

Internet: see also:

---

ASP.NET: Visual Basic: Database: Microsoft: SQL server: How to connect 
to database? [SqlDataAdapter]
http://www.faqts.com/knowledge_base/view.phtml/aid/27649/fid/1601

----------------------------------------------------------------------