Click here to Skip to main content
15,921,905 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: windows form while restore Pin
balakpn11-Dec-07 1:51
balakpn11-Dec-07 1:51 
Questionhow can i determine the location of current cell Pin
Rupesh Kumar Swami9-Dec-07 23:38
Rupesh Kumar Swami9-Dec-07 23:38 
AnswerRe: how can i determine the location of current cell Pin
Michael Sync10-Dec-07 1:34
Michael Sync10-Dec-07 1:34 
GeneralRe: how can i determine the location of current cell Pin
Rupesh Kumar Swami10-Dec-07 5:56
Rupesh Kumar Swami10-Dec-07 5:56 
QuestionUrgent HELP with usercontrols!!!!!! Pin
highjo9-Dec-07 23:06
highjo9-Dec-07 23:06 
GeneralRe: Urgent HELP with usercontrols!!!!!! Pin
Michael Sync10-Dec-07 1:27
Michael Sync10-Dec-07 1:27 
GeneralRe: Urgent HELP with usercontrols!!!!!! Pin
highjo10-Dec-07 4:58
highjo10-Dec-07 4:58 
Questionimporting excel sheet into datagrid Pin
sivaram praveen9-Dec-07 21:18
sivaram praveen9-Dec-07 21:18 
hi all,

In my application vb.net 2003 and ASP.net i have to import excel sheet into sql server 2003 existing table n then into datagrid.

I have used this code but throwing an error "System.Data.OleDb.OleDbException: The Microsoft Jet database engine could not find the object. Make sure the object exists and that you spell its name and the path name correctly."


Dim connstr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("Team wise EMP Profile.xls") + ";Extended Properties=Excel 8.0;"
Dim objconn As New OleDbConnection(connstr)
Dim ds As New DataSet
Dim objadapter As New OleDbDataAdapter("SELECT * FROM Emp_Profile_Tbl", objconn)
Try

objconn.Open()
objadapter.Fill(ds, "nomi")
dg.DataSource = ds.Tables(0).DefaultView
dg.DataBind()

Finally
objconn.Close()
End Try


pls help me
GeneralRe: importing excel sheet into datagrid Pin
Michael Sync9-Dec-07 22:30
Michael Sync9-Dec-07 22:30 
GeneralTimer object don't tick in a Module Pin
Narenge9-Dec-07 10:58
Narenge9-Dec-07 10:58 
GeneralRe: Timer object don't tick in a Module Pin
Luc Pattyn9-Dec-07 11:15
sitebuilderLuc Pattyn9-Dec-07 11:15 
GeneralRe: Timer object don't tick in a Module Pin
Narenge9-Dec-07 11:20
Narenge9-Dec-07 11:20 
GeneralRe: Timer object don't tick in a Module Pin
Luc Pattyn9-Dec-07 12:09
sitebuilderLuc Pattyn9-Dec-07 12:09 
GeneralVB database Pin
BOREC9-Dec-07 10:25
BOREC9-Dec-07 10:25 
GeneralRe: VB database Pin
Christian Graus9-Dec-07 13:11
protectorChristian Graus9-Dec-07 13:11 
GeneralAccessing fields in crosstab in Crystal11 from VB Pin
mikeh nz9-Dec-07 7:57
mikeh nz9-Dec-07 7:57 
Question[Message Deleted] Pin
BOREC9-Dec-07 4:01
BOREC9-Dec-07 4:01 
GeneralRe: visual basic question Pin
Christian Graus9-Dec-07 9:41
protectorChristian Graus9-Dec-07 9:41 
Generalswf in vb 2005 Pin
Sai Yasodharan9-Dec-07 1:07
Sai Yasodharan9-Dec-07 1:07 
GeneralRe: swf in vb 2005 Pin
Dave Kreskowiak9-Dec-07 4:44
mveDave Kreskowiak9-Dec-07 4:44 
QuestionHow to declare a Fortran DLL in ASP.NET 2.0 - Visual Basic Pin
Sergio2santos8-Dec-07 17:56
Sergio2santos8-Dec-07 17:56 
AnswerRe: How to declare a Fortran DLL in ASP.NET 2.0 - Visual Basic Pin
Dave Kreskowiak9-Dec-07 4:39
mveDave Kreskowiak9-Dec-07 4:39 
GeneralRe: How to declare a Fortran DLL in ASP.NET 2.0 - Visual Basic Pin
Sergio2santos12-Dec-07 11:09
Sergio2santos12-Dec-07 11:09 
GeneralRe: How to declare a Fortran DLL in ASP.NET 2.0 - Visual Basic Pin
Dave Kreskowiak12-Dec-07 12:49
mveDave Kreskowiak12-Dec-07 12:49 
GeneralRe: How to declare a Fortran DLL in ASP.NET 2.0 - Visual Basic Pin
Sergio2santos12-Dec-07 16:12
Sergio2santos12-Dec-07 16: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.