DataAdapter.Update（）在Update和Delete Command中不起作用 [英] DataAdapter.Update () doesn't work in Update and Delete Command

问题描述

我的sql语句如下

insert语句只能工作

更新和删除语句不起作用

my sql statments are as follows
the insert statement only works
update and delete statements don't work

string deletecmd_PurchaseProduct =
    @"DELETE FROM PurchaseProduct Where" +
    "PurchaseProduct_No=@PurchaseProduct_No and "+
    "Purchase_InvoiceNo=@Purchase_InvoiceNo ";

string updatcmd_PurchaseProduct =
    "UPDATE PurchaseProduct "
+ "  SET    "
+ "  PurchaseProduct_SerialNo =@PurchaseProduct_SerialNo"
+ ", Purchase_InvoiceNo =@Purchase_InvoiceNo"
+ ", ProductNo =@ProductNo"
+ " PurchaseProduct_Quantity =@PurchaseProduct_Quantity "
+ ", PurchaseProduct_Unit =@PurchaseProduct_Unit"
+ ", PurchaseProduct_Price =@PurchaseProduct_Price"
+ " Where "
+ " PurchaseProduct_No=@PurchaseProduct_No";



string insertcmd_PurchaseProduct = "INSERT INTO PurchaseProduct" +
                   "(" +
                   " PurchaseProduct_SerialNo"+
                   ",Purchase_InvoiceNo" +
                   ",ProductNo" +
                   ",PurchaseProduct_Quantity " +
                   ",PurchaseProduct_Price" +
                   ",PurchaseProduct_Unit" +    //6
                   ")" +
                    "Values" +
                   "(" +
                   " @PurchaseProduct_SerialNo"+
                   ",@Purchase_InvoiceNo" +
                   ",@ProductNo " +
                   ",@PurchaseProduct_Quantity " +
                   ",@PurchaseProduct_Price" +
                   ",@PurchaseProduct_Unit" +       //6
                   ");";

推荐答案

要使用更新和删除查询，您应该使用ExecuteNonQuery;您可以使用以下示例代码进行更新：



SqlDataAdapter adapter = new SqlDataAdapter（）;

SqlConnection connection = new SqlConnection（Connection这里的字符串...）;

字符串sql =这里更新语句......;

尝试

{

connection.Open（）;

adapter.UpdateCommand = connection.CreateCommand（）;

adapter.UpdateCommand.CommandText = sql;



adapter.UpdateCommand.ExecuteNonQuery（）;

MessageBox.Show（行更新!!）;

}





您可以使用以下示例代码进行删除：



SqlDataAdapter adapter = new SqlDataAdapter（）;

SqlConnection connection = new SqlConnection（Connection string here ...）;

string sql =delete query here ...;

尝试

{

connection.Open（）;

adapter.DeleteCommand = connection.CreateCommand（）;

adapter.DeleteC ommand.CommandText = sql;



adapter.DeleteCommand.ExecuteNonQuery（）;

MessageBox.Show（行已删除!! ）;

}



我希望它可以帮助您解决问题：）

To use the update and delete query, you should use the ExecuteNonQuery; you can use the following sample code for Update:

SqlDataAdapter adapter = new SqlDataAdapter();
SqlConnection connection = new SqlConnection("Connection string here...");
string sql = "update statement here...";
try
{
connection.Open();
adapter.UpdateCommand = connection.CreateCommand();
adapter.UpdateCommand.CommandText = sql;

adapter.UpdateCommand.ExecuteNonQuery();
MessageBox.Show ("Row updated !! ");
}


you can use the following sample code for Delete:

SqlDataAdapter adapter = new SqlDataAdapter();
SqlConnection connection = new SqlConnection("Connection string here...");
string sql = "delete query here...";
try
{
connection.Open();
adapter.DeleteCommand = connection.CreateCommand();
adapter.DeleteCommand.CommandText = sql;

adapter.DeleteCommand.ExecuteNonQuery();
MessageBox.Show ("Row(s) deleted !! ");
}

I hope it will help you resolve your issue :)

这篇关于DataAdapter.Update（）在Update和Delete Command中不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！