Network variable in .NET aspx page

[Kanu]

Hi All,

We have a Labwindows project which is using CVI SQL Toolkit to send data to MS SQL database. We need to retrieve this data and show it in a excel like table control which has functionalities like sorting column, adding dynamic column, etc. Since Labwindows did not have such a control, we decided to navigate to a web page when a button is clicked in Labwindows program. Now, I need to suspend the Labwindows program until user closes the webpage. Since for this I will need to communicate between webpage and labwindows program, I tried using Network Variable in Reader\Writer mode. I could find from the examples what I need to write in Labwindows. However, I could not figure out the webpage part. I will appreciate if someone can help me or give me an example for the code in aspx page.

Thanks,

Kanu

[nickb · Accepted solution]

Although what you're asking can be done with components from Measurement Studio, it's going to be a lot of work to get the framework setup. 

Before we go down that road though, I wanted to make sure that you'd seen the CVI table control.  It is very capable of sorting columns and adding columns dynamically.  I've attached a small example program doing both of these things.  Take a look, and let me know if there are still things you find it can't do.

NickB

National Instruments

[Kanu]

Thanks for your reply Nick. Actually, I felt that table control will indeed solve my probelm. But I am facing a new issue now. Basically, I want to retrieve columns from MS SQL database and bind it to table control dynamically. I searched CVI SQL Toolkit hlep and found out DBGetVariantArray and DBGetVariantArrayColumn will help me to retrieve columns from result sets obtained from database query. Until an hour ago, I was able to obtain an int column from the database. Somehow, it throws General Protection Fault error now. I will appreciate if someone can suggest why is this problem happening.

Regards,

Kanu

[Kanu]

I was having this problem because I was giving wrong address to retrieve string column from the database. Never mind. Looks like I have solved my problem.

Thanks,

Kanu