Click here to Skip to main content
15,897,891 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Linking database with ASP Pin
MatthysDT22-Jan-07 21:57
MatthysDT22-Jan-07 21:57 
QuestionDetailsView ItemUpdating event not fired Pin
kascakm13-Oct-06 0:56
kascakm13-Oct-06 0:56 
AnswerRe: DetailsView ItemUpdating event not fired Pin
TerryPatrick9-Aug-10 10:01
TerryPatrick9-Aug-10 10:01 
Questionhow to give proeperty for textbox Pin
dany.s13-Oct-06 0:42
dany.s13-Oct-06 0:42 
AnswerRe: how to give proeperty for textbox Pin
kirthikirthi13-Oct-06 1:05
kirthikirthi13-Oct-06 1:05 
QuestionTransforming standard values from excel to database record Pin
dhatchu13-Oct-06 0:32
dhatchu13-Oct-06 0:32 
QuestionNeed help to update excel file using oledb Pin
RaghuSanta13-Oct-06 0:21
RaghuSanta13-Oct-06 0:21 
Answerupdate excel file using oledb Pin
RaghuSanta13-Oct-06 1:09
RaghuSanta13-Oct-06 1:09 
Hi,

I just found the solution. May be this could help others.
Dim sConn As String
Dim OleConn As OleDbConnection
Dim OleCmd As OleDbCommand
sConn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\testexcel.xls;Extended Properties=""Excel 8.0;HDR=No;"""
OleConn = New OleDbConnection(strConn)
OleConn.Open()
OleCmd = OleConn.CreateCommand()
Olecmd.commandtext="UPDATE [sheet1$F1:A1] SET F1 ='6'"
OleCmd.ExecuteNonQuery()
OleCmd = Nothing
OleConn.Close()

On giving the above statement, the cell A1(first row first column) gets updated with value in the excel.





Regards,
Raghu.
QuestionChanging 'Look and Feel' and 'Text' of Browse button which we get from FileUpload Control Pin
Soniya_k12-Oct-06 23:02
Soniya_k12-Oct-06 23:02 
AnswerRe: Changing 'Look and Feel' and 'Text' of Browse button which we get from FileUpload Control Pin
Guffa13-Oct-06 6:54
Guffa13-Oct-06 6:54 
GeneralRe: Changing 'Look and Feel' and 'Text' of Browse button which we get from FileUpload Control Pin
Soniya_k13-Oct-06 20:29
Soniya_k13-Oct-06 20:29 
Questionarray of datasets Pin
max_dev2006@yahoo.com12-Oct-06 21:19
max_dev2006@yahoo.com12-Oct-06 21:19 
AnswerRe: array of datasets Pin
rah_sin13-Oct-06 0:10
professionalrah_sin13-Oct-06 0:10 
QuestionDescription of property in property window [modified] Pin
Nitin198112-Oct-06 21:15
Nitin198112-Oct-06 21:15 
AnswerRe: Description of property in property window Pin
e-laj13-Oct-06 10:03
e-laj13-Oct-06 10:03 
QuestionNew Window.Open Pin
kirthikirthi12-Oct-06 20:52
kirthikirthi12-Oct-06 20:52 
AnswerRe: New Window.Open Pin
Exelioindia12-Oct-06 21:10
Exelioindia12-Oct-06 21:10 
GeneralRe: New Window.Open Pin
kirthikirthi12-Oct-06 21:43
kirthikirthi12-Oct-06 21:43 
AnswerRe: New Window.Open Pin
tha.karthik12-Oct-06 21:35
tha.karthik12-Oct-06 21:35 
GeneralRe: New Window.Open Pin
kirthikirthi12-Oct-06 22:39
kirthikirthi12-Oct-06 22:39 
GeneralRe: New Window.Open Pin
I A Khan13-Oct-06 3:51
I A Khan13-Oct-06 3:51 
Questionmerging web server state Pin
max_dev2006@yahoo.com12-Oct-06 20:31
max_dev2006@yahoo.com12-Oct-06 20:31 
Questionhow to access the files present in private folders Pin
King Shez12-Oct-06 20:23
King Shez12-Oct-06 20:23 
QuestionHow to make upoaded files secure ? Pin
King Shez12-Oct-06 20:17
King Shez12-Oct-06 20:17 
QuestionUrgent plz..How to bind Controls in Repeater Control Pin
Exelioindia12-Oct-06 20:15
Exelioindia12-Oct-06 20:15 

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.