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

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

Programming Tutorials

Comment on Tutorial - Update cell data in an Excel file using OLEDB in VB.net By Issac

categories

Subscribe to Tutorials

Related Tutorials

Archived Comments