Click here to Skip to main content
15,889,795 members
Home / Discussions / C#
   

C#

 
QuestionRegistering COM+ Assembly Error Pin
Member 813710526-Jun-12 9:37
Member 813710526-Jun-12 9:37 
AnswerRe: Registering COM+ Assembly Error Pin
Richard Andrew x6426-Jun-12 11:48
professionalRichard Andrew x6426-Jun-12 11:48 
GeneralRe: Registering COM+ Assembly Error Pin
Member 81371056-Jul-12 5:16
Member 81371056-Jul-12 5:16 
AnswerRe: Registering COM+ Assembly Error Pin
Member 813710513-Jul-12 3:47
Member 813710513-Jul-12 3:47 
GeneralSql Update Pin
Member 771897926-Jun-12 8:53
Member 771897926-Jun-12 8:53 
GeneralRe: Sql Update Pin
PIEBALDconsult26-Jun-12 9:25
mvePIEBALDconsult26-Jun-12 9:25 
QuestionHow to check for a driver in C#? Pin
glennPattonWork326-Jun-12 3:47
professionalglennPattonWork326-Jun-12 3:47 
AnswerRe: How to check for a driver in C#? Pin
Alan N26-Jun-12 5:49
Alan N26-Jun-12 5:49 
GeneralRe: How to check for a driver in C#? Pin
glennPattonWork326-Jun-12 5:58
professionalglennPattonWork326-Jun-12 5:58 
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 

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.