Architecture :: Query Data Across Different Database?

Jul 19, 2010

We have a requirement in which we need to query data across 2 different databases ( 1 in SQL Server and other in Oracle).

Here are the scenarios which need to be implemented:

Query: Get the data from one database and match for values in other Update: Get the data from one database and update the objects in other Technology that we are using: ASP.net, C#

The options that we have thought about:

Staging area in one database Link Server ( can't go with the approach as it is not allowed due to organization wide policy) Create web services Create 2 different DAL and perform list operations with the data from 2 sources in DAL.

View 2 Replies


Similar Messages:

Architecture :: Ado.net Entity Framework - Query - Return Correct Data

May 26, 2010

I just tring to a complex (for me) with ado.net entity framework this is the structure: In practice it is a sort of group purchasing (Buyers) For each group of purchase (Buyer) should have the opportunity 'to select all products of the brands indicated in buyer I'm doing function to return correct data like this:

public List<Product> GetProductsByBuyer(int vBuyerId)
{
Buyersctx.Products.MergeOption = MergeOption.NoTracking;
return (from lProduct in Buyersctx.Products.Include("Brand").Include("Buyers")
where select lProduct).ToList();
}

View 2 Replies

Architecture :: Database Vs XML For Complex Changing Data

Sep 8, 2010

a designer interface (like visio)2. client to display the content created within the designer interface.We have the design outline in place, the client will be in many forms, via the web using Flash or Silverlight (depending what's installed) and via windows using a WPF application.I would like to know what people think regarding storing information from the designer, all the clients will need to access the information via the internet so a database storage solution seems the first choice. But another alternative is exporting the information from the designer in something such as XML and storing that as a physical file

View 7 Replies

ADO.NET :: Inserting Data Into Database Using 3 Tier Architecture C#?

Jan 24, 2011

I am doing a project which requires me to input survey response to database, which means i have to insert data into the table after survey has been attempted.Is there any solutions that i can use to do it in 3 tier architecture?

View 2 Replies

Architecture :: Get The Form Data And Store The Data Locally And Sync To Database Later

Feb 17, 2011

I need to create a asp .net web application which should have several forms to get the survey data, When the user is out of the wifi or don't have internet access to connect to the server even though the user should have access to the forms or any other tools to input data and store them locally and sync to the database later. What are the options available to do this kind of tasks in asp.net / C# / Sql Server

View 2 Replies

Architecture :: How To Design A Map With Co-ordinates That's Driven From Data In A Database

Jan 17, 2010

I didn't really know where and how to put this so here we go:

I'm trying to design a map with co-ordinates that's driven from data in a database. I want it to look something like this:

Also, the selected X/Y co-ordinate must be centered for the user to see. How could I produce something like this?

View 5 Replies

DataSource Controls :: Can't Find Query's / By Right Clicking On Database Created A Query In Server Explorer?

May 17, 2010

By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.

View 10 Replies

Architecture :: Binding Of Gridview With Database Versus XML Layer / Database

Apr 13, 2010

I am having serious performances issues with gridview + tabs. Its very slow.. I was thinking to create a XML based logical layer between my database and UI.

1) Will it be useful if i use webservice to get data from database to poppulate gridview?

2) or Use xml + some service (need advice on it)

View 3 Replies

Architecture :: Searching Over 2 Datasources - Result Is Query Parameter For Second Search

May 3, 2010

I would like a site that offers the users the possibility to search over 2 datasources but as i tried to indicate in the subject title the searches are one after another where the result of search 1 is used as a parameter for searching the second datasource. The order of the search would depend for what you search (ideally). Some "fields" or "data" of course appear in both datasources.

To get more specific: datasource 1 contains chemical structures and the associated "id" for this structure + additonal properties. You can search for chemical structures here. (chemically intelligent system). datasource 2 contains documents which are indexed (full text) and have metadata fields one of them beeing above id. No chemical search possible.

The idea is now that i perform a search by chemical structure on datasource 1. As as a result I get a list of id's. These id's are then past into datasource 2 as parameter + also all additionaly parameters entered. There are API's available to perform above searches on the 2 datasources. Is this a reasonable approach? Would it be better to create somekind of a simple datawarehouse, eg a table with all numbers linked to all documents they appear in? (would't know how to achievie this actually since it's the 2 datasoruces are not the same rdbms).

View 2 Replies

DataSource Controls :: Select Query / Not Filtering Data From Database?

Mar 19, 2010

i have used one query like this

Select skillReq from tblPostJobs where SkillReq like '%Silverlight 2.0%'

it is working fine. But while giving

Select skillReq from tblPostJobs where SkillReq like '%Silverlight 2.0,C#%'

It is not filtering data from database. It is only checking starting and ending Character.In my database some keyskill are like that

Asp.net 3.5,4.0,C#,Sql server 2008,Silverlight 2.0,3.0.

My requirement is to check each word in "SkillReq" text.

View 3 Replies

Forms Data Controls :: SQL Database Query For Dropdown Selection As All?

Apr 29, 2010

How to query a SQL database with Dropdown Value Selected as All. Supportgrp is a Dropdown List, if i select All in the Dropdown List all

values from the database should be displayed.

I use the below code currently without All selection:

[code]....

View 4 Replies

SQL Server :: Query To Select Data From Multiple Tables And A Different Database?

Dec 1, 2010

Is there a way to select data from multiple tables other than the UNION ALL statement. Addtionally I need to select data from a different database.

My current statement is as follows (there are alot more fields but I have shortened it ):

SELECT server.dbo.SRFILE.SR_GROUP, server.dbo.SRFILE.SROWNERSHIP, server.dbo.SRFILE.SRCONMAE, BSFLBWF_1.Incidentx,
BSFLBWF_1.Severityx FROM server.dbo.SRFILE INNER JOIN
BSFLBWF AS BSFLBWF_1 ON BSFLBWF_1.Incidentx = server.dbo.SRFILE.SRONUMBER
WHERE (BSFLBWF_1.Closex IS NULL).........

View 4 Replies

Forms Data Controls :: Database Query For SQL 2005 Using C#.NET For 3 Field Values

Apr 28, 2010

How to query a SQL database with 3 field values ( From date, To date and based on a Dropdown Selection)

I use the below code:

sqls = "SELECT * FROM QlyData where Date >='" + txtstartdate.Text +
"' and Date<='" + txtenddate.Text +
"' and '" + supportgrp.Text +
"'";

Supportgrp.text is a Dropdown selection.I get the below error:

Exception Details: System.Data.SqlClient.SqlException: An expression of non-boolean type specified in a context where a condition is expected, near 'Database'.

View 2 Replies

Forms Data Controls :: Query About Listbox Control For Updating To Database?

Aug 11, 2010

I do have a listbox control and a button to update values of the list box with few other values of the form to the database. If i select 3 values in the listbox, it has to update the database in 3 rows (Unique for Listbox value) with the other value being the same. I use a details value for inserting values.

View 5 Replies

Web Forms :: Error In Retrieving Data From Database Using Query String For Having In Table

May 18, 2012

I am using query string under gridview, when i click link on gridview "

Datas are in table,

 add_cat_name(field)

Educational aides-Glass Decorators  (Display the value in search related page)

Colleges-Arts & Science Colleges UG/PG (does not display the value because (&)

 My coding

<asp:GridView ID="GridView2" GridLines="none" runat="server" AutoGenerateColumns="false" >
<Columns>
<asp:TemplateField>
<ItemTemplate>
<a href="search_related.aspx?id=<%# Eval("add_cat_name")%>">

[Code] .....

View 1 Replies

Query The Database Through A Query String?

Jan 15, 2011

I wanted to create a URL like http://localhost/menu.aspx/?id so that on typing this, it displays all the id's in the database. for eg:134

123

543

234

may be the id's which should be displayed after fetching from the database. However, it should be displayed as it it is without any control or without arranging in any gird etc. How can that be done?

View 1 Replies

Forms Data Controls :: Database Query Returns 2 Rows But Repeater Only Shows 1?

Apr 12, 2010

here is my code:

My sql query is returning 2 rows by my repeater is only displaying 1.

[Code]....

View 3 Replies

Access :: Database Architecture - Howto Design The Data Access?

Feb 12, 2010

I am starting a new project in ASP.NET (With silverlight) - I would like to get expert opinion about how to design the data access.I can use DataAccess Layer with SQL helper, but the challenge is every new field that I add needs to be added in the sql helper.I am trying to see if there is a way to design the system, so that it appears in the front end when a new field is added. I don't want to have in the ASPX files (binding in controls) I want to have ability to change items in code. Essentially I am trying to see the best option to have a database application.

View 1 Replies

Architecture :: Use Different Database For One Application?

Nov 24, 2010

How to use different database for One Application

View 6 Replies

Architecture :: Want To Add Record In Database With The Date?

Apr 11, 2010

In my application i want add record in database with the date. My need is that particular record should be deleted on a given date.Example: i have added one record on 1 Apr 2010 and it will be deleted on 25 Apr 2010.Any idea how to achieve this? I need a logic to delete that particular record automatically from the database on a given date. I am using MS SQL 2005.

View 6 Replies

Which Architecture Use To Access A Database With Web Services

Sep 10, 2010

Suppose we are building a web-based application to retrieve and enter information into a database. The user-interface invokes web services. Which architecture would use for the application.

View 10 Replies

Architecture :: Database Tables Have To Include?

Oct 20, 2010

I'm developing Web Desktop like Glide or Icloud. It's gonna be a web application that gives the real world desktop application functions.

The DBMS I'm goin' to use is SQL Server. Now, I'm designing the database schema, but having some problems with it. I've no idea what tables I've to include.

So far I've only Users, Folders, Files, RecycleBin, Contacts, ContactGroups tables, but it seems very few. May be I've missed something.

View 2 Replies

Architecture :: How To Represent Scenario In A Relational Database

May 26, 2010

i'm new with design patterns and i'm not sure if in this situation i can use a composite pattern.

The scenario is a web application for an address book : the address book cointains AddressBoookItem, generalization for Contact and ContactGroup. The last one is the composite object containing a collection of AddressBoookItem.

With these scenario i'm sure that this is a composite pattern, but what is confusing me is that a contact may belong to many contactgroup. Does this request change the situation? Till now i thought that between the Leaf object and the Composite (in the composite pattern) there was a 1-to-m relationship (a composite may contains many leaf but a leaf is contained in only one composite object). Can i still use the composite pattern ? And, the last question,

How could i represent my scenario in a relational database? One table for the entire hierarchy or two table (Contact and ContactGroup) with a m:n relationship between them ?

View 3 Replies

Architecture :: How To Create Ecommerce Site And Database For It

Oct 2, 2010

I want to create small ecommerce site with sign up and log in pages. there are two categories jeans and T- shirt

I want to create category pages and product pages but I dont understand how to form tables in database means exactly how

many tables required for this application and how all tables are connected to each other ( how to make relationship in tables)

when particular user sign in and select particular pages how it will added in his cart.

View 1 Replies

Architecture :: How To Design Small Web Project And Database

Oct 7, 2010

how to design following small webproject and database .i am totally new in this area.

I need to quickly develop a system so that everyone can access the status of the job going online into the system

Activities

Move the job between work centers when it's completed.

Transfer button. So when design is done we should be able to click the transfer button and move the job from Design to Procurement

Here are the work centers.

plan cerement TST Shipped Each work center should have due dates User will have to update manually due date for each work center and this will be different for each job.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved