Ado.net and SQl view ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all,

I would like to bind a datgrid control to an SQL view.
How set SQL command type for a view ? Is it Text ?

IN which form the sql view is returned, data set ?

When I get my view bind to my grid, if new data is inserted in my database,
does my view will be automatically refreshed with new data or dor I have to
run the refresh my self with my datagrid ?

The idea is that I would like that my grid data gets automatically updated
if new data gets inserted and remove from my tables manged by the view

thnaks for help
regards
serge
 
Think of an SQL VIEW as a macro that simplifies a SELECT statement. When you
execute a SELECT on a VIEW instead of a TABLE, you get a set of columns and
rows (a rowset) determined by the SQL in the VIEW. This means ADO.NET (or
ADO) can manage the rowset like any other--with some limitations if the VIEW
is too complex. AFA as data viability, the rowset returned from a view is
cached on your client system--just as if it came from a TABLE or procedure.
If you want to see current data, you have to requery somehow.

I discuss this issue in depth in my book.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
 
Back
Top