![]() |
No... while trying to update to Excel file
Hi,
I already searched old posts, but still confused. I am a asp.net application and user "everyone" does have write and read right to the excel file public static readonly string sConnectionString1 = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Extended Properties=\"Excel 12.0;HDR=No; IMEX=1\"; Data Source= 1.xlsx"; My code is DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb" ); using (DbConnection conn = factory.CreateConnection()) { conn.ConnectionString = this.ConnString; conn.Open(); using (DbCommand command = conn.CreateCommand()) { command.CommandText = "SELECT * FROM [HP Calculator APR$E4:E6]"; //reading is ok using (DbDataReader dr = command.ExecuteReader()) { while (dr.Read()) { string hello = dr[0].ToString(); } } //update fails as well, the exception is:No value given for one or more required parameters. StringBuilder sb = new StringBuilder("update [HP Calculator APR$] set "); sb.AppendFormat("{0}='{1}'", "G3", quoteRequest.TotalPrice); command.CommandText = sb.ToString(); command.ExecuteNonQuery(); } I am totally confused, can someone help me? Thanks |
All times are GMT +1. The time now is 05:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com