Comment on Tutorial - Update cell data in an Excel file using OLEDB in VB.net By Issac
Comment Added by : Sagar
Comment Added at : 2011-05-12 06:47:13
Comment on Tutorial : Update cell data in an Excel file using OLEDB in VB.net By Issac
string strInsert = "Insert into [Sheet1$](F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15,F16,F17,F18,F19,F20,F21,F22,F23,F24,F25,F26,F27,F28,F29,F30) VALUES(@F1,@F2,@F3,@F4,@F5,@F6,@F7,@F8,@F9,@F10,@F11,@F12,@F13,@F14,@F15,@F16,@F17,@F18,@F19,@F20,@F21,@F22,@F23,@F24,@F25,@F26,@F27,@F28,@F29,@F30)";
da.InsertCommand=new OleDbCommand(strInsert,con);
da.InsertCommand.Parameters.Add("@F1",OleDbType.VarChar,50,"F1");//Name
da.InsertCommand.Parameters.Add("@F2",OleDbType.Numeric,50,"F2");//Mon
da.InsertCommand.Parameters.Add("@F3",OleDbType.VarChar,50,"F3");
da.InsertCommand.Parameters.Add("@F4",OleDbType.VarChar,50,"F4");
da.Update(ds, "[Sheet1$]");
View Tutorial
- Data Science
- Android
- AJAX
- ASP.net
- C
- C++
- C#
- Cocoa
- Cloud Computing
- HTML5
- Java
- Javascript
- JSF
- JSP
- J2ME
- Java Beans
- EJB
- JDBC
- Linux
- Mac OS X
- iPhone
- MySQL
- Office 365
- Perl
- PHP
- Python
- Ruby
- VB.net
- Hibernate
- Struts
- SAP
- Trends
- Tech Reviews
- WebServices
- XML
- Certification
- Interview
categories
Related Tutorials
Program using concept of byte long short and int in java
Update contents of a file within a jar file
Tomcat and httpd configured in port 8080 and 80
Count number of vowels, consonants and digits in a String in Java
Student marks calculation program in Java
Calculate gross salary in Java
Calculate average sale of the week in Java
Vector in Java - Sample Program
MultiLevel Inheritance sample in Java
Archived Comments
1. if i wanna push the data from my keyboard input, h
View Tutorial By: andys at 2008-11-09 03:09:32
2. one closing bracket ')' is required at while loop
View Tutorial By: varsha Tambe at 2013-01-07 09:34:37
3. good
View Tutorial By: vishal at 2013-02-11 03:50:04
4. so what about, if i need to remove these letters f
View Tutorial By: need Help at 2009-11-12 08:40:31
5. Helpfull!
View Tutorial By: touraj at 2010-08-11 13:40:33
6. thanx to schildt
View Tutorial By: singh at 2012-10-26 11:57:11
7. This article helped me a lot to learn struts 2 and
View Tutorial By: Shiv Prakash at 2012-12-07 07:37:35
8. nice
View Tutorial By: srfds at 2012-05-28 09:25:15
9. hi good article with explanation
View Tutorial By: yuganthi at 2012-09-24 05:18:35
10. How can I submit my query in here?
View Tutorial By: Kafedha Rwezaula at 2010-06-04 01:32:30