Click here to Skip to main content
15,919,567 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Email body format Pin
Dave Kreskowiak12-Sep-04 3:48
mveDave Kreskowiak12-Sep-04 3:48 
GeneralRe: Email body format Pin
Anonymous16-Oct-04 11:10
Anonymous16-Oct-04 11:10 
GeneralRecord sound to a WAV file, Using VB6 Pin
scag10-Sep-04 16:30
scag10-Sep-04 16:30 
Generalenabling/disabling internet access Pin
Asim N.10-Sep-04 9:31
Asim N.10-Sep-04 9:31 
GeneralRe: enabling/disabling internet access Pin
Dave Kreskowiak10-Sep-04 10:09
mveDave Kreskowiak10-Sep-04 10:09 
GeneralRe: enabling/disabling internet access Pin
Mekong River11-Sep-04 5:16
Mekong River11-Sep-04 5:16 
GeneralDataGrid in .Net Pin
Britnt710-Sep-04 9:20
Britnt710-Sep-04 9:20 
GeneralRe: DataGrid in .Net Pin
HarryBo11-Sep-04 2:14
HarryBo11-Sep-04 2:14 
Dim oConn As New OleDbConnection
Dim oCmd As New OleDbCommand
Some thing like this:

Dim oDS As New DataSet
Dim oDSNew As New DataSet
Dim oDA As New OleDbDataAdapter(oCmd)
Dim oCol As New DataColumn
Dim oCol2 As New DataColumn
Dim oCol3 As New DataColumn
Dim oRows As DataRow
Dim oTable As New DataTable
oConn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=HealthandSafety;Data Source=."
oConn.Open()
oCmd.CommandType = CommandType.Text
oCmd.Connection = oConn
oCmd.CommandText = "SELECT * FROM HSDocumentFloorZone"

oDA.Fill(oDS)

With oDS.Tables(0)
oCol = .Columns(1)
oCol2 = .Columns(3)
oCol3 = .Columns(5)
End With

oDS.Tables(0).Columns.Clear()

oDS.Clear()

oDS.Dispose()

With oTable
.Columns.Add(oCol)
.Columns.Add(oCol2)
.Columns.Add(oCol3)
End With

oDSNew.Tables.Add(oTable)

With DataGrid1
.DataSource = oDSNew
End With



Many Thanks

Harry
GeneralRe: DataGrid in .Net Pin
Nick Seng12-Sep-04 15:14
Nick Seng12-Sep-04 15:14 
GeneralRe: DataGrid in .Net Pin
Britnt713-Sep-04 2:27
Britnt713-Sep-04 2:27 
GeneralRe: DataGrid in .Net Pin
Nick Seng13-Sep-04 3:25
Nick Seng13-Sep-04 3:25 
GeneralRe: DataGrid in .Net Pin
Britnt713-Sep-04 3:37
Britnt713-Sep-04 3:37 
GeneralRe: DataGrid in .Net Pin
Nick Seng13-Sep-04 4:00
Nick Seng13-Sep-04 4:00 
GeneralRe: DataGrid in .Net Pin
Britnt713-Sep-04 4:13
Britnt713-Sep-04 4:13 
GeneralRe: DataGrid in .Net Pin
Nick Seng13-Sep-04 4:20
Nick Seng13-Sep-04 4:20 
GeneralRe: DataGrid in .Net Pin
Britnt713-Sep-04 5:19
Britnt713-Sep-04 5:19 
GeneralRe: DataGrid in .Net Pin
Nick Seng13-Sep-04 14:04
Nick Seng13-Sep-04 14:04 
General.Net ToolTip properties Pin
mryan999910-Sep-04 8:43
mryan999910-Sep-04 8:43 
GeneralRe: .Net ToolTip properties Pin
Dave Kreskowiak10-Sep-04 10:04
mveDave Kreskowiak10-Sep-04 10:04 
GeneralRe: .Net ToolTip properties Pin
mryan999916-Sep-04 12:19
mryan999916-Sep-04 12:19 
Generalvb and ms soap Pin
necroleak9-Sep-04 21:58
sussnecroleak9-Sep-04 21:58 
GeneralRe: vb and ms soap Pin
Purple Monk9-Sep-04 23:42
Purple Monk9-Sep-04 23:42 
GeneralRe: vb and ms soap Pin
necroleak10-Sep-04 0:41
sussnecroleak10-Sep-04 0:41 
GeneralRe: vb and ms soap Pin
Purple Monk10-Sep-04 4:33
Purple Monk10-Sep-04 4:33 
GeneralA little problem in ActiveX control programming Pin
gamerPotatoe9-Sep-04 21:15
gamerPotatoe9-Sep-04 21:15 

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.