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


Similar Messages:

Architecture :: Search Input Box For Searching Inside Website

Nov 22, 2010

Does anyone has a idea how to write code for a search box to look for keywords,etc inside the website or sitemap?

View 11 Replies

DataSource Controls :: Searching TextBox Data In Sql Database And Binding The Result In Gridview

Oct 28, 2010

I have few textboxes and I want to search the text (partial search is also required) in the database and then show the result in a telerik grid. The grid has to be hidden initially and when I click the search button it should show up and display the results.

View 2 Replies

Forms Data Controls :: Displaying Correct Result Inside DropDownList From LINQ Query Result

Jul 1, 2010

I have this ListView that has a Drop Down List.Everything works fine (I think/hope) except that the drop down list are not showing its result correctly.This is the code.

Front-End
[Code]....

The code behind consist of the page_load and the ItemDataBound
[Code]....

View 3 Replies

Linq To XML - Getting Correct Query Result, But It's Buried Deep In The Result Var?

Mar 1, 2011

I'm having a problem with my Linq to XML query. I'm getting the result data I want, but it's nested so deep that there must be a better way.Here is my XML:

[Code]....

I'm trying to get a list (simple string[]) of all Item IDs where Category Names contains "Other".Here is my Linq:

[Code]....

[Code]....

Here is a snapshot of my result from Visual Studio:The results I want are there ("item100", "item400", "item500"), but buried so deeply in the results var.

How can I get the query to return a simple

string[] = { "item100", "item400", "item500" }

View 4 Replies

MVC :: Search Form - Redirect To A Search Result Page

Mar 27, 2011

simpel search form. that redirect to a search result page.

View 4 Replies

Architecture :: Design A Class For Product Searching?

Oct 21, 2010

I'm refactoring an old website that has product search code littered throught the codebehind. I'm trying to encapsulate the search logic into its own class so I've created a Product class with a Search() method. I would like some suggestions about OO best practices so that the class is reusable and maintainable. The questions I have are:

- Should I make the search() method an instance method or make it static? For now the class is just really there to encapsulate my search logic

- If I make it an instance method should it return a list of products or should it populate a member property that I can access like p.Search(); var x = p.ProductList;

- The search method requires upward of 7 parameters of different types, what's the best way to provide them?
- pass them all i.e. p.Search (param1, param2, ..., param7)
- create a SearchParams structure in the class, populate it and pass that i.e. p.Search(searchParams)
- Instantiate a Product object and set properties on it that are used by the Search method i.e. p.ID = 123; etc.... p.Search();

I've used variations of the above before but would like to know what's the best way.

View 1 Replies

Web Forms :: Full Featured Search For Searching In GridView Columns

Jul 7, 2012

Developing a full featured search in my web application. so that in search for data in grid view or data list control and also for search for pages containing search text.

View 1 Replies

DataSource Controls :: Filtering Data (searching) On Parameters (more Than 1 Parameter)

Feb 12, 2010

I want to make data-driven page and ability to filter data on some parameters, for example 3 text boxes and 2 dropdown lists and then show the results by the grid view control.

Actually I like input data in the text boxes and select item from dropdown list and then press "OK" Button and result (filtered data) show in the new page by the grid view.

What I have seen in the quick start tutorial is filtering by one parameter.

View 1 Replies

SQL Server :: Query Slow In Loading / Trying To Display Query Result?

Feb 1, 2011

I am trying to display this query result in an aspx page.

It is very slow in loading. Here is the query. The inner query inside the outer quesry is the problem.(Please see the underlined part in the query) - (If I remove that part it is very fast.)

select

top 500

--This column is the issue
,Governing_Class=( case when exists (select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.appid and tqc.class_code not in('8742' ,'8810','7380')
order by tqcm.premium_amt desc
)
then ( select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.
appid
order by tqcm.premium_amt desc
)
......... From tables

View 7 Replies

SQL Server :: How To Copy Result Query To Another Query

Nov 4, 2010

i have tow query in one stored procedure

first query and the second one every of them return only value

i want to copy the result of tow values in a new row in new table

as i want to check on this tow values in ado.net

i want to get only this tow values as a row not first and secon query

only a row has result of first and second query results

[Code]....

View 3 Replies

SQL Reporting :: MDX Query Parameter From SSRS / Setup @from And @to As Parameter But Not Working?

Aug 21, 2010

I've a MDX Query that has where clause as shown below.I'm designing report using SSRS 2008. How can i pass date as parameter? I tried to setup @from and @to as parameter but not working?

WHERE ( {[Date Central].[Calendar Date].[2010-04-01 00:00:00]:[Date Central].[Calendar Date].[2010-08-30 00:00:00]} )

need it to work as
WHERE ( {[Date Central].[Calendar Date].[@From]:[Date Central].[Calendar Date].[@To]} )

View 1 Replies

ADO.NET :: Display Result Search Error

Nov 12, 2010

Has a stored procedure in the database to retrieve data

[Code]....

i store dataset in session to use it in resultsearch page Then in the resultsearch page I added a gridviewIn the event Abaj LodI added the code below

[Code]....

but this code is not working any one can modify and correct this code

View 7 Replies

MVC :: Do A Search And Get Result Back In A Table

Jan 27, 2010

Basically I want to have a page do a search on first name(textbox), last name(textbox), gender(dropdown). and return a grid result back. it's so easy in web forms. how do i do in mvc? So far I have: Controller

[Code]....

View: Search.aspx

[Code]....

I didn't modify the route. When I put in [URL], it says resource not found.

View 22 Replies

AJAX :: Sql Search With Weighted Result?

Aug 4, 2010

Does anyone know how to do this? My boss wants to have an indexed sql server return a set of hits based on their weight in the db.

View 1 Replies

C# - Sql Inline Query - Parameter Is Not Read When The Query Is Executed

Apr 23, 2010

I am having a problem with my sql query in c#, basically it's inline query with parameters, but when I run it it tells me that parameter 1 or parameter 2 is not there here is my query declared on top of the page as public:

public const string InsertStmtUsersTable = "insert into Users (username, password, email, userTypeID, memberID, CM7Register) " +
"Values(@username, @password, @email, @userTypeID, @memberID,@CM7Register ); select @@identity";

this is my code for assigning the parameters, I know I am having problem so I am assigning the params twice:

Username =(cmd.Parameters["@username"].Value = row["username"].ToString()) as string;
cmd.Parameters["@username"].Value = row["username"].ToString();

In 1 methopd it calls this query and tries to insert to table, here is the code:

Result = Convert.ToInt32(SqlHelper.ExecuteScalar(con, CommandType.Text,InsertStmtUsersTable));

Exact error message is: Must declare the variable '@username'. Could this code be a problem, because all the previous coding is declared with in this using statement, except declaration of query, here the using statement: using (SqlCommand cmd = new SqlCommand(InsertStmtUsersTable, con))

View 1 Replies

Web Forms :: Creating Search Box With Dropdown Result

Oct 15, 2010

I have one left side panel which containg one search box and treeview, when user type any search text than i have to dropdown the list of matching item below textbox,according to search text user can able to find text on dropdown, when user select particular text and click on same on treeview that text would be automated selected and on right side panel data will pupulate automatically according to selected item.same like

[URL]

View 4 Replies

Display The Search Result In Aspx Page?

Dec 5, 2010

i am working with search page .. when i click the search button it will show some result like google.. when i click url it will show some personal information. But my problem is i will store data in line line by format. like our forms . but it will display only one single line as page width.. how can i store data in database like that and how can i get that data like to display what i am putting in textbox like this forms

View 3 Replies

Web Forms :: Create A Search Result Page Using C#?

Jan 25, 2010

I am new to visual studio .net c#. I was able to use Jdeveloper to create a search result page - search criteia on top with a "search" button, a result set table or form at the bottom of the page.

View 1 Replies

Grid Using Paging - Search And Scroll To Result

Jan 3, 2011

I have an ASP .NET web application. I'm fairly new to .Net but a longtime SQL and Java programmer. I have a requirement to implement a search feature as it is currently implemented in the legacy application. There is a pageable grid of data displayed and a search box. You type your search criteria and the grid pages to the first match. A "next match" button pages to the next item etc. This way the user sees where their search item falls in the hierarchy of the data. I have seen examples where the search criteria filters the data, limiting the data results.

View 1 Replies

C# - Storing Search Result For Paging And Sorting?

Feb 15, 2010

I've been implementing MS Search Server 2010 and so far its really good. Im doing the search queries via their web service, but due to the inconsistent results, im thinking about caching the result instead.

The site is a small intranet (500 employees), so it shouldnt be any problems, but im curious what approach you would take if it was a bigger site.

I've googled abit, but havent really come over anything specific. So, a few questions:

What other approaches are there? And why are they better?

How much does it cost to store a dataview of 400-500 rows? What sizes are feasible?

Other points you should take into consideration.

View 4 Replies

Parse Google Search Result Into Title?

Jan 1, 2010

how i can parse Google search result into title, desc and urls?

View 1 Replies

How To Bold Search Keyword In Description Of Result

Nov 13, 2010

i develope the search engine project

how to bold search key word in description of result

View 1 Replies

Jquery - SQL FullText Search And Highlight Result?

Mar 29, 2011

I have a table in SQL Server with structure:

Students
(
StudentId bigint,
FullName nvarchar(100),
DegreeId smallint,
Articel nvarchar(max)
)

i have created a full text index and enabled it for "students" table.

in my asp.net page ,users type words and i call a stored proc filter students using these words.

Create Procedure GetStudents(@Article nvarchar(200)=typed words)
AS
BEGIN
SET NOCOUNT ON
SELECT StudentId,FullName,DegreeId,Article
FROM Students
WHERE WHERE FREETEXT(Article,'''+ @Article+''')
END

The search works fine ,now i need to highlight(yellow background)the "articles" of returned stuents in my asp.net page(by jquery,or asp.net).

View 3 Replies

Web Forms :: How To Show Search Result In A Gridview In A New Page

Jun 6, 2010

i have a requirement in which the user can search for other user he enters three char of the name clicks on the search button and a new window is opened and he can see all the search results in a gridview he can select one of them and this closes the new window and the details are populated on the previous page.

View 6 Replies







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