试试这个

Try this

 DataTable dt = new DataTable();
            try
            {
                con = da_con.DA_Connect();
                SqlCommand cmd = new SqlCommand("FetchShopSellerOnId", con);
                cmd.CommandType = CommandType.StoredProcedure;
                SqlDataAdapter sqlDa = new SqlDataAdapter();
                sqlDa.SelectCommand = cmd;
                sqlDa.Fill(dt);
<pre> foreach (DataRow dRow in dt.Rows)
                {
                    if (dt.Rows.Count > 0)
                    {
           Label11.Tex   = dRow["ShopOfficeDetailsId"].ToString();

                  }
}

In Above Code

In Above Code

dRow["ShopOfficeDetailsId"].ToString();

ShopOfficeDetailsID用于存储过程，例如。选择ShopOfficeDetailsID ,,您可以使用您的ID名称

ShopOfficeDetailsID is used in stored procedure eg. Select ShopOfficeDetailsID ,, You can use your ID name