Instructions: Due to the time relationship, the problem in the OLEDB version is said later. Usage and Precautions I simply say this, please see the following example of using the detailed code. Let me talk about the use of SQL version of PowerDataGrid: First you need to install controls, the installation method is to open the toolbox -> Select "Add / Transfer", you will come out, select "Browse", select this DLL file , Wait a moment you can appear in your toolbox (if you can't drag it directly to the page, please turn off the vs.net and turn it back). Next, set the connectionString property to connect the database (or set the keyword in Web.config to identify the connection string, note: Key must be Connectionstring, at the same time, in order to get the data, you must set the queryCommand property as specified. SELECT statement (now does not support stored procedures), if you need to automatically paid, you must set uppaging to "True", if you need to automatically sort, set allowsorting to "True". If you want to display the print and save buttons you can set the appropriate properties, if printing and saving does not display, selecting the drop-down box for the file type will also be displayed. If you need to display more data in a page but you can use the smaller display control, you can set itshowscroll to true (when you set this property to true, the control will change, because I didn't write Design At the same time, it is reserved for the render method, and he doesn't have to take him). Secondly, the OLEDB version is the same, but it also mentioned that the OLEDB version is not the latest because of the time relationship, that is to say that there is not necessarily in the OLEDB in the SQL version, but SQL in OLEDB must have. Since the control is not only a data presented control, he is equivalent to a data control, so I think that the connectionstring and querycommand properties in him are normal, otherwise and DataGrid is nothing distinguished, just more abundant! Here is the feedback from my Blog and 9CBS, and what I make a corresponding modification. If you have the same problem with them, you can look at this. If there is any problem, you can go to http://expert.9cbs.net/expert/topic/2928/2928057.xml?temp =.989773 reply or go to my blog
Feedback from BLOG:
Wubin264: What you said, I have changed, maybe you didn't see the properties of Connectionstring, but there is no relationship is now good! I also provided an OLEDB version. WGGWAN: Yes, you know that you can use this control to your toolbox. Instance of setting an object reference to an object: Your question I have already solved, now there is no such error now. Donald: Thank you, now there are some methods and properties that I haven't achieved but later due to time relationships or technical issues, I am going to be stabilized to be stabilized. Wayneliu: You can download a new version, then see if there is this problem, if you have, please inform me thank you. Loreal: Your letter I have received it. I have seen it wrong. I have said that I will say that the source code of the control will be announced. I want the network itself is a shared platform. I know through the network. Many people have learned a lot through the network, so I think you don't worry, I will release the source code at the right time. You must inform you or send you an email. Now if there is any technical problem we can communicate, my MSN is wu_jian830@hotmail.com. Thank you for your attention. Xia Yu: Hello, it seems that everyone is the same man, I didn't use my own defined event when I wrote this control. In fact, I made a package that encapsulates the commonly used function to reduce programming. I didn't override it in DataGrid. Realism is too hard. If there is any technical problem we can communicate, the above MSN. XSD: Just add it to the toolbox. WY_ROVER: The question you said is to use cache, I wrote this control to support Nocache, each time I only take this page, other data is not taken, this is just some high requirements for your database server, However, I think this amount of data is no problem with the database. I will return this page after sending the ready SELECT to the server (the principle and the Paging control of Wu Qiwa are the same, I am the dealive string) . Feedback from 9CBS:
The address of the original post: http://expert.9cbs.net/expert/topic/2928/2928057.xml? Temp = .989773 Details Please see the original post! I will go there to answer your questions and browse your comments, thank you for your support. After reading you, I have to forget the UP! Thank you! Update record: 2004-04-08 12:20 Recent update, update content: Modify the page angle display error when modifying the scroll bar, the page angle display error problem, now there is no use of DropDownList to select page number, because technical reasons DropDownList does not send events to the server correctly, now you can only use the front and back page navigation now, but if you don't use scroll, everything is normal. A problem that you cannot print and save properly after the scroll bar will be made. 2004-04-09 last update, fixed check all problem when more than one powerdatagrid in a page! And I added some new examples in SqlPowerDataGrid.aspx. You can click a Download Example that you can get it.Thanks for advice.If you Have Any Problem Please Give Me Email Or Contact Me Whit MSN.2004-05-04 Today will be organized the source code! 2004-05-09 Today will rearrange the source code! Realize OLEDB! Modified a lot of questions in the previous version! When the property describes the Cacheduration paging, if you choose to use a cache method, you represent the time of the cache saved. ItemShowLength When the content in DataGrid is too long, you can specify this parameter when you cannot display, set the number of other parts displayed in each cell in DataGrid instead, at which time the mouse moves to the unit The complete information will be displayed when the grid is. Connectionstring database connection string, if not set, the control will go to
