Click button outside grid view and display the grid view upon load?

 

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlTypes;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using com.vrm.database;

using com.vrm.com;

namespace StarTrack

{

public partial class 
ContractTemplate : System.Web.UI.Page

{

private vrm_database vrmdb 
= new vrm_database();

private String 
viewStateGVName = "gvTemplate";





//set the index 
for the columns of the gridview in the aspx that required formatting of 
text

private const int 
GVCHKBOX = 0;

private const int 
GVEDITBTN = 1;

private const int 
GVVENDORBRN = 2;

private const int 
GVMATERIALGRP = 4;

private const int 
GVINSAP = 8;

private const int 
GVSTARHUBCONTACTPERSON = 9;

private const int 
GVDELETEFLAG = 16;

private const int 
GVBLOCKED = 17;

//set the const 
for the ID of the GV Checkbox column

private const string GVCHECKBOXCOLID = "selected";



protected void 
Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

//Set the 
sortExpression

ViewState[this.ToString() + "_SortExpression"] 
= "TemplateName";

ViewState[this.ToString() + "_SortDirection"] = 
"ASC";







}

}

protected void 
btnClear_Click(object sender, EventArgs e)

{

gvTemplate.Visible = false;

tbSearchTID.Text = "";

tbSearchTName.Text = "";



}

protected void 
btnSearch_Click(object sender, EventArgs e)

{

BindGrid(true);

gvTemplate.Visible = true;

}

protected void 
chkSelectAll_CheckedChanged(object sender, EventArgs e)

{

CheckBox chk;

foreach (GridViewRow rowItem 
in gvTemplate.Rows)

{

chk = (CheckBox)(rowItem.Cells[0].FindControl("selected"));

chk.Checked = ((CheckBox)sender).Checked;

}

}

private void 
lblerror(string p)

{

throw new NotImplementedException();

}

//Bind the 
GridView to with the Database returned records

private void 
BindGrid(bool Reload)

{



DataTable dtTemplateRecords = null;



if (Reload)

//get from 
database and bind to GV

{

dtTemplateRecords = vrmdb.Get_TemplateRecords(tbSearchTID.Text, 
tbSearchTName.Text).Tables[0];

ViewState[viewStateGVName] = dtTemplateRecords;

}

else

{ //vrmdb.Get_TemplateRecords(tbSearchTName.Text)

//retrive the 
view state object data table from previous retrival

dtTemplateRecords = ViewState[viewStateGVName] as DataTable;

}

if (dtTemplateRecords != null)

{

gvTemplate.Columns[GVCHKBOX].Visible = true;

gvTemplate.DataSource = ViewState[viewStateGVName];

gvTemplate.AllowSorting = true;

gvTemplate.DataBind();

}

else

{

dtTemplateRecords.Rows.Add(dtTemplateRecords.NewRow());

ViewState[viewStateGVName] = dtTemplateRecords;

gvTemplate.AllowSorting = false;

gvTemplate.DataSource = ViewState[viewStateGVName];

gvTemplate.DataBind();

//hide the 
checkbox and edit columns

gvTemplate.Columns[GVCHKBOX].Visible = false;

gvTemplate.Columns[GVEDITBTN].Visible = false;



int TotalColumns = 
gvTemplate.Rows[0].Cells.Count;

gvTemplate.Rows[0].Cells.Clear();

gvTemplate.Rows[0].Cells.Add(new TableCell());

gvTemplate.Rows[0].Cells[0].ColumnSpan = TotalColumns;

gvTemplate.Rows[0].Cells[0].Text = "No Record Found";

}





}

protected void 
gvTemplate_RowCreated(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.Header)

{

GridView header = (GridView)sender;

GridViewRow gvr = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Insert);

TableCell tCell = new TableCell();

tCell.Text = "Contract Management Templates";

tCell.ColumnSpan = 9;

tCell.HorizontalAlign = HorizontalAlign.Left;

tCell.CssClass = "trWithBorder";

gvr.Cells.Add(tCell);

// Add the 
Merged TableCell to the GridView Header 

Table tbl = gvTemplate.Controls[0] 
as Table;

if (tbl != null)

{

tbl.Rows.AddAt(0, gvr);

}

}



}

protected void 
gvTemplate_Sorting(object sender, GridViewSortEventArgs e)

{

GetSortDirection(e.SortExpression);

BindGrid(false);

}

private void 
GetSortDirection(string sColumn)

{

//set sort 
direction to asc

string sSortDirection = "ASC";

string sSortExpression = 
ViewState[this.ToString() +

"_SortExpression"] as string;

if (sSortExpression != null)

{

//check same 
column is being sorted

if (sSortExpression == sColumn)

{

string sLastDirection = ViewState[this.ToString() +

"_SortDirection"] as string;

if ((sLastDirection != null) 
&& (sLastDirection == "ASC"))

{

sSortDirection = "DESC";

}

}

}

//save new 
values in view

ViewState[this.ToString() + "_SortDirection"] = 
sSortDirection;

ViewState[this.ToString() + "_SortExpression"] 
= sColumn;

}





protected void 
gvTemplate_RowCommand(object sender, GridViewCommandEventArgs e)

{

if (e.CommandName.Equals("AddNew"))

{

TextBox txtTemplateID = (TextBox)gvTemplate.FooterRow.FindControl("txtTemplateID");

TextBox txtTemplateName = (TextBox)gvTemplate.FooterRow.FindControl("txtTemplateName");

TextBox txtFileName = (TextBox)gvTemplate.FooterRow.FindControl("txtFileName");

TextBox txtFilePath = (TextBox)gvTemplate.FooterRow.FindControl("txtFilePath");



Console.WriteLine(txtTemplateID.Text);

Console.WriteLine(txtTemplateName.Text);

Console.WriteLine(txtFileName.Text);

Console.WriteLine(txtFilePath.Text);







vrmdb.Insert_TemplateRecords(txtTemplateID.Text, txtTemplateName.Text, 
txtFileName.Text, txtFilePath.Text);



BindGrid(true);

Response.Redirect("ContractTemplate.aspx");

}

}



protected void 
gvTemplate_RowEditing(object sender, GridViewEditEventArgs e)

{

gvTemplate.EditIndex = e.NewEditIndex;

BindGrid(true);

}

protected void 
gvTemplate_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

TextBox txtTemplateID = (TextBox)gvTemplate.Rows[e.RowIndex].FindControl("txtTemplateID");

TextBox txtFilePath = (TextBox)gvTemplate.Rows[e.RowIndex].FindControl("txtFilePath");







vrmdb.Update_TemplateRecords(txtTemplateID.Text,txtFilePath.Text);

gvTemplate.EditIndex = -1;

BindGrid(true); 

}

protected void 
gvTemplate_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

gvTemplate.EditIndex = -1;

BindGrid(true);

}

protected void 
gvTemplate_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

vrmdb.Delete_TemplateRecords(gvTemplate.DataKeys[e.RowIndex].Values[0].ToString());

BindGrid(true);

}

protected void 
AddBtn_Click(object sender, EventArgs e)

{

DataTable dtTemplateRecords = null;

if (dtTemplateRecords != null)

{

if (dtTemplateRecords.Rows.Count > 0)

{

ViewState[viewStateGVName] = dtTemplateRecords;

gvTemplate.DataSource = ViewState[viewStateGVName];

gvTemplate.DataBind();

}



}







}

}

}