I can't say it is stronger than DataGrid, because DataGrid has a lot of deep things you can discover, but I can say it is more easy to use than DataGrid, because it is easy to implement the following function, at the same time, it is completely free, no Need to register without any functional restrictions.
1. Display 2, client data sorting 3, various field types, formatted display 4, all data tables easy to implement built-in data add, update, delete function 5, provide support and use of password fields 32-bit MD5 encoding 6, add, update the image field, automatically upload file 7, automatically generate thumbnail 8 when uploading images, add, automatically generate client data verification (empty character verification, max) when the image is uploaded, add, update (empty character verification, maximum character) Number verification, digital format, date format verification, email verification) 9 The image field 11, the built-in can be customized to see the page 12. The input parameters have been filtered to prevent SQLServer injection attack 13, prevent non-page submission 14, automatic paging technology, reduce query data returns 15, provide The built-in field value combined function 16, the data table directly exports Excel format 17, when adding a record, you can specify a column to use the HTML editor 18, directly to the SQLServer operation 19, support the stored procedure 20, the double-layer header display 21, the sub-table display 22, the built-in query function 23 generates a click event 24, the mouse button function 25, the built-in 21 practical style 26, the lead direct can generate the CHECKBOX or RADIO27, multiple display mode of the data table (data sheet, thumbnail , Report)
More features can't be said. Below is a simple application of this control:
First, use 1. Copy the DTable.dll file to the bin directory of the project 2. Like other third-party controls, add this control in the custom toolbox 3. Drag the control to the right location 4. Re-generate projects, you can find that you can now access the NortWind database Employees 5. If you develop the ASPNET user has permission to access the Northwind database, then your page displays the employee's data sheet. Otherwise, you will be prompted to access the database.
Second, immediately display the data table 1 you need, the display of the DTABLE control data table is set by the property. Normally, its properties have some default. If you feel that the result it shows is not what you need, then change the relevant properties to get the results you need. 2. First, you have to specify 3 properties so that you can display your data sheet immediately. a) Database connection string properties DataConnectString. When using: DTABLE1.DATACONNECTSTRING = "Data Source = localhost; integrated security = sspi; initial catalog = mydatabase"; of course, you can also package the link string into other forms or a global variable. Such as: DTABLE1. DataconnectString = include.datastr;
b) The name of the data sheet Tablename. When using: DTABLE1.TABLENAME = "User_TB";
c) Query statement list_sqltext in the data list is set as: DTABLE1.LIST_SQLTEXT = "Select * from user_tb";
3, OK, if you define the above three properties in the Page_Load event, you can immediately get the list of data sheets you defined, and DTABLE automatically defines the interlaced pattern of the table, Title style And paging columns, line first serial numbers, etc. 4. You now double-click the first column link, you can immediately view the field information. Of course, this is the result of the DTABLE to allow detailed viewing, you can also close, or you define the names of the fields or fields that need to be displayed when you detailed viewing ... and even the type conversion of the field, etc.. Third, immediately have a record update, add, delete, and do not need to write other code. What you need to do is to set up 3 properties. 1. Allow built-in update features: AE_ENAbleEdit settings: DTABLE1. AE_ENABLEDIT = TRUE;
a) How do I use the built-in update function? When the built-in update is allowed, the data list will automatically appear, and you click this button to enter the status of the update list. b) How do I change the appearance of the data update button? Define the style of the update button by setting the properties: AE_EDITBUTTON_HTM. For example, setting the update button for a picture edit.gif as: DTABLE1. AE_EDITBUTTON_HTM = "" c) How to define fields that need to be updated? The default state, the record update interface will list all the fields of the table. You can display the fields displayed by an attribute setting: ae_fieldlist, such as: DTABLE1. AE_FIELDLIST = "ID, Name, Age, Gender" This time, the update interface only lists the name, age, gender, and provides changing data. . d) What is the difference between the record update interface? DTABLE provides a lot of easy-to-use features to increase data entry in the record update interface to increase the validity and entry speed of data. For example: it automatically provides a date selector for the date field (click Open Selector) to automatically provide a calculator for the numeric field (double click to open the calculator). Moreover, DTABLE automatically generates the number, date, maximum number of characters of the client, and does not allow testing of null values. e) Security issues on record updates DTABLE internal to prevent cross-page submission, that is, the system only updates the data submitted by this physical page, from other pages, even if the data submitted by the page from this site is prohibited from updating. At the same time, DTABLE also provides the ability to prevent repeated submission, you cannot use refresh features to repeatedly submit data. f) How to limit the conditions for updates? You can set data to be updated by attributes must be data that meets a certain rule. For details, please check the recording update and add advanced applications later. 2. Allow built-in deletion: AE_ENABLELETE settings: DTABLE1. AE_ENABLEDELETE = true; a) How to use built-in deletion function? When you allow the built-in delete function, the data table will automatically add a column delete button. b) How do I change the style of the delete button? Define the appearance of the delete button by setting an attribute: AE_DELETEBUTTON_HTML, such as DTABLETEBUTTON_HTML, such as: DTABLE1. AE_DELETEBUTTON_HTML = "
" c) How to ensure the security of delete function? Like the built-in record update, DTABLE prohibits a cross-page submission to delete commands. Other restrictions also provide illegal deletion. For details, please see the recording update, add, delete advanced applications. 3. Allow records to add: AE_ENABLEADDNEW Settings: DTABLE1. AE_ENABLEADDNEW = true; A) How to enter the record to add state? Access the record add interface by accessing the current page parameter. Of course, the premise is that you have allowed the record to add functions. Such as: http://localhost/test/test.aspx? Addnew = true The above link is included with the parameters: • addNew = true to enter the record add interface. If you do not have a record to add functions, you will not enter the recorded add interface, but directly enter the data list display interface. b) How do I define the fields added to add? Like the definition recorded field: AE_fieldlist, such as: DTABLE1. AE_FieldList = "ID, Name, Age, Gender" Record Add and Update Use the same property to define the field you want to display.
c) How do I define the security of the addition record? Update with the record. d) What is the difference between DTABLE record? Update with the record. 4. Define the data table display 1. Define the display of different types of data a) Boolean field Boolean field is bit type in SQL Server, the allowed value is 1 and 0. If our data table wants to display the Boolean field, TRUE and FALSE may be displayed by default. DTABLE provides a property to define this Boolean conversion: list_formatboolreplace_no, for example: we have to query the SELECT ID, name, age, gender, current salary, near, graduation certificate, the Boolean field returned "Sex" replaces "Men" and "Female", you can set this property DTABLE1. List_formatBoolReplace_no = "3 | Male | Female". Of course, it is also possible to set up a replacement directly in the query statement. b) Save the field of the picture path tells DTABLE by setting a property, and a field belongs to the field saved by the image path. DTABLE will automatically use the path to a picture tab. Such as: DTABLE1.LIST_URLIMAGE_NO = "| 6 |"; The column number displayed in the list is displayed, and the first column of the query statement is not displayed (used as a unique identity). c) The currency field is displayed by 2 simple properties: list_formatcur_no defines the field sequences that need to be displayed as a currency format, which allows for display, settings such as: DTABLE. List_formatcur_no = "| 4 | 6 | 7 "; ie: 4th, 6, 7 fields are currency fields, displayed in currency format. Another attribute defines the prefix displayed by the currency: List_formatcur_str, the renminbi setting is: DTABLE1. List_formatcur_str = "¥"; how should the US dollar set up? d) The built-in binary image field DTABLE allows the built-in binary image field to be displayed directly. But it is not automatically displayed, you need to do the following: 1. Define the column name of the binary image field: Test_imgfieldname is: DTABLE1. Test_imgfieldname = "Graduation certificate picture"; 2. Define file names used to view binary image fields. This file name is a file that the system is about to automatically generate. If your current directory has only one page you will use directly to view the binary image field, you can define this property. Because it has a default definition. This attribute is Test_ShowImg_FileName, you can define a file name: DTABLE1. Test_showimg_filename = "showimg.aspx"; 3. Generate this file. By accessing: The path parameter of the current page can generate this page immediately. For example: Access http://localhost/test/test.aspx? Makeshowimgfile = true can generate showimg.aspx files. If the column name you define is Chinese, you may also need to open ShowImg.aspx with your editor, correct the incorrect column name insufficiency. 4. The above three steps typically only need to perform one time. You finally define a property telling the DTABLE which field is a binary image field: List_image_no, such as: DTABLE1. List_image_no = "| 5 | 9 | 12 |", the 5th, 9, 12 columns are binary image fields.
By then, the data sheet automatically uses such a label to implement: The following is a brief description of the control in data entry, update, deletion:
First, enter the data to add, update the status
1, enter the data add interface
Enter the data added state by accessing the current page parameter. For example, the current page name is: showdTable.aspx, then the path to the add interface should be http: //yoursite/aspnetApplication/showdtable.aspx? Addnew = true You can enter the page through a hyperlink, a picture link, buttons actions. Of course, the premise is that you must allow data to add: DTABLE1.AE_ENABLEADDNEW = true;
2, enter the data update interface
There are a variety of ways to enter the data update interface.
1) Enter the Update button to the Update Interface To turn on the built-in update button, you must set an attribute: DTABLE1. AE_ENAbleEdit = true; this property is defined: allowing the built-in record update function. At this point, the display data table will automatically add a link to the updated update, and enter the record update interface by clicking the link. Related properties:
2) Enter the record update interface through an external custom link. You need to set up an attribute: AE_SHOWED_BUTTON This property defines whether the link button that automatically displays the update interface when allowing the built-in update function. The default is displayed. When you decide to implement the entered an update interface through your own definition, you can define this property to false. It should be noted that: If you enter an update interface from the outside, you must give the link parameters: fURL = xxxxx. Such as: http://localhost/test/test.aspx? Meditid = 28 & furl = / test / test.aspx? Pageno = 1meditid and FURL parameters are must be. MeditID defines the ID of the record, and FURL defines the source page path to enter the update interface. You can get the current path through page.Request.currentexecutionFilePath.
Second, custom record add interface
1. Define the fields that need to be added to the record
Default, DTABLE will use all fields of the data table as the fields you need to add. It provides an attribute to define the field you really need, and you will hide the real details of the data table by redefining the column name of the field. DTABLE1. AE_FIELDLIST = "ID, Yourname As Name, YouSex AS Gender, You" Age "; through such settings, the data sheet will display the name, gender, and age of 3 fields. The ID is used as the identity field, it must be placed first, otherwise it will be wrong.
2. Understand which features that DTABLE provide when the file is recorded.
1) DTABLE will automatically use the maximum number of characters to the String field, empty character inspection
2) DTABLE automatically uses the radio button for the Boolean field. If the Boolean field allows null values, the default is displayed as unselected status.
3) DTABLE automatically uses the date selector to the date, the time field, disables the keyboard entry. Although DTABLE is not allowed to enter the date characters through the keyboard, the date of the field will still be legal when submitted.
4) DTABLE logs, the Money field automatically uses the calculator to enter, and open the calculator by double-clicking on the text control while allowing the keyboard to enter. When submitted, the input character is to be verified is a legal number. It should be noted that the client value verification only allows the 2-digit value, which is greater than 2 decimals is considered illegal.
5) DTABLE provides a file to the field of the Link Image Address and the Link Image file, and save the file name, the file path to the relevant field; even thumbnails; no limit to the number of changed fields. For example, the 5th column of the employee record records the picture of the employee's degree, and the six column records the training certificate provided by the employee, and we can tell the property: dtable.ae_upfiles_no = "| 5 | 6 |"; this property tells DTABLE, column 5, 6 are listed as files. When entering the record add interface, the 5th, 6 column locations automatically display the file control and automatically upload pictures when submitted. Related Attributes: AE_UPFILE_AUTORENAME: The uploaded file is automatically renamed. The default is true, ie: Allows the automatic rename AE_upfilesfd: Define the path that the uploaded file needs to be saved, specify a relative path. For example: ./ Images or ./Images/abde Need to confirm: Your site must exist this folder. AE_MINIATURE_FD: Defines the path to the thumbnail storage. If this property is defined, DTABLE thinks that all file upload fields defined by all your DTABLE.AE_UPFILES_NO need to generate a thumbnail! ! AE_MINIATURE_WIDTH: Generates the maximum width of the thumbnail, and specifies the maximum height of the thumbnail. Attribute category is Integerae_MiniaTure_Height: Generates the maximum height of the thumbnail, and specifies the maximum width of the thumbnail. The attribute type is Integer6) DTABLE can directly upload files to built-in binary image fields and there is no quantity limit.
If you have any questions in use, please give me a message:
http://dtable.2smm.com/default.html
At the same time, you can also find the downloaded address and some examples on the above page, I believe it will give you an unexpected help to your project development.
Second, immediately display the data table 1 you need, the display of the DTABLE control data table is set by the property. Normally, its properties have some default. If you feel that the result it shows is not what you need, then change the relevant properties to get the results you need. 2. First, you have to specify 3 properties so that you can display your data sheet immediately. a) Database connection string properties DataConnectString. When using: DTABLE1.DATACONNECTSTRING = "Data Source = localhost; integrated security = sspi; initial catalog = mydatabase"; of course, you can also package the link string into other forms or a global variable. Such as: DTABLE1. DataconnectString = include.datastr;
b) The name of the data sheet Tablename. When using: DTABLE1.TABLENAME = "User_TB";
c) Query statement list_sqltext in the data list is set as: DTABLE1.LIST_SQLTEXT = "Select * from user_tb";
3, OK, if you define the above three properties in the Page_Load event, you can immediately get the list of data sheets you defined, and DTABLE automatically defines the interlaced pattern of the table, Title style And paging columns, line first serial numbers, etc. 4. You now double-click the first column link, you can immediately view the field information. Of course, this is the result of the DTABLE to allow detailed viewing, you can also close, or you define the names of the fields or fields that need to be displayed when you detailed viewing ... and even the type conversion of the field, etc.. Third, immediately have a record update, add, delete, and do not need to write other code. What you need to do is to set up 3 properties. 1. Allow built-in update features: AE_ENAbleEdit settings: DTABLE1. AE_ENABLEDIT = TRUE;
a) How do I use the built-in update function? When the built-in update is allowed, the data list will automatically appear, and you click this button to enter the status of the update list. b) How do I change the appearance of the data update button? Define the style of the update button by setting the properties: AE_EDITBUTTON_HTM. For example, setting the update button for a picture edit.gif as: DTABLE1. AE_EDITBUTTON_HTM = "" c) How to define fields that need to be updated? The default state, the record update interface will list all the fields of the table. You can display the fields displayed by an attribute setting: ae_fieldlist, such as: DTABLE1. AE_FIELDLIST = "ID, Name, Age, Gender" This time, the update interface only lists the name, age, gender, and provides changing data. . d) What is the difference between the record update interface? DTABLE provides a lot of easy-to-use features to increase data entry in the record update interface to increase the validity and entry speed of data. For example: it automatically provides a date selector for the date field (click Open Selector) to automatically provide a calculator for the numeric field (double click to open the calculator). Moreover, DTABLE automatically generates the number, date, maximum number of characters of the client, and does not allow testing of null values. e) Security issues on record updates DTABLE internal to prevent cross-page submission, that is, the system only updates the data submitted by this physical page, from other pages, even if the data submitted by the page from this site is prohibited from updating. At the same time, DTABLE also provides the ability to prevent repeated submission, you cannot use refresh features to repeatedly submit data. f) How to limit the conditions for updates? You can set data to be updated by attributes must be data that meets a certain rule. For details, please check the recording update and add advanced applications later. 2. Allow built-in deletion: AE_ENABLELETE settings: DTABLE1. AE_ENABLEDELETE = true; a) How to use built-in deletion function? When you allow the built-in delete function, the data table will automatically add a column delete button. b) How do I change the style of the delete button? Define the appearance of the delete button by setting an attribute: AE_DELETEBUTTON_HTML, such as DTABLETEBUTTON_HTML, such as: DTABLE1. AE_DELETEBUTTON_HTML = "
" c) How to ensure the security of delete function? Like the built-in record update, DTABLE prohibits a cross-page submission to delete commands. Other restrictions also provide illegal deletion. For details, please see the recording update, add, delete advanced applications. 3. Allow records to add: AE_ENABLEADDNEW Settings: DTABLE1. AE_ENABLEADDNEW = true; A) How to enter the record to add state? Access the record add interface by accessing the current page parameter. Of course, the premise is that you have allowed the record to add functions. Such as: http://localhost/test/test.aspx? Addnew = true The above link is included with the parameters: • addNew = true to enter the record add interface. If you do not have a record to add functions, you will not enter the recorded add interface, but directly enter the data list display interface. b) How do I define the fields added to add? Like the definition recorded field: AE_fieldlist, such as: DTABLE1. AE_FieldList = "ID, Name, Age, Gender" Record Add and Update Use the same property to define the field you want to display.
c) How do I define the security of the addition record? Update with the record. d) What is the difference between DTABLE record? Update with the record. 4. Define the data table display 1. Define the display of different types of data a) Boolean field Boolean field is bit type in SQL Server, the allowed value is 1 and 0. If our data table wants to display the Boolean field, TRUE and FALSE may be displayed by default. DTABLE provides a property to define this Boolean conversion: list_formatboolreplace_no, for example: we have to query the SELECT ID, name, age, gender, current salary, near, graduation certificate, the Boolean field returned "Sex" replaces "Men" and "Female", you can set this property DTABLE1. List_formatBoolReplace_no = "3 | Male | Female". Of course, it is also possible to set up a replacement directly in the query statement. b) Save the field of the picture path tells DTABLE by setting a property, and a field belongs to the field saved by the image path. DTABLE will automatically use the path to a picture tab. Such as: DTABLE1.LIST_URLIMAGE_NO = "| 6 |"; The column number displayed in the list is displayed, and the first column of the query statement is not displayed (used as a unique identity). c) The currency field is displayed by 2 simple properties: list_formatcur_no defines the field sequences that need to be displayed as a currency format, which allows for display, settings such as: DTABLE. List_formatcur_no = "| 4 | 6 | 7 "; ie: 4th, 6, 7 fields are currency fields, displayed in currency format. Another attribute defines the prefix displayed by the currency: List_formatcur_str, the renminbi setting is: DTABLE1. List_formatcur_str = "¥"; how should the US dollar set up? d) The built-in binary image field DTABLE allows the built-in binary image field to be displayed directly. But it is not automatically displayed, you need to do the following: 1. Define the column name of the binary image field: Test_imgfieldname is: DTABLE1. Test_imgfieldname = "Graduation certificate picture"; 2. Define file names used to view binary image fields. This file name is a file that the system is about to automatically generate. If your current directory has only one page you will use directly to view the binary image field, you can define this property. Because it has a default definition. This attribute is Test_ShowImg_FileName, you can define a file name: DTABLE1. Test_showimg_filename = "showimg.aspx"; 3. Generate this file. By accessing: The path parameter of the current page can generate this page immediately. For example: Access http://localhost/test/test.aspx? Makeshowimgfile = true can generate showimg.aspx files. If the column name you define is Chinese, you may also need to open ShowImg.aspx with your editor, correct the incorrect column name insufficiency. 4. The above three steps typically only need to perform one time. You finally define a property telling the DTABLE which field is a binary image field: List_image_no, such as: DTABLE1. List_image_no = "| 5 | 9 | 12 |", the 5th, 9, 12 columns are binary image fields.
By then, the data sheet automatically uses such a label to implement: The following is a brief description of the control in data entry, update, deletion:
First, enter the data to add, update the status
1, enter the data add interface
Enter the data added state by accessing the current page parameter. For example, the current page name is: showdTable.aspx, then the path to the add interface should be http: //yoursite/aspnetApplication/showdtable.aspx? Addnew = true You can enter the page through a hyperlink, a picture link, buttons actions. Of course, the premise is that you must allow data to add: DTABLE1.AE_ENABLEADDNEW = true;
2, enter the data update interface
There are a variety of ways to enter the data update interface.
1) Enter the Update button to the Update Interface To turn on the built-in update button, you must set an attribute: DTABLE1. AE_ENAbleEdit = true; this property is defined: allowing the built-in record update function. At this point, the display data table will automatically add a link to the updated update, and enter the record update interface by clicking the link. Related properties:
2) Enter the record update interface through an external custom link. You need to set up an attribute: AE_SHOWED_BUTTON This property defines whether the link button that automatically displays the update interface when allowing the built-in update function. The default is displayed. When you decide to implement the entered an update interface through your own definition, you can define this property to false. It should be noted that: If you enter an update interface from the outside, you must give the link parameters: fURL = xxxxx. Such as: http://localhost/test/test.aspx? Meditid = 28 & furl = / test / test.aspx? Pageno = 1meditid and FURL parameters are must be. MeditID defines the ID of the record, and FURL defines the source page path to enter the update interface. You can get the current path through page.Request.currentexecutionFilePath.
Second, custom record add interface
1. Define the fields that need to be added to the record
Default, DTABLE will use all fields of the data table as the fields you need to add. It provides an attribute to define the field you really need, and you will hide the real details of the data table by redefining the column name of the field. DTABLE1. AE_FIELDLIST = "ID, Yourname As Name, YouSex AS Gender, You" Age "; through such settings, the data sheet will display the name, gender, and age of 3 fields. The ID is used as the identity field, it must be placed first, otherwise it will be wrong.
2. Understand which features that DTABLE provide when the file is recorded.
1) DTABLE will automatically use the maximum number of characters to the String field, empty character inspection
2) DTABLE automatically uses the radio button for the Boolean field. If the Boolean field allows null values, the default is displayed as unselected status.
3) DTABLE automatically uses the date selector to the date, the time field, disables the keyboard entry. Although DTABLE is not allowed to enter the date characters through the keyboard, the date of the field will still be legal when submitted.
4) DTABLE logs, the Money field automatically uses the calculator to enter, and open the calculator by double-clicking on the text control while allowing the keyboard to enter. When submitted, the input character is to be verified is a legal number. It should be noted that the client value verification only allows the 2-digit value, which is greater than 2 decimals is considered illegal.
5) DTABLE provides a file to the field of the Link Image Address and the Link Image file, and save the file name, the file path to the relevant field; even thumbnails; no limit to the number of changed fields. For example, the 5th column of the employee record records the picture of the employee's degree, and the six column records the training certificate provided by the employee, and we can tell the property: dtable.ae_upfiles_no = "| 5 | 6 |"; this property tells DTABLE, column 5, 6 are listed as files. When entering the record add interface, the 5th, 6 column locations automatically display the file control and automatically upload pictures when submitted. Related Attributes: AE_UPFILE_AUTORENAME: The uploaded file is automatically renamed. The default is true, ie: Allows the automatic rename AE_upfilesfd: Define the path that the uploaded file needs to be saved, specify a relative path. For example: ./ Images or ./Images/abde Need to confirm: Your site must exist this folder. AE_MINIATURE_FD: Defines the path to the thumbnail storage. If this property is defined, DTABLE thinks that all file upload fields defined by all your DTABLE.AE_UPFILES_NO need to generate a thumbnail! ! AE_MINIATURE_WIDTH: Generates the maximum width of the thumbnail, and specifies the maximum height of the thumbnail. Attribute category is Integerae_MiniaTure_Height: Generates the maximum height of the thumbnail, and specifies the maximum width of the thumbnail. The attribute type is Integer6) DTABLE can directly upload files to built-in binary image fields and there is no quantity limit.
If you have any questions in use, please give me a message:
http://dtable.2smm.com/default.html
At the same time, you can also find the downloaded address and some examples on the above page, I believe it will give you an unexpected help to your project development.
Second, immediately display the data table 1 you need, the display of the DTABLE control data table is set by the property. Normally, its properties have some default. If you feel that the result it shows is not what you need, then change the relevant properties to get the results you need. 2. First, you have to specify 3 properties so that you can display your data sheet immediately. a) Database connection string properties DataConnectString. When using: DTABLE1.DATACONNECTSTRING = "Data Source = localhost; integrated security = sspi; initial catalog = mydatabase"; of course, you can also package the link string into other forms or a global variable. Such as: DTABLE1. DataconnectString = include.datastr;
b) The name of the data sheet Tablename. When using: DTABLE1.TABLENAME = "User_TB";
c) Query statement list_sqltext in the data list is set as: DTABLE1.LIST_SQLTEXT = "Select * from user_tb";
3, OK, if you define the above three properties in the Page_Load event, you can immediately get the list of data sheets you defined, and DTABLE automatically defines the interlaced pattern of the table, Title style And paging columns, line first serial numbers, etc. 4. You now double-click the first column link, you can immediately view the field information. Of course, this is the result of the DTABLE to allow detailed viewing, you can also close, or you define the names of the fields or fields that need to be displayed when you detailed viewing ... and even the type conversion of the field, etc.. Third, immediately have a record update, add, delete, and do not need to write other code. What you need to do is to set up 3 properties. 1. Allow built-in update features: AE_ENAbleEdit settings: DTABLE1. AE_ENABLEDIT = TRUE;
a) How do I use the built-in update function? When the built-in update is allowed, the data list will automatically appear, and you click this button to enter the status of the update list. b) How do I change the appearance of the data update button? Define the style of the update button by setting the properties: AE_EDITBUTTON_HTM. For example, setting the update button for a picture edit.gif as: DTABLE1. AE_EDITBUTTON_HTM = "" c) How to define fields that need to be updated? The default state, the record update interface will list all the fields of the table. You can display the fields displayed by an attribute setting: ae_fieldlist, such as: DTABLE1. AE_FIELDLIST = "ID, Name, Age, Gender" This time, the update interface only lists the name, age, gender, and provides changing data. . d) What is the difference between the record update interface? DTABLE provides a lot of easy-to-use features to increase data entry in the record update interface to increase the validity and entry speed of data. For example: it automatically provides a date selector for the date field (click Open Selector) to automatically provide a calculator for the numeric field (double click to open the calculator). Moreover, DTABLE automatically generates the number, date, maximum number of characters of the client, and does not allow testing of null values. e) Security issues on record updates DTABLE internal to prevent cross-page submission, that is, the system only updates the data submitted by this physical page, from other pages, even if the data submitted by the page from this site is prohibited from updating. At the same time, DTABLE also provides the ability to prevent repeated submission, you cannot use refresh features to repeatedly submit data. f) How to limit the conditions for updates? You can set data to be updated by attributes must be data that meets a certain rule. For details, please check the recording update and add advanced applications later. 2. Allow built-in deletion: AE_ENABLELETE settings: DTABLE1. AE_ENABLEDELETE = true; a) How to use built-in deletion function? When you allow the built-in delete function, the data table will automatically add a column delete button. b) How do I change the style of the delete button? Define the appearance of the delete button by setting an attribute: AE_DELETEBUTTON_HTML, such as DTABLETEBUTTON_HTML, such as: DTABLE1. AE_DELETEBUTTON_HTML = "
" c) How to ensure the security of delete function? Like the built-in record update, DTABLE prohibits a cross-page submission to delete commands. Other restrictions also provide illegal deletion. For details, please see the recording update, add, delete advanced applications. 3. Allow records to add: AE_ENABLEADDNEW Settings: DTABLE1. AE_ENABLEADDNEW = true; A) How to enter the record to add state? Access the record add interface by accessing the current page parameter. Of course, the premise is that you have allowed the record to add functions. Such as: http://localhost/test/test.aspx? Addnew = true The above link is included with the parameters: • addNew = true to enter the record add interface. If you do not have a record to add functions, you will not enter the recorded add interface, but directly enter the data list display interface. b) How do I define the fields added to add? Like the definition recorded field: AE_fieldlist, such as: DTABLE1. AE_FieldList = "ID, Name, Age, Gender" Record Add and Update Use the same property to define the field you want to display.
c) How do I define the security of the addition record? Update with the record. d) What is the difference between DTABLE record? Update with the record. 4. Define the data table display 1. Define the display of different types of data a) Boolean field Boolean field is bit type in SQL Server, the allowed value is 1 and 0. If our data table wants to display the Boolean field, TRUE and FALSE may be displayed by default. DTABLE provides a property to define this Boolean conversion: list_formatboolreplace_no, for example: we have to query the SELECT ID, name, age, gender, current salary, near, graduation certificate, the Boolean field returned "Sex" replaces "Men" and "Female", you can set this property DTABLE1. List_formatBoolReplace_no = "3 | Male | Female". Of course, it is also possible to set up a replacement directly in the query statement. b) Save the field of the picture path tells DTABLE by setting a property, and a field belongs to the field saved by the image path. DTABLE will automatically use the path to a picture tab. Such as: DTABLE1.LIST_URLIMAGE_NO = "| 6 |"; The column number displayed in the list is displayed, and the first column of the query statement is not displayed (used as a unique identity). c) The currency field is displayed by 2 simple properties: list_formatcur_no defines the field sequences that need to be displayed as a currency format, which allows for display, settings such as: DTABLE. List_formatcur_no = "| 4 | 6 | 7 "; ie: 4th, 6, 7 fields are currency fields, displayed in currency format. Another attribute defines the prefix displayed by the currency: List_formatcur_str, the renminbi setting is: DTABLE1. List_formatcur_str = "¥"; how should the US dollar set up? d) The built-in binary image field DTABLE allows the built-in binary image field to be displayed directly. But it is not automatically displayed, you need to do the following: 1. Define the column name of the binary image field: Test_imgfieldname is: DTABLE1. Test_imgfieldname = "Graduation certificate picture"; 2. Define file names used to view binary image fields. This file name is a file that the system is about to automatically generate. If your current directory has only one page you will use directly to view the binary image field, you can define this property. Because it has a default definition. This attribute is Test_ShowImg_FileName, you can define a file name: DTABLE1. Test_showimg_filename = "showimg.aspx"; 3. Generate this file. By accessing: The path parameter of the current page can generate this page immediately. For example: Access http://localhost/test/test.aspx? Makeshowimgfile = true can generate showimg.aspx files. If the column name you define is Chinese, you may also need to open ShowImg.aspx with your editor, correct the incorrect column name insufficiency. 4. The above three steps typically only need to perform one time. You finally define a property telling the DTABLE which field is a binary image field: List_image_no, such as: DTABLE1. List_image_no = "| 5 | 9 | 12 |", the 5th, 9, 12 columns are binary image fields.
By then, the data sheet automatically uses such a label to implement: The following is a brief description of the control in data entry, update, deletion:
First, enter the data to add, update the status
1, enter the data add interface
Enter the data added state by accessing the current page parameter. For example, the current page name is: showdTable.aspx, then the path to the add interface should be http: //yoursite/aspnetApplication/showdtable.aspx? Addnew = true You can enter the page through a hyperlink, a picture link, buttons actions. Of course, the premise is that you must allow data to add: DTABLE1.AE_ENABLEADDNEW = true;
2, enter the data update interface
There are a variety of ways to enter the data update interface.
1) Enter the Update button to the Update Interface To turn on the built-in update button, you must set an attribute: DTABLE1. AE_ENAbleEdit = true; this property is defined: allowing the built-in record update function. At this point, the display data table will automatically add a link to the updated update, and enter the record update interface by clicking the link. Related properties:
2) Enter the record update interface through an external custom link. You need to set up an attribute: AE_SHOWED_BUTTON This property defines whether the link button that automatically displays the update interface when allowing the built-in update function. The default is displayed. When you decide to implement the entered an update interface through your own definition, you can define this property to false. It should be noted that: If you enter an update interface from the outside, you must give the link parameters: fURL = xxxxx. Such as: http://localhost/test/test.aspx? Meditid = 28 & furl = / test / test.aspx? Pageno = 1meditid and FURL parameters are must be. MeditID defines the ID of the record, and FURL defines the source page path to enter the update interface. You can get the current path through page.Request.currentexecutionFilePath.
Second, custom record add interface
1. Define the fields that need to be added to the record
Default, DTABLE will use all fields of the data table as the fields you need to add. It provides an attribute to define the field you really need, and you will hide the real details of the data table by redefining the column name of the field. DTABLE1. AE_FIELDLIST = "ID, Yourname As Name, YouSex AS Gender, You" Age "; through such settings, the data sheet will display the name, gender, and age of 3 fields. The ID is used as the identity field, it must be placed first, otherwise it will be wrong.
2. Understand which features that DTABLE provide when the file is recorded.
1) DTABLE will automatically use the maximum number of characters to the String field, empty character inspection
2) DTABLE automatically uses the radio button for the Boolean field. If the Boolean field allows null values, the default is displayed as unselected status.
3) DTABLE automatically uses the date selector to the date, the time field, disables the keyboard entry. Although DTABLE is not allowed to enter the date characters through the keyboard, the date of the field will still be legal when submitted.
4) DTABLE logs, the Money field automatically uses the calculator to enter, and open the calculator by double-clicking on the text control while allowing the keyboard to enter. When submitted, the input character is to be verified is a legal number. It should be noted that the client value verification only allows the 2-digit value, which is greater than 2 decimals is considered illegal.
5) DTABLE provides a file to the field of the Link Image Address and the Link Image file, and save the file name, the file path to the relevant field; even thumbnails; no limit to the number of changed fields. For example, the 5th column of the employee record records the picture of the employee's degree, and the six column records the training certificate provided by the employee, and we can tell the property: dtable.ae_upfiles_no = "| 5 | 6 |"; this property tells DTABLE, column 5, 6 are listed as files. When entering the record add interface, the 5th, 6 column locations automatically display the file control and automatically upload pictures when submitted. Related Attributes: AE_UPFILE_AUTORENAME: The uploaded file is automatically renamed. The default is true, ie: Allows the automatic rename AE_upfilesfd: Define the path that the uploaded file needs to be saved, specify a relative path. For example: ./ Images or ./Images/abde Need to confirm: Your site must exist this folder. AE_MINIATURE_FD: Defines the path to the thumbnail storage. If this property is defined, DTABLE thinks that all file upload fields defined by all your DTABLE.AE_UPFILES_NO need to generate a thumbnail! ! AE_MINIATURE_WIDTH: Generates the maximum width of the thumbnail, and specifies the maximum height of the thumbnail. Attribute category is Integerae_MiniaTure_Height: Generates the maximum height of the thumbnail, and specifies the maximum width of the thumbnail. The attribute type is Integer6) DTABLE can directly upload files to built-in binary image fields and there is no quantity limit.
If you have any questions in use, please give me a message:
http://www.dtable.com
At the same time, you can also find the downloaded address and some examples on the above page, I believe it will give you an unexpected help to your project development.
