Viewing a table

Let’s start with a simple example. Here’s QuickAdmin being used to edit a single table:

Next steps:

Adding records - Click the Add button.
Editing records - Click the Supplier ID or Company Name.
Deleting records - Click the Supplier ID or Company Name.

These 10 lines of code were used to generate this page:

<QuickAdmin:Admin Runat=server id="myAdmin" Table="Suppliers" DataFieldIsString=false DataField="SupplierID" SqlDBConnStr="Data Source=(local); Initial Catalog=Northwind; Integrated Security=SSPI;" AllowFuzzy=True AddButton=true DeleteButton=true >
    <Results>
        <QuickAdmin:ResultsDataGrid runat=server Width=100% DataKeyField="SupplierID" ID="ResultsDataGrid1" AllowPaging=True AllowSorting=True >
            <Columns>
                <QuickAdmin:ResultsColumn DataField=SupplierID HeaderText="Supplier ID" SortExpression=SupplierID Table=Suppliers Link=False />
                <QuickAdmin:ResultsColumn DataField=CompanyName HeaderText="Company Name" SortExpression=CompanyName Link=True ToolTip="Click here to edit this Supplier" />
            </Columns>
        </QuickAdmin:ResultsDataGrid>
    </Results>
</QuickAdmin:Admin>