返回select行數

string strCon = "Data Source=xxx;Database=db;Uid=xx;Pwd=xx";
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection connection = new SqlConnection(strCon);
            connection.Open();
            string username = Environment.UserName;
            string sql = "select 語句";
            SqlCommand sqlcom = new SqlCommand(sql, connection);
            string n = sqlcom.ExecuteScalar().ToString ();
            if (n!="0")
            {
                Response.Redirect("頁面");
            }
        }

 

1、返回update、delete、insert的行数
int   rows   =   cmd.ExecuteNonQuery();