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. hello everyone

i want to implement
View Tutorial By: Prateek at 2010-09-05 00:40:57

2. ok this is gud example to build an abstract class.
View Tutorial By: ashish at 2011-12-01 06:22:32

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

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

4. Very concise, but it would be more helpful without
View Tutorial By: Randy at 2010-11-17 14:16:01

5. This tutorial is really good for beginners.It help
View Tutorial By: Prabhat Kumar at 2007-04-09 05:02:02

6. That was nice.
View Tutorial By: Arnab at 2007-10-17 02:02:11

7. Pl send some sample program for speech to text wit
View Tutorial By: gokul at 2012-09-27 10:28:19

8. hi everbody. i need to extract a output from one j
View Tutorial By: keerthi at 2010-10-29 13:38:28

9. THNX RAMLAK..
HEY RAMLAK I HAVE A LOT OF DO
View Tutorial By: Vinod at 2009-01-02 22:04:40

10. Thanks...it was very helpful :)
View Tutorial By: Swathi at 2012-01-25 06:49:46

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