protected void GVCadastral_PageIndexChanged(object sender, EventArgs e)
{
GVCadastral.DataSource = ViewState["SwcCadastral"]; //GV分頁2 ViewState暫存網頁 關掉就消失
//GridView1.DataSource = Session["Date"]; //GV分頁2 暫存網頁
GVCadastral.DataBind();
}
private void ShowGvAll(string v)
{
//地籍...
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection ItemConn = new SqlConnection(connectionString.ConnectionString))
{
ItemConn.Open();
int nj = 0;
string strSQLRV2 = "select * from SWCLAND";
strSQLRV2 = strSQLRV2 + " Where SWC000 = '" + v + "' ";
strSQLRV2 = strSQLRV2 + " order by convert(int,LAND000) ";
SqlDataReader readerItem;
SqlCommand objCmdItem = new SqlCommand(strSQLRV2, ItemConn);
readerItem = objCmdItem.ExecuteReader();
while (readerItem.Read())
{
string dLAND000 = readerItem["LAND000"] + "";
string dLAND001 = readerItem["LAND001"] + "";
string dLAND002 = readerItem["LAND002"] + "";
string dLAND003 = readerItem["LAND003"] + "";
string dLAND004 = readerItem["LAND004"] + "";
string dLAND005 = readerItem["LAND005"] + "";
string dLAND006 = readerItem["LAND006"] + "";
string dLAND007 = readerItem["LAND007"] + "";
string dLAND008 = readerItem["LAND008"] + "";
DataTable tbCadastral = (DataTable)ViewState["SwcCadastral"];
if (tbCadastral == null)
{
DataTable GVTBCD = new DataTable();
GVTBCD.Columns.Add(new DataColumn("序號", typeof(string)));
GVTBCD.Columns.Add(new DataColumn("區", typeof(string)));
GVTBCD.Columns.Add(new DataColumn("段", typeof(string)));
GVTBCD.Columns.Add(new DataColumn("小段", typeof(string)));
GVTBCD.Columns.Add(new DataColumn("地號", typeof(string)));
GVTBCD.Columns.Add(new DataColumn("土地使用分區", typeof(string)));
GVTBCD.Columns.Add(new DataColumn("土地可利用限度", typeof(string)));
GVTBCD.Columns.Add(new DataColumn("林地類別", typeof(string)));
GVTBCD.Columns.Add(new DataColumn("地質敏感區", typeof(string)));
ViewState["SwcCadastral"] = GVTBCD;
tbCadastral = (DataTable)ViewState["SwcCadastral"];
}
DataRow GVTBCDRow = tbCadastral.NewRow();
GVTBCDRow["序號"] = ++nj;
GVTBCDRow["區"] = dLAND001;
GVTBCDRow["段"] = dLAND002;
GVTBCDRow["小段"] = dLAND003;
GVTBCDRow["地號"] = dLAND004;
GVTBCDRow["土地使用分區"] = dLAND005;
GVTBCDRow["土地可利用限度"] = dLAND006;
GVTBCDRow["林地類別"] = dLAND007;
GVTBCDRow["地質敏感區"] = dLAND008;
tbCadastral.Rows.Add(GVTBCDRow);
//Store the DataTable in ViewState
ViewState["SwcCadastral"] = tbCadastral;
GVCadastral.DataSource = tbCadastral;
GVCadastral.DataBind();
}
readerItem.Close();
}
}