public void LoadGrid()
{
DatabaseRowObject.DatabaseColumnObject databaseColumnObj = null;
dataGridObject = new DataGridObject(WebConfigurationManager.ConnectionStrings["MyTherapistDatabaseConnectionString"].ConnectionString, "PatientInformation");
databaseRowObject = new DatabaseRowObject();
databaseColumnObj = new DatabaseRowObject.DatabaseColumnObject();
databaseColumnObj.DataBaseTableColumnName = "Id";
databaseColumnObj.DataGridColumnName = "Id";
databaseColumnObj.DataType = MyDataTypes.INTEGER;
databaseColumnObj.IncludeInDataGrid = true;
databaseColumnObj.OrderByColumn = true;
databaseColumnObj.Encrypted = false;
databaseRowObject.AddColumn(databaseColumnObj);
databaseColumnObj = new DatabaseRowObject.DatabaseColumnObject();
databaseColumnObj.DataBaseTableColumnName = "FirstName";
databaseColumnObj.DataGridColumnName = "First Name";
databaseColumnObj.DataType = MyDataTypes.STRING;
databaseColumnObj.IncludeInDataGrid = true;
databaseColumnObj.OrderByColumn = false;
databaseColumnObj.Encrypted = false;
databaseRowObject.AddColumn(databaseColumnObj);
databaseColumnObj = new DatabaseRowObject.DatabaseColumnObject();
databaseColumnObj.DataBaseTableColumnName = "LastName";
databaseColumnObj.DataGridColumnName = "Last Name";
databaseColumnObj.DataType = MyDataTypes.STRING;
databaseColumnObj.IncludeInDataGrid = true;
databaseColumnObj.OrderByColumn = false;
databaseColumnObj.Encrypted = false;
databaseRowObject.AddColumn(databaseColumnObj);
databaseColumnObj = new DatabaseRowObject.DatabaseColumnObject();
databaseColumnObj.DataBaseTableColumnName = "BirthDate";
databaseColumnObj.DataGridColumnName = "BirthDate";
databaseColumnObj.DataType = MyDataTypes.STRING;
databaseColumnObj.DisplayType = MyDisplayTypes.DATE;
databaseColumnObj.IncludeInDataGrid = true;
databaseColumnObj.OrderByColumn = false;
databaseColumnObj.Encrypted = true;
databaseRowObject.AddColumn(databaseColumnObj);
databaseColumnObj = new DatabaseRowObject.DatabaseColumnObject();
databaseColumnObj.DataBaseTableColumnName = "EmailAddress";
databaseColumnObj.DataGridColumnName = "Email Address";
databaseColumnObj.DataType = MyDataTypes.STRING;
databaseColumnObj.IncludeInDataGrid = true;
databaseColumnObj.OrderByColumn = false;
databaseColumnObj.Encrypted = true;
databaseRowObject.AddColumn(databaseColumnObj);
databaseColumnObj = new DatabaseRowObject.DatabaseColumnObject();
databaseColumnObj.DataBaseTableColumnName = "TelephoneNumber";
databaseColumnObj.DataGridColumnName = "Telephone Number";
databaseColumnObj.DataType = MyDataTypes.STRING;
databaseColumnObj.IncludeInDataGrid = true;
databaseColumnObj.OrderByColumn = false;
databaseColumnObj.Encrypted = true;
databaseRowObject.AddColumn(databaseColumnObj);
dataGridObject.DatabaseRowObject = databaseRowObject;
dataGridObject.FillToCompletePage = true;
dataGridObject.PageNumber = 1;
dataGridObject.NumberRowsToDisplay = 15;
pager = new MyDataGridPager();
pager.AddColumn("Id", 15);
pager.AddColumn("First Name", 25);
pager.AddColumn("Last Name", 250);
pager.AddColumn("Email Address", 250);
pager.AddColumn("Telephone Number", 100);
if (txtBoxPatientFirstName.Text.Length > 0)
{
dataGridObject.AddWhereClauseArgument("FirstName", txtBoxPatientFirstName.Text);
}
if (txtBoxPatientLastName.Text.Length > 0)
{
dataGridObject.AddWhereClauseArgument("LastName", txtBoxPatientLastName.Text);
}
if (IsPostBack == false)
{
dataGridObject.PageNumber = 1;
Session["PatientList_PageNumber"] = "1";
}
else
{
dataGridObject.PageNumber = Int32.Parse(Session["PatientList_PageNumber"].ToString());
}
patientlistgridview.DataSource = dataGridObject.BuildTable();
patientlistgridview.RowDataBound += Patientlistgridview_RowDataBound;
patientlistgridview.SelectedIndexChanged += Patientlistgridview_SelectedIndexChanged;
patientlistgridview.DataBind();
if (dataGridObject.NumberOfCompletedPages == 0)
{
btnNextPAge.Enabled = false;
}
else
{
btnNextPAge.Enabled = true;
}
}
