Click here to Skip to main content
15,887,776 members
Home / Discussions / C#
   

C#

 
QuestionDatagridview [modified] Pin
mjelten22-Jun-09 23:55
mjelten22-Jun-09 23:55 
QuestionA better way Pin
Sevententh22-Jun-09 23:44
Sevententh22-Jun-09 23:44 
AnswerRe: A better way Pin
Christian Graus23-Jun-09 1:00
protectorChristian Graus23-Jun-09 1:00 
AnswerRe: A better way Pin
dan!sh 23-Jun-09 1:02
professional dan!sh 23-Jun-09 1:02 
AnswerRe: A better way Pin
kb-boxer23-Jun-09 2:04
kb-boxer23-Jun-09 2:04 
GeneralRe: A better way Pin
Sevententh23-Jun-09 3:57
Sevententh23-Jun-09 3:57 
GeneralRe: A better way Pin
S. Senthil Kumar23-Jun-09 6:26
S. Senthil Kumar23-Jun-09 6:26 
GeneralRe: A better way Pin
Sevententh6-Oct-09 0:02
Sevententh6-Oct-09 0:02 
I found that rewriting the SQL as a stored procedure was easier to get the hierarchy that I needed
CREATE PROC sp_Hierarchy
(@ParentID int)
AS
BEGIN
WITH _items(ID, ParentID, TypeID, Depth)
AS (
SELECT ID, ParentID, TypeID, 0 AS Depth FROM tblItems WHERE ID = @ParentID
UNION ALL
SELECT t.ID, t.ParentID, t.TypeID, i.Depth + 1 FROM tblItems t JOIN _item i ON t.ParentID = i.ID
)
SELECT * FROM _item
END

Just incase somebody else needed to know Big Grin | :-D
QuestionHow to check whether PC is working with UPS power? Pin
sujithkumarsl22-Jun-09 23:37
sujithkumarsl22-Jun-09 23:37 
AnswerRe: How to check whether PC is working with UPS power? Pin
himanshu256122-Jun-09 23:52
himanshu256122-Jun-09 23:52 
QuestionSaving webservice dll Pin
rmedo22-Jun-09 22:58
rmedo22-Jun-09 22:58 
AnswerRe: Saving webservice dll Pin
DoctorMick23-Jun-09 4:55
DoctorMick23-Jun-09 4:55 
Questionactive directory authentication using C# Pin
rhcp0822-Jun-09 22:54
rhcp0822-Jun-09 22:54 
AnswerRe: active directory authentication using C# Pin
himanshu256122-Jun-09 23:00
himanshu256122-Jun-09 23:00 
GeneralRe: active directory authentication using C# Pin
rhcp0823-Jun-09 0:52
rhcp0823-Jun-09 0:52 
GeneralRe: active directory authentication using C# Pin
himanshu256123-Jun-09 1:06
himanshu256123-Jun-09 1:06 
GeneralRe: active directory authentication using C# Pin
rhcp0823-Jun-09 1:24
rhcp0823-Jun-09 1:24 
QuestionDate Time Conversion Pin
papy-boom22-Jun-09 22:45
papy-boom22-Jun-09 22:45 
AnswerRe: Date Time Conversion Pin
Christian Graus23-Jun-09 1:08
protectorChristian Graus23-Jun-09 1:08 
AnswerRe: Date Time Conversion Pin
PIEBALDconsult23-Jun-09 3:47
mvePIEBALDconsult23-Jun-09 3:47 
Question[SOLVED] Process ID Pin
CodingLover22-Jun-09 22:36
CodingLover22-Jun-09 22:36 
AnswerRe: Process ID Pin
CodingLover22-Jun-09 22:51
CodingLover22-Jun-09 22:51 
QuestionClosing Child Form using {Escap-Key} Pin
M Riaz Bashir22-Jun-09 22:31
M Riaz Bashir22-Jun-09 22:31 
AnswerRe: Closing Child Form using {Escap-Key} Pin
stancrm22-Jun-09 22:32
stancrm22-Jun-09 22:32 
GeneralRe: Closing Child Form using {Escap-Key} Pin
M Riaz Bashir22-Jun-09 22:55
M Riaz Bashir22-Jun-09 22:55 

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.