Introduction of a free ASP. NET control with data display/input/update/delete function

Introduction of a free ASP. NET control with data display/input/update/delete function

I can't say it's stronger than the DataGrid, because the DataGrid has a lot of deep stuff to explore, but I can say it's easier to use than the DataGrid, and it's more practical because it's easy to do the following, and it's completely free, doesn't require registration, and doesn't have any functional limitations.

1. Setting the data table display by property
2, client data sorting
3. Format display of various field types
4, all the data table easy to implement the built-in data add, UPDATE, delete function
5. Provide support for password fields and use 32-bit MD5 encoding
6. Automatically upload files when adding, updating image fields and linking file fields
7. You can automatically generate thumbnails when uploading images
8. Client data validation (null character verification, maximum character verification, numeric format verification, date format verification, e-mail verification) is automatically generated when adding and updating
9, Automatic date/Time field using date selector (JavaScript), automatic numeric field practical Digital Selector
10, built-in Image field generator program, direct display image field
11, the built-in can customize the Detailed view page
12, the input parameters have been filtered to prevent SQL Server injection attacks
13. Prevent non-submission of this page
14, automatic paging technology, reduce the amount of query data return
15, provide built-in field value Total function
16. Data sheet directly exported Excel format
17. You can specify a column to use the HTML editor when adding records
18. Operate directly on SQL Server
19. Supporting Stored Procedures
20, double-sided table head display
21. Child table Display
22. Built-in query function
23. Generate a Click event for each column
24. Right mouse button function
25. Built-in 21 kinds of practical styles
26. A checkbox or radio can be generated directly at the beginning of line
27. Various display modes of data sheet (data table, thumbnail, report)

More features are not covered. Here is a simple application note for the control:

First time use
1. Copy the DTABLE.DLL file to the bin directory of the project
2. As with other third-party controls, add the control in the custom Toolbox
3. Drag the control to the appropriate location on the page
4. Regenerate the project and discover that you are now able to access the employee data sheet for the Northwind database
5. If the ASPNET user has access to the Northwind database on the machine you are developing, your page will display the employee's data table by default, otherwise you will be prompted not to have permission to access the database.

Second, immediately display the data sheet you need
1, dtable Control data table display is dependent on the property to set. Typically, its properties have some default values. If you feel that the result is not what you need, change the relevant properties to get the results you want.
2. First, you must specify 3 attributes so that your data table can be displayed immediately.
A) Database connection string property dataconnectstring.
When used, set such as:
dtable1.dataconnectstring= "Data source=localhost;integrated security=sspi;initial catalog=mydatabase";
Of course, you can also pre-encapsulate the link string in other forms or as a global variable. Such as:
DTable1. DATACONNECTSTRING=INCLUDE.DATASTR;

b) The name of the data table TableName.
When used, set such as:
Dtable1.tablename= "USER_TB";

c) Query statement for the data list List_sqltext
When used, set such as:
Dtable1.list_sqltext = "SELECT * from USER_TB";

3, OK, if you define the above 3 properties in the Page_Load event, you can immediately get a list of the data tables you have defined, and dtable automatically defines the staggered row style, title style, and page bar, line number, and so on for the table.
4. You can now double-click the first column link to see the field information for that row immediately. Of course, this is the result that dtable allows for detailed viewing by default, or you can turn it off, or define the field or even the name of the field you want to display when you view it in detail ... And even the type conversion of fields.

Iii. immediately have the ability to record updates, additions, and deletions without the need to write additional code. All you need to do is set 3 properties.
1. Allow built-in update function: Ae_enableedit
Settings: DTable1. Ae_enableedit=true;

a) How do I use the built-in update feature?  
when the built-in update feature is allowed, the data list automatically appears with the Update button, and you click the button to enter the status of the update list.  
B) How do I change the appearance of the Data Update button?  
defines the style of the Update button by setting properties: ae_editbutton_htm. For example, set the Update button to a picture edit.gif:  
DTable1. ae_editbutton_htm= " C) How do I define the fields that need to be updated?  
Default state, the record update interface lists all fields of the table. The fields displayed by the update interface can be set through a property: Ae_fieldlist, such as:  
DTable1. ae_fieldlist= "ID, name, age, gender"  
at this point, the update interface simply lists the 3 fields of name, age, and gender to provide change data.  
D) What is the difference between recording the update interface?   The
Dtable provides a number of easy-to-use features to improve the efficiency and speed of data entry in the record update interface. For example, it automatically provides a date selector for a Date field (click Open Selector) and automatically provides a calculator for numeric fields (double-click to open the Calculator). Furthermore, Dtable automatically generates a test of the client's number, date, maximum number of characters, and the null value is not allowed.  
e) Security issues related to record updates  
Dtable has built-in functionality to prevent cross-page submissions: The system submits only to this physical page.