D
DAXU
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
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