Sunday, March 25, 2012

Bind Grid View....

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;

public partial class EmployeeList : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
// The Page is accessed for the first time.
if (!IsPostBack)
{
// Initialize the sorting expression.
ViewState["SortExpression"] = "EmployeeID";

BindGrid();
}
else
{

string ctrlname = Page.Request.Params.Get("__EVENTTARGET");

Control _ctlPostback =GetPostBackControl(this.Page);

if (_ctlPostback != null)
{
#region
if (_ctlPostback.ClientID.ToString().Equals("ctl00_ContentPlaceHolder1__ddlPagerSize"))
{
int _intGetPagerSize = int.Parse(_ddlPagerSize.SelectedValue.ToString());
string _strGetFilter = _ddlFilter.SelectedValue.ToString();

_gridEmployeeList.PageSize = _intGetPagerSize;

BindGrid();
}
#endregion
}
}
}



///


/// Get Which html Controls cause Postback...
///

///
///
public static Control GetPostBackControl(Page page)
{
Control control = null;

string ctrlname = page.Request.Params.Get("__EVENTTARGET");
if (ctrlname != null && ctrlname != string.Empty)
{
control = page.FindControl(ctrlname);
}
else
{
foreach (string ctl in page.Request.Form)
{
Control c = page.FindControl(ctl);
if (c is System.Web.UI.WebControls.Button)
{
control = c;
break;
}
}
}
return control;
}




///
/// Fired when Cancel button is clicked
///

///
///
protected void CancelRecord(object sender, GridViewCancelEditEventArgs e)
{
_gridEmployeeList.EditIndex = -1;
BindGrid();
}


///
/// Fires when Edit button is clicked
///

///
///
protected void EditRecord(object sender, GridViewEditEventArgs e)
{
_gridEmployeeList.EditIndex = e.NewEditIndex;
BindGrid();
}

///
/// Fires when Update button is clicked
///

///
///
protected void UpdateRecord(object sender, GridViewUpdateEventArgs e)
{
//// Refresh the list
BindGrid();
}

///
/// fires when Delete button is clicked
///

///
///
protected void DeleteRecord(object sender, GridViewDeleteEventArgs e)
{
}

///
/// Fires when page links are clicked
///

///
///
protected void ChangePage(object sender, GridViewPageEventArgs e)
{
_gridEmployeeList.PageIndex = e.NewPageIndex;
// Refresh the list
BindGrid();
}

///
/// Fires when Columns heading are clicked
///

///
///
protected void SortRecords(object sender, GridViewSortEventArgs e)
{
}


///
/// Bind the gridview
///

private void BindGrid()
{
DataSet _dsGetEmployees = Employee.GetEmployees(true);

if (UIUtil.IsDataSetValidate(_dsGetEmployees))
{
// Set the sort column and sort order.
_gridEmployeeList.Sort(ViewState["SortExpression"].ToString(), SortDirection.Ascending);

// Bind the GridView control.
_gridEmployeeList.DataSource = _dsGetEmployees;
_gridEmployeeList.DataBind();
}
}


// Initialize the Employee List DataTable.
private void InitializeDataSource()
{
// Create a DataTable object named dtPerson.
DataTable dtPerson = new DataTable();
}


protected void _ddlPagerSize_SelectedIndexChanged(object sender, EventArgs e)
{

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

}
protected void _imgButAddEmployee_Click(object sender, ImageClickEventArgs e)
{
Response.Redirect("~/EmployeePage.aspx");
}


///
/// On Row Data Bound...
///

///
///
protected void _gridEmployeeList_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
ImageButton imgBut = (ImageButton)e.Row.FindControl("delbut");
imgBut.Attributes.Add("onclick", "javascript:return " +
"confirm('Are you sure you want to delete this record " +
DataBinder.Eval(e.Row.DataItem, "EmployeeID") + "')");
}
}

///
/// Delete Record....
///

///
///
protected void _gridEmployeeList_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
int _intEmpIdtoUpdateStatus = Convert.ToInt32(e.CommandArgument);

if (_intEmpIdtoUpdateStatus > 0)
{
// Delete the record
bool _bIsUpdatedStatus = Employee.UpdateStatusEmployee(_intEmpIdtoUpdateStatus, false);
}

BindGrid();
}
}
}

0 comments:

About This Blog

  © Blogger templates 'Neuronic' by Ourblogtemplates.com 2008

Back to TOP