Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 18th, 2004, 12:37 AM
Registered User
Join Date: Sep 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to nishim.attreja
Default How do I insert stored procedure through C#


I have created a stored procedure to insert carclassid in mstcarclass table.The stored procedure is given below.

CREATE PROCEDURE [dbo].[nishim1](@carclassid numeric(9)) AS
insert into mstcarclass(carclassid)

How I call this stored procedure through schedule task.
Actually I want that this procedure should run automatically when new day starts.

Plz give me the proper solution

Nishim Attreja
Old September 18th, 2004, 01:24 AM
Friend of Wrox
Join Date: Oct 2003
Posts: 463
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to madhukp

Hello Nishim,

You can do this at SQL server itself. Open enterprise manager. Login as administrator. You can create a job. Specify the type as Transact-SQL. Then set its execution time and frequency.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Check value while insert in stored procedure Andraw SQL Server 2005 2 August 12th, 2008 09:08 AM
insert using stored procedure & sqldatasource ctrl mahajanvit ASP.NET 2.0 Basics 10 September 13th, 2006 09:03 AM
Stored Procedure Insert Null Value harpua SQL Server ASP 2 March 5th, 2005 10:19 AM
stored procedure dynamic insert harpua Classic ASP Databases 3 January 21st, 2005 12:50 AM
Using an insert stored procedure morpheus VB How-To 3 August 7th, 2003 08:42 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.