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; } }