.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Geometry Search Question

Posted By:      Posted Date: August 29, 2010    Points: 0   Category :Sql Server
 
Hello Group, I am have a column of gemetry type in my sql server 2008 database.  I stored POINT data there IE( POINT(23.989899, 21.090909).  I have a parameter page in which I allow users to put a range on the latitude and longitude. My question is, how can I use those parameters in a where clause to limits the records that come back based upon what the user enters? I have seen examples for most geometric data types but nothing for POINTs.  For example, if the user enters in a latitude of greater than 10.010101 and a longitude of 45.999999, I want to return all the records containing lats > 10.010101 and longs greater 45.999999..... I have tried several solutions with nothing working so far... Any ideas? thanks.  


View Complete Post


More Related Resource Links

Text Search Strategy Question for the SSIS Gurus...

  
BACKGROUND: As I have mentioned in some of my other posts I am using SSIS 2005 to replace an existing MS Access 2003 / VBA based ETL engine which I developed some years back.   Part of my existing Access-based ETL performs a text search of the source records and I am now attempting to replicate that functionality in SSIS (replicate in terms of the end-result and not necessarily the methods used to get to that end result).  I have an idea of how I plan to go about this but since am relatively new to SSIS so would greatly appreciate the feedback of those more experienced... DETAILED DESCRIPTION: In the source (Sybase ASE15) database, there is an "object" table (not the actual table name but for illustrative purposes it will suffice).  Within the object table there is a "description" column which is a char(60) datatype.  The description column simply represents a description of the object as defined by the source system end-user. For my ETL solution I allow the ETL administrator to define one or many (1...n) key words or phrases which represent search criteria.  These search criteria are stored in a reference table in my target SQL Server 2005 database (the same database to which my ETL will transform results and store them).  My objective, is as follows:  For each of the 1...n search criteria defined, try and find th

Search field question

  
hi guysin my database i have one table that has basic patient information (id,name,dob etc, visit date etc)i would like for the user to be able to search for a patient based on his unique personal id number and return the fields i specify (name,lastname) in the gridview. my problem in that one patient may have multiple visit dates. i would like the gridview to return the following as an exampleName     Lastname   Visit dateJoe         Johnson      10/05/10Joe         Johnson      13/08/10joe         Johnson       20/09/10from that the user will be able to click on the visit date that he wants to see the details aboutmy problem in that since the user ID is a unique field in my table i dont know how to create multiple visit dates. i think i should put the visit date in a different table and create a relationship but then i dont know how to present details from 2 tables in one gridviewthank you

SharePoint 2007 Enterprise Search Scope Question

  

Hello,

I have configured different search scopes to point to different search contents on my MOSS server and had them displayed on cope dropdown menu.  Everything is working great but with one issue; the selected scope from the default Search page does not stick on the Result page.

For example, I have three scope choices available on my scope dropdown menu: scope1, scope2, and scope3.  For this particular scope Display Group, I have selected "scope1" to be the default.  So when I go to the main Search page, "scope1" is shown as the default choice on the scope dropdown menu.  If I select another scope from the dropdown menu (e.g., scope2) and perform a search, it takes me to the Result page showing the result of the search and also shows what I typed in in the search text box.  The problem is that although I selected "scope2" on the original page's dropdown menu, the result page's dropdown menu shows "scope1" which is the default choice and not what I selected on the original page.  This behavior is confusing to my end users who want to refine their search from the Result page but then they have to re-select "scope2" from the dropdown menu.

My question is, is there a way for me to make the selected scope choice from the original page to stick on the Result page's s

SharePoint 2007 Enterprise Search Scope Question

  

Hello,

I have configured different search scopes to point to different search contents on my MOSS server and had them displayed on cope dropdown menu.  Everything is working great but with one issue; the selected scope from the default Search page does not stick on the Result page.

For example, I have three scope choices available on my scope dropdown menu: scope1, scope2, and scope3.  For this particular scope Display Group, I have selected "scope1" to be the default.  So when I go to the main Search page, "scope1" is shown as the default choice on the scope dropdown menu.  If I select another scope from the dropdown menu (e.g., scope2) and perform a search, it takes me to the Result page showing the result of the search and also shows what I typed in in the search text box.  The problem is that although I selected "scope2" on the original page's dropdown menu, the result page's dropdown menu shows "scope1" which is the default choice and not what I selected on the original page.  This behavior is confusing to my end users who want to refine their search from the Result page but then they have to re-select "scope2" from the dropdown menu.

My question is, is there a way for me to make the selected scope choice from the original page to stick on the Result page's s

Question regarding result types in Sharepoint Enterprise Search

  

I'm trying to setup search scopes for content sources that are various shares on file servers in our domain, and the main things users will be searching for are autocad drawings and folders - searching by file/folder name. I've added the dwg file type to the list of file types included in the content index (we'll see if they show up in search results after the next incremental crawl), but I don't know how to add folders as a result type. Ideally, a user will be able to check off a box for Drawing/Folder/Word Doc/Spreadsheet/etc. right next to the text box where they enter the search term(s).

Any ideas?


use question mark in search representing exactly one character - possible?

  

Hi,

Is there way to use the question mark ? in MS SQL Search Expression? Like so:

SELECT [Name] FROM [dbo].[Users] WHERE [Name] = "M?yers"

The ? stands for exactly 1 character. I tried LIKE

SELECT [Name] FROM [dbo].[Users] WHERE [Name] LIKE "M%yers"

but the % represents 0 or more characters!

Thanx for help,

S.


Sharepoint 2010 Foundation search question

  

I'm new to Sharepoint and have just setup 2010 Foundation.  I know that it's search will only index the contents of Office docs and that you can't install ifilters in Foundation.  However, I would think that all documents uploaded to a doc library should be searchable by file name, is that correct?  However, using pdf's has an example, in my testing, search results come up empty when searching for keywords in the filename.  In order to make these files searchable, I have to edit their properties and add a Title.

I know that not all users will bother to manually add a Title to all documents, so we need to be able to find files by their names, how is this possible?

Rich


MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

SharePoint Gets Search Analytics

  
Microsoft's SharePoint Portal Server 2003 was sold into a large number of organizations based solely on the strength of the search tool. Organizations hungered for a way to find the data they had generated.

Using SharePoint Search feature in ASP.Net Application

  
Integrating ASP.Net application in to MOSS 2007 to utilize SharePoint Enterprise Search Feature can be done by using Business Data Search.

Get more then google search from here

  
Just make it home page and enjoy more then google search you not only get google result and prizes for searching but also free ebooks and link from here like orkut,facebook,twitter,yahoomail etc...

Thanks

Adding Search Refinements in SharePoint 2010

  
I have been playing around with SharePoint 2010 Search this morning. I love the new UI. The search refinements panel is just begging to be messed with. In my case I wanted to add the file extension JPG as an Image Type refiner.

WPF Geometry Transformation Tool

  
The geometry transformer is a simple tool I wrote to scale-, translate- and rotate-transform a geometry in the path mini language.

Search Engines and Multilanguage Websites - using .resx

  

I have a website (asp.net 3.5+c# +linq ) having thopition to change languages (2) by the user, Am using the search engine like in the example of:

http://www.codeproject.com/KB/applications/SearchDotnet.aspx

this search will find any searched word in all the pages and return the link in the default language of the site, but problem for the second language , because by default the site language is English and the user have the option to change to other language.

and as I understood that the .resx files can not be searched like the aspx by the search engines.



I looked in many blogs and discussion boards for similar  case but unfortunately no clues on this issue .
The only same case posted :

http://forums.asp.net/p/1523698/3669127.aspx#3669127

and also I could not find any clue to move on, 

 Kindly requsted to guide me for the soultio

Thanks for your time and wish you all the best
your help is always appreciated

Mohamad


Some basic MVC question

  
  1. In regular asp net I can run (debug) the application but I can either "view in browser" that gives me the option to view the application and write code on same time.

In MVC I can't find this option.

  1. What is the basic DATA MODEL for working with SQL DB.

I mean with no any framework (entity framework, Sub sonic, Link to SQL etc')

I look for basic application that works with data but with no fw.

  1. What is the popular DB framework that working with data.
  2.  I am looking on  mvc series

Like

C# Soup To Nuts  (the best series ever)

http://blogs.msdn.com/b/wsteele/archive/2007/01/29/c-soup-to-nuts-webcast-links.aspx

I watch some of the MVC video, seems that the music store is good but I have to wait to the other part.

Does any one know and recommend   a Microsoft MVC tutorial?

https://msevents.microsoft.com/CUI/AdvancedSearch.aspx?culture=en-US#advsearchloaded

 

Thanks!

 


how to make a dropdownlist looks like google search box

  

dear all...

any idea how to do that ?


Thnx in advance


Web Site to Web Application Question

  

I've been building web sites and for my next project I will be creating a web application.  I use a 'BasePage' class in all my projects but, since web applications do not contain the 'App_Code' folder, what is the best place/practice for the 'BasePage' class?

Thanks,

TML


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend