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)
{
}
}
