vahid_erad
پنج شنبه 22 بهمن 1388, 10:52 صبح
مشکل کد زیر چیه ؟؟
Ds دیتاست هست و DA دیتاآداپر .
conn.Open();
DataTable dt = DS.Tables["Vahid"];
dt.Rows[curRow][3] = textBox_Snobat_fname.Text; //write in database
dataGridView1[3, curRow].Value = textBox_Snobat_fname.Text; //write in datagrid
dt.Rows[curRow][2] = textBox_Snobat_lname.Text;
dataGridView1[2, curRow].Value = textBox_Snobat_lname.Text;
dt.Rows[curRow][4] = textBox_Snobat_tell.Text;
dataGridView1[4, curRow].Value = textBox_Snobat_tell.Text;
dt.Rows[curRow][5] = textBox_Snobat_illness.Text;
dataGridView1[5, curRow].Value = textBox_Snobat_illness.Text;
SqlCommand cmd = new SqlCommand(@"update Table
set FirstName='@fname'
, LastName='@lname'
, Phone='@phn'
, illness='@iln'
where [Number]=1" , conn);
cmd.Parameters.Add("@fname", SqlDbType.NVarChar, 30, "FirstName");
cmd.Parameters.Add("@lname", SqlDbType.NVarChar, 30, "LastName");
cmd.Parameters.Add("@phn", SqlDbType.NVarChar, 30, "Phone");
cmd.Parameters.Add("@iln", SqlDbType.NVarChar, 60, "illness");
DA.UpdateCommand = cmd;
DA.Update(DS, "Vahid");پیغام خطاش هست :
The parameterized query '(@fname nvarchar(30),@lname nvarchar(30) , @phn nvarchar(30) , @iln' expects the parameter '@fname' , which was not supplied.
Ds دیتاست هست و DA دیتاآداپر .
conn.Open();
DataTable dt = DS.Tables["Vahid"];
dt.Rows[curRow][3] = textBox_Snobat_fname.Text; //write in database
dataGridView1[3, curRow].Value = textBox_Snobat_fname.Text; //write in datagrid
dt.Rows[curRow][2] = textBox_Snobat_lname.Text;
dataGridView1[2, curRow].Value = textBox_Snobat_lname.Text;
dt.Rows[curRow][4] = textBox_Snobat_tell.Text;
dataGridView1[4, curRow].Value = textBox_Snobat_tell.Text;
dt.Rows[curRow][5] = textBox_Snobat_illness.Text;
dataGridView1[5, curRow].Value = textBox_Snobat_illness.Text;
SqlCommand cmd = new SqlCommand(@"update Table
set FirstName='@fname'
, LastName='@lname'
, Phone='@phn'
, illness='@iln'
where [Number]=1" , conn);
cmd.Parameters.Add("@fname", SqlDbType.NVarChar, 30, "FirstName");
cmd.Parameters.Add("@lname", SqlDbType.NVarChar, 30, "LastName");
cmd.Parameters.Add("@phn", SqlDbType.NVarChar, 30, "Phone");
cmd.Parameters.Add("@iln", SqlDbType.NVarChar, 60, "illness");
DA.UpdateCommand = cmd;
DA.Update(DS, "Vahid");پیغام خطاش هست :
The parameterized query '(@fname nvarchar(30),@lname nvarchar(30) , @phn nvarchar(30) , @iln' expects the parameter '@fname' , which was not supplied.