当excel表中的数据更新到更多列不能正常工作时 [英] When update data in excel sheet to more columns not working why

问题描述

我有excel工作表名称Allprinting



包含UserID，UserName，UserNameAR，Country，CountryAR，Member，MemberAR列



如果客户更改了这些



列中的任何数据，我需要在此Excel工作表中生成更新数据（UserID，UserName，UserNameAR，Country， CountryAR，会员，会员AR）



但是轰鸣声代码对我不起作用



这样什么是问题



我的代码

I have excel sheet name Allprinting

contain to UserID,UserName,UserNameAR,Country,CountryAR,Member,MemberAR columns

I need to make update data in this excel sheet if client change any data in these

columns (UserID,UserName,UserNameAR,Country,CountryAR,Member,MemberAR)

but bellow code not working for me

so that what is the problem

my code

var fileName = string.Format("{0}\\Book502", Directory.GetCurrentDirectory());
var connection = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source={0};Mode=ReadWrite;Extended Properties=Excel 12.0 Xml;", fileName);
try
{
System.Data.OleDb.OleDbConnection MyConnection;
System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand();
string sql = null;
MyConnection = new System.Data.OleDb.OleDbConnection(connection);
                MyConnection.Open();
                myCommand.Connection = MyConnection;
            sql = "Update [AllPrinting$] SET UserName=@UserName and UserNameAR=@UserNameAR and Country=@Country and CountryAR=@CountryAR AND Member=@Member AND MemberAR=@MemberAR WHERE UserID=@UserID";
           
            myCommand.CommandText = sql;
                myCommand.Parameters.AddWithValue("@UserName", textBox2.Text);
                myCommand.Parameters.AddWithValue("@UserID", textBox1.Text);
               myCommand.Parameters.AddWithValue("@UserNameAR", textBox3.Text);
            myCommand.Parameters.AddWithValue("@Country", textBox4.Text);
            myCommand.Parameters.AddWithValue("@CountryAR", textBox5.Text);
            myCommand.Parameters.AddWithValue("@Member", textBox6.Text);
            myCommand.Parameters.AddWithValue("@MemberAR", textBox7.Text);
            myCommand.ExecuteNonQuery();
                MyConnection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }

我可以更新excel表中的数据如果我对一列进行更新

I can update data in excel sheet if i make update to one column

sql = "Update [AllPrinting$] SET UserName=@UserName and UserNameAR=@UserNameAR WHERE UserID=@UserID";

但是将数据更新到更多列不能正常工作：

But update data to more column not working as following :

sql = "Update [AllPrinting$] SET UserName=@UserName and UserNameAR=@UserNameAR and Country=@Country and CountryAR=@CountryAR AND Member=@Member AND MemberAR=@MemberAR WHERE UserID=@UserID";

我尝试了什么：



当excel表中的更新数据更多列无效时为什么

What I have tried:

when update data in excel sheet to more columns not working why

推荐答案

SET UserName = @ UserName和UserNameAR = @ UserNameAR和Country = @ Country and CountryAR = @ CountryAR AND Member = @ Member AND MemberAR = @ MemberAR WHERE UserID = @ UserID;

myCommand.CommandText = sql;
myCommand.Parameters.AddWithValue（ @ UserName，textBox2.Text）;
myCommand.Parameters.AddWithValue（ @ UserID，textBox1.Text）;
myCommand.Parameters.AddWithValue（ @ UserNameAR，textBox3.Text）;
myCommand.Parameters.AddWithValue（ @ Country，textBox4.Text）;
myCommand.Parameters.AddWithValue（ @ CountryAR，textBox5.Text）;
myCommand.Parameters.AddWithValue（ @ Member，textBox6.Text）;
myCommand.Parameters.AddWithValue（ @ MemberAR，textBox7.Text）;
myCommand.ExecuteNonQuery（）;
MyConnection.Close（）;
}
catch （Exception ex）
{
MessageBox.Show（ex.ToString（））;
}

SET UserName=@UserName and UserNameAR=@UserNameAR and Country=@Country and CountryAR=@CountryAR AND Member=@Member AND MemberAR=@MemberAR WHERE UserID=@UserID"; myCommand.CommandText = sql; myCommand.Parameters.AddWithValue("@UserName", textBox2.Text); myCommand.Parameters.AddWithValue("@UserID", textBox1.Text); myCommand.Parameters.AddWithValue("@UserNameAR", textBox3.Text); myCommand.Parameters.AddWithValue("@Country", textBox4.Text); myCommand.Parameters.AddWithValue("@CountryAR", textBox5.Text); myCommand.Parameters.AddWithValue("@Member", textBox6.Text); myCommand.Parameters.AddWithValue("@MemberAR", textBox7.Text); myCommand.ExecuteNonQuery(); MyConnection.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); }

我可以更新excel表中的数据如果我对一列进行更新

I can update data in excel sheet if i make update to one column

sql = "Update [AllPrinting

SET UserName = @ UserName和UserNameAR = @ UserNameAR WHERE UserID = @ UserID;

SET UserName=@UserName and UserNameAR=@UserNameAR WHERE UserID=@UserID";

但是将数据更新到更多列不能正常工作：

But update data to more column not working as following :

sql = "Update [AllPrinting

SET UserName = @ UserName和UserNameAR = @ UserNameAR和Country = @ Country和CountryAR = @ CountryAR AND Member = @ Member AND MemberAR = @ MemberAR WHERE UserID = @ UserID;

SET UserName=@UserName and UserNameAR=@UserNameAR and Country=@Country and CountryAR=@CountryAR AND Member=@Member AND MemberAR=@MemberAR WHERE UserID=@UserID";

我的尝试：



将excel表格中的数据更新为更多不起作用的列

What I have tried:

when update data in excel sheet to more columns not working why

这篇关于当excel表中的数据更新到更多列不能正常工作时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！