Welcome to WebmasterWorld Guest from 100.26.182.28

Forum Moderators: ocean10000

Message Too Old, No Replies

What is the equivalent of Recordset in Dreamweaver in Visual Studio C#

Changing from Dreamweaver to Visual Studio C#

     
12:24 pm on Jan 10, 2010 (gmt 0)

New User

5+ Year Member

joined:Jan 10, 2010
posts: 2
votes: 0


Hi everyone,
I am changing from creating websites in Dreamweaver to using VStudio. I am creating my first database website using SQL 2008 and Visual Studio C# 2008.

I am stuck at a point where I would use a Recordset Query in Bindings to check a URL Parameter in the database. I would then have used the Recordset result to diplay 2 different pages depending if the result was empty or not empty.

Could someone please explain the equivalent of how to acheive this in Visual Studio 2008 C#? :(

2:03 pm on Jan 10, 2010 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 1, 2005
posts:733
votes: 0


Hi freeriderDaz, and welcome to WebmasterWorld [webmasterworld.com].

If I understand correctly you would like to achieve the following:

A URL may or may not have a Querystring parameter, and you want to query the database with the given parameter, ie:

www.example.com/user.aspx?username=freeriderDaz

One option, which is an easy way of doing it is to do the following
- Add a Data aware control (such as a GridView) to the page.
- In design view, click on the control and then on the Arrow button, and in the menu that appears select <new data source...>
- Select the Database Data source type, and click OK
- Build your connection string (or select an existing one)
- Create your Query
- Now you can select Query parameters, this can come from a QueryString, a Form control, play around with the options.

Here are some great video tutorials as well:
[asp.net...]

3:11 pm on Jan 10, 2010 (gmt 0)

New User

5+ Year Member

joined:Jan 10, 2010
posts:2
votes: 0


HI marcel,

Thanks for the reply and welcome.

I will work through your suggestions.

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members