C# = Stored Procedure/dbo Question?

Reply Forum
Forum postDavid R. Byrd @ 2012-01-13 18:04:57
ReplyReply to
I have built the following:

dbo.CPMessage

Stored Procedures:
dbo.admin_SelectMessage
ALTER PROCEDURE [dbo].[admin_SelectMessage]
AS
BEGIN
SELECT MessageID, [Message]
FROM dbo.CPMessage
WHERE MessageID = 1 --( Hardcoding - will always be first.)
END

dbo.admin_UpdateMessage
ALTER PROCEDURE [dbo].[admin_UpdateMessage]
(
@message varchar(1000)
)
AS
BEGIN
UPDATE dbo.CPMessage
SET [Message] = @message
WHERE MessageID = 1 -- (Hard coded again)
END

I developed MessageCenter: admin/MessageCenter.aspx w/multiline textbox "Banner1TB" that updates dbo.CPMessage.

I need to place the text from dbo.CPMessage into --
admin/Lead/Lead.aspx, multiline textbox "Banner2TB"
admin/Lead/Subs.aspx, multiline textbox "Banner3TB"
admin/Lead/Aids.aspx, multiline textbox "Banner4TB"
What is the best way to do this? SqlDataSource?
Please illustrate...













© net-tutorials.com 2006 - 2012

MailContact net-tutorials.com