Click here to Skip to main content
15,902,447 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: DrawItem for flagged listbox item? Pin
Sonhospa12-Jul-09 7:25
Sonhospa12-Jul-09 7:25 
QuestionRead selected Excel data into DataGridView using VB.NET2008 Pin
drexler_kk11-Jul-09 21:58
drexler_kk11-Jul-09 21:58 
AnswerRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
dan!sh 11-Jul-09 22:34
professional dan!sh 11-Jul-09 22:34 
QuestionRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
drexler_kk11-Jul-09 22:51
drexler_kk11-Jul-09 22:51 
AnswerRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
dan!sh 11-Jul-09 23:47
professional dan!sh 11-Jul-09 23:47 
AnswerRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
helelark12311-Jul-09 23:52
helelark12311-Jul-09 23:52 
QuestionRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
drexler_kk12-Jul-09 0:17
drexler_kk12-Jul-09 0:17 
AnswerRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
Paramu197312-Jul-09 0:29
Paramu197312-Jul-09 0:29 
Iam using like the following Thumbs Up | :thumbsup:

ExcelFile="C:\temp\My_test.xls"

Dim strConn As String = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" & ExcelFile & "; Extended Properties=""Excel 8.0; HDR=Yes; IMEX=1"""

Dim excelsheet As String = "[Sheet1$]"
Dim sql As String = "SELECT * FROM " & excelsheet

Try
Using cn As New OleDb.OleDbConnection
cn.ConnectionString = strConn
Dim da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(sql, cn)
cn.Open()
da.Fill(items)
cn.Close()
End Using

Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
QuestionRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
drexler_kk12-Jul-09 0:38
drexler_kk12-Jul-09 0:38 
AnswerRe: Read selected Excel data into DataGridView using VB.NET2008 [modified] Pin
helelark12312-Jul-09 0:49
helelark12312-Jul-09 0:49 
QuestionRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
drexler_kk12-Jul-09 0:54
drexler_kk12-Jul-09 0:54 
AnswerRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
helelark12312-Jul-09 0:56
helelark12312-Jul-09 0:56 
QuestionRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
drexler_kk12-Jul-09 1:21
drexler_kk12-Jul-09 1:21 
AnswerRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
helelark12312-Jul-09 1:24
helelark12312-Jul-09 1:24 
QuestionRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
drexler_kk12-Jul-09 1:42
drexler_kk12-Jul-09 1:42 
AnswerRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
helelark12312-Jul-09 1:45
helelark12312-Jul-09 1:45 
GeneralRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
drexler_kk12-Jul-09 2:00
drexler_kk12-Jul-09 2:00 
GeneralRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
helelark12312-Jul-09 2:10
helelark12312-Jul-09 2:10 
QuestionRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
drexler_kk12-Jul-09 2:15
drexler_kk12-Jul-09 2:15 
AnswerRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
helelark12312-Jul-09 2:17
helelark12312-Jul-09 2:17 
AnswerRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
drexler_kk12-Jul-09 2:25
drexler_kk12-Jul-09 2:25 
GeneralRe: Read selected Excel data into DataGridView using VB.NET2008 Pin
helelark12312-Jul-09 2:28
helelark12312-Jul-09 2:28 
QuestionNetwork Messages? Pin
Paramu197311-Jul-09 21:34
Paramu197311-Jul-09 21:34 
AnswerRe: Network Messages? Pin
Dave Kreskowiak13-Jul-09 3:57
mveDave Kreskowiak13-Jul-09 3:57 
QuestionClass Library question Pin
kmas375211-Jul-09 21:00
kmas375211-Jul-09 21:00 

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.