Gecko [ vsec.in ]

Name	Size	Permission
Bin	[ DIR ]	drwxrwxrwx
Images	[ DIR ]	drwxrwxrwx
css	[ DIR ]	drwxrwxrwx
js	[ DIR ]	drwxrwxrwx
scss	[ DIR ]	drwxrwxrwx
vendor	[ DIR ]	drwxrwxrwx
.mad-root	0 B	-rw-rw-rw-
AddMedia.aspx	349 B	-rw-rw-rw-
AddMedia.aspx.cs	286 B	-rw-rw-rw-
Addblog.aspx	344 B	-rw-rw-rw-
Addblog.aspx.cs	285 B	-rw-rw-rw-
Addvideo.aspx	349 B	-rw-rw-rw-
Addvideo.aspx.cs	286 B	-rw-rw-rw-
Admin.master	14.4 KB	-rw-rw-rw-
Admin.master.cs	291 B	-rw-rw-rw-
Admin_Login - Copy.aspx	4.84 KB	-rw-rw-rw-
Admin_Login.aspx	4.84 KB	-rw-rw-rw-
Admin_Login.aspx.cs	1.5 KB	-rw-rw-rw-
DashboadMain.aspx	3.13 KB	-rw-rw-rw-
DashboadMain.aspx.cs	290 B	-rw-rw-rw-
Dashboard.aspx	16.1 KB	-rw-rw-rw-
Dashboard.aspx.cs	7.9 KB	-rw-rw-rw-
Events.aspx	8.94 KB	-rw-rw-rw-
Events.aspx.cs	4.34 KB	-rw-rw-rw-
Examination.aspx	7.83 KB	-rw-rw-rw-
Examination.aspx.cs	5.45 KB	-rw-rw-rw-
Gallery.aspx	6.5 KB	-rw-rw-rw-
Gallery.aspx.cs	4.5 KB	-rw-rw-rw-
Interhousecompetition.aspx	10 KB	-rw-rw-rw-
Interhousecompetition.aspx.cs	5.15 KB	-rw-rw-rw-
Life_Insurance.png	111.09 KB	-rw-rw-rw-
Newupdate.aspx	6.26 KB	-rw-rw-rw-
Newupdate.aspx.cs	4.2 KB	-rw-rw-rw-
Photo-gallery.aspx	5.36 KB	-rw-rw-rw-
Photo-gallery.aspx.cs	2.35 KB	-rw-rw-rw-
Show-contact-data.aspx	2.85 KB	-rw-rw-rw-
Show-contact-data.aspx.cs	871 B	-rw-rw-rw-
Showallgallery.aspx	5.15 KB	-rw-rw-rw-
Showallgallery.aspx.cs	5.31 KB	-rw-rw-rw-
SpecialMoments.aspx	7.15 KB	-rw-rw-rw-
SpecialMoments.aspx.cs	5.3 KB	-rw-rw-rw-
adminer.php	465.43 KB	-rw-rw-rw-
alumni_data.aspx	7.41 KB	-rw-rw-rw-
alumni_data.aspx.cs	4.62 KB	-rw-rw-rw-
career.aspx	39.47 KB	-rw-rw-rw-
career.aspx.cs	6.3 KB	-rw-rw-rw-
career_form_data.aspx	6.4 KB	-rw-rw-rw-
career_form_data.aspx.cs	868 B	-rw-rw-rw-
contact.aspx	347 B	-rw-rw-rw-
contact.aspx.cs	285 B	-rw-rw-rw-
download.aspx	15.01 KB	-rw-rw-rw-
download.aspx.cs	5.38 KB	-rw-rw-rw-
edit-gallery.aspx	4.51 KB	-rw-rw-rw-
edit-gallery.aspx.cs	1.32 KB	-rw-rw-rw-
profilemain.aspx	7.6 KB	-rw-rw-rw-
profilemain.aspx.cs	5.58 KB	-rw-rw-rw-
pwnkit	10.99 KB	-rw-rw-rw-

Code Editor : career.aspx.cs

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Configuration;
using System.Configuration;
using System.IO;

public partial class Admin_career : System.Web.UI.Page
{
    dbconnection con = new dbconnection();
    SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["myconnection"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Bind();
        }
    }

public override void VerifyRenderingInServerForm(Control control)
    {
        //required to avoid the runtime error "
        //Control 'GridView1' of type 'GridView' must be placed inside a form tag with runat=server."
    }

private void Bind()
    {
        SqlCommand cmd = new SqlCommand("select * from career", conn);
        SqlDataAdapter da = new SqlDataAdapter(cmd) ;
        DataSet ds = new DataSet();
        da.Fill(ds, "career");
        gv5.DataSource = ds;
        gv5.DataBind();
    }

protected void gv1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        gv5.EditIndex = e.NewEditIndex;
        Bind();
    }
    protected void gv1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {

int index = e.RowIndex;

GridViewRow row = (GridViewRow)gv5.Rows[index];

Label eid = (Label)row.FindControl("lbleid");

Label Com = (Label)row.FindControl("lblCom");

Label day = (Label)row.FindControl("lbldate");

FileUpload fu = (FileUpload)row.FindControl("fu1");

if (fu.HasFile)
        {

string file = System.IO.Path.Combine(Server.MapPath("Images/Resume/"), fu.FileName);
            fu.SaveAs(file);

SqlCommand cmd = new SqlCommand("update career set imgname = '" + fu.FileName + "' where id=" + Convert.ToInt32(eid.Text) + "," + (Com.Text) + "," + (day.Text) + ",", conn);

conn.Open();
            int res1 = cmd.ExecuteNonQuery();
            conn.Close();

if (res1 == 1)
            {
                Response.Write("<script>alert('Updation done!')</script>");
            }
            gv5.EditIndex = -1;
            Bind();
        }

}
    protected void gv1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        gv5.EditIndex = -1;
        Bind();
    }

protected void gv1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int index = e.RowIndex;

GridViewRow row = (GridViewRow)gv5.Rows[index];

Label eid = (Label)row.FindControl("lbleid");

SqlCommand cmd = new SqlCommand("delete from career where id=" + Convert.ToInt32(eid.Text) + "", conn);
        conn.Open();
        int res = cmd.ExecuteNonQuery();
        conn.Close();

if (res == 1)
        {
            Response.Write("<script>alert('Deletion done!')</script>");
        }
        Bind();
    }
    protected void gv1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gv5.PageIndex = e.NewPageIndex;  // Naya page index set karo
        Bind();
    }

protected void btnDownload_Click(object sender, EventArgs e)
    {
        int id = int.Parse((((sender as LinkButton).NamingContainer as GridViewRow).FindControl("Reid") as HiddenField).Value);
        byte[] bytes;
        string filename, ContentType;
        string constr = ConfigurationManager.ConnectionStrings["myconnection"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.CommandText = ("select Name,Resume from career where id=@id");
                {
                    cmd.Parameters.AddWithValue("@id", id);
                    cmd.Connection = con;
                }
                con.Open();
                using (SqlDataReader sdr = cmd.ExecuteReader())
                {

sdr.Read();
                    ContentType = sdr["Resume"].ToString();
                    filename = sdr["Name"].ToString();
                    con.Close();
                }
            }
        }

Response.Clear();
        Response.Buffer = true;
        Response.Charset = " ";
        Response.Cache.SetCacheability(HttpCacheability.NoCache);
        Response.ContentType = ContentType;
        Response.AddHeader("Content-Disposition", "attachment;filename =" + filename);
        Response.Flush();
        Response.End();
    }

protected void gv2_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            if (e.Row.RowIndex == 0)
                e.Row.Style.Add("HtmlTextWriterStyle.Width", "50px");
        }
    }

protected void btn2_Click(object sender, EventArgs e)
    {
        ExportToExcel();
    }

private void ExportToExcel()
    {
        Response.Clear();
        Response.Buffer = true;
        Response.ClearContent();
        Response.ClearHeaders();
        Response.Charset = " ";
        string FileName = "Career" + DateTime.Now + ".xls";
       
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite =new HtmlTextWriter(stringWrite);
        Response.Cache.SetCacheability(HttpCacheability.NoCache);
        Response.ContentType = "application/vnd.ms-excel";
        Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);
        gv5.GridLines = GridLines.Both;
        gv5.HeaderStyle.Font.Bold = true;
        
        gv5.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());
        Response.End();

}

protected void gv5_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {

}

protected void gv5_RowDataBound(object sender, GridViewRowEventArgs e)
    {

}

protected void gv5_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        // Set the new page index
        gv5.PageIndex = e.NewPageIndex;
        // Rebind the data to the GridView
        Bind();
    }
   
}

${this.title}

Code Editor : career.aspx.cs