ADo.net

Jul 30 2013 7:37 AM
I wrote this like ,if any mistake is their, correct it and send
 SqlConnection con = new SqlConnection("DataSource=WEBDEV1-PC;Initial Catalog=srinu;User Id=sa;Password=pftec");
            SqlCommand cmd = new SqlCommand("select * from Approval_Matrix_Setup", con);
            con.Open();
          
           SqlDataReader dr= cmd.ExecuteReader();

           while (dr.Read())
           {
               //answer
           }


for all  i need to get the full data of the table
      in   the Response.Write


Answers (1)