private void ViewUsers()
{
IList <GetAccountDetails> details = new List <GetAccountDetails>();
details = ad.ListViewUsers();
IList <GetAccountDetails> de = details.Where(a => a.CustomerName == "ramya").ToList();
var ga = from a in details
orderby a.Age ascending
select a;
ViewUsersGrid.DataSource = ga;
ViewUsersGrid.DataBind();
}
protected void Filling_Gridview()
{
try
{
sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@flag", "1");
datast = new DataSet();
datast = accessclass.GetDataSet("ViewUsers", CommandType.StoredProcedure, sqlParams);
if (datast.Tables[0].Rows.Count > 0)
{
ViewUsersGrid.DataSourceID = null;
ViewUsersGrid.DataSource = datast;
ViewUsersGrid.DataBind();
Lbl_rc.ForeColor = System.Drawing.Color.Black;
Lbl_rc.Font.Bold = true;
Lbl_rc.Text = "<font color='#009933'>Total no of records : " + datast.Tables[0].Rows.Count + "</font>";
trP1.Visible = true;
ViewUsersGrid.Visible = true;
}
else
{
ViewUsersGrid.DataSourceID = null;
Lbl_rc.ForeColor = System.Drawing.Color.Black;
Lbl_rc.Font.Bold = true;
Lbl_rc.Text = "<font color='#FF0000'>No record in the list.</font>";
trP1.Visible = false;
ViewUsersGrid.Visible = false;
}
}
catch (Exception ex)
{
lblmsg.Visible = true;
lblmsg.Text = "Error : " + ex.Message;
}
finally
{
sqlParams = null;
datast.Dispose();
}
}