Microsoft KB Archive/193226

= How To Use the bindAllColumns Method to Rebind a Grid DTC =

Article ID: 193226

Article Last Modified on 3/16/2005

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



This article was previously published under Q193226



SUMMARY
The bindAllColumns method is used to bind all the columns in the current recordset to a Grid Design-time control (DTC). This method is specifically useful when the number of columns in the underlying recordset of a bound Grid DTC changes or is not known at design time. In that case, the bindAllColumns method associated with the Grid DTC has to be called to rebind the Grid with the recordset so that the updated number of columns in the recordset can appear on the Grid.



MORE INFORMATION
This example shows a Grid DTC bound to a recordset that is set to the Customers table in the sample AdvWorks.mdb database. If a different database is used, modify the select statement in the sample code provided below to use a valid table from the database.

When the user clicks Button1, the ChangeRS function is called in the onclick event of Button1. The recordset is closed and the setSQLText of the recordset is changed. Then the Grid DTC is rebound to the new recordset using the bindAllColumns method.

Following are the step-by-step procedures:  Open a new Web project in Visual InterDev 6.0 and a new Active Server Pages (ASP) page. Create a database connection to the sample AdvWorks.mdb database in the project. Add a Recordset DTC to the ASP page. Bind the recordset to a table in the data connection. Add a Grid DTC to the ASP page. Bind the Grid DTC to the recordset and select some fields. Add a Button DTC to the ASP page.</li>  Add the following code to the ASP page: <SCRIPT ID=serverEventHandlersVBS LANGUAGE=vbscript RUNAT=Server> Sub Button1_onclick call ChangeRS End Sub

Sub Grid_onenter If thisPage.firstEntered then Recordset1.open End if        End Sub

Sub ChangeRS If Recordset1.isOpen then Recordset1.close

'Change to a New SQL Statement Recordset1.setSQLText( "Select * from Employees") Recordset1.open Grid1.bindAllColumns End Sub </SCRIPT> </li> Click Button1 to rebind the grid.</li></ol>

Keywords: kbhowto kbctrl KB193226

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.