tableedit.aspx

基于vs2.0开发的WEB管理SQL功能该软件是一个用于管理SQL Server的工具

	                            <tr>
		                            <td style="background-color:#fff;"></td>
		                            <td style="background-color:#D4D0C8;" height="20" width="100">
		                                <asp:HiddenField runat="server" ID="hid_colName" Value='<%# Bind("name") %>'/>
			                            <a id="btn_column_del" href="javascript:;" onclick="Column_Delete(this);" style="display:none;"><img align="absMiddle" src="Style/col_del.gif" border="0" /></a>&nbsp;
		                            </td>
	                            </tr>
                            </table>
                        </ItemTemplate>
                        <HeaderTemplate>
                            <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>
	                            <tr>
		                            <td style="background-color:#fff;"></td>
		                            <td style="background-color:#D4D0C8;" height="20" >
			                            &nbsp;
		                            </td>
	                            </tr>
                            </table>
                        </HeaderTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="列名">
                        <EditItemTemplate>
                            <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("name") %>'></asp:TextBox>
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="lab_ColumnName" runat="server" Text='<%# Bind("name") %>' CssClass="lab_ColumnName"></asp:Label>
                        </ItemTemplate>
                        <HeaderStyle BackColor="#D4D0C8" BorderColor="Black" BorderStyle="Solid" Font-Bold="False" />
                        <ItemStyle BorderColor="#D4D0C8" BorderStyle="Solid" CssClass="column_state_cell"
                            Width="100px" />
                        <HeaderTemplate>
                            <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>
	                            <tr>
		                            <td style="background-color:#fff;"></td>
		                            <td style="background-color:#D4D0C8;" height="20" >
			                            列名
		                            </td>
	                            </tr>
                            </table>
                        </HeaderTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="数据类型">
                        <EditItemTemplate>
                            <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("typestring") %>'></asp:TextBox>
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="lab_type" runat="server" Text='<%# Bind("typestring") %>'></asp:Label>
                        </ItemTemplate>
                        <HeaderStyle BackColor="#D4D0C8" BorderColor="Black" BorderStyle="Solid" Font-Bold="False" />
                        <ItemStyle BorderColor="#D4D0C8" BorderStyle="Solid" CssClass="column_state_cell"
                            Width="100px" />
                        <HeaderTemplate>
                            <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>
	                            <tr>
		                            <td style="background-color:#fff;"></td>
		                            <td style="background-color:#D4D0C8;" height="20" >
			                            数据类型
		                            </td>
	                            </tr>
                            </table>
                        </HeaderTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="允许空">
                        <EditItemTemplate>
                            <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("isnullable") %>'></asp:TextBox>
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:CheckBox ID="txt_isnull" runat="server" CssClass="txt_columnAttr" Enabled="false" />
                        </ItemTemplate>
                        <HeaderStyle BackColor="#D4D0C8" BorderColor="Black" BorderStyle="Solid" Font-Bold="False" />
                        <ItemStyle BorderColor="#D4D0C8" BorderStyle="Solid" CssClass="column_state_cell" HorizontalAlign="Center"
                            Width="100px" />
                        <HeaderTemplate>
                            <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>
	                            <tr>
		                            <td style="background-color:#fff;"></td>
		                            <td style="background-color:#D4D0C8;" height="20" >
			                            允许空
		                            </td>
	                            </tr>
                            </table>
                        </HeaderTemplate>
                    </asp:TemplateField>
                </Columns>
            </asp:GridView>
                    <table id="newRowTable" cellpadding="0" cellspacing="0" style="border:1px solid #000;border-top:none;">
                        <tr>
                            <td width="101" style="border-right:1px solid #000;">
                                <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>
                                    <tr>
	                                    <td style="background-color:#fff;"></td>
	                                    <td align="right" style="background-color:#D4D0C8;" height="20" width="100">
                                            <a id="btn_column_add" href="javascript:;" onclick="Column_Add();" style="display:none;"><img align="absMiddle" src="Style/col_add.gif" border="0" /></a>&nbsp;
	                                    </td>
                                    </tr>
                                </table>
                            </td>
                            <td width="104" style="border-right:1px solid #D4D0C8;" align="center">
                                <span id="txta_columnName_p"><asp:TextBox ID="txta_columnName" runat="server" class="txt_columnAttr"></asp:TextBox></span>
                            </td>
                            <td width="104" style="border-right:1px solid #D4D0C8;" align="center">
                                <span id="txta_columnType_p"><asp:TextBox ID="txta_columnType" runat="server" class="txt_columnAttr" Text=""></asp:TextBox></span>
                            </td>
                            <td width="104" align="center">
                                <asp:CheckBox ID="txta_isnull" runat="server" CssClass="txt_columnAttr" />
                            </td>
                        </tr>
                    </table>
                    <div style="display:none;">
                        <asp:Button ID="btn_ColumnAdd" runat="server" Text="列添加" UseSubmitBehavior="False" OnClick="btn_ColumnAdd_Click" />
                        <asp:Button ID="btn_ColumnDelete" runat="server" Text="删除列" UseSubmitBehavior="False" OnClick="btn_ColumnDelete_Click" />
                        <span id="hid_editName_p"><asp:HiddenField ID="hid_editName" runat="server" Value="" /></span>
                    </div>
                </td>
                <td valign="top" align="left" style="padding:10px;">
                    
                    说明：<br /><br />
                    <div style="width:250px;">
                    １.目前只有添加列和删除列的功能。<br /><br />
                    
                    ２.因为修改列名这种操作比较少见，目前暂时不考虑该功能。<br /><br />
                    
                    ３.修改列数据类型或是修改数据长度、精度，这种操作是要将当前表放入临时表，再删除当前表，重新创建新表（新表中，列的类型已被更改），再将临时表数据还原到新表，最后删除临时表。这样的操作较危险，所以不考虑该功能。<br /><br />
                    </div>
                </td>
            </tr>
        </table>
    </div>
    </td>
  </tr>
</table>
</div>
</form>
</body>
</html>