Re: design advice
From: rodchar (rodchar_at_discussions.microsoft.com)
Date: 10/19/04
- Next message: HenkeBenke: "Re: How to share objects in an ASP.NET application"
- Previous message: Kevin Spencer: "Re: Session object question"
- In reply to: ESPN Lover: "Re: design advice"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 19 Oct 2004 14:29:02 -0700
Thanks i'll give a shot and let you know.
"ESPN Lover" wrote:
> Assuming "name" is your key field, here's the SQL call:
>
> SELECT * FROM Media m LEFT JOIN Borrowed b ON m.name = b.name
>
> Then in the datagrid, you'll want to specify an ItemDataBound event function
> that checks or unchecks the checkbox depending upon the the precense of a
> date in your date borrowed field.
>
>
> Here's a link to a links page for many useful articles on DataGrids.
>
> http://www.datagridgirl.com/articles.aspx
>
> Enjoy!
>
>
>
> "rodchar" <rodchar@discussions.microsoft.com> wrote in message
> news:079C03F2-AA36-4E19-A79C-29402A60A68B@microsoft.com...
> > Hey all,
> >
> > I'm trying to create a personal media tracker in asp.net and had a few
> > design questions. Following is a snippet of my pertinent fields in my
> database
> >
> > Media Table:
> > name
> > media type
> >
> > Borrowed Table:
> > name
> > date borrowed
> > borrowed by
> >
> >
> > I'd like to display a datagrid of all my media, and then have a read-only
> > checkbox column that's checked when the media is checked out. I'm assuming
> > that in my media table I wouldn't already have a boolean field to indicate
> > whether it's checked out or not, correct? This would be calculated by the
> > records in the borrowed table.
> >
> > So if I display all the records in my media table, what do i have to do to
> > make my requirement a reality?
> >
> > thanks,
> > rodchar
>
>
>
- Next message: HenkeBenke: "Re: How to share objects in an ASP.NET application"
- Previous message: Kevin Spencer: "Re: Session object question"
- In reply to: ESPN Lover: "Re: design advice"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
