Wednesday, September 29, 2010

stored procedures

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