Navigation

WINCC using c# to read archive data

Created by: ice_mizan at: 1/29/2024 2:05 AM (1 Replies)

1/29/2024 2:05 AM	Rate (0)
ice_mizan Posts: 1 Rating: (0)	Hi all! I am writing a simple c# application to read archive data into dataset, my wincc version is 7.5+sp2 with connectivity pack. Question: The oledbdataadapter.fill command didn't work as expected, after execution my dataset is filled with a 0 row table with several tags - valueid, timestamp and so on. What should I do? [code] HMIRuntime HMIRT = new HMIRuntime(); IHMITag Catlog = HMIRT.Tags["@DatasourceNameRT"]; IHMITag PCname = HMIRT.Tags["@LocalMachineName"]; string ConnectionStr = @"Provider=WinCCOLEDBProvider.1;Catalog=" + Catlog.Read() + ";Data Source=" + PCname.Read() + "\\WINCC"; OleDbConnection connection = new OleDbConnection(ConnectionStr); connection.Open(); string Begin = dateTimePicker1.Value.ToString(); string End = dateTimePicker2.Value.ToString(); string query = @"TAG:R,('data\t';'data\fan'),'" + Begin + ".001','" + End + ".000'"; int a; DataSet ds = new DataSet(); using (OleDbCommand command = new OleDbCommand(query, connection)) using (OleDbDataAdapter adapter = new OleDbDataAdapter(command)) { try { a = adapter.Fill(ds); } catch(Exception error) { throw error; } } this.dataGridView1.DataSource = ds.Tables[0].DefaultView; this.dataGridView1.Columns["Timestamp"].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss.fff"; connection.Close(); Thank you for your help!
ice_mizan Posts: 1 Rating: (0)	Last edited by: ice_mizan at: 01/29/2024 02:10:12
Suggestion To thank Quote Answer

2/2/2024 9:31 AM	Rate (0)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 9/12/2025 Posts: 16409 Rating: (1935)	Hello ice_mizan check this application example, perhaps it helps: https://support.industry.siemens.com/cs/de/en/view/35840700 Bye Murof
	If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer