add news

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Text;
public partial class Reporter_AddNews : System.Web.UI.Page
{
    DBUpdate newsins = new DBUpdate();
    SqlDataReader drdr;
    protected void Page_Load(object sender, EventArgs e)
    {
        int idUser = Convert.ToInt32(Session["idUser"]);
        string name = "";
        newsins.cmd.Parameters.Clear();

        SqlParameter p = new SqlParameter("@ret", SqlDbType.Int);
        p.Direction = ParameterDirection.ReturnValue;
        newsins.cmd.Parameters.Add(p);
        newsins.cmd.Parameters.AddWithValue("@userid", idUser);

        string fetchrow = "select * from tblReporterRegistration,tblUser where tblReporterRegistration.regnId = tblUser.registrationid and  tblUser.userid= " + idUser;

        drdr = newsins.datareader(fetchrow);
        while (newsins.dr.Read())
        {

            name = drdr["firstname"].ToString();
        }
        lbllogin.Text = "Welcome " + name;
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        newsins.cmd.Parameters.Clear();
        string curdate = System.DateTime.Now.ToString();
        SqlParameter p = new SqlParameter("@ret", SqlDbType.Int);
        p.Direction = ParameterDirection.ReturnValue;
        newsins.cmd.Parameters.Add(p);
        newsins.cmd.Parameters.AddWithValue("@categoryId ", drCategory.SelectedValue);
        newsins.cmd.Parameters.AddWithValue("@Title", txtTitle.Text);
        newsins.cmd.Parameters.AddWithValue("@link", "http://www." + txtLink.Text);
        newsins.cmd.Parameters.AddWithValue("@description", txtContents.Text);
        newsins.cmd.Parameters.AddWithValue("@curdate", curdate);

        string filename = UploadImage.FileName.ToString();
        newsins.cmd.Parameters.AddWithValue("@adimage", filename);
        ////advertise.cmd.Parameters.AddWithValue("@advideo", "");

        UploadImage.SaveAs(Server.MapPath("..\\Reporter\\images\\") + UploadImage.FileName.ToString());
      
            string s = newsins.excproc("newsinsert");

            if (s == "1")
            {


                Response.Write("<script>alert('News Inserted...')</script>");
                //  clearall();
                StringBuilder sb = new StringBuilder();
                sb.Append("<script>");
                sb.Append("window.open('ReporterHome.aspx', '', '');");
                sb.Append("</scri");
                sb.Append("pt>");

                Page.RegisterStartupScript("test", sb.ToString());
            }
           

      
    }
    private void clientScriptAlert(string Message)
    {
        Page.RegisterClientScriptBlock("clientScript", "<script>alert('" + Message + "')</script>");
    }
}