private void bind()
{
string userName = this.txtLoginName.Text.Replace("'", "''").Trim();
DateTime startDate = Convert.ToDateTime(this.t_Date.Text);
DateTime endDate = Convert.ToDateTime(this.e_Date.Text).AddDays(1);
Resource obj = new Resource();
DataSet ds=obj.GetNotPassResources(userName,startDate,endDate,this.AspNetPager1.PageSize,pageIndex);
this.GridView1.DataSource = ds.Tables[1];
this.GridView1.DataBind();
this.AspNetPager1.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
}