在数据库中读字段！在线等>>>

Question

  SqlConnection con = new SqlConnection(@"server=.;uid=sa;pwd=sa;database=Wish");
        SqlCommand com=new SqlCommand("select cpId,cpName,cpImages from ChanPin",con);
        con.Open();
        SqlDataReader red = com.ExecuteReader(CommandBehavior.CloseConnection);
        while (red.Read())
        {
            Response.ContentType="application/octet-stream"; 
                Response.BinaryWrite((Byte[])red["cpImages"]);
                Response.Write(red.GetOrdinal("cpId"));
                Response.Write(red.GetOrdinal("cpName"));
                Response.End(); 
                red.Close();        }
        con.Close();
       怎么样才能显示cpId字段和cpName 这是产品的型号和产品的名称，现在想读出来显示在cpImages产品图片下面，怎么做！

Answer 1

Response.ContentType="application/octet-stream";
                Response.BinaryWrite((Byte[])red["cpImages"]);
                Response.Write(“<br/>");
                Response.Write(red.GetOrdinal("cpId"));
                Response.Write(red.GetOrdinal("cpName"));
                Response.End();
                red.Close();