Click here to Skip to main content
15,907,329 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralWireless Card and AP Pin
Member 204556016-Jun-05 0:22
Member 204556016-Jun-05 0:22 
GeneralRe: Wireless Card and AP Pin
Dave Kreskowiak16-Jun-05 4:06
mveDave Kreskowiak16-Jun-05 4:06 
Generaltrying to catch messages in VB6 Pin
15-Jun-05 23:00
suss15-Jun-05 23:00 
GeneralRe: trying to catch messages in VB6 Pin
Dave Kreskowiak16-Jun-05 4:03
mveDave Kreskowiak16-Jun-05 4:03 
GeneralVS 2005 Beta Pin
broadbent15-Jun-05 22:22
broadbent15-Jun-05 22:22 
GeneralRe: VS 2005 Beta Pin
Jim Matthews16-Jun-05 2:54
Jim Matthews16-Jun-05 2:54 
GeneralNeed help Pin
Nguyen Dinh Quy15-Jun-05 21:41
Nguyen Dinh Quy15-Jun-05 21:41 
GeneralRe: Need help Pin
lata07mahi16-Jun-05 0:49
lata07mahi16-Jun-05 0:49 
You can extract the values from the excel file using following code:

Private ds As DataSet
Private myCommand As OleDbDataAdapter
Private myConnection As OleDbConnection

Private Sub FillDataSet()
myConnection = New OleDbConnection( _
"provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source=E:\EmbedBday\Bday.xls; " & _
"Extended Properties=Excel 8.0;")
If Not myConnection Is Nothing Then
myCommand = New OleDbDataAdapter( _
"select * from [sheet1$A1:A35]", myConnection)

If Not myCommand Is Nothing Then
ds = New DataSet

myCommand.Fill(ds)

myConnection.Close()
End If
End If

DataGrid1.DataSource = ds
End Sub

where "Extended Properties" refers to the MSExcel version on your system which is Excel 8.0 for version higher than Excel 97(inclusive).



Lata Agrawal
GeneralHELP!! updating datagrid Pin
15-Jun-05 20:47
suss15-Jun-05 20:47 
Generalftp Pin
ADY00715-Jun-05 11:02
ADY00715-Jun-05 11:02 
GeneralRe: ftp Pin
Dave Kreskowiak15-Jun-05 11:51
mveDave Kreskowiak15-Jun-05 11:51 
GeneralFTP Pin
ADY00715-Jun-05 22:20
ADY00715-Jun-05 22:20 
GeneralRe: FTP Pin
J4amieC15-Jun-05 22:59
J4amieC15-Jun-05 22:59 
GeneralFTP Pin
ADY00715-Jun-05 23:03
ADY00715-Jun-05 23:03 
GeneralRe: FTP Pin
Dave Kreskowiak16-Jun-05 3:56
mveDave Kreskowiak16-Jun-05 3:56 
GeneralRe: FTP Pin
ADY00716-Jun-05 5:55
ADY00716-Jun-05 5:55 
GeneralRe: FTP Pin
Dave Kreskowiak16-Jun-05 7:36
mveDave Kreskowiak16-Jun-05 7:36 
GeneralFTP Pin
ADY00717-Jun-05 3:54
ADY00717-Jun-05 3:54 
GeneralRe: FTP Pin
Dave Kreskowiak17-Jun-05 4:30
mveDave Kreskowiak17-Jun-05 4:30 
GeneralA great group for anyone watning to learn VB.Net Pin
mark0197015-Jun-05 10:26
mark0197015-Jun-05 10:26 
GeneralRe: A great group for anyone watning to learn VB.Net Pin
toxcct16-Jun-05 0:33
toxcct16-Jun-05 0:33 
GeneralTimer Pin
ADY00715-Jun-05 8:25
ADY00715-Jun-05 8:25 
GeneralRe: Timer Pin
Dave Kreskowiak15-Jun-05 8:29
mveDave Kreskowiak15-Jun-05 8:29 
GeneralRe: Timer Pin
ADY00715-Jun-05 8:34
ADY00715-Jun-05 8:34 
GeneralRe: Timer Pin
Mitch F.15-Jun-05 8:44
Mitch F.15-Jun-05 8:44 

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.