How to bind the Datagrid Control to the ADO Data Control on a Web page (233188)

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.

Create new a html page in Visual InterDev
Insert the ADO Data Control and Datagrid Control in the page
Set the properties of the ADO Data Control to connect to a database
Resize Datagrid Control, so it will appear big enough to display data on the page

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>

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

Note: These controls are licensed controls, you might need to add the license for these controls to view this page on machines that do not have the required license. Please see

159923 How to use licensed ActiveX controls in Internet Explorer

REFERENCES

For more information about developing Web-based solutions for Microsoft Internet Explorer, visit the following Microsoft Web sites:

http://msdn.microsoft.com/ie/

http://support.microsoft.com/iep

To learn more about Microsoft Visual InterDev, please go to http://msdn.microsoft.com/vinterdev/
To learn more about the ADO Data Control and Datagrid Control, please reference to your Visual Basic Menu or searchMSDN Online