Datagridview to reflect changes made in Server database

[amitjaura]

Well i have a datagridview in my application and i want it to reflect any changes made in server database instantly with some trigger or so?
I have a choice to use timer and get the desired results by binding datagridview after every 5 sec's or so but i dont want to do this .As it ll affect the performanc e of my application.Ple ase suggest a better way out......

[dmj07]

Put the gridview in an update panel with any controls that update it and on the back end run:

GridView1.DataB ind();

In the call that the control makes it will bind the gridview with all changed values without posting back.