Click here to Skip to main content
15,912,977 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Div refresh using AJAX Pin
just3ala212-Dec-06 3:44
just3ala212-Dec-06 3:44 
GeneralRe: Div refresh using AJAX Pin
ednrgc12-Dec-06 3:49
ednrgc12-Dec-06 3:49 
GeneralRe: Div refresh using AJAX Pin
just3ala212-Dec-06 19:21
just3ala212-Dec-06 19:21 
GeneralRe: Div refresh using AJAX Pin
ednrgc13-Dec-06 1:41
ednrgc13-Dec-06 1:41 
Questionwhy nobody answer my question. is it really so complicated? Pin
m.rastgar12-Dec-06 2:44
m.rastgar12-Dec-06 2:44 
AnswerRe: why nobody answer my question. is it really so complicated? Pin
ednrgc12-Dec-06 3:30
ednrgc12-Dec-06 3:30 
AnswerRe: why nobody answer my question. is it really so complicated? Pin
GaryWoodfine 12-Dec-06 5:40
professionalGaryWoodfine 12-Dec-06 5:40 
QuestionProblem in Importing data from excel to database,please help me Pin
kishore19@hotmail.com12-Dec-06 1:48
kishore19@hotmail.com12-Dec-06 1:48 
'Getting a file path
If Not FILE1.PostedFile.FileName = "" Then
FilePath = FILE1.PostedFile.FileName
End If

'Excel Work Sheet Database Connection
MyConnection = New System.Data.OleDb.OleDbConnection( _
"provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source=" & FilePath & "; " & _
"Extended Properties=Excel 8.0;")

'Select the data from Sheet1 of the workbook.

'FilePath comes as c:\export\mydata.xls
'now i am going to retrive the "mydata" name only
because of while iam storing the excel file,it is being stored as mydata.xls and at the same time sheet name also being changed as mydata

whenever i am going to retrieve the data, i have to specify the sheet name
for that i am doing the below code, but i am getting an error, it is alreday open by another user or some other error is displayed


Dim f As Array
f = Split(FilePath, "\")
Dim k As Integer = f.Length
Dim str As String = f(k - 1)

Dim filename As String = str.Substring(0, str.LastIndexOf("."))



'' Select the data from Sheet1 of the workbook.
MyCommand = New System.Data.OleDb.OleDbDataAdapter( _
"select * from [" & filename & "$]", MyConnection)




DS = New System.Data.DataSet 'DataSet
MyCommand.Fill(DS) 'Filling The dataset



please help me, when iam going to export the data from database to excel, it is storing it as c1.xls(we give) and sheet1 name is also stored as c1.xls

when i am going to retrieve the data from it, it is giving an error(as above said)

please help me

regards

kishore

go2kish@yahoo.com



kishore
QuestionTo control the size of the dropdownlist's item [modified] Pin
Senthil Kumar Murugan12-Dec-06 1:46
Senthil Kumar Murugan12-Dec-06 1:46 
QuestionFailed to map the path '/WSConcessionaria/App_GlobalResources/'. Pin
Imran Khan Pathan12-Dec-06 1:03
Imran Khan Pathan12-Dec-06 1:03 
GeneralAllocation of images on site Pin
El'Cachubrey12-Dec-06 1:02
El'Cachubrey12-Dec-06 1:02 
QuestionBatch Problem asp.net and vb.net Pin
Carlos Felipe12-Dec-06 0:43
Carlos Felipe12-Dec-06 0:43 
QuestionBrowsing problem Pin
OlaMohammed12-Dec-06 0:35
OlaMohammed12-Dec-06 0:35 
AnswerRe: Browsing problem Pin
karam chandrabose12-Dec-06 0:41
karam chandrabose12-Dec-06 0:41 
GeneralRe: Browsing problem Pin
OlaMohammed12-Dec-06 0:56
OlaMohammed12-Dec-06 0:56 
AnswerRe: Browsing problem Pin
l0kke12-Dec-06 0:52
l0kke12-Dec-06 0:52 
GeneralRe: Browsing problem Pin
karam chandrabose12-Dec-06 2:00
karam chandrabose12-Dec-06 2:00 
GeneralRe: Browsing problem Pin
karam chandrabose12-Dec-06 2:01
karam chandrabose12-Dec-06 2:01 
QuestionCalendar Control Pin
aaraaayen12-Dec-06 0:34
aaraaayen12-Dec-06 0:34 
AnswerRe: Calendar Control Pin
l0kke12-Dec-06 0:53
l0kke12-Dec-06 0:53 
GeneralRe: Calendar Control Pin
aaraaayen12-Dec-06 1:48
aaraaayen12-Dec-06 1:48 
QuestionHow to add a checkbox in a datagrid using datagrid Pin
sivaraman_ms12-Dec-06 0:05
sivaraman_ms12-Dec-06 0:05 
AnswerRe: How to add a checkbox in a datagrid using datagrid Pin
Imran Khan Pathan12-Dec-06 0:56
Imran Khan Pathan12-Dec-06 0:56 
AnswerRe: How to add a checkbox in a datagrid using datagrid Pin
postmaster@programmingknowledge.com12-Dec-06 16:17
postmaster@programmingknowledge.com12-Dec-06 16:17 
QuestionDeployment of Asp.net 2.0 Application. Pin
Kamal.Afridi11-Dec-06 23:59
Kamal.Afridi11-Dec-06 23:59 

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.