Grid view code

using System;
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;
public partial class _Default : System.Web.UI.Page
{
    SqlConnection sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString());

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

    protected void BinData()
    {
        //SqlDataAdapter sqlDa = new SqlDataAdapter("select * from Gridview", sqlCon);
        //DataSet Ds = new DataSet();
        //sqlDa.Fill(Ds, "Gridview");
        //GridView1.DataSource = Ds.Tables["Gridview"].DefaultView;
        //GridView1.DataBind();

        sqlCon.Open();
        SqlCommand sqlCmd = new SqlCommand("select * from Gridview",sqlCon);
        SqlDataReader dr = sqlCmd.ExecuteReader();
        if(dr.Read())
        {
            GridView1.DataSource = dr;
            GridView1.DataBind();
       
        }

        sqlCon.Close();


    }
    //public void ddlfill()
    //{
    //    for (byte i = 1; i < GridView1.PageCount; i++)
    //    {
    //        DropDownList1.Items.Add(i.ToString());
    //    }
    //}

   
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }

protected void  GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
//  GridView1.PageIndex=e.NewPageIndex;
//    BinData();
//   btnSearch.Text = (e.NewPageIndex + 1) + "/out of/" + GridView1.PageCount;
}
protected void  GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
    //GridView1.EditIndex=e.NewEditIndex;
    //BinData();

}
protected void  GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
    //GridView1.EditIndex= -1;
    //BinData();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
    int sid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
    GridViewRow row = GridView1.Rows[e.RowIndex];
    TextBox TSname = (TextBox)row.FindControl("txtSName");
    TextBox TSclass = (TextBox)row.FindControl("txtSClass");
    TextBox TSCollege = (TextBox)row.FindControl("txtSCollege");
    TextBox TSCourse = (TextBox)row.FindControl("txtSCourse");
    TextBox TSPlace = (TextBox)row.FindControl("txtSPlace");
    SqlCommand sqlCmd = new SqlCommand();
    sqlCon.Open();
    sqlCmd.Connection = sqlCon;
    sqlCmd.CommandType = CommandType.StoredProcedure;
    sqlCmd.CommandText = "usp_update";
    sqlCmd.Parameters.Add("@sid", SqlDbType.Int).Value = sid;
    sqlCmd.Parameters.Add("@sname", SqlDbType.VarChar, 50).Value = TSname.Text;
    sqlCmd.Parameters.Add("@sclass", SqlDbType.VarChar, 50).Value = TSclass.Text;
    sqlCmd.Parameters.Add("@scollege", SqlDbType.VarChar, 50).Value = TSCollege.Text;
    sqlCmd.Parameters.Add("@scourse", SqlDbType.VarChar, 50).Value = TSCourse.Text;
    sqlCmd.Parameters.Add("@splace", SqlDbType.VarChar, 50).Value = TSPlace.Text;
    sqlCmd.ExecuteNonQuery();
    sqlCon.Close();
    GridView1.EditIndex = -1;
    BinData();


}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
    int sid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
    GridViewRow row = GridView1.Rows[e.RowIndex];
    SqlCommand sqlcmd = new SqlCommand();
    sqlCon.Open();
    sqlcmd.Connection = sqlCon;
    sqlcmd.CommandType = CommandType.StoredProcedure;
    sqlcmd.CommandText = "usp_delete";
    sqlcmd.Parameters.Add("@sid", SqlDbType.Int).Value = sid;
    sqlcmd.ExecuteNonQuery();
    sqlCon.Close();
    GridView1.EditIndex = -1;
    BinData();


}
protected void Button1_Click(object sender, EventArgs e)
{

    if (ddlSelect.SelectedIndex > 0)
    {
        SqlDataAdapter sqlDa = new SqlDataAdapter("select * from sdetails where " + ddlSelect.SelectedItem.Text + " like  '%" + txtSearch.Text + "%'", sqlCon);
        DataSet Ds = new DataSet();
        sqlDa.Fill(Ds, "sdetails");
        GridView1.DataSource = Ds.Tables["sdetails"].DefaultView;

        GridView1.DataBind();
    }

    else
    {
        SqlDataAdapter sqlDa = new SqlDataAdapter("select * from sdetails", sqlCon);
        DataSet Ds = new DataSet();
        sqlDa.Fill(Ds, "sdetails");
        GridView1.DataSource = Ds.Tables["sdetails"].DefaultView;
        GridView1.DataBind();

    }
}


protected void ddlSelect_SelectedIndexChanged(object sender, EventArgs e)
{

}

protected void btnCancel_Click(object sender, EventArgs e)
{
    SqlDataAdapter sqlDa = new SqlDataAdapter("select * from sdetails", sqlCon);
    DataSet Ds = new DataSet();
    sqlDa.Fill(Ds, "sdetails");
    GridView1.DataSource = Ds.Tables["sdetails"].DefaultView;
    GridView1.DataBind();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
    for (int i = 0; i < GridView1.Rows.Count; i++)
    {
        CheckBox ch = (CheckBox)GridView1.Rows[i].FindControl("chkDel");
        if (ch.Checked == true)
        {
            Label l1 = (Label)GridView1.Rows[i].FindControl("lblSid");
            sqlCon.Open();
            SqlCommand sqlCmd = new SqlCommand("delete from sdetails where sid='" + l1.Text + "'", sqlCon);
            sqlCmd.ExecuteNonQuery();
            sqlCon.Close();
        }

    }
    BinData();
}
protected void GridView1_SelectedIndexChanged1(object sender, EventArgs e)
{

}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
    GridView1.PageIndex = DropDownList1.SelectedIndex;
    BinData();
    btnShow.Text = (DropDownList1.SelectedIndex + 1) + "Outof" + GridView1.PageCount;
}
protected void CheckBox2_CheckedChanged(object sender, EventArgs e)
{
    CheckBox ch;
    CheckBox chkall = (CheckBox)GridView1.HeaderRow.FindControl("Chkall");
    if (chkall.Checked == true)
    {
        foreach (GridViewRow gvr in GridView1.Rows)
        {
            ch = (CheckBox)gvr.FindControl("chkDel");
            ch.Checked = true;

        }
    }
    else
    {
        foreach (GridViewRow gvr in GridView1.Rows)
        {
            ch = (CheckBox)gvr.FindControl("chkDel");
            ch.Checked = false;

        }
    }
}
protected void btnInsert_Click(object sender, EventArgs e)
{
    TextBox TSid = (TextBox)GridView1.FooterRow.FindControl("txtSid");
    TextBox TSname = (TextBox)GridView1.FooterRow.FindControl("txtSName");
    TextBox TSclass = (TextBox)GridView1.FooterRow.FindControl("txtSClass");
    TextBox TSCollege = (TextBox)GridView1.FooterRow.FindControl("txtSCollege");
    TextBox TSCourse = (TextBox)GridView1.FooterRow.FindControl("txtSCourse");
    TextBox TSPlace = (TextBox)GridView1.FooterRow.FindControl("txtSPlace");
    sqlCon.Open();
    SqlCommand sqlCmd = new SqlCommand("insert into sdetails values('" + TSid.Text + "','" + TSname.Text + "','" + TSclass.Text + "','" + TSCollege.Text + "','" + TSCourse.Text + "','" + TSPlace.Text + "')", sqlCon);
    sqlCmd.ExecuteNonQuery();
    sqlCon.Close();
    TSid.Text = "";
    TSid.Text = "submitted";
}
protected void chkall_CheckedChanged(object sender, EventArgs e)
{
    CheckBox ch;
    CheckBox chkall = (CheckBox)GridView1.HeaderRow.FindControl("Chkall");
    if (chkall.Checked == true)
    {
        foreach (GridViewRow gvr in GridView1.Rows)
        {
            ch = (CheckBox)gvr.FindControl("chkDel");
            ch.Checked = true;

        }
    }
    else
    {
        foreach (GridViewRow gvr in GridView1.Rows)
        {
            ch = (CheckBox)gvr.FindControl("chkDel");
            ch.Checked = false;

        }
    }
}
protected void GridView1_SelectedIndexChanged2(object sender, EventArgs e)
{

}
}