How to request querystring

[Bob]

I'm a Visual Studio 2005 beginner and trying to make a dataset to query a
newsstory. The url to the story looks like this news.aspx?ID=1.

I'm using Access DB and I made a query there which looks like this
SELECT articles.ArticleID articles.Titel, articles.Story
FROM articles
WHERE articles.ArticleID = @ID;

My question is how I make a dataset in Visual Studio which will do this? Any
tutorials or something to guide me along? Pasting the sql above gives an
error so I guess I must be missing something.

[intrader]

On Wed, 07 Dec 2005 23:34:51 +0100, Bob wrote:

I'm a Visual Studio 2005 beginner and trying to make a dataset to query a
newsstory. The url to the story looks like this news.aspx?ID=1.

I'm using Access DB and I made a query there which looks like this
SELECT articles.ArticleID articles.Titel, articles.Story
FROM articles
WHERE articles.ArticleID = @ID;

My question is how I make a dataset in Visual Studio which will do this? Any
tutorials or something to guide me along? Pasting the sql above gives an
error so I guess I must be missing something.

I like ASP.NET Unleashed; lots of good examples.

[Nathan Sokalski]

I think the reason for your error is the fact that you are mixing SQL code
with other code. Try rewriting your code like this:

"SELECT articles.ArticleID,articles.Title,articles.Story FROM articles WHERE
articles.ArticleID=" & Request.QueryString("ID")

See if this solves your problem. If not, let me know. You are also more
likely to get better help sometimes if you copy and paste the actual error
text in the posting, it gives people more information to work with. Good
Luck!
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

"Bob" <do*************@usa.net> wrote in message
news:%2******************@TK2MSFTNGP12.phx.gbl...

I'm a Visual Studio 2005 beginner and trying to make a dataset to query a
newsstory. The url to the story looks like this news.aspx?ID=1.

I'm using Access DB and I made a query there which looks like this
SELECT articles.ArticleID articles.Titel, articles.Story
FROM articles
WHERE articles.ArticleID = @ID;

My question is how I make a dataset in Visual Studio which will do this?
Any tutorials or something to guide me along? Pasting the sql above gives
an error so I guess I must be missing something.

[Nathan Sokalski]

I have to support you on that, ASP.NET Unleashed is probably the best book I
have ever bought. I found the example-based teaching style to be very
helpful in understanding, and I think that the book must have increased my
ASP.NET skills ten-fold, if not more. I don't know what I would have done
without it, it's an ASP.NET developer's best friend.
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

"intrader" <in******@aol.com> wrote in message
news:pa****************************@aol.com...

On Wed, 07 Dec 2005 23:34:51 +0100, Bob wrote:

I'm a Visual Studio 2005 beginner and trying to make a dataset to query a
newsstory. The url to the story looks like this news.aspx?ID=1.

I'm using Access DB and I made a query there which looks like this
SELECT articles.ArticleID articles.Titel, articles.Story
FROM articles
WHERE articles.ArticleID = @ID;

My question is how I make a dataset in Visual Studio which will do this?
Any
tutorials or something to guide me along? Pasting the sql above gives an
error so I guess I must be missing something.

I like ASP.NET Unleashed; lots of good examples.