/// <summary>
/// Method Name: Page_Load
/// Description:Concept of session dataset & Binding with GridView
/// Author:bhumi
/// created On:2/6/2015
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
try
{
//Typed Dataset & its TableAdapter
dataset = new Employees_TypedDataSet();
adapter = new Employees_TypedDataSetTableAdapters.EmployeesTableAdapter();
//fill the daset with specific table
adapter.Fill(dataset.Employees);
//display data in gridview
Session["Dataset_session"] = dataset.Employees;
gvEmployees.DataSource = Session["Dataset_session"];
gvEmployees.DataBind();
}
catch (Exception)
{
objconstmsg = new ConstantMessages();
Response.Redirect(objconstmsg.strerrorpage);
}
finally
{
adapter = null;
dataset = null;
}
}
/// <summary>
/// Event Name:Page Load Event
/// Description:databinding with gridview
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
StringBuilder strbuilder;//string builder for query
try
{
//insert SQLquery in String builder
strbuilder = new StringBuilder("SELECT * ");
strbuilder.Append(" FROM");
strbuilder.Append(" EmployeeTerritories;");
//connection generation and read the data fro reader
objcmnfunction = new CommonFunctions();
//datatable
datatable = new DataTable();
//dataset
dataset = new Employees_TypedDataSet();
datatable = objcmnfunction.ConnectionGenerate(strbuilder.ToString());
//fill the dataset
dataset.Tables.Add(datatable);
//store data in grid view
gvEmployeeTerritory.DataSource = datatable;
gvEmployeeTerritory.DataBind();
}
catch (Exception)
{
objconstmsg = new ConstantMessages();
Response.Redirect(objconstmsg.strerrorpage);
}
finally
{
objcmnfunction = null;
dataset = null;
datatable = null;
}
}
/// <summary>
/// method name:Grid_Fill
/// Description: Fill and bind the Gridview
/// Author:bhumi
/// Created On:1/6/2015
/// </summary>
public void Grid_Fill()
{
StringBuilder strbuilder;//string builder for query
try
{
objconstmsg = new ConstantMessages();
//insert SQLquery in String builder
strbuilder = new StringBuilder("SELECT EmployeeID,FirstName,LastName,TitleOfCourtesy,CONVERT(nvarchar,BirthDate,110) AS BirthDate,Address,City,Country,HomePhone");
strbuilder.Append(" FROM");
strbuilder.Append(" Employees;");
//connection generation and read the data fro reader
objcmnfunction = new CommonFunctions();
//datatable
dtEmployees = new DataTable();
//dataset
dataset = new Employees_TypedDataSet();
dtEmployees = objcmnfunction.ConnectionGenerate(strbuilder.ToString());
//fill the dataset
dataset.Tables.Add(dtEmployees);
//store data in grid view
gvEmployees.DataSource = dtEmployees;
gvEmployees.DataBind();
}
catch (Exception)
{
Response.Redirect(objconstmsg.strerrorpage);
}
finally
{
//objcmnfunction = null;
}
}
/// <summary>
/// Event Name:Page Load
/// Description:databinding with the gridview
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
StringBuilder strbuilder;//string builder for query
int EmployeeID;
try
{
EmployeeID = Convert.ToInt32(Request.QueryString[0]);
//insert SQLquery in String builder
strbuilder = new StringBuilder("SELECT * ");
strbuilder.Append(" FROM");
strbuilder.Append(" EmployeeTerritories");
strbuilder.Append(" where EmployeeID=" + EmployeeID);
objcmnfunction = new CommonFunctions();
objconstmsg = new ConstantMessages();
//dataset
dataset = new Employees_TypedDataSet();
table = new DataTable();
//fill the dataset
table = objcmnfunction.ConnectionGenerate(strbuilder.ToString());
if (table.Rows.Count > 0)
{
dataset.Tables.Add(table);
//store data in grid view
gvEmployeeTerritory.DataSource = table;
gvEmployeeTerritory.DataBind();
}
else
{
objconstmsg = new ConstantMessages();
Response.Write(objconstmsg.strdata_notavailable);
}
}
catch (Exception)
{
objconstmsg = new ConstantMessages();
Response.Redirect(objconstmsg.strdefault1page);
}
finally
{
objcmnfunction = null;
dataset = null;
table = null;
strbuilder = null;
}
}
