Controlling database with aspx

Mint_Sauce · 20 Jul 2008 at 20:04

Ok, my friend and I have different skills. I am competent at CSS/HTML and he is competent at building databases.

The problem is the middle bit, I don't know a whole heap of aspx and neither does he. We realise to get the most from the database (and what we want to do) we will need to code it ourselves rather than rely on the wizards in VB Studio 2008.

Does anyone have any tips on places to learn some stuff on the 'middle bit' since we're both a bit clueless at the moment.

Gman · 20 Jul 2008 at 20:34

I would try and MSDN Quickstart guides that should get you up and running maiing connections using ADO.Net

GravyMonster · 21 Jul 2008 at 09:25

There are some examples of database access at http://www.asp101.com/samples

Mint_Sauce · 21 Jul 2008 at 17:11

Thanks for the link and info we managed to get the database working online!!

Now we are trying to customize the tables etc. We have a list of items on a table and underneath a description window. What we have right now is some text called select which when clicked shows the description underneath in a box. This isn't ideal as we want people to be able to click the text itself.

For example what we currently have:

Cat - Small animal, four legs, purrs - Select
Dog - Small to large animal, four legs, eats stuff - Select
Bird - Small animal, two stick like legs, pecks things - Select

DESCRIPTION OF ANIMAL APPEARS HERE WHEN SELECT IS CLICKED

Whereas we want to get rid of the select and just have the name of the animal as the clickable bit:

Cat - Small animal, four legs, purrs
Dog - Small to large animal, four legs, eats stuff
Bird - Small animal, two stick like legs, pecks things

DESCRIPTION OF ANIMAL APPEARS HERE WHEN ANIMAL NAME IS CLICKED

Simple but confusing the hell out of both of us. Any ideas?

MMD · 21 Jul 2008 at 17:17

I don't code in aspx but surely it's just a simple case of making the select call from the db and wrapping it in a link ?

Mint_Sauce · 21 Jul 2008 at 17:18

Maybe, I think I need to do a bit more learning.

Gman · 21 Jul 2008 at 18:46

if its a grid view then you can configure the colls seperatly, I assume your just letting it display automatically at the moment.

In the designer click the > next to the grid view then edit colls. you can manually add your colls now and choose how you want them to display. Just set the col you need as a HyperLinkField and feed it the url, using the data section of the properties.