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...
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...