SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

WinCC 8 DataGridView

9/29/2024 7:53 AM	Rate (0)
H.SAPER Bronze Member Joined: 11/12/2008 Last visit: 7/26/2025 Posts: 225 Rating: (16)	Hello, This is the first time to work in a project compleltly simatic software, But we facing a problem in HOW to load data from sql database into DataGridView, we tried some VB codes but not succeed, note that we are used some of these code in other softwares it's Running without Error. OUR Database Name (data_dt) and Table Name (wincctbl) Note This Code we copied from website Code: Dim conn, rs, sqlQuery Set conn = CreateObject("ADODB.Connection") conn.ConnectionString = "Provider=MSDASQL;DSN=data_dt" conn.Open Set rs = CreateObject("ADODB.Recordset") sqlQuery = "SELECT * FROM wincctbl" rs.Open sqlQuery, conn Set DataGridView1.DataSource = rs rs.Close conn.Close Set rs = Nothing Set conn = Nothing Attachment DGV.jpg (180 Downloads)
	HASSAN.S POJAILA
Suggestion To thank Quote Answer

10/4/2024 9:40 AM	Rate (0)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 9/2/2025 Posts: 16290 Rating: (1930)	Hello H.SAPER which Data do you want to show in a table control? For Trend Data from wincc you can use the WinCC Online Table Control. Also Siemens offers an own Datagrid Control: PM Grid Control: https://support.industry.siemens.com/cs/de/en/view/109806438 Another way could be to use the CWC from this FAQ. WinCC should also be able to use CWC in V8: https://support.industry.siemens.com/cs/de/en/view/109779176 (Table Custom web Control) Bye Murof
	If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer