i am a newbie in asp.net, i need little assisstence that how can i use sql views in asp.net + views with parameter ,please tel me little sample. i am very gr8ful to u.

you call them just like a normal query:

SELECT Field1 FROM View1 WHERE Field2=0

Chi

They mostly come at night...mostly

Thanks chi , plz one thing more .
how can i pass value like date from asp to sql views .
example: txt1= 18-04-05
views = select * from exp where dt=txt1.value

how can i pass txt1 to views ?

thanx

views = "select * from exp where dt='" & txt1.value & "'"

Chi

They mostly come at night...mostly