insert query not working in excel file using C#

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 开发者_C百科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

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

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"));