Click here to Skip to main content
15,919,479 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionASP.net In Visual Studio 2019 Pin
Ebrahimaw20-Nov-19 13:09
Ebrahimaw20-Nov-19 13:09 
AnswerRe: ASP.net In Visual Studio 2019 Pin
Eddy Vluggen20-Nov-19 14:03
professionalEddy Vluggen20-Nov-19 14:03 
QuestionSQL Parameter Collection - Not able to assign to SQLCommand Pin
Member 1115418819-Nov-19 6:11
Member 1115418819-Nov-19 6:11 
AnswerRe: SQL Parameter Collection - Not able to assign to SQLCommand Pin
Richard MacCutchan19-Nov-19 6:19
mveRichard MacCutchan19-Nov-19 6:19 
General[Solved] Re: SQL Parameter Collection - Not able to assign to SQLCommand Pin
Member 1115418819-Nov-19 19:10
Member 1115418819-Nov-19 19:10 
QuestionWhat's so bad about webforms? Pin
DerekT-P18-Nov-19 4:29
professionalDerekT-P18-Nov-19 4:29 
AnswerRe: What's so bad about webforms? Pin
jkirkerx18-Nov-19 13:47
professionaljkirkerx18-Nov-19 13:47 
PraiseRe: What's so bad about webforms? Pin
Eddy Vluggen18-Nov-19 14:19
professionalEddy Vluggen18-Nov-19 14:19 
GeneralRe: What's so bad about webforms? Pin
jkirkerx18-Nov-19 16:07
professionaljkirkerx18-Nov-19 16:07 
GeneralRe: What's so bad about webforms? Pin
Eddy Vluggen19-Nov-19 2:47
professionalEddy Vluggen19-Nov-19 2:47 
GeneralRe: What's so bad about webforms? Pin
F-ES Sitecore18-Nov-19 23:18
professionalF-ES Sitecore18-Nov-19 23:18 
GeneralRe: What's so bad about webforms? Pin
Richard Deeming19-Nov-19 1:21
mveRichard Deeming19-Nov-19 1:21 
GeneralRe: What's so bad about webforms? Pin
F-ES Sitecore19-Nov-19 1:35
professionalF-ES Sitecore19-Nov-19 1:35 
GeneralRe: What's so bad about webforms? Pin
jkirkerx19-Nov-19 12:59
professionaljkirkerx19-Nov-19 12:59 
GeneralRe: What's so bad about webforms? Pin
F-ES Sitecore19-Nov-19 23:04
professionalF-ES Sitecore19-Nov-19 23:04 
GeneralRe: What's so bad about webforms? Pin
jkirkerx20-Nov-19 10:43
professionaljkirkerx20-Nov-19 10:43 
GeneralRe: What's so bad about webforms? Pin
DerekT-P20-Nov-19 1:22
professionalDerekT-P20-Nov-19 1:22 
GeneralRe: What's so bad about webforms? Pin
DerekT-P19-Nov-19 0:23
professionalDerekT-P19-Nov-19 0:23 
AnswerRe: What's so bad about webforms? Pin
F-ES Sitecore18-Nov-19 23:30
professionalF-ES Sitecore18-Nov-19 23:30 
AnswerRe: What's so bad about webforms? Pin
A_Griffin20-Nov-19 5:57
A_Griffin20-Nov-19 5:57 
GeneralRe: What's so bad about webforms? Pin
DerekT-P20-Nov-19 9:05
professionalDerekT-P20-Nov-19 9:05 
AnswerRe: What's so bad about webforms? Pin
Steve Naidamast24-Nov-19 6:53
professionalSteve Naidamast24-Nov-19 6:53 
GeneralRe: What's so bad about webforms? Pin
DerekT-P24-Nov-19 9:18
professionalDerekT-P24-Nov-19 9:18 
GeneralRe: What's so bad about webforms? Pin
Steve Naidamast25-Nov-19 4:30
professionalSteve Naidamast25-Nov-19 4:30 
QuestionFacing Issues while reading an excel file and inserting it's rows to a my sql tabble. Working fine in local machine but giving error after deployement Pin
Member 1465772316-Nov-19 3:23
Member 1465772316-Nov-19 3:23 
Error:'D:\test_data\sample_bulk_upload_File.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides

code::
path = TextBox3.Text

        s1 = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" + path + ";Extended Properties=""Excel 8.0;HDR=YES;"""

        Dim OLEcon As OleDb.OleDbConnection = New OleDb.OleDbConnection(s1)

        Dim OLEcmd As New OleDb.OleDbCommand
        Dim OLEda As New OleDb.OleDbDataAdapter
        Dim OLEdt As New DataTable
        Dim sql As String
        Dim resul As Boolean
        OLEcon.Close()

        Try
            OLEcon.Open()



            With OLEcmd
                .Connection = OLEcon
                .CommandText = "Select * from [data1$]"
            End With
            OLEda.SelectCommand = OLEcmd
            OLEda.Fill(OLEdt)

            For Each r As DataRow In OLEdt.Rows

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.