Re: Is asp.net database design different to ado and access?
- From: "Cowboy \(Gregory A. Beamer\)" <NoSpamMgbworld@xxxxxxxxxxxxxxxxxx>
- Date: Mon, 4 Sep 2006 13:21:48 -0500
I assume you mean you have dragged tables onto a DataSet? Cool. You now have
Table Adapters. Add the Relationship. You can now bind like you desire. As
for INSERT and update, run the table adapters in the order they need to be
inserted into the database (parente first, child last).
What generally causes problems with relationships is improper ordering of
saving items. If you have automagic stuff, you will have to take control and
force them to save (and pull out of the database, for that matter) in the
proper order.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
*************************************************
Think outside the box!
*************************************************
<kiwileiro> wrote in message news:u8MxGR6zGHA.4796@xxxxxxxxxxxxxxxxxxxxxxx
Hi, i am using asp.net 2.0 to make a database front end. I would like
opinions on which field of a lookup table to store in the main table.
Currently I store the keyfield value from a dropdownlist that is
retrieving data from another table, in to my main table.
I have had difficulties when trying to display the data in the
itemtemplate of a gridview.
There appears to be no easy way to show the RELATED TABLE information
without linking the tables in the query to retrieve it.
Doing this though makes it harder to update the table adapter in Edit or
Insert mode. I would rather use the adapters as Visual Studio made them
for me.
A helpful person in a forum has suggested that instead of storing the
keyfield in the table that I store the actual text value, and that would
make it a lot easier as I have just to display the value and not link to
it.
I have made many Access and winform databases but this is my first asp.net
one.
In an Access or winforms database I would bind the keyfield and save that
in to the main table. As asp doesnt have the continuous state connected to
the database, I wonder if we design differently too.
What are your thoughts on this? What is a preferred approach to a very
common issue?
.
- References:
- Is asp.net database design different to ado and access?
- From: kiwileiro
- Is asp.net database design different to ado and access?
- Prev by Date: Problem with nested QueryString
- Next by Date: Re: Problem with nested QueryString
- Previous by thread: Is asp.net database design different to ado and access?
- Next by thread: Inserting to Access Database
- Index(es):
Relevant Pages
|
