How to Update Excel data using asp.net

Question

I have an Excel workbook which contains data in different sheets. I want to update excel workbook using asp.net.

In asp.net, I am using following query to update excel data:

OdbcConnection con = new OdbcConnection(ConfigurationManager.ConnectionStrings["SportTech"].ConnectionString);
OdbcCommand cmd;
con.Open();

string name = "sandeep";
string pos = "1";
string time = "11";
string point = "70";

string query = "UPDATE [Sheet1$] SET POSITION=\"" + pos + "\",Time=\"" + time + "\",Point=\"" + point + "\" WHERE NAME=" + name;

cmd = new OdbcCommand(query,con);
string x = cmd.ExecuteNonQuery().ToString();
MessageBox.Show(x.ToString());

but the query is showing error

ERROR [42000Ձ] [Microsoft][ODBC Excel Driver] Syntax error in UPDATE statement.

Thanks!

can anyone help me in this question

Sunny Sandeep
– Sunny Sandeep

2013-09-12 07:54:01 +00:00
Commented Sep 12, 2013 at 7:54 — Sunny Sandeep
– Sunny Sandeep, Commented Sep 12, 2013 at 7:54

soccer7 · Accepted Answer · 2018-12-06 02:05:59Z

1

Put excel file into App_Data foldet in your site.

You can try this:

string name = "sandeep";
string pos = "1";
string time = "11";
string point = "70";
string conStr = @"Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};" +
@"DBQ=|DataDirectory|\SportTech.xls;ReadOnly=0;";
OdbcConnection con = new OdbcConnection(conStr);
con.Open();
string query = "update [Sheet1$] set [POSITION]=?,[Time]=?,[Point]=? where [NAME]=?";
OdbcCommand cmd = new OdbcCommand(query, con);
cmd.Parameters.AddWithValue("?", pos);
cmd.Parameters.AddWithValue("?", time);
cmd.Parameters.AddWithValue("?", point);
cmd.Parameters.AddWithValue("?", name);
cmd.ExecuteNonQuery();
con.Close();

edited Dec 6, 2018 at 2:05

soccer7

4,0613 gold badges33 silver badges54 bronze badges

answered Sep 12, 2013 at 15:47

Samiey Mehdi

9,49419 gold badges51 silver badges65 bronze badges

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

1 Comment

Samiey Mehdi Over a year ago

@ Sunny Sandeep - in left answer exist a mark picture. you can click on.

Collectives™ on Stack Overflow

How to Update Excel data using asp.net

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related