必须声明标量变量“@ customer”。 [英] Must declare the scalar variable "@customer".

问题描述

我正在创建Windows应用程序使用 c＃ 2010 ，这里我am 使用数据网格视图进行计费，但将网格视图值保存到数据 base 低于错误 来自
 
必须声明标量变量  @ customer。 
 
 SqlCommand cmd2 =  new  SqlCommand（  update stkdetails set customer = customer + @ customer + rows.Cells [ 7 ]。Value +   其中empname =' + rows.Cells [ 2 ]。值+  'and date =' + txtdate.Text +  '，con2）; 
 
 
任何一位给我一些想法如何解决上述错误

什么我试过了：



必须声明标量变量@customer。

解决方案

您创建参数并将它们添加到SQLCommand对象：

 SqlCommand cmd2 =  new  SqlCommand（  update stkdetails set customer = customer + @ customer where empname =' + rows.Cells [ 2 ]。值+  '和date =' + txtdate.Text +  '，con2）; 
 cmd2.Parameters.AddWithValue（  @ customer，rows.Cells [ 7 ]。值）; 

我也强烈建议您为@设置参数empname和@date同时。

 SqlCommand cmd2 =  new  SqlCommand（  update stkdetails set customer = customer + @ customer where empname = @ empname and date = @ date，con2）; 
 cmd2.Parameters.AddWithValue（  @ customer，rows.Cells [ 7 ]值）。 
 cmd2.Parameters.AddWithValue（  @ empname，rows.Cells [ 2 ]值）。 
 cmd2.Parameters.AddWithValue（  @ date，txtDate.Text）; 

I am creating windows application using c# 2010, here i am using data grid view for billing purpose, but save the grid view values to data base below error is came 

Must declare the scalar variable "@customer".
 
 SqlCommand cmd2 = new SqlCommand("update stkdetails set customer=customer+@customer" + rows.Cells[7].Value + " where empname='" + rows.Cells[2].Value + "'and date='" + txtdate.Text + "'", con2);


any one give me some ideas how to solve above error

What I have tried:

Must declare the scalar variable "@customer".

解决方案

You create parameters and add them to the SQLCommand object:

SqlCommand cmd2 = new SqlCommand("update stkdetails set customer=customer+@customer where empname='" + rows.Cells[2].Value + "'and date='" + txtdate.Text + "'", con2);
cmd2.Parameters.AddWithValue("@customer", rows.Cells[7].Value);

I would also strongly suggest you set up parameters for @empname and @date at the same time.

SqlCommand cmd2 = new SqlCommand("update stkdetails set customer=customer+@customer where empname=@empname and date=@date", con2);
cmd2.Parameters.AddWithValue("@customer", rows.Cells[7].Value);
cmd2.Parameters.AddWithValue("@empname", rows.Cells[2].Value);
cmd2.Parameters.AddWithValue("@date", txtDate.Text);

这篇关于必须声明标量变量“@ customer”。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！