protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
string s;
title = txtTitle.Text.ToString();
insertcontents.cmd.Parameters.AddWithValue("@title",txtTitle.Text);
insertcontents.cmd.Parameters.AddWithValue("@url",txtTitle.Text+".html");
insertcontents.cmd.Parameters.AddWithValue("@bloggerid", Session["idUser"]);
insertcontents.cmd.Parameters.AddWithValue("@date",DateTime.Now.ToString());
s = insertcontents.excproc("spInsertTitle");
if (s == "1")
Response.Write("Inserted Succ");
// insertcontents.cmd.Parameters.AddWithValue("@status","Active");
}
ALTER PROCEDURE [dbo].[spInsertTitle]
(@title varchar(150), @url varchar(50),@bloggerid int,@date varchar(20))
AS
insert into tblTitle values (@title,@url,@bloggerid,@date)
No comments:
Post a Comment