Recovering quantity of records in a table

[see07]

Hello:

I�m trying to obtain quantity of records in a table that meet certain criteria.

When I run the project I�m obtaining an error: �Specified conversion isn�t valid�, this in line where I put value of command to TextBox2.

What is bad in this script?

I�ll thank your help.

A.L.

 

 

private void Button3_Click(object sender, System.EventArgs e)

{

sqlConnection1.Open();

SqlCommand comandante = new SqlCommand("Comando",sqlConnection1);

comandante.CommandType = CommandType.Text;

comandante.CommandText = "SELECT count(*) FROM PETICION where(id_status = 1)";

TextBox2.Text = (string)(comandante.ExecuteScalar());

sqlConnection1.Close();

}

[Arch4ngel]

Check that commandante.ExecuteScalar() doesn't return a null pointer.

 

If it return null... no cast can be made.

[PlausiblyDamp]

Try

TextBox2.Text=comandante.ExecuteScalar().ToString();

[see07]

Thanks you PlausibleDamp, your suggestion is orking very well, you re so gentle ith me, again thanks you.....

Thanks you too Arch4angel....