473,396 Members | 1,816 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

XSD File and Database View

hi Guys!
i've faced very very strange problem. i don't know whether it is a
problem or its the feature of the .net 2.0. I'd made some Dataset using
XSD file. in this XSD files i've created 3 tables and defined some
constraint in them. i generated Data Adapter and everything was working
fine. Then i made change in the database. i added one column in the one
of the table and renamed the table and also created the view with the
previous name of the table so that my dataset work correctly. but what
surprised me is, my dataset didnt work. yeah, i spent hours to find out
the problem but all my R&D failed.

after lots of R&D i drop the view and again renamed the table and
everything started working back. and that surprised me.

My conclusion on this is :
-- if you have enforced constriant in the Dataset XSD files, then do
remember to modifiy tables in the file as you modify them in the
database
-- XSD file doesnt work with views. i mean if you have constraint
enabled then XSD failes to work with view as it only requires physical
tables so that constraint can be enfored.
I want your vies on my experienced because this is something i cant
find it anywhere and only experienced developers can tell me why, what
and how on this problem. please let me know if there is something i'm
missing.

thanks,
Lucky

Jun 9 '06 #1
0 946

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Bing Du | last post by:
Greetings, Our former SQL Server 2000 DBA backed up everything in a single disk file. By everything I mean, full backup, differential backup and transaction logs. See below for details of how...
3
by: R Reyes | last post by:
what are the pros/cons of uploading a file into a database (like access, sql server, oracle) vs. uploading a file into a folder (and only storing its path in a database table) ? i've never had...
9
by: semesm22 | last post by:
hello all, i am using asp.net with IIS on a Windows XP machine to open an Access database, and i know that this topic has been posted on forums hundreds of times, but i can't find an answer that...
5
by: Seok Bee | last post by:
Dear Experts, I currently trying to use the FileUpload control from asp.net 2.0 to upload files. The uploading of the file I would like to store it in the Access Database. Unfortunately, I've no...
3
by: MN | last post by:
Hello all - I'm hoping that someone knows the answer to this as I have not done this in ASP before. Basically, I need to select a csv file from my desktop through the "Browse.." button in my...
0
by: Lucky | last post by:
hi Guys! i've faced very very strange problem. i don't know whether it is a problem or its the feature of the .net 2.0. I'd made some Dataset using XSD file. in this XSD files i've created 3...
12
by: SAL | last post by:
Hello, Is it possible to read a CSV from the Client, and bind my Datagrid to the data in the CSV file without uploading the file to the Server first? I have tried and in Debug mode on my...
2
by: cckelly | last post by:
Hello, all! I need help. There is a "view" in a SQL Server 7 database that contains all the data I need. I want to create an Excel file (version Excel 2000). I want the file to open the view and...
26
by: Don Calloway | last post by:
I have created a <filename>.db1 (where <filenameis the name given to the database) Access database that is being used in multi-user mode. When the <filename>.db1 file is opened by a user, the...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
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...
0
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
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
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,...
0
tracyyun
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...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.