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 can be Made Popular by adding Links or Suggesti
View Tutorial          By: Ramalingam at 2010-03-20 23:00:41

2. i'ma beginer in this android devopment tutorial ca
View Tutorial          By: vijay at 2015-08-18 05:16:54

3. this site is very useful to the freshers ...

View Tutorial          By: sweth at 2009-09-02 18:53:46

4. DOWNLOAD IT
View Tutorial          By: KUSUM at 2010-02-02 23:48:50

5. thanks nice article , but there is bug as already
View Tutorial          By: YZ at 2011-08-05 13:10:49

6. hai

Please show ByteAraayOutputStre

View Tutorial          By: WebMayuri at 2010-02-10 22:30:01

7. well done!!nice work
View Tutorial          By: Dxy at 2010-07-26 00:46:55

8. why do't you create ActionErrors object like this<
View Tutorial          By: veera reddy at 2011-07-15 12:14:57

9. Thank you ... was very helpfull indeed !!
View Tutorial          By: Avinav at 2011-02-09 15:46:37

10. thanks for providing information in a simple langu
View Tutorial          By: shailaja at 2010-09-01 03:50:41