SQL Server :: Create A Relationship Between Database Table And Xml File?
Mar 17, 2011
I've just taken over looking after a website and well to be honest the way it's been put together is not the best, but I have to make do as the client does not have the money to make major changes.Anyway currently there is data stored in a MsSQL database and some in an XML file. The xml file does have a ContentID attribute which matches the ContentID in a table.Not really done much with XML as I tend to use a database and LINQ.What would be the best way to tie these two together so I could output the results in a gridview for example.
View 2 Replies
Similar Messages:
Dec 17, 2010
i am working with multiple table with some same columns, so here i want to use the concept of primary key and foreign key.primary key is very easy to put on any fields but, i dont know how to give foreign key and how to create relationship between same fields of two table.
View 2 Replies
Nov 29, 2010
I have two tables as below.
I tried to establish a relation between two tables in such a way that Table_Contracts will still accept NULL values for [PO_No], but [PO_No] on TableContract will be automatically updated when [PO_No] on Table2_PONo changed. Moreover, if you want to delete a record on Table2_PONo, it needs to be stopped if there is a related data in Table_Contracts.
I set a relation with these parameters:
Check existing data on creation or re-enabling>
No
Enforce for replication>
No
Enforce foreign key constraint>
No
Delete Rule>
No Action
Update Rule>
Cascade
I got this error
Introducing FOREIGN KEY constraint 'FK_Table_Contracts_Table2_PONo' on table 'Table_Contracts' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Table2_PONo
[PO_No]
(primary key)
[Project_ID]
[SupplierID]
[Description]
[TotalPrice]
[PO_Currency]
[VATpercent]
[CostCode]
[Notes]
[PO_Date]
[Reality]
[UpdatedBy]
[FromAccess]
Table_Contracts
[ContractID]
[ProjectID]
[PO_No]
(accepts null values)
[ContractNo]
[ContractDate]
[ContractValue_woVAT]
[ContractCurrency]
[SupplierID]
[ContractDescription]
[ContractType]
[LinkToTemplatefile_DOC]
[SentToSupplier]
[SignBySupplier]
[SignByMercury]
[CollectionBySupplier]
[LinkToPDFcopy]
[ArchivedByMercury]
[UpdatedBy]
[Retention]
[Note]
View 2 Replies
Mar 30, 2011
When I created table on the shared SQL server on hosting server using management studio, I right click mouse on the table, it pops up create table. However, the table schema is my user name but not dbo. I wnat to create table with dbo schema.
View 2 Replies
Aug 16, 2010
Please advice me how can we create we create a new table or can add rows in database sql server 2005 while user make changes in site?
View 5 Replies
Feb 22, 2011
I want to create a database in Sql server 2005 with library tables like aspnet_applications, aspnet_profile etc.,
I want to provide admin interface[webform] for the client to create user in the aspnet_Users.
How can I attain this?
View 1 Replies
Sep 26, 2010
I am able to create database through script generated by SQL Server 2008 but unable to create tables from generated script. Please indicate if any step is missing.
************* Code *******************
[Code]....
****************** Contents of text file appended below ***********************
[Code]....
View 5 Replies
Sep 28, 2010
I am working on a multi-lingual application Assume the following:
Database has 50 tables and application has to support 5 languages
Which is the best way to design the database:
1. Include a langugae column for each table. Repeat the values for each language. Say i have a country table which has 100 countries in it. Then my design will contain 500 rows (100 for each langugae)
2. Create a separate table which will contain the translations for all the 50 tables in with a foreign key to the parent table.
Which is more efficient out of the above two.
View 3 Replies
Oct 25, 2010
How to create Database from .bak file in asp.net c#
and the new database should be created with new database name,user id and password
View 4 Replies
Sep 24, 2010
I dont know where to start, but I have a simple issue that you may be able to resolve.
I have a SQL database that contains a table with user name / password / Account level in it.
What I am trying to do is to create a Login page that will use this database and table to authenticate the login.
I have spent some time looking about for an example, and the nearest that I have found is for an access Database, but I really need this to work with SQL.
View 2 Replies
Feb 15, 2010
I think I'm just after advice on best practice with this! I have a database which has 2 tables. The first table has ID, Name, Address and the second table has ID and JobType. Table 02 can list multiple types of JobType so we could have
Table01:
1. D Smith. Address01
2. S.Jones. Address02
Table02
1. Accounts
1. Sales Ledger
1. Chartered Accountant
2. IT
2. Web Design
2. Graphic Design
2. 1st line support
A join gets them together and all works perfectly.However, the content will be updated when some one fills in a web form. Do get the form to send results to both tables, I assume I have to open the database twice or can I open it once and open each table one at a time? I know I could practice this and not ask the question but I am interested to know what is the most efficient way. I would also need to know what ID to use. So when I populate Table02 it uses the correct ID from Table01. At the moment Table01 ID field is incremented automatically. Would you suggest I always assign the ID myself, or would I need to query the database, find out what ID number is currently in use and then increment it by 1 and assign the new number to an ID variable which then populates the Table's Field? In which case, am I opening the database again or trying to perform all 2/3 stages in one go?
View 3 Replies
Jan 18, 2011
i am trying to create a temporary table as like an existing table.
create table #tmp AS ( select Table1.* from Table1 where Table1.column name in (select Table2.column name from Table2 where conditions) )
But it is showing Error...
View 2 Replies
Apr 18, 2010
I working on website and i have ready database from the company database. I have a table Location has only two fields : city andtate.I tried to get select the * city where state = something , but i think it is wrong,Is it a Many-to-Many realtionship
View 4 Replies
Jun 26, 2010
I have my membership provider configured and working on my web host.
IŽd like to create a table, for example, table ARTICLES, and iŽd like that the user logged in, his ID or his NAME, was inserted into my ARTICLES database.Which one is the best table i could get for doing that ?
I was checking the table aspnet_users, but its Primary Key has a uniqueidentifer type.This wonŽt be a problem in the future ?Or is there a better way to relate my table with the membership provider ? Maybe another table OR another field.
View 1 Replies
Feb 10, 2011
I want to create a temporary table where the columns of that temporary table needs to be dynamic (those columns needs to come from the rows of another table)
View 6 Replies
Jan 8, 2013
i want to take sql table .sql extesion in sql server 2008r2Â
View 1 Replies
Aug 15, 2010
I create table:
DataSet data=new DataSet();
DataTable myTable = new DataTable("NewTable");
DataColumn[] keys = new DataColumn[1];
[Code]....
And how can I now add this table to real database( I am already conected to my sql server).
View 2 Replies
Jun 5, 2010
i am very new to the programming and also asp.net. i have an assignment to create a table on webpage the information is coming from mysql database.
View 2 Replies
Jul 19, 2010
i want show menu as :
PCLaptop
MacIBMAsusAcer
Printer
HPCanon
So , how to create table in database ?
View 2 Replies
Jan 12, 2011
How to create a table which is the combination of different columns in database tables.
I know how to make the var table using single table.
What is I have to combine multiple coolumns and create a table.
My requirement is a gridview which has a datasource which is loading from columns from multiple tables.
View 13 Replies
Jul 22, 2010
how to create the xy table like above? Currently i have able to create to insert row table read from databse which is Worker Name. My problem know is to show column name also read from data and not key in manually. Her's is myb sample codewhich is i have able to show Roa read from database.
[Code]....
View 5 Replies
Mar 8, 2011
i have database in internet ,its now on my server by using ip and username and password but this database is empty table ;i have database on my pc how can i copy all table from this database to new dabase with relation and procedure..?
View 3 Replies
Jun 26, 2010
i want to create database on single button click and create table on newly created database on second button click . I am using ASP.Net and c#.
View 1 Replies
Mar 1, 2011
how I can correct an error. I've built the MVCMusicStore tutorial here:
http://mike-ciccone.com/Store/
The first time I visit the site and attempt a database connection I get this error:
Exception Details: System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database 'master'.
But when I refresh, it all works fine. I'm at a bit of a loss. I don't believe I'm attempting to create a database, but I realise that the error may not really have anything to do with that. This is hosted at GoDaddy shared hosting. The database was created and I used an SQL script to create the tables initially and populate the data. My connection string works as I can pull data from the database, but I do have
a feeling it will be a web.config setting that will correct this.
View 3 Replies
Mar 17, 2011
i m developing an inventory module in which i have a GRN(Goods Received Note) form, the user opens the form and enter the items which are coming from itemMaster table. I want to add the grn entry in a table named GRN and all its respective item details in other table and also want to update the instock quantity in item Master table. how can i achive this there are multiple items in a grid in grn form which are to be stored in a table and only 1entry of grn in grn table and also update the instock Qty in the itemMaster Table,,...i ned write my logic using Stored procedures and ADO.NET i m totally confused
View 1 Replies
