Hi all.
Using Visual Studio VB.NET and SQL Server 2000.
When I drag tables from the SQL Server Explorer into a dataset I am building
I get the table, fieldnames and types. But, why doesn't it put in relations,
defaults and all the other information from the SQL Server. It takes time to
do this in VS when it is already done on the SQL Server. When I build a
diagram in SQL Server all this information gets there automaticly, but not
in VS.NET. Are there som settings I am missing here? We do have some
datasets with lots of tables and relations, constraints, defaults....
Thanx all.
gh
1  1540 
The XSD tool that VS uses is but one way of creating typed datasets.
You may want to take a look at alternative tools like CodeSmith http://www.ericjsmith.net/codesmith/ which uses customizable templates to
generate code like typed datasets, data access layers and business objects..
"Geir Holme" <ge**@multicase.no> wrote in message
news:eD**************@TK2MSFTNGP10.phx.gbl... Hi all.
Using Visual Studio VB.NET and SQL Server 2000.
When I drag tables from the SQL Server Explorer into a dataset I am
building
I get the table, fieldnames and types. But, why doesn't it put in
relations,
defaults and all the other information from the SQL Server. It takes time
to
do this in VS when it is already done on the SQL Server. When I build a
diagram in SQL Server all this information gets there automaticly, but not
in VS.NET. Are there som settings I am missing here? We do have some
datasets with lots of tables and relations, constraints, defaults....
Thanx all.
gh
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: DrSarang |
last post by:
While building XmlSampleGenerator code from MSDN, I get missing XmlSchemaSet
reference. Here is the screen dump, if needed.
C:\Documents and Settings\Dr Sarang\My Documents\MSDN\XML Sample...
|
by: alex via SQLMonster.com |
last post by:
Hi, anybody can help me.
How can i synchronize 2 tables on 2 different sql servers 2000
i mean TABLE1(col1, col2, col3, col4) and
TABLE1(col1, col2, col3, col4, col5, col6)
the first 3...
|
by: RWC |
last post by:
Hi Folks,
I should begin by saying I'm fairly new to SQL Server. I'm an application
developer who has built front ends atop Server, but have never done much in
the way of design / development....
|
by: mscir |
last post by:
I would like to generate a page of links including some of the pdf
properties (title, author, version, etc.) for a folder full of pdf's.
Is this possible from Javascript?
TIA,
Mike
|
by: Geir Holme |
last post by:
Hi all.
Using Visual Studio VB.NET and SQL Server 2000.
When I drag tables from the SQL Server Explorer into a dataset I am building
I get the table, fieldnames and types. But, why doesn't it put...
|
by: Peter M. |
last post by:
Hi all,
I'm currently designing an n-tier application and have some doubts about my
design.
I have created a Data Access layer which connects to the database (SQL
Server) and performs Select,...
|
by: Luqman |
last post by:
Is it recommended to use datasets in ASP.Net 2.0 / VS.Net 2005 ?
Best Regards,
Luqman
|
by: robin9876 |
last post by:
I have two data connections and two returned datasets which one set of
results need to be used in the other connection.
The first dataset will return a list of customer reference codes that
are...
|
by: newtonwong |
last post by:
I have a web reference WSDL, but it doesn't really create an XSD. I'm
trying to generate datasets from the WSDL file but not sure how to do
so.
I successfully created the proxy class, but the...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
