sql result saved into c# variable

See more:

SQL-Server-2005

C#

SQL-Server

Hi

How do i save sql result saved into c# variable

Please correct me below is my code i have to find total number rows in DeliveryOrdertable and save it to count variable.

public void autono()
    {
        int count;
        SqlDataReader reader = null;
        string connectionString = ConfigurationManager.ConnectionStrings["InvoiceConnectionString"].ConnectionString;
        SqlConnection conn = new SqlConnection(connectionString);  
        string selectcmd = " SELECT count(*)as numberofrows FROM DeliveryOrder" ;
        SqlCommand cmd = new SqlCommand(selectcmd, conn);

    
        conn.Open();
        reader = cmd.ExecuteReader();
        
        while (reader.Read())
        {
            count = Convert.ToInt32(reader);
                
            conn.Close();
                

        }    }

Regards
Lancy