Click here to Skip to main content
15,908,906 members

Comments by william_nhl (Top 8 by date)

william_nhl 28-Jun-11 12:35pm View    
What i want is to let the source code above to run to calculate each data grid view row column 1 data and show it on that row column 2 if the column 1 have data. The below is the source code that will show the distinct data in data grid view column 1.
Dim n As Integer = 0
row = 0
dgv.Rows.Clear()
datagridview1.Rows.Clear()
connection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\AnalyzerDb.mdb")
connection.Open()
cmd = New OleDbCommand("SELECT DISTINCT (Protocol) FROM Raw_Protocol", connection)
Dr = cmd.ExecuteReader
Do
While Dr.Read()
dgv.Rows.Add(Dr("Protocol"))
datagridview1.Rows.Add(Dr("Protocol"))
n += 1
End While
Loop While Dr.NextResult
Dr.Close()
connection.Close()
william_nhl 28-Jun-11 12:27pm View    
Ok,thanks for advice.^^
william_nhl 28-Jun-11 12:25pm View    
ok, but how can i modify the loading csv source code above to made it auto load all the csv file in the folder into the dgv? Can it be done?
william_nhl 28-Jun-11 11:57am View    
I need it in vb.
william_nhl 28-Jun-11 11:07am View    
Ok,after i discussed with my lecturer she juz ask me assume that all the connected computer are allowed the system to copy file, so is tat possible to do the system i mention above which will detect all computer in the same network and retrieve file from those computer? The system must be able to detect all computer connected even if got new computer connected. If it can done, can giv me some idea and source code how it can be done?