A Living Data Connection

[jp2msft]

With the control DataGridView1, I can fill it with data easily:

using (SqlDataAdapter da = new SqlDataAdapter(sqlText, sqlConnection))
{
DataTable table = new DataTable();
da.Fill(table);
DataGridView1.DataSource = table.DefaultView;
}

Now consider viewing your portfolio in Google Finance or Yahoo! Finance: The
stock price values for every item in your portfolio appear to update real
time! The current asking price of any stock updates without you having to
click the refresh button.

How can I get my tables to automatically update the controls on my forms? Do
I have to create and register some event with SQL Server, is this ability
built into the SqlDataAdapter, or ... something else?

 

[Morten Wennevik [C# MVP]]

Hi,

You might be able to use query notification

[Implementing SQL Server 2005 Query Notifications in C# Windows Application]
http://support.microsoft.com/default.aspx/kb/555893