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
Subscribe to Tutorials
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. hi i am new to JSP wht is class.forname in the cod
View Tutorial By: chanti at 2011-05-07 03:02:26
2. Good
View Tutorial By: sirisha at 2009-09-08 23:04:22
3. hey hiii.
at last the progrma has be runnin
View Tutorial By: jugal at 2009-02-20 08:22:31
4. Very informative and simple to understand. Thank y
View Tutorial By: Rosa Vladivord at 2012-12-23 13:00:52
5. i run this program. its not showing any runtime or
View Tutorial By: anand sp at 2011-03-07 10:11:37
6. What is a mean by maintaining the Session State of
View Tutorial By: Saranya at 2011-05-14 13:17:42
7. how to execute all the 5 files plz tell me step by
View Tutorial By: asraf at 2007-11-14 22:29:20
8. Nice example of System.arraycopy()function. Thank
View Tutorial By: Rahul Raj at 2015-08-17 03:11:44
9. @bibiki, you are right for simpler conditions what
View Tutorial By: Marcin at 2012-04-05 02:34:13
10. Thanks a ton. Was struggling to get the ListView u
View Tutorial By: Avinash at 2012-09-25 12:25:12