Click here to Skip to main content
15,903,175 members
Home / Discussions / C#
   

C#

 
GeneralRe: Implementation of Generic Method in List Pin
ezazazel26-Jun-12 19:52
ezazazel26-Jun-12 19:52 
GeneralRe: Implementation of Generic Method in List Pin
Trak4Net26-Jun-12 20:31
Trak4Net26-Jun-12 20:31 
AnswerRe: Implementation of Generic Method in List Pin
DaveyM6926-Jun-12 20:08
professionalDaveyM6926-Jun-12 20:08 
GeneralRe: Implementation of Generic Method in List Pin
Trak4Net26-Jun-12 20:40
Trak4Net26-Jun-12 20:40 
GeneralRe: Implementation of Generic Method in List Pin
DaveyM6927-Jun-12 4:54
professionalDaveyM6927-Jun-12 4:54 
AnswerRe: Implementation of Generic Method in List Pin
Trak4Net26-Jun-12 21:03
Trak4Net26-Jun-12 21:03 
AnswerRe: Implementation of Generic Method in List Pin
Trak4Net27-Jun-12 1:44
Trak4Net27-Jun-12 1:44 
GeneralRe: Implementation of Generic Method in List Pin
ezazazel28-Jun-12 8:11
ezazazel28-Jun-12 8:11 
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)

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.