Click here to Skip to main content
15,888,984 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionRe: date/time Pin
Sonia Gupta17-May-07 19:01
Sonia Gupta17-May-07 19:01 
AnswerRe: date/time Pin
Christian Graus17-May-07 21:12
protectorChristian Graus17-May-07 21:12 
GeneralRe: date/time [modified] Pin
Sonia Gupta17-May-07 21:17
Sonia Gupta17-May-07 21:17 
GeneralRe: date/time Pin
Dave Kreskowiak18-May-07 3:20
mveDave Kreskowiak18-May-07 3:20 
Questiongeeting the selected items from a checked list box Pin
Rajiya17-May-07 18:22
Rajiya17-May-07 18:22 
AnswerRe: geeting the selected items from a checked list box Pin
Sonia Gupta17-May-07 18:34
Sonia Gupta17-May-07 18:34 
AnswerRe: geeting the selected items from a checked list box Pin
Christian Graus17-May-07 18:35
protectorChristian Graus17-May-07 18:35 
QuestionHelp on Getting Excel Database as Dataset or Datable Pin
Kenneth Villasenor17-May-07 17:07
Kenneth Villasenor17-May-07 17:07 
i have a problem retrieving all available information in a specific column in Excel File. A Column in Excel has many cell data information that could reach a thousand characters if needed, so when i converted the said Excel File to a dataset most of the Column data information were omitted, i just assumed that a DataColumn has a specific Limit of character length allowed that's why this problem occur.

Below is the function i'm using:

Public Function GetExcelData(ByVal sFile As String, ByVal strSheetName As String) As Data.Dataset

Dim strCon As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & sFile & ";" & _
"Extended Properties=""Excel 8.0;HDR=YES;IMEX=1"""
Dim conexcel As OleDb.OleDbConnection
Dim cmdExcel As OleDb.OleDbCommand
Dim daExcel As OleDb.OleDbDataAdapter
Dim dsExcel As Data.DataSet


Try
conexcel = New OleDb.OleDbConnection(strCon)
conexcel.Open()
cmdExcel = New OleDb.OleDbCommand("Select PDFColorPages from [" & strSheetName & "$]", conexcel)
daExcel = New OleDb.OleDbDataAdapter(cmdExcel)
dsExcel = New Data.DataSet

daExcel.Fill(dsExcel)

Return dtTable
Catch ex As Exception
MsgBox(ex.ToString)
Finally
conexcel.Close()
conexcel.Dispose()
cmdExcel.Dispose()
daExcel.Dispose()
dtExcel.Dispose()
End Try
End Function
QuestionHow to Connect DVR Card with VB2005 Pin
somchoto17-May-07 16:02
somchoto17-May-07 16:02 
AnswerRe: How to Connect DVR Card with VB2005 Pin
Christian Graus17-May-07 16:03
protectorChristian Graus17-May-07 16:03 
GeneralRe: How to Connect DVR Card with VB2005 Pin
somchoto17-May-07 16:20
somchoto17-May-07 16:20 
GeneralRe: How to Connect DVR Card with VB2005 Pin
Christian Graus17-May-07 16:23
protectorChristian Graus17-May-07 16:23 
GeneralRe: How to Connect DVR Card with VB2005 Pin
somchoto17-May-07 16:30
somchoto17-May-07 16:30 
GeneralRe: How to Connect DVR Card with VB2005 Pin
somchoto17-May-07 16:40
somchoto17-May-07 16:40 
GeneralRe: How to Connect DVR Card with VB2005 Pin
Christian Graus17-May-07 18:11
protectorChristian Graus17-May-07 18:11 
QuestionGet Drive Pin
Socheat.Net17-May-07 15:33
Socheat.Net17-May-07 15:33 
AnswerRe: Get Drive Pin
Dave Kreskowiak17-May-07 15:41
mveDave Kreskowiak17-May-07 15:41 
GeneralRe: Get Drive Pin
Socheat.Net17-May-07 15:48
Socheat.Net17-May-07 15:48 
GeneralRe: Get Drive Pin
Dave Kreskowiak17-May-07 17:01
mveDave Kreskowiak17-May-07 17:01 
GeneralRe: Get Drive Pin
Socheat.Net17-May-07 17:06
Socheat.Net17-May-07 17:06 
AnswerRe: Get Drive Pin
Christian Graus17-May-07 16:02
protectorChristian Graus17-May-07 16:02 
GeneralRe: Get Drive Pin
Socheat.Net17-May-07 16:06
Socheat.Net17-May-07 16:06 
GeneralRe: Get Drive Pin
Christian Graus17-May-07 16:24
protectorChristian Graus17-May-07 16:24 
GeneralRe: Get Drive Pin
Socheat.Net17-May-07 16:44
Socheat.Net17-May-07 16:44 
GeneralRe: Get Drive Pin
Christian Graus17-May-07 18:12
protectorChristian Graus17-May-07 18:12 

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.