Click here to Skip to main content
16,005,389 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionEventHandler Pin
Socheat.Net7-Nov-06 14:49
Socheat.Net7-Nov-06 14:49 
AnswerRe: EventHandler Pin
mr_lasseter7-Nov-06 16:24
mr_lasseter7-Nov-06 16:24 
GeneralRe: EventHandler Pin
Socheat.Net11-Nov-06 15:18
Socheat.Net11-Nov-06 15:18 
GeneralRe: EventHandler Pin
mr_lasseter13-Nov-06 2:19
mr_lasseter13-Nov-06 2:19 
QuestionReading integers from a binary file Pin
Instamatix_Simon7-Nov-06 14:28
Instamatix_Simon7-Nov-06 14:28 
AnswerRe: Reading integers from a binary file Pin
Guffa7-Nov-06 14:59
Guffa7-Nov-06 14:59 
GeneralRe: Reading integers from a binary file Pin
Instamatix_Simon8-Nov-06 15:13
Instamatix_Simon8-Nov-06 15:13 
QuestionExcel to DatGrid Problem Pin
alexfromto7-Nov-06 11:32
alexfromto7-Nov-06 11:32 
Hi.
I have Excel file, which I'm trying to load into DataGrid. The problem I have is that in Excel file some columns have TEXT (like: OLYMPIA EXP) or NUMBER (like: 100084) as a value. Let's say columnt Vendor has the above values(OLYMPIA EXP and 100084).

My code doesn't throgh any errors but displays TEXT only missing NUMBER values. I cannot figure this one out.
HELP PLEASE.

Private Sub DB_Connect()<br />
        Try<br />
            DS = New System.Data.DataSet<br />
            MyAdpapter = New System.Data.OleDb.OleDbDataAdapter<br />
            MyConnection = New System.Data.OleDb.OleDbConnection( _<br />
             "provider=Microsoft.Jet.OLEDB.4.0; " & _<br />
             "data source=" & ExcelFilePath & "; " & _<br />
             "Extended Properties=Excel 8.0")<br />
<br />
            MyCmdSelect = New System.Data.OleDb.OleDbCommand("SELECT * FROM [Sheet1$]", MyConnection)<br />
            MyConnection.Open()<br />
            MyAdpapter.SelectCommand = MyCmdSelect<br />
            MyAdpapter.Fill(DS, "[Sheet1$]")<br />
<br />
            ' Dim DV As DataView = DS.Tables(0).DefaultView<br />
            'If Not sort = "" Then<br />
            'DV.Sort = sort & Session("ORDER").ToString()<br />
            'End If<br />
            DG.DataSource = DS.Tables(0).DefaultView<br />
            DG.DataBind()<br />
<br />
            btnImport.Visible = False<br />
            MyConnection.Close()<br />
<br />
        Catch ex As Exception<br />
            lblError.Text = ex.ToString()<br />
            lblError.Visible = True<br />
        End Try<br />
       <br />
    End Sub

AnswerRe: Excel to DatGrid Problem Pin
_mubashir7-Nov-06 22:13
_mubashir7-Nov-06 22:13 
GeneralRe: Excel to DatGrid Problem Pin
alexfromto8-Nov-06 3:06
alexfromto8-Nov-06 3:06 
QuestionHelp Convert C# Threading Code to Vb.net Pin
eatwork7-Nov-06 9:46
eatwork7-Nov-06 9:46 
QuestionVB .NET Interoperability Pin
dpagka7-Nov-06 6:37
dpagka7-Nov-06 6:37 
AnswerRe: VB .NET Interoperability Pin
nlarson117-Nov-06 7:58
nlarson117-Nov-06 7:58 
QuestionNetwork Programming Pin
Nakul Sharma7-Nov-06 3:02
Nakul Sharma7-Nov-06 3:02 
AnswerRe: Network Programming Pin
coolestCoder7-Nov-06 3:42
coolestCoder7-Nov-06 3:42 
AnswerRe: Network Programming Pin
Yona Low7-Nov-06 4:37
Yona Low7-Nov-06 4:37 
GeneralRe: Network Programming Pin
Nakul Sharma8-Nov-06 0:56
Nakul Sharma8-Nov-06 0:56 
GeneralRe: Network Programming Pin
Yona Low8-Nov-06 16:34
Yona Low8-Nov-06 16:34 
AnswerRe: Network Programming Pin
MyAccountDied7-Nov-06 19:14
MyAccountDied7-Nov-06 19:14 
QuestionIs this possible Pin
Pete Newman7-Nov-06 2:49
Pete Newman7-Nov-06 2:49 
Questionchange permission in registry Pin
ingsgr01@gmail.com7-Nov-06 2:16
ingsgr01@gmail.com7-Nov-06 2:16 
AnswerRe: change permission in registry Pin
Yona Low7-Nov-06 4:32
Yona Low7-Nov-06 4:32 
QuestionSystem.InvalidCastException was unhandled by user code Pin
binujeesman7-Nov-06 0:21
binujeesman7-Nov-06 0:21 
Questionadding schema table in treeview Pin
nbulut6-Nov-06 23:34
nbulut6-Nov-06 23:34 
Questionvb 6.0 Pin
sukhchain singh6-Nov-06 22:40
sukhchain singh6-Nov-06 22:40 

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.