THis is My SP
USE [PostBook]
GO
/****** Object: StoredProcedure [dbo].[CreateNewPost] Script Date: 01/17/2009 15:36:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Mark Stewart
-- Create date: 09/10/2008
-- Description: New Post Item
-- =============================================
ALTER PROCEDURE [dbo].[CreateNewPost]
-- Add the parameters for the stored procedure here
--@DateReceived smalldatetime ,
@PostFrom varchar(200),
@PostTo varchar(200),
@CorrespondenceDate smalldatetime,
@DateForwarded smalldatetime,
@ResponseDate smalldatetime,
@Summary varchar(max),
@Disposal varchar(max),
@DisposalDate smalldatetime,
@ReferredTo varchar (200),
@AckDate smalldatetime,
@AckBy varchar (200),
@InterimReply varchar (200),
@InterimDate smalldatetime,
@ReplyDate smalldatetime,
@BusinessArea varchar (200),
@UserID int,
@ClassID int
AS
DECLARE @i AS INT
BEGIN TRANSACTION
SELECT @i = COALESCE(MAX(ReferenceID), 0)
FROM dbo.PostBookItems WITH (TABLOCKX, HOLDLOCK)
WHERE PostBookID = 1
INSERT INTO dbo.PostBookItems(PostBookID, ReferenceID, DateReceived, PostFrom, PostTo,
CorrespondenceDate, DateForwarded, ResponseDate, Summary,
Disposal, DisposalDate, ReferredTo, AckDate, AckBy,
InterimReply, InterimDate, ReplyDate, BusinessArea,ClassID,UserID,DateUpdated)
VALUES(1, @i + 1, GETDATE(), @PostFrom, @PostTo,
@CorrespondenceDate, @DateForwarded, @ResponseDate, @Summary,
@Disposal, @DisposalDate, @ReferredTo, @AckDate, @AckBy,
@InterimReply, @InterimDate, @ReplyDate, @BusinessArea,@ClassID,@UserID,GETDATE())
COMMIT
And this is my windows form code:-
private void saveNewPostItemMenuStrip_Click(object sender, EventArgs e)
{
dtPostBookItemsBindingSource.EndEdit();
taPostBookItems.CreateNewPost(dsMain.dtPostBookItems,, Program.PostbookID,(Convert.ToInt32(postFromTextBox.Text.ToString)
(Convert.ToString(postToTextBox.Text.ToString)
correspondenceDateDateTimePicker.Value.ToShortTimeString)
dateForwardedDateTimePicker.Value.ToShortTimeString),
responseDateDateTimePicker.Value,
summaryTextBox.ToString,
disposedTextBox.ToString,
disposalNotesTextBox.ToString,
ValueType = Convert.ToDateTime(disposalDateDateTimePicker.Value))
referredToTextBox.ToString,
ackDateDateTimePicker.Value,
ackByTextBox.ToString,
interimReplyTextBox.ToString,
interimDateDateTimePicker.Value,
replyDateDateTimePicker.Value,
businessAreaTextBox.ToString,
classIDTextBox)));
Help please.
No one has replied yet! Why not be the first?
Sign in or Join us (it's free).