using?System;
using?System.Collections;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Web;
using?System.Web.SessionState;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.HtmlControls;

using?SqlAdmin;

namespace?SqlWebAdmin
{
????public?partial?class?edittable?:?System.Web.UI.Page
????{



????????public?edittable（）
????????{
????????????Page.Init?+=?new?System.EventHandler（Page_Init）;
????????}

????????protected?void?Page_Load（object?sender?System.EventArgs?e）
????????{
????????????HttpCookie?cookie?=?Request.Cookies[“WebDataAdministrator“];
????????????if?（cookie?==?null）
????????????????Response.Redirect（“default.aspx?error=sessionexpired“）;

????????????SqlServer?server?=?new?SqlServer（cookie.Values[“server“]?cookie.Values[“username“]?cookie.Values[“password“]）;

????????????server.Connect（）;

????????????SqlDatabase?database?=?server.Databases[Request[“database“]];
????????????if?（database?==?null）?{
????????????????server.Disconnect（）;
????????????????Response.Redirect（String.Format（“error.aspx?error={0}“?1000））;
????????????????return;
????????????}

????????????SqlTable?table?=?database.Tables[Request[“table“]];
????????????AddNewColumnHyperlink.NavigateUrl?=?String.Format（“editcolumn.aspx?database={0}&table={1}“?Server.UrlEncode（Request[“database“]）?Server.UrlEncode（Request[“table“]））;


????????????if?（table?!=?null）?{
????????????????ColumnsDataGrid.Visible?=?true;
????????????????NoColumnsLabel.Visible?=?false;

????????????????if?（!IsPostBack）?{
????????????????????SqlColumnCollection?columns?=?table.Columns;

????????????????????DataSet?ds?=?new?DataSet（）;
????????????????????ds.Tables.Add（）;
????????????????????ds.Tables[0].Columns.Add（“key“?typeof（bool））;
????????????????????ds.Tables[0].Columns.Add（“id“?typeof（bool））;
????????????????????ds.Tables[0].Columns.Add（“name“?typeof（string））;
????????????????????ds.Tables[0].Columns.Add（“datatype“?typeof（string））;
????????????????????ds.Tables[0].Columns.Add（“size“?typeof（int））;
????????????????????ds.Tables[0].Columns.Add（“precision“?typeof（int））;
????????????????????ds.Tables[0].Columns.Add（“scale“?typeof（int））;
????????????????????ds.Tables[0].Columns.Add（“nulls“?typeof（bool））;
????????????????????ds.Tables[0].Columns.Add（“default“?typeof（string））;

????????????????????ds.Tables[0].Columns.Add（“encodedname“?typeof（string））;

????????????????????for?（int?i?=?0;?i?????????????????????????SqlColumnInformation?columnInfo?=?columns[i].ColumnInformation;
????????????????????????ds.Tables[0].Rows.Add（new?object[]?{columnInfo.Key?columnInfo.Identity?Server.HtmlEncode（columnInfo.Name）?Server.HtmlEncode（columnInfo.DataType）?columnInfo.Size?columnInfo.Precision?columnInfo.Scale?columnInfo.Nulls?Server.HtmlEncode（columnInfo.DefaultValue）?Server.UrlEncode（columnInfo.Name）}）;
????????????????????}
???????????????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1623??2010-03-31?23:47??images\95599.gif

?????文件???????1340??2010-03-31?23:47??images\95599_ico.gif

?????文件???????3205??2010-03-31?23:47??images\admin-foot1.gif

?????文件????????825??2010-03-31?23:47??images\admin-foot2.gif

?????文件????????944??2010-03-31?23:47??images\admin-foot3.gif

?????文件????????270??2010-03-31?23:47??images\admin-foot4.gif

?????文件?????????70??2010-03-31?23:47??images\admin-ico.gif

?????文件????????186??2010-03-31?23:47??images\admin-leftbg.gif

?????文件?????????67??2010-03-31?23:47??images\admin-right1.gif

?????文件?????????67??2010-03-31?23:47??images\admin-right2.gif

?????文件????????779??2010-03-31?23:47??images\admin-top1.gif

?????文件????????170??2010-03-31?23:47??images\admin-top2.gif

?????文件????????766??2010-03-31?23:47??images\admin-top3.gif

?????文件??????21655??2010-03-31?23:47??images\Ajax_img.gif

?????文件????????946??2010-03-31?23:47??images\ajax_x.gif

?????文件????????343??2010-03-31?23:47??images\butt_img.gif

?????文件????????272??2010-03-31?23:47??images\butt_img_1.gif

?????文件????????402??2010-03-31?23:47??images\butt_img_to.gif

?????文件???????2001??2010-03-31?23:47??images\card.jpg

?????文件???????4151??2010-03-31?23:47??images\ccb.gif

?????文件???????1252??2010-03-31?23:47??images\ccb_ico.gif

?????文件???????2143??2010-03-31?23:47??images\ChinaBank.gif

?????文件?????????74??2010-03-31?23:47??images\close.gif

?????文件???????5319??2010-03-31?23:47??images\cms-gif.gif

?????文件????????614??2010-03-31?23:47??images\cms-ico1.gif

?????文件????????256??2010-03-31?23:47??images\cms-ico10.gif

?????文件????????581??2010-03-31?23:47??images\cms-ico2.gif

?????文件????????588??2010-03-31?23:47??images\cms-ico3.gif

?????文件??????14057??2010-03-31?23:47??images\cms-ico4.gif

?????文件??????14113??2010-03-31?23:47??images\cms-ico5.gif

............此處省略2101個文件信息