Click here to Skip to main content
15,913,836 members
Home / Discussions / C#
   

C#

 
QuestionParse from string Pin
Member 1546737514-Dec-21 4:00
Member 1546737514-Dec-21 4:00 
AnswerRe: Parse from string Pin
Pete O'Hanlon14-Dec-21 5:21
mvePete O'Hanlon14-Dec-21 5:21 
GeneralRe: Parse from string Pin
jsc4214-Dec-21 6:55
professionaljsc4214-Dec-21 6:55 
AnswerRe: Parse from string Pin
#realJSOP15-Dec-21 0:35
professional#realJSOP15-Dec-21 0:35 
GeneralRe: Parse from string Pin
jsc4215-Dec-21 0:49
professionaljsc4215-Dec-21 0:49 
GeneralRe: Parse from string Pin
#realJSOP15-Dec-21 6:54
professional#realJSOP15-Dec-21 6:54 
Questionc# Search in root/subtree active directory users Pin
jwradhe9-Dec-21 2:10
jwradhe9-Dec-21 2:10 
AnswerRe: c# Search in root/subtree active directory users Pin
Richard Andrew x6411-Dec-21 9:16
professionalRichard Andrew x6411-Dec-21 9:16 
QuestionAccess Exif Metadata Pin
Dave Dec20216-Dec-21 10:05
Dave Dec20216-Dec-21 10:05 
AnswerRe: Access Exif Metadata Pin
OriginalGriff6-Dec-21 10:19
mveOriginalGriff6-Dec-21 10:19 
GeneralRe: Access Exif Metadata Pin
Dave Dec20216-Dec-21 13:09
Dave Dec20216-Dec-21 13:09 
GeneralRe: Access Exif Metadata Pin
Luc Pattyn6-Dec-21 16:39
sitebuilderLuc Pattyn6-Dec-21 16:39 
GeneralRe: Access Exif Metadata Pin
Dave Dec20216-Dec-21 21:24
Dave Dec20216-Dec-21 21:24 
GeneralRe: Access Exif Metadata Pin
Dave Dec20217-Dec-21 17:02
Dave Dec20217-Dec-21 17:02 
GeneralRe: Access Exif Metadata Pin
Luc Pattyn7-Dec-21 17:20
sitebuilderLuc Pattyn7-Dec-21 17:20 
GeneralRe: Access Exif Metadata Pin
Dave Dec20217-Dec-21 20:51
Dave Dec20217-Dec-21 20:51 
GeneralRe: Access Exif Metadata Pin
Richard MacCutchan7-Dec-21 22:13
mveRichard MacCutchan7-Dec-21 22:13 
GeneralRe: Access Exif Metadata Pin
Richard Deeming7-Dec-21 22:17
mveRichard Deeming7-Dec-21 22:17 
QuestionCreated Access DB, now how to load a list into a single column in the newly created DB. Pin
Richard A Knox4-Dec-21 6:18
Richard A Knox4-Dec-21 6:18 
AnswerRe: Created Access DB, now how to load a list into a single column in the newly created DB. Pin
OriginalGriff4-Dec-21 6:48
mveOriginalGriff4-Dec-21 6:48 
GeneralRe: Created Access DB, now how to load a list into a single column in the newly created DB. Pin
jsc426-Dec-21 2:58
professionaljsc426-Dec-21 2:58 
I agree with @OriginalGriff but over 20 years ago I had a requirement to do what you wanted (I forget the details now), probably for a report or some such. The code that I used was ...
(This code was run in-stream as a column inside the query in MS-Access, not as 'external' C# accessing an Ms-Access table)
VBScript
Function MakeList( _
    ByVal InSQL As String, _
    Optional ByVal InColName = 0, _
    Optional ByVal InSeparator As String = ",", _
    Optional ByVal InDataBase = "" _
    ) As String
    ' Convert a column from a table into a list
    '
    ' Parameters
    '   InSQL       SQL query
    '   InColName   Optional. Column containing data to be converted to a list
    '               (either by column number or by name)
    '   InSeparator Optional. Text to separate list items
    '   InDataBase  Optional. Database to find. Can be name (string) or
    '               database object. Current DB assumed if not specified
    '
    ' Result
    '   List of data
 
    Dim DB As Database
    Dim rs ' As Recordset
    
    ' Open the recordset
    If IsObject(InDataBase) Then
        Set DB = InDataBase
    Else
        Set DB = IIf(InDataBase = "", CurrentDb, OpenDatabase(InDataBase))
    End If
    
    Set rs = DB.OpenRecordset(InSQL)
    ' rs.MoveFirst
    While Not rs.EOF
        MakeList = MakeList & InSeparator & rs(InColName)
        rs.MoveNext
    Wend
    
    ' Get the data
    rs.Close
    DB.Close
    
    MakeList = Mid(MakeList, Len(InSeparator) + 1)  ' Drop first ','
End Function    ' MakeList

QuestionPass field Pin
Luis M. Rojas3-Dec-21 2:25
Luis M. Rojas3-Dec-21 2:25 
AnswerRe: Pass field Pin
Richard Deeming3-Dec-21 2:56
mveRichard Deeming3-Dec-21 2:56 
Questionthread safety and performance Pin
Super Lloyd2-Dec-21 15:31
Super Lloyd2-Dec-21 15:31 
GeneralRe: thread safety and performance Pin
harold aptroot2-Dec-21 16:03
harold aptroot2-Dec-21 16:03 

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.