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. Hi all
Can you please tell ,how to recei

View Tutorial          By: Nanthini at 2011-09-07 16:48:04

2. Nice code easily understand the code and useful
View Tutorial          By: satish at 2010-01-22 06:30:22

3. Hi,

I am using this code and gettin

View Tutorial          By: Akanksha at 2014-01-20 10:31:31

4. Hi i changed some codes in that and i gave interne
View Tutorial          By: Göktuğ ÖZEL at 2013-03-13 22:44:55

5. Hi there, I fixed the above (non-working) example
View Tutorial          By: JavaBoy at 2011-09-24 05:41:19

6. Ku is quite correct. When you create any object, i
View Tutorial          By: Avnish at 2010-10-28 04:00:20

7. thank you for code
View Tutorial          By: turki at 2013-12-11 13:23:44

8. Hi sir just send me the code sir .... i am interes
View Tutorial          By: maruthi at 2013-10-30 05:14:15

9. what is the usage of 'detail' and 'debug' init par
View Tutorial          By: uday at 2011-07-21 04:53:02

10. I'm a beginner, and I was told it is a good practi
View Tutorial          By: Nelson at 2009-08-17 09:13:28