Edit ,Delete,Update in Gridview

    
    


    

    

    

    
update college/univercity name in COLLEGEPATH table:
    

    
   
    
        
            
                <%#Eval("RegID")%>
            
           
             
                
                 
        
              
        
            
                <%#Eval("companyname")%>
            
            
               

            
            
        
               
     
   
    
   
   




     


    
    
    

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class multieditepage : System.Web.UI.Page
{
    advReport adv = new advReport();
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!Page.IsPostBack)
        {

            this.DataBind1();
        }

    }

    protected void cancel(object sender, GridViewCancelEditEventArgs e)
    {
        dg.EditIndex = -1;
        this.DataBind1();
    }
    protected void edit(object sender, GridViewEditEventArgs e)
    {
        dg.EditIndex = e.NewEditIndex;
        this.DataBind1();
    }
    protected void update(object sender, GridViewUpdateEventArgs e)
    {
        string regid = ((TextBox)(dg.Rows[e.RowIndex].FindControl("txtreg"))).Text;
        string name = ((FileUpload)(dg.Rows[e.RowIndex].FindControl("upfile"))).FileName;
       
            adv.updateevents(regid, name);
            dg.EditIndex = -1;
            this.DataBind1();
     
    }
   protected void delete(object sender, GridViewDeleteEventArgs e)
    {
   
        int regid = Convert.ToInt32(dg.DataKeys[e.RowIndex].Value);
        adv.deleterecord(regid);
        dg.EditIndex = -1;
      this.DataBind1();
    }
    protected void DataBind1()
    {
         DataSet ds = new DataSet();
      
        SqlDataAdapter myAdapter = new SqlDataAdapter("collegepathupdate", adv.connect());
       
        myAdapter.Fill(ds);
        PagedDataSource objPds = new PagedDataSource();
        objPds.DataSource = ds.Tables[0].DefaultView;

        objPds.AllowPaging = true;
        objPds.PageSize = 13;

        objPds.CurrentPageIndex = CurrentPage;

        lblfind.Text = "Page: " + (CurrentPage + 1).ToString() + " of "
            + objPds.PageCount.ToString() + "    Total Records :(" + ds.Tables[0].Rows.Count.ToString() + ")";

        // Disable Prev or Next buttons if necessary
        cmdPrev.Enabled = !objPds.IsFirstPage;
        cmdNext.Enabled = !objPds.IsLastPage;
        dg.DataSource = objPds;
        dg.DataBind();

    }

    protected void cmdPrev_Click(object sender, System.EventArgs e)
    {
        // Set viewstate variable to the previous page
        CurrentPage -= 1;

        // Reload control
        DataBind1();
    }

    protected void cmdNext_Click(object sender, System.EventArgs e)
    {
        // Set viewstate variable to the next page
        CurrentPage += 1;

        // Reload control
        DataBind1();
    }
    public int CurrentPage
    {
        get
        {
            // look for current page in ViewState
            object o = this.ViewState["_CurrentPage"];
            if (o == null)
                return 0; // default to showing the first page
            else
                return (int)o;
        }

        set
        {
            this.ViewState["_CurrentPage"] = value;
        }
    }
   
}

public class advReport
{
   public advReport()
    {
    }

 public void updateevents(string regid,string name)
    {
        int chk=1;
      
        SqlCommand cmd = new SqlCommand("insert into collegepath(regid,collegeurl,updatechk) values(@regid,@name,@chk)", connect());
        cmd.Parameters.Add("@regid", SqlDbType.Int).Value = Convert.ToInt32(regid);
        cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = name;
        cmd.Parameters.Add("@chk", SqlDbType.Int).Value = chk;

       
        cmd.ExecuteNonQuery();
        cmd.Connection.Close();
    }
public void deleterecord(int regid)
    {
        SqlCommand cmd = new SqlCommand("delete from registration where regID=@regid", connect());
        cmd.Parameters.Add("@regid", SqlDbType.Int).Value = regid;
        cmd.ExecuteNonQuery();
        cmd.Connection.Close();

    }
}