检查delete命令中的语法不起作用

问题描述

需要更正以下代码才能删除









//调用要删除的语句

SqlCommand sqlCmd = new SqlCommand（从Loan_TRANS中删除IDNO ='+ txt_Actual_Loan_No.Text +'，

ID_CODE = '+ txt_Id_Code.Text +'，

TRANS_NO ='+ txt_Transaction_No.Text +'，sqlCon）;





使用逗号（，）分隔过滤请通过输入正确的语法协助

解决方案

Need to correct the codes below for deleting




//Call the statement to delete
SqlCommand sqlCmd = new SqlCommand("Delete from Loan_TRANS Where IDNO = '" + txt_Actual_Loan_No.Text + "'" ,
ID_CODE = '" + txt_Id_Code.Text + "'" ,
TRANS_NO = '" + txt_Transaction_No.Text + "'" , sqlCon);


using comma (,) to separate to filter please assist by putting in the right syntax

解决方案

这篇关于检查delete命令中的语法不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！