📄 tableedit.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TableEdit.aspx.cs" Inherits="isqlweb.TableEdit" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>编辑表</title>
<link href="Style/main.css" rel="stylesheet" type="text/css" />
<link href="Style/jquery.autocomplete.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<script type="text/javascript" src="Style/jquery.js"></script>
<script type="text/javascript" src="Style/jquery.autocomplete.js"></script>
<script type="text/javascript">
var dbName = "<%=DbName %>";
var tableName = "<%=TableName %>";
var columnTypes = ['bigint','binary(50)','bit','char(10)','datetime','decimal(18,0)','float(53)','image','int','money','nchar(10)','ntext','numeric(18,0)','nvarchar(50)','real','smalldatetime','smallint','smallmoney','sql_variant','text','timestamp','tinyint','uniqueidentifier','varbinary(50)','varchar(50)'];
var tableEditDiv,grid,newRowTable,txta_columnName,txta_columnType,btn_column_add,hid_editName;
$(function(){
newRowTable = $("#newRowTable");
btn_column_add = $("#btn_column_add");
txta_columnName = $("#txta_columnName_p")[0].firstChild;
txta_columnName = $(txta_columnName);
txta_columnType = $("#txta_columnType_p")[0].firstChild;
txta_columnType = $(txta_columnType);
txta_columnType.autocompleteArray(columnTypes,
{
delay:10,
minChars:1,
matchSubset:1,
autoFill:true,
maxItemsToShow:10
});
newRowTable.mouseover(function(){
btn_column_add.show();
});
newRowTable.mouseout(function(){
btn_column_add.hide();
});
tableEditDiv = $("#tableEditDiv");
grid = tableEditDiv[0].firstChild.firstChild.firstChild.firstChild.firstChild.firstChild
hid_editName = $("#hid_editName_p")[0].firstChild;
});
//列添加
function Column_Add(){
if(txta_columnName[0].value==""){
alert("请输入列名");
txta_columnName[0].focus();
return;
}
var t = txta_columnType[0].value;
if(t==""){
alert("请输入列类型");
txta_columnType[0].focus();
return;
}
try{
t = t.split('(')[0].toLowerCase();
}catch(e){};
var t2,b = false;
for(var i=0;i<columnTypes.length;i++){
t2=columnTypes[i].split('(')[0];
if(t==t2){
b=true;
break;
}
}
if(!b){
alert("请输入正确的数据类型");
txta_columnType[0].focus();
return;
}
__doPostBack('btn_ColumnAdd','');
}
//显示行控制按扭
function showRowBtn(idx){
var btn_column_del = $("#btn_column_del",grid.rows[idx+1]);
btn_column_del.show();
}
//显示行控制按扭
function hideRowBtn(idx){
var btn_column_del = $("#btn_column_del",grid.rows[idx+1]);
btn_column_del.hide();
}
//删除列
function Column_Delete(btn){
var hid = btn.parentElement.firstChild;
if(!confirm("确定删除[" + hid.value + "]列吗？"))
return;
var hid = btn.parentElement.firstChild;
hid_editName.value=hid.value;
__doPostBack('btn_ColumnDelete','');
}
</script>
<div>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="8" height="29"><img src="Style/sqltools_01.gif" width="8" height="29" alt="" /></td>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="2" background="Style/sqltools_02.gif"></td>
</tr>
<tr>
<td height="26" bgcolor="#D4D0C8"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left">
<span style="color:#888;">正在编辑 <asp:Label ID="lab_dbName" runat="server"></asp:Label> 数据库中的 <asp:Label ID="lab_tableName" runat="server" ForeColor="Maroon"></asp:Label> 表。 </span>
<button class="sqltoolbtn" onclick="location.href='sqlexec.aspx?initdbName=' + escape(dbName) + '&initsql=' + escape('select top 100 * from [' + tableName + ']');"><img src="Style/obj_table.gif" alt="" width="16" height="15" align="absmiddle" /> 查看数据</button>
<button class="sqltoolbtn" onclick="if(confirm('确认删除 [' + tableName + '] 表？')){__doPostBack('btn_delTable','');};"><img src="Style/btn_deltable.gif" alt="" width="16" height="15" align="absmiddle" /> 删除表</button>
<span style="display:none;"><asp:Button ID="btn_delTable" runat="server" Text="删除表" OnClick="btn_delTable_Click" UseSubmitBehavior="False" /></span>
</td>
<td align="right"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" style="background-color:#808080;"></td>
</tr>
</table></td>
<td width="2" background="Style/sqltools_04.gif"></td>
</tr>
</table></td>
</tr>
<tr>
<td>
<div id="tableEditDiv" style="padding-left:10px;padding-top:10px;">
<table>
<tr>
<td valign="top">
<asp:GridView ID="grid" runat="server" AutoGenerateColumns="False" BorderColor="Black" BorderStyle="Solid" CellPadding="0" OnRowDataBound="grid_RowDataBound">
<Columns>
<asp:TemplateField HeaderText=" ">
<ItemStyle BorderColor="Black" BorderStyle="Solid" BackColor="#D4D0C8" CssClass="column_caption" HorizontalAlign="Right" />
<HeaderStyle BorderColor="Black" BorderStyle="Solid" Font-Bold="False" BackColor="#D4D0C8" CssClass="column_caption" />
<ItemTemplate>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="1" height="1" style="background-color:#fff;"><img src="Style/space.gif" width="1" height="1"/></td>
<td style="background-color:#fff;"></td>
</tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -