Error generating invoice number.

Question

Hello everyone

 

I am migrating from vb.net to C Sharp.

 

I am trying to generate the invoice number, but I am getting several errors.

using (var cnx = new SqlConnection(VariablesGlobales.CadenaConexion))                 {                     cnx.Open();                      using (SqlCommand cmd = cnx.CreateCommand;                     {                         string maximo;                         var Agregar = new SqlCommand();                          Agregar.Connection = cnx;                         Agregar.CommandType = CommandType.Text;                         Agregar.CommandText = "select Max(CodigoFactura) As maximo FROM TblaFactura2";                          object objeto = Agregar.ExecuteScalar;                         if (objeto is DBNull)                         {                             maximo = 1.ToString();                             txtCodigoFactura.Text = maximo;                         }                          else                         {                             maximo = (Convert.ToInt64(Agregar.ExecuteScalar) + 1L).ToString();                             txtCodigoFactura.Text = maximo;                          }                     }                 } 

You already know I count on your help.

Answer 1

Unlike in VB you need to use parenthesis to call a method (e.g. cnx.CreateCommand should be cnx.CreateCommand()), like this:

using (SqlCommand cmd = cnx.CreateCommand())
{
	// ...
}

object objeto = Agregar.ExecuteScalar();

Also you're creating two SqlCommand instances (cmd and Agregar) but you're only using one of them (Agregar) so you could get rid of cmd all together.