Skip to Content

SiePortal

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

SiePortalDeutsch

Search

Home
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menu temporary not available
- Menue temporary not available
- {{item.title}}

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

Connectivity Pack for accesing Tag Loggin in C#

Created by: Radastan at: 10/2/2009 4:17 PM (4 Replies)

Rating (0)

Thanks 1

5 Entries

10/2/2009 4:17 PM	Rate (0)
Radastan Posts: 56 Rating: (8)	Hello all. I am writing a routine in C# for get historical Tags from Wincc database (SQL). I need the value of a tag in a precise moment, not all the historical data. For accesing the database, with Connectivity Pack, I use: [code] //We use COM to retrieve catalog TAG in Wincc (@DatasourceNameRT) System.Type oType = System.Type.GetTypeFromProgID("WinCC-Runtime-Project"); object wincc = System.Activator.CreateInstance(oType); object catalog = oType.InvokeMember("GetValue", System.Reflection.BindingFlags.InvokeMethod, null, wincc, new object[] { "@DatasourceNameRT" }); //Preparing connection to database, my PC is PROGRAMACION2 string myConnectionString = "Provider = WinCCOLEDBProvider.1; Data Source = PROGRAMACION2\\WinCC; Catalog = " + Convert.ToString(catalog); OleDbConnection myConnection; myConnection = new OleDbConnection(myConnectionString); //Connect to database myConnection.Open(); //Close connection myConnection.Close(); [/code] No errors, all fine. But if I want to get only ONE tag value in only ONE moment... ¿what I should do? Thanks a lot.
Radastan Posts: 56 Rating: (8)
Suggestion To thank Quote Answer

10/2/2009 4:40 PM	Rate (0)
Manuelzes Posts: 99 Rating: (7)	If you want to do it only for a view tags you can yuse the code i posted /tf/WW/en/Posts/32158#top the 4 posting. And its a free solution so you don't have to buy connectivity pack. Greetings ME
Manuelzes Posts: 99 Rating: (7)
Suggestion To thank Quote Answer

10/2/2009 4:53 PM	Rate (0)
Radastan Posts: 56 Rating: (8)	Connectivity Pack bring access to compressed data and fast logging. I don't want to read all historical data of ONE tag, I need to read ONE historical data of ONE tag. Thanks for your reply. EDIT: New progress... it works, but failed retreiving data: [code] System.Type oType = System.Type.GetTypeFromProgID("WinCC-Runtime-Project"); object wincc = System.Activator.CreateInstance(oType); object catalog = oType.InvokeMember("GetValue", System.Reflection.BindingFlags.InvokeMethod, null, wincc, new object[] { "@DatasourceNameRT" }); string myConnectionString = "Provider = WinCCOLEDBProvider.1; Data Source = PROGRAMACION2\\WinCC; Uid = prueba; Pwd = prueba45; Catalog = " + Convert.ToString(catalog); string mySelectQuery = "TAG:R, 'fichero1\\prueba2', '0000-00-00 00:00:01.000', '0000-00-00 00:00:00.000', 'TIMESTEP=1,1'"; DataTable dt; dt = new DataTable(); OleDbConnection myConnection; OleDbCommand myCommand; OleDbDataAdapter myAdapter; myConnection = new OleDbConnection(myConnectionString); myCommand = new OleDbCommand(mySelectQuery); myCommand.Connection = myConnection; myAdapter = new OleDbDataAdapter(myCommand); myConnection.Open(); myAdapter.Fill(dt); //failed here myConnection.Close(); [/code] Any idea?
Radastan Posts: 56 Rating: (8)	Last edited by: Radastan at: 10/2/2009 5:06 PM More code...
Suggestion To thank Quote Answer

10/5/2009 10:13 AM	Rate (0)
Radastan Posts: 56 Rating: (8)	Ok, new advance, reading error is for uses "spaces" in mySelectQuery. Only spaces in UTC times. [code] //Making COM to use System.Type oType = System.Type.GetTypeFromProgID("WinCC-Runtime-Project"); object wincc = System.Activator.CreateInstance(oType); //We read Catalog from Wincc from @DatasourceNameRT tag object catalog = oType.InvokeMember("GetValue", System.Reflection.BindingFlags.InvokeMethod, null, wincc, new object[] { "@DatasourceNameRT" }); //Preparing data connection string myConnectionString = "Provider = WinCCOLEDBProvider.1; Data Source = VMWARE\\WinCC; uid = prueba; pwd = prueba45; Catalog = " + Convert.ToString(catalog); string mySelectQuery = "TAG:R,'fichero1\\prueba2','2009-10-05 09:51:00.000','2009-10-05 9:52:00.000','TIMESTEP=60,1'"; DataTable dt; dt = new DataTable(); OleDbConnection myConnection; OleDbCommand myCommand; OleDbDataAdapter myAdapter; myConnection = new OleDbConnection(myConnectionString); myCommand = new OleDbCommand(mySelectQuery); myCommand.Connection = myConnection; myAdapter = new OleDbDataAdapter(myCommand); //Connecting myConnection.Open(); try { myAdapter.Fill(dt); MessageBox.Show(Convert.ToString(dt)); } catch (Exception ex) { MessageBox.Show("Error: ", ex.Message); } //Closing Connection myConnection.Close(); } [/code] No errors... but I cant read "td" table on MessageBox. ¿How can I read only tag value?
Radastan Posts: 56 Rating: (8)
Suggestion To thank Quote Answer

10/5/2009 12:17 PM	Rate (0)
Radastan Posts: 56 Rating: (8)	SOLVED!!!! Add this line after myAdapter.Fill(dt); [code] MessageBox.Show(Convert.ToString(dt.Rows[0][2])); [/code] It returns tag value if you query in the exact time (if you write tag every minute on tag logging you need to search it on database with a aperture of one minute). Complete code: [code] System.Type oType = System.Type.GetTypeFromProgID("WinCC-Runtime-Project"); object wincc = System.Activator.CreateInstance(oType); object catalog = oType.InvokeMember("GetValue", System.Reflection.BindingFlags.InvokeMethod, null, wincc, new object[] { "@DatasourceNameRT" }); string myConnectionString = "Provider = WinCCOLEDBProvider.1; Data Source = VMWARE\\WinCC; uid = prueba; pwd = prueba45; Catalog = " + Convert.ToString(catalog); 00:00:00.000','TIMESTEP=1,1'"; string mySelectQuery = "TAG:R,'fichero1\\prueba2','2009-10-05 09:51:00.000','2009-10-05 09:52:00.000','TIMESTEP=60,1'"; DataTable dt; dt = new DataTable(); OleDbConnection myConnection; OleDbCommand myCommand; OleDbDataAdapter myAdapter; myConnection = new OleDbConnection(myConnectionString); myCommand = new OleDbCommand(mySelectQuery); myCommand.Connection = myConnection; myAdapter = new OleDbDataAdapter(myCommand); myConnection.Open(); try { myAdapter.Fill(dt); MessageBox.Show(Convert.ToString(dt.Rows[0][2])); // on column 2 is tag data } catch (Exception ex) { MessageBox.Show("Error reading data", ex.Message); } myConnection.Close(); } [/code]
Radastan Posts: 56 Rating: (8)
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users S_Moderator

|

Share this page:

Share this page on...

Follow us on