aic007 Posted July 30, 2008 Share Posted July 30, 2008 Hi all. I am a newbie that doesn't know what to search for. I need to develop an application where I get data from an SQL view.Anyon ehere that knows about any samples, or any good links, that can help me in the right direction in making an web application like this:http://www.thommessen.no/no/Team-Thommesse...idere/?letter=aRegards Link to comment Share on other sites More sharing options...
justsomeguy Posted July 30, 2008 Share Posted July 30, 2008 Using a view is like using normal queries, if you go through the SQL tutorials and things you'll get what you need to know. When you use a view you select records from the view instead of selecting from a specific table. Link to comment Share on other sites More sharing options...
aic007 Posted July 30, 2008 Author Share Posted July 30, 2008 Hi.I know how to usw gridview, and to use SQL queries, but don't how to get a view like in this sample. Do you know about any good samples or guides I can follow? :-) Link to comment Share on other sites More sharing options...
justsomeguy Posted July 30, 2008 Share Posted July 30, 2008 I'm not sure which sample you're talking about, but this is how you create a view:http://www.w3schools.com/SQL/sql_view.aspMore information here:http://en.wikipedia.org/wiki/View_(database) Link to comment Share on other sites More sharing options...
aic007 Posted July 31, 2008 Author Share Posted July 31, 2008 Ok, thanks. The sample I was talking about was this:http://www.thommessen.no/no/Team-Thommesse...idere/?letter=aSo, basicly, I was wondering if someone knew about a sample that could help me making an application like in the link above - if I click on the "B" letter, then I will get a view of all emplyees that have a name starting with the letter "B" and so on. Link to comment Share on other sites More sharing options...
Synook Posted August 1, 2008 Share Posted August 1, 2008 SELECT * FROM employees WHERE name LIKE "B%" ? Link to comment Share on other sites More sharing options...
justsomeguy Posted August 1, 2008 Share Posted August 1, 2008 I was confused, when you use the term "view", there is a very specific thing in the SQL language called a view. It sounds like you just want to know how to display your information on the page. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.