insert query not working in excel file using C#

Question

I have executed SELECT query to get data form .xls (Ms-EXCEL) file which works fine

 OdbcConnection con = new OdbcConnection("Dsn=XlsDB"); //Created DSN for .xls file
 con.Open();
 OdbcCommand cmd = new OdbcCommand("Select Password from [Users$] where UserName='javed'",con);
 OdbcDataReader dr = cmd.ExecuteReader();
 while (dr.Read())
 {
       if(dr[0].ToString()=="akram")
          MessageBox.Show("Welcome");
 }

BUT

while inserting values in .xls file its giving error

OdbcConnection con = new OdbcConnection("Dsn=XlsDB"); //Created DSN for .xls file
con.Open();

OdbcCommand cmd1 = new OdbcCommand("INSERT INTO [Users$](UserName,Password) VALUES(@name, @pass)", con);
cmd1.Parameters.Add(new OdbcParameter("@name", "hello"));
cmd1.Parameters.Add(new OdbcParameter("@pass", "world"));
cmd1.ExecuteNonQuery();  //error here

@Peter: ERROR [07002] [Microsoft][ODBC Excel Driver] Too few parameters. Expected 2. — Javed Akram
– Javed Akram, Commented Mar 4, 2011 at 18:19

Peter M · Accepted Answer · 2011-03-10 18:03:49Z

1

Take a look at system.data.odbc.odbcparameter and you will see that you are using the odbcparameter class incorrectly.

answered Mar 10, 2011 at 18:03

Peter M

7,5913 gold badges55 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Craig · Accepted Answer · 2011-03-04 18:31:19Z

0

I think the parameter names should not contain the @ symbol like...

cmd1.Parameters.Add(new OdbcParameter("name", "hello"));
cmd1.Parameters.Add(new OdbcParameter("pass", "world"));

answered Mar 4, 2011 at 18:31

Craig

7,0863 gold badges36 silver badges55 bronze badges

Collectives™ on Stack Overflow

insert query not working in excel file using C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related