Click here to Skip to main content
15,881,139 members
Home / Discussions / C#
   

C#

 
GeneralRe: How to check for a driver in C#? Pin
Alan N26-Jun-12 6:44
Alan N26-Jun-12 6:44 
GeneralRe: How to check for a driver in C#? Pin
glennPattonWork326-Jun-12 22:21
professionalglennPattonWork326-Jun-12 22:21 
Questionkeycode Pin
a.fatemeh26-Jun-12 1:16
a.fatemeh26-Jun-12 1:16 
QuestionHow to retrieve a list of active computers in a LAN? Pin
asdf900925-Jun-12 23:47
asdf900925-Jun-12 23:47 
AnswerRe: How to retrieve a list of active computers in a LAN? Pin
Sandeep Mewara26-Jun-12 0:49
mveSandeep Mewara26-Jun-12 0:49 
QuestionSearch String for SQL Server Pin
FredS225-Jun-12 21:40
FredS225-Jun-12 21:40 
AnswerRe: Search String for SQL Server Pin
Dave Kreskowiak26-Jun-12 2:08
mveDave Kreskowiak26-Jun-12 2:08 
GeneralRe: Search String for SQL Server Pin
FredS226-Jun-12 3:49
FredS226-Jun-12 3:49 
At the moment I have the operator input a search string and pass it to a stored procedure in SQL server. The filtering is done with freetext.

select P.co_name
,P.add_city
,P.ProvinceCode
,case when Co.UseCodeAsName = 1
then Co.CountryCode
else Co.CountryName end as CountryName

,isnull(DATEDIFF(month, P.profile_date, getdate()), 999) as proMonths

,P.proServices
,P.proRegions
,P.p_key
,P.co_status as coStatus
,P.PostalCode

,case
when P.PostalCode is null
then null
else sqrt(square(sin((ZZ.LatitudeInRadians-@TestLatRadians)/2.0E)) +
(cos(@TestLatRadians) * cos(ZZ.LatitudeInRadians) * square(sin((ZZ.LongitudeInRadians-@TestLongRadians)/2.0E))) )
end
as dist_base

from dbo.SourcingPool as P
left outer join dbo.defProvince as Pr
on P.ProvinceCode = Pr.ProvinceCode
and P.CountryCode = Pr.CountryCode

left outer join dbo.defCountry as Co
on P.CountryCode = Co.CountryCode

left outer join dbo.defPostalCodes as ZZ
on ZZ.PostalCode = P.PostalCode

where (freetext(P.*, @SearchString) or CHARINDEX(@SearchString, P.proServices) > 0)
AnswerRe: Search String for SQL Server Pin
Abhinav S26-Jun-12 2:34
Abhinav S26-Jun-12 2:34 
QuestionNeed a multilingual virtual keyboard. Simulating key action using virtual key codes. Unable to generate accented charcacters Pin
revengeoffallen25-Jun-12 19:12
revengeoffallen25-Jun-12 19:12 
AnswerRe: Need a multilingual virtual keyboard. Simulating key action using virtual key codes. Unable to generate accented charcacters Pin
Richard MacCutchan25-Jun-12 22:09
mveRichard MacCutchan25-Jun-12 22:09 
GeneralRe: Need a multilingual virtual keyboard. Simulating key action using virtual key codes. Unable to generate accented charcacters Pin
revengeoffallen26-Jun-12 1:53
revengeoffallen26-Jun-12 1:53 
GeneralRe: Need a multilingual virtual keyboard. Simulating key action using virtual key codes. Unable to generate accented charcacters Pin
Richard MacCutchan26-Jun-12 2:02
mveRichard MacCutchan26-Jun-12 2:02 
Questionxaml parser exception Pin
Mydsh25-Jun-12 18:28
Mydsh25-Jun-12 18:28 
AnswerRe: xaml parser exception Pin
Dave Kreskowiak26-Jun-12 2:00
mveDave Kreskowiak26-Jun-12 2:00 
Questionarabic to roman numerals Pin
Salomon Velazquez25-Jun-12 12:38
Salomon Velazquez25-Jun-12 12:38 
AnswerRe: arabic to roman numerals Pin
PIEBALDconsult25-Jun-12 13:31
mvePIEBALDconsult25-Jun-12 13:31 
GeneralRe: arabic to roman numerals Pin
Salomon Velazquez25-Jun-12 13:51
Salomon Velazquez25-Jun-12 13:51 
GeneralRe: arabic to roman numerals Pin
PIEBALDconsult25-Jun-12 17:04
mvePIEBALDconsult25-Jun-12 17:04 
QuestionHow To Convert This From VB.Net Pin
Kevin Marois25-Jun-12 8:26
professionalKevin Marois25-Jun-12 8:26 
AnswerRe: How To Convert This From VB.Net Pin
Richard MacCutchan25-Jun-12 8:36
mveRichard MacCutchan25-Jun-12 8:36 
GeneralRe: How To Convert This From VB.Net Pin
Kevin Marois25-Jun-12 8:38
professionalKevin Marois25-Jun-12 8:38 
AnswerRe: How To Convert This From VB.Net Pin
OriginalGriff25-Jun-12 8:43
mveOriginalGriff25-Jun-12 8:43 
GeneralRe: How To Convert This From VB.Net Pin
Kevin Marois25-Jun-12 10:12
professionalKevin Marois25-Jun-12 10:12 
AnswerRe: How To Convert This From VB.Net Pin
Karthik Harve25-Jun-12 21:46
professionalKarthik Harve25-Jun-12 21:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.