473,385 Members | 1,331 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,385 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 947

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...
12
by: dbuchanan | last post by:
Hello, (Is this the proper newsgroup?) === Background === I am building a solution with two projects. One project is my data access layer which contains my DataSet as an xsd file. The XSD...
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...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
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?
1
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 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.