رفع خطا

[shahram176]

سلام
دوستان مشکل این کد چیه؟
string stConnection = WebConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ToString();
SqlConnection cnc = new SqlConnection(stConnection);
string stCmd = "INSERT INTO tpayment(username,banknam,fishno,dtvariz,amount,st atus";
stCmd += ")VALUSE(@username,@banknam,@fishno,@dtvariz,@amoun t,@status";
stCmd += ")";
SqlConnection csd = new SqlConnection(stCmd,cnc);
csd.Parameters.AddWithValue("@username",TextBox4.Text );
csd.Parameters.AddWithValue("@banknam",DropDownList3.SelectedValue);
csd.Parameters.AddWithValue("@fishno",TextBox5.Text );
csd.parameters.AddWithValue("@dtvariz",TextBox6.Text);
csd.parameters.AddWithValue("@amount",TextBox7.Text);
csd.parameters.AssWithValue("@status",false );

[mehrzad_ali]

string stConnection = WebConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ToString();
SqlConnection cnc = new SqlConnection(stConnection);
string stCmd = "INSERT INTO tpayment(username,banknam,fishno,dtvariz,amount,st atus";
stCmd += ")VALUSE(@username,@banknam,@fishno,@dtvariz,@amou nt,@status";
stCmd += ")";
SqlConnection csd = new SqlConnection(stCmd,cnc);
csd.Parameters.AddWithValue("@username",TextBox4.T ext );
csd.Parameters.AddWithValue("@banknam",DropDownLis t3.SelectedValue);
csd.Parameters.AddWithValue("@fishno",TextBox5.Tex t );
csd.parameters.AddWithValue("@dtvariz",TextBox6.Te xt);
csd.parameters.AddWithValue("@amount",TextBox7.Tex t);
csd.parameters.AssWithValue("@status",false );

[mehrzad_ali]

کانکشن رو open نکردی و ExecuteNonQuery نکردی

[shahram176]

خب من کدم را این طوری نوشتم بازم خطا میده:

string stConnection = WebConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ToString();
SqlConnection cnc = new SqlConnection(stConnection);
string stCmd = "INSERT INTO tpayment(username,banknam,fishno,dtvariz,amount,st atus";
stCmd += ")VALUSE(@username,@banknam,@fishno,@dtvariz,@amoun t,@status";
stCmd += ")";
SqlConnection csd = new SqlConnection(stCmd,cnc);
csd.Parameters.AddWithValue("@username",Session["karbar"] );
csd.Parameters.AddWithValue("@banknam",DropDownList3.SelectedValue);
csd.Parameters.AddWithValue("@fishno",TextBox5.Text );
csd.parameters.AddWithValue("@dtvariz",TextBox6.Text);
csd.parameters.AddWithValue("@amount",TextBox7.Text);
csd.parameters.AssWithValue("@status",false );
int upp = 0;
try
{
cnc.Open();
upp = csd.ExecuteNonQuery();
if (upp > 0)
{
Response.Redirect("Message.aspx?id=2");
}
else
{
Response.Redirect("Message.aspx?id=4");
}
}

finally
{
cnc.Close();
}

[mehrzad_ali]

خطا رو بزار

[shahram176]

http://upload7.ir/imgs/2014-03/52918000373898476390.png