editcolumn.aspx

wrox c#高级编程

                                                                <asp:ListItem Value="decimal">decimal</asp:ListItem>
                                                                <asp:ListItem Value="float">float</asp:ListItem>
                                                                <asp:ListItem Value="image">image</asp:ListItem>
                                                                <asp:ListItem Value="int">int</asp:ListItem>
                                                                <asp:ListItem Value="money">money</asp:ListItem>
                                                                <asp:ListItem Value="nchar">nchar</asp:ListItem>
                                                                <asp:ListItem Value="ntext">ntext</asp:ListItem>
                                                                <asp:ListItem Value="numeric">numeric</asp:ListItem>
                                                                <asp:ListItem Value="nvarchar">nvarchar</asp:ListItem>
                                                                <asp:ListItem Value="real">real</asp:ListItem>
                                                                <asp:ListItem Value="smalldatetime">smalldatetime</asp:ListItem>
                                                                <asp:ListItem Value="smallint">smallint</asp:ListItem>
                                                                <asp:ListItem Value="smallmoney">smallmoney</asp:ListItem>
                                                                <asp:ListItem Value="sql_varient">sql_varient</asp:ListItem>
                                                                <asp:ListItem Value="text">text</asp:ListItem>
                                                                <asp:ListItem Value="timestamp">timestamp</asp:ListItem>
                                                                <asp:ListItem Value="tinyint">tinyint</asp:ListItem>
                                                                <asp:ListItem Value="uniqueidentifier">uniqueidentifier</asp:ListItem>
                                                                <asp:ListItem Value="varbinary">varbinary</asp:ListItem>
                                                                <asp:ListItem Value="varchar">varchar</asp:ListItem>
                                                            </asp:DropDownList>
                                                        </TD>
                                                        <td class="databaseListItem"></td>
                                                    </TR>
                                                    <TR>
                                                        <TD class="databaseListItem">Length</TD>
                                                        <TD class="databaseListItem" width="25">&nbsp;</TD>
                                                        <TD class="databaseListItem">
                                                            <asp:TextBox id="LengthTextbox" Runat="server" Text="10" Columns="15">10</asp:TextBox>
                                                        </TD>
                                                        <td class="databaseListItem">
                                                            <asp:requiredfieldvalidator id="LengthRequiredFieldValidator" runat="server" ErrorMessage=" Must specify a length (or specify 0 for non-length datatypes)." ControlToValidate="LengthTextBox" Display="Dynamic"></asp:requiredfieldvalidator>
                                                            <asp:RangeValidator ID="LengthRangeValidator" Runat="server" ErrorMessage=" Length must be between 0 and 8000" ControlToValidate="LengthTextBox" Display="Dynamic" MaximumValue="8000" MinimumValue="0" Type="Integer"></asp:RangeValidator>
                                                        </td>
                                                    </TR>
                                                    <TR>
                                                        <TD class="databaseListItem">Allow Null</TD>
                                                        <TD class="databaseListItem" width="25">&nbsp;</TD>
                                                        <TD class="databaseListItem">
                                                            <asp:CheckBox id="AllowNullCheckbox" Runat="server"></asp:CheckBox>
                                                        </TD>
                                                        <td class="databaseListItem"></td>
                                                    </TR>
                                                    <TR>
                                                        <TD colSpan="3" height="2"><hr></TD>
                                                        <td class="databaseListItem"></td>
                                                    </TR>
                                                    <TR>
                                                        <TD class="databaseListItem">Default Value</TD>
                                                        <TD class="databaseListItem" width="25">&nbsp;</TD>
                                                        <TD class="databaseListItem">
                                                            <asp:TextBox id="DefaultValueTextbox" Runat="server" Columns="15"></asp:TextBox>
                                                        </TD>
                                                        <td class="databaseListItem"></td>
                                                    </TR>
                                                    <TR>
                                                        <TD class="databaseListItem">Precision</TD>
                                                        <TD class="databaseListItem" width="25">&nbsp;</TD>
                                                        <TD class="databaseListItem">
                                                            <asp:TextBox id="PrecisionTextbox" Runat="server" Columns="15"></asp:TextBox>
                                                        </TD>
                                                        <td class="databaseListItem">
                                                            <asp:RangeValidator ID="PrecisionRangeValidator" Runat="server" ErrorMessage=" Precision must be an integer" ControlToValidate="PrecisionTextBox" Display="Dynamic" MaximumValue="32000" MinimumValue="0" Type="Integer"></asp:RangeValidator>
                                                        </td>
                                                    </TR>
                                                    <TR>
                                                        <TD class="databaseListItem">Scale</TD>
                                                        <TD class="databaseListItem" width="25">&nbsp;</TD>
                                                        <TD class="databaseListItem">
                                                            <asp:TextBox id="ScaleTextbox" Runat="server" Columns="15"></asp:TextBox>
                                                        </TD>
                                                        <td class="databaseListItem">
                                                            <asp:RangeValidator ID="ScaleRangeValidator" Runat="server" ErrorMessage=" Scale must be an integer" ControlToValidate="ScaleTextBox" Display="Dynamic" MaximumValue="32000" MinimumValue="0" Type="Integer"></asp:RangeValidator>
                                                        </td>
                                                    </TR>
                                                    <TR>
                                                        <TD class="databaseListItem">Identity</TD>
                                                        <TD class="databaseListItem" width="25">&nbsp;</TD>
                                                        <TD class="databaseListItem">
                                                            <asp:CheckBox id="IdentityCheckBox" runat="server"></asp:CheckBox>
                                                        </TD>
                                                        <td class="databaseListItem"></td>
                                                    </TR>
                                                    <TR>
                                                        <TD class="databaseListItem">Identity Seed</TD>
                                                        <TD class="databaseListItem" width="25">&nbsp;</TD>
                                                        <TD class="databaseListItem">
                                                            <asp:TextBox id="IdentitySeedTextbox" Runat="server" Columns="15"></asp:TextBox>
                                                        </TD>
                                                        <td class="databaseListItem"></td>
                                                    </TR>
                                                    <TR>
                                                        <TD class="databaseListItem">Identity Increment</TD>
                                                        <TD class="databaseListItem" width="25">&nbsp;</TD>
                                                        <TD class="databaseListItem">
                                                            <asp:TextBox id="IdentityIncrementTextbox" Runat="server" Columns="15"></asp:TextBox>
                                                        </TD>
                                                        <td class="databaseListItem"></td>
                                                    </TR>
                                                    <TR>
                                                        <TD class="databaseListItem">Is RowGuid</TD>
                                                        <TD class="databaseListItem" width="25">&nbsp;</TD>
                                                        <TD class="databaseListItem">
                                                            <asp:CheckBox id="IsRowGuidCheckBox" runat="server"></asp:CheckBox>
                                                        </TD>
                                                        <td class="databaseListItem"></td>
                                                    </TR>
                                                    <TR>
                                                        <TD colSpan="3" height="2"></TD>
                                                        <td class="databaseListItem"></td>
                                                    </TR>
                                                </TABLE>
                                                <br>
                                                <asp:Button id="UpdateButton" Runat="server" CSSClass="button" onMouseOver="this.style.color='#808080';" onMouseOut="this.style.color='#000000';" Text="Update"></asp:Button>
                                                &nbsp;
                                                <asp:Button id="CancelButton" Runat="server" CSSClass="button" onMouseOver="this.style.color='#808080';" onMouseOut="this.style.color='#000000';" Text="Cancel" CausesValidation="false"></asp:Button>
                                                <br>
                                                <br>
                                                <asp:Label id="ErrorUpdatingColumnLabel" runat="server" Visible="False" ForeColor="red"></asp:Label>
                                                <!-- Column Editor END -->
                                            </td>
                                        </tr>
                                        <!-- Section END -->
                                        <!-- Section Footer START -->
                                    </table>
                                    <br>
                                    <!-- Section Footer END -->
                                    <!-- Page content END -->
                                </td>
                            </tr>
                        </table>
                    </td>
                </tr>
                <!-- THIRD ROW: BOTTOM SECTION -->
            </TABLE>
        </FORM>
    </body>
</HTML>