Request Web Database Tutorial - Simple Examples

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Greetings,

To clear the air, I am a hardware guy and not a software guy by nature.
However, need to learn some basics quickly.

We have a Sql Express 2008 DB that houses some scanned data.

Using Sharepoint Designer, was able to whip up a quick DataGrid thing and
view the data - just don't like the limitation I have.

The table elements are below:

SELECT [StockID]
,[PalletBarcode]
,[BoxBarcode]
,[StockCode]
,[OrderNumber]
,[StatusID]
,[StatusDate]
,[RevisionStamp]
FROM [DataWhse].[dbo].[Stock]
WHERE BoxBarcode LIKE 'value%'


What I would like to try to learn how to do is:

Main Querey is display top 10 records for todays date.

Give an Input Box and Button to search for a Boxcode and display records
associated.

Also search for a PalletCode, Group and show all boxes on the pallet.

I think I can figure out the SQL for it, just get confused on how to code it.

If someone can give some examples - or better yet point me in the best
direction of resources - keeping my frame of reference. MSDN showing
libraries probably not the best location for newbies.
 
If someone can give some examples - or better yet point me in the best
direction of resources - keeping my frame of reference. MSDN showing
libraries probably not the best location for newbies.
Click to expand...

First, understand how to drag and drop controls on the page to query a
database:
http://bit.ly/SW4O

This is in SharePoint Designer. You can also look at earlier Expression
tutorials at http://www.microsoft.com/expression/, as the two tools are
the same. Here is a video on the DataSource for example:

http://expression.microsoft.com/en-us/cc265108.aspx


Now some specifics:
Main Querey is display top 10 records for todays date.
Click to expand...

SELECT TOP 10 *
FROM Table
ORDER BY TableDate DESC

You should iterate the fields rather than use the *, but that is the
basics.
Give an Input Box and Button to search for a Boxcode and display
records associated.
Click to expand...

This is done by setting up a DataSource control (SqlDataSource for SQL
Server) and linking the input of the query to the DataSource. I used to
have a link for an example for this. NOTE: if this is on the same page
as the last example, you will have to use a second DataSource, as the
control is mapped both to the results grid and the textbox.

Also search for a PalletCode, Group and show all boxes on the pallet.
Click to expand...

Same basic idea, but you will end up with a bit of code to link
everything together.
I think I can figure out the SQL for it, just get confused on how to
code it.
Click to expand...

Solve problem 1 first, which is learning the DataSource control. You may
outgrow it, but it is a good start.

I would also look at ASP.NET sites for data binding, as there are some
great tutorials out there. This is a great starting place:

http://www.asp.net/learn/

Peace and Grace,


--
Gregory A. Beamer (MVP)

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************
 
Back
Top