Ado.net and SQl view ???

[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

 

[William \(Bill\) Vaughn]

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)