Help creating a very simple page

[johnc83]

Hi All,

I have been creating a new windows VB application for the past few months and it has become necessary for part of it to be web-based. I have never created a new asp.net web site before and was hoping someone could point out the basics.

How would I go about setting up a home page where someone entered a value and a query was ran on my table.

e.g my Table 'tblJobs' has two fields, JobNumber & AccountNumber.

I would like user to enter their account number and be presented with all the jobs linked to that account number.

All I have been able to do so far is show every single record from the table.

Hope someone can help.

thanks and regards

John

.NET 2.0, Visual Studio 2005, SQL Server 2005 Express

 

[ca8msm]

Have a look at these ASP.NET beginner resources as it will benefit you to watch and read some of the tutorials on basic ASP.NET data access.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[johnc83]

Thanks for that, i'll take a look

much appreciated

John

.NET 2.0, Visual Studio 2005, SQL Server 2005 Express

 

[johnc83]

Hi again, sorry if it looks like I am being lazy but I only need to be able to run a simple select query with one parameter. Need it quite quick thats all - I can look at the basics later on when I get chance.

Done so far:

On my default.aspx form I have a textbox (CustCodeTextBox) and because I have dragged some fields from the database I now have a 'SqlDataSource'.

I have configured this datasource to include a WHERE clause against what is in the CustCodeTextBox but I don't know how to execute it and populate the data.

It doesn't need to be perfect - just to show my bosses that it is possible.

Cheers

John

.NET 2.0, Visual Studio 2005, SQL Server 2005 Express

 

[ca8msm]

One of the tutorials from the ASP.NET site does pretty much what you are asking:

http://asp.net/learn/data-access/tutorial-05-vb.aspx

However, if you do go down the route of using the data controls then potentially they will make things harder in the long run


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[johnc83]

got what i was looking for now,

thanks a lot

John

.NET 2.0, Visual Studio 2005, SQL Server 2005 Express