Problema "QueryNonStop"

[jrlcp32]

protected void btnGuardarVars_Click(object sender, EventArgs e)
	{
		string conn = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
		using (SqlConnection con = new SqlConnection(conn))
		{
			SqlCommand cmd = new SqlCommand("Insert into ErpFinancialVars(ErpFinancialVarId, Variable, Description, BuildUpBalanceSignal, Year, Month, Value) values(@ErpFinancialVarId, @Variable, @Description, @BuildUpBalanceSignal, @Year, @Month, @Value)", con);

			cmd.CommandType = CommandType.Text;

			cmd.Parameters.AddWithValue("@ErpFinancialVarId", txtID.Text.Trim());
			cmd.Parameters.AddWithValue("@Variable", txtVariable.Text.Trim());
			cmd.Parameters.AddWithValue("@Description", txtDescription.Text.Trim());
			cmd.Parameters.AddWithValue("@BuildUpBalanceSignal", txtBUBSignal.Text.Trim());
			cmd.Parameters.AddWithValue("@Year", txtYear.Text.Trim());
			cmd.Parameters.AddWithValue("@Month", txtMonth.Text.Trim());
			cmd.Parameters.AddWithValue("@Value", txtValue.Text.Trim());
			con.Open();
			cmd.ExecuteNonQuery();
		}
	}

Edited May 24, 2012 at 08:44 AM by M6

[M6]

jrlcp32,

por favor coloca apenas um tópico para uma única dúvida e coloca a questão de forma clara e simples.