[RESOLVED] Query web page in asp.net+vb

in my asp.net+vb web with accessdatabase i have a new web page in which i am willing to design a query(flexible) web page and out put to a gridview. 

the table name is pers and fields are

PNO, name, enroled(date), dob(date) grading, courses, home_station

i am willing to take output as per the users requirement

eg:- if  a usser want people who are qualified in BCA and whose DOB is less than 23 yrs and have been enroled before 2011 having home station in delhi.

how can i do that. 

HI Baiju,

you can make dynamic queries either in .net or in SQL:

Please read the below article on dynamic queries:

http://www.codeproject.com/Articles/20815/Building-Dynamic-SQL-In-a-Stored-Procedure

Hi,

Try this tutorials:

http://www.aspdotnet-suresh.com/2012/05/aspnet-gridview-examples-and-samples-in.html

http://www.encodedna.com/2013/01/asp.net-gridview-edit-delete.htm

Hope this helps!

Thanks!

i watched all 2+1 links provided . my requirement was not that.

i am wiiling to make a query web page in which interactive dropdownmenu,textbox,check box are available and user can select the data as per their requirement and press a submit button and the out put of that query can be viewd in gridview

Hi,

I  think you can use Using the ASP.NET 4 QueryExtender Control to
filter data easier on a web page. For detailed information, you can refer here

http://www.codeproject.com/Articles/79742/How-to-Using-the-ASP-NET-4-QueryExtender-Control

http://dotnetslackers.com/articles/aspnet/Working-with-Query-Extender-control.aspx

And refer here about Using control Parameters with Data Source Controls

http://msdn.microsoft.com/en-us/library/xt50s8kz(v=vs.100).aspx

http://www.aspsnippets.com/Articles/Filter-GridView-with-TextBox-using-FilterExpression-in-SqlDataSource-in-ASPNet.aspx

Hope it can help you