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