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,
I'm studying core java.java is new for

View Tutorial          By: shantkumar at 2011-12-01 17:02:26

2. Thank ... for idea But
i m confuse how run

View Tutorial          By: Tanaji at 2010-06-01 23:13:19

3. pretty simply explained
View Tutorial          By: nivedita at 2011-06-09 07:32:58

4. I am new to J2ME but this was really help full and
View Tutorial          By: Subhash at 2013-05-05 08:57:38

5. Hi mate,
When I compile the DomParserExampl

View Tutorial          By: Suresh Kumar D at 2013-06-25 07:06:19

6. Okay, this article cleared my two doubts i.e. Use
View Tutorial          By: Shrikrishna Meena at 2010-09-26 12:38:04

7. one closing bracket ')' is required at while loop
View Tutorial          By: varsha Tambe at 2013-01-07 09:34:37

8. this helped a lot!!!!
View Tutorial          By: karthik rk at 2012-09-04 16:32:25

9. Hi i copied the same code n change the comport no
View Tutorial          By: Nidhi Puri at 2010-12-04 00:55:29

10. j = 0;
while(--j)
{

View Tutorial          By: alistair at 2012-01-28 06:05:48