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



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

Java File

Java String

Count number of vowels, consonants and digits in a String in Java

Reverse a number in Java

Student marks calculation program in Java

Handling Fractions 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

Multiple Inheritance sample in Java

Java program using Method Overriding

Archived Comments

1. it is gooo...very helpful to know the basics
View Tutorial          By: srikanth at 2010-08-24 00:38:57

2. Hi
I can able to execute the abov

View Tutorial          By: sruthy at 2010-07-23 03:29:39

3. EXACTLY COPIED BY "C PROGRAMMING" by DEN
View Tutorial          By: Aashish at 2012-06-06 17:56:36

4. Gan,

Above print is not working bec

View Tutorial          By: Amit at 2011-07-25 05:26:47

5. i have json data like coffeename and coffee prize
View Tutorial          By: Paramatma sharan upadhyay at 2015-09-21 12:14:31

6. So I appreciate this website, however... would it
View Tutorial          By: Christina at 2013-02-06 16:46:12

7. @ anub : This is because you need to add external
View Tutorial          By: Sushil at 2009-09-09 12:24:23

8. very bad example.......can v call overrided functi
View Tutorial          By: abdul nasir khayam at 2011-10-27 20:57:00

9. pretty good explanation
View Tutorial          By: Prithwi at 2009-11-26 07:28:33

10. HI.KEEP ME ON WORK I HAVE MASTER PROGRAMMING C++ <
View Tutorial          By: NINHNGUYEN at 2011-06-19 12:54:20