Click here to Skip to main content
15,909,193 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: seeking guideline Pin
AmitGajjar16-Sep-13 21:08
professionalAmitGajjar16-Sep-13 21:08 
GeneralRe: seeking guideline Pin
crood29-Sep-13 4:25
crood29-Sep-13 4:25 
GeneralRe: seeking guideline Pin
Eddy Vluggen9-Sep-13 8:27
professionalEddy Vluggen9-Sep-13 8:27 
GeneralRe: seeking guideline Pin
crood11-Sep-13 2:01
crood11-Sep-13 2:01 
GeneralRe: seeking guideline Pin
jschell9-Sep-13 10:02
jschell9-Sep-13 10:02 
QuestionLinq to SQL, undo changes or maybe dereference? Pin
Scalee8-Sep-13 9:32
Scalee8-Sep-13 9:32 
AnswerRe: Linq to SQL, undo changes or maybe dereference? Pin
Pete O'Hanlon9-Sep-13 1:32
mvePete O'Hanlon9-Sep-13 1:32 
QuestionInterop.Word prob with Arabic Pin
nagham_4ng6-Sep-13 21:25
nagham_4ng6-Sep-13 21:25 
AnswerRe: Interop.Word prob with Arabic Pin
nagham_4ng8-Sep-13 20:20
nagham_4ng8-Sep-13 20:20 
AnswerRe: Interop.Word prob with Arabic Pin
Bernhard Hiller9-Sep-13 0:05
Bernhard Hiller9-Sep-13 0:05 
GeneralRe: Interop.Word prob with Arabic Pin
nagham_4ng9-Sep-13 23:25
nagham_4ng9-Sep-13 23:25 
QuestionRetreive Data from sql server along with headers or column name Pin
ashu20016-Sep-13 18:25
ashu20016-Sep-13 18:25 
AnswerRe: Retreive Data from sql server along with headers or column name Pin
Richard MacCutchan6-Sep-13 23:04
mveRichard MacCutchan6-Sep-13 23:04 
AnswerRe: Retreive Data from sql server along with headers or column name Pin
jschell8-Sep-13 8:29
jschell8-Sep-13 8:29 
GeneralRe: Retreive Data from sql server along with headers or column name Pin
ashu200112-Sep-13 1:44
ashu200112-Sep-13 1:44 
Questionproblem fetching data from excel Pin
Member 102027525-Sep-13 10:07
Member 102027525-Sep-13 10:07 
pls help am working on a system that collects data from different forms of database and i have been able to implement 4 (mysql,xml,....)out 5 using vb.net and now am on the last one which is getting data from an excel sheet but the code aint working .. please i would be grateful for any solutions

this is my code :::

Dim olecon As OleDbConnection
Dim olecomm As OleDbCommand


Try
olecon = New OleDbConnection
olecon.ConnectionString = connstring_busary
'connection_busary is a variable the stores the conection string
olecon.Open()
olecomm = New OleDbCommand(String.Format("SELECT * FROM [sheet1$]"), olecon)

VB
Dim reading As OleDbDataReader = olecomm.ExecuteReader()


           While (reading.Read)
           If Not reading.IsDBNull(reading.GetOrdinal("A7")) Then
                Label1.Text = reading.GetString(reading.GetOrdinal("A7"))
                
                End If


            End While

        Catch ex As OleDb.OleDbException
            MessageBox.Show(ex.Message)
        End Try


    End Sub

when ever i run this code it just runs and does not return any value to the label i used to track if any value is been returned from the excel file ... please i need help  :thumbsup:

AnswerRe: problem fetching data from excel Pin
Dave Kreskowiak5-Sep-13 10:53
mveDave Kreskowiak5-Sep-13 10:53 
Questionsuppress filedownload dialog box Pin
Erika Chinchio5-Sep-13 0:23
Erika Chinchio5-Sep-13 0:23 
AnswerRe: suppress filedownload dialog box Pin
Richard MacCutchan5-Sep-13 0:43
mveRichard MacCutchan5-Sep-13 0:43 
GeneralRe: suppress filedownload dialog box Pin
Erika Chinchio5-Sep-13 21:11
Erika Chinchio5-Sep-13 21:11 
GeneralRe: suppress filedownload dialog box Pin
Richard MacCutchan5-Sep-13 21:54
mveRichard MacCutchan5-Sep-13 21:54 
AnswerRe: suppress filedownload dialog box Pin
Bernhard Hiller5-Sep-13 21:21
Bernhard Hiller5-Sep-13 21:21 
GeneralRe: suppress filedownload dialog box Pin
Erika Chinchio6-Sep-13 0:04
Erika Chinchio6-Sep-13 0:04 
Question.net framework Pin
abusalehrajib31-Aug-13 20:53
abusalehrajib31-Aug-13 20:53 
SuggestionRe: .net framework Pin
Eddy Vluggen31-Aug-13 22:57
professionalEddy Vluggen31-Aug-13 22:57 

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.