HOWTO: How to Bind the Datagrid Control to the ADO Data Control on a Web Page

• Microsoft Internet Explorer (Programming) versions 4.0, 4.01, 4.01 SP1, 4.01 SP2, 5.0

SUMMARY

To bind a Microsoft Datagrid Control 6.0 to a Microsoft ADO Data Control 6.0 with Microsoft Visual InterDev, it is not enough to just set the Datagrid DataSource property to point to the ADO Data Control in the design view as if using them inside a Visual Basic application. With the assumption that you are familiarize working with these ActiveX controls and Visual InterDev, this article describes the steps to make these two controls bind together.

MORE INFORMATION

In order to make the Datagrid Control bind to the ADO Data Control, the following steps are needed.

1. Create new a html page in Visual InterDev



2. Insert the ADO Data Control and Datagrid Control in the page



3. Set the properties of the ADO Data Control to connect to a database



4. Resize Datagrid Control, so it will appear big enough to display data on the page



5. To bind the Datagrid Control with the ADO Data Control when the page loads, you would write the following codes in the window_onload event. Otherwise you would write these codes in other events.

   
   <SCRIPT LANGUAGE=vbscript>
   <!--
   	Sub window_onload()
             ' Datagrid1 is the id of the Datagrid control
             ' Adodc1 is the id of the ADO Data Control
   	  Set Datagrid1.DataSource = Adodc1.Recordset
   	End sub
   //-->
   </SCRIPT> 




6. Save this html page and view it under Microsoft Internet Explorer. You will see the data is displayed on the Datagrid control.

Q159923 HOWTO: Using Licensed ActiveX Controls in Internet Explorer

REFERENCES

For more information, please see the MSDN Web Workshop:

http://msdn.microsoft.com/workshop/default.asp

Additional query words: ADODC DATAGRID DataSource

Keywords : kbActiveX kbSBNWorkshop kbGrpInet
Version : WINDOWS:4.0,4.01,4.01 SP1,4.01 SP2,5.0
Platform : WINDOWS
Issue type : kbhowto