SqlDataReader与SqlDataAdapter读取数据库

 private void Practice()  

{   SqlConnection sqlconn=new SqlConnection("server=.;DataBase=DB_MyZone;uid=sa;psw=0"); 

  sqlconn.Open();  

 SqlCommand sqlcomm=new SqlCommand("select vc_URL from tb_MyMusic");   

SqlDataReader dr=new SqlDataReader();  

 dr=sqlcomm.ExecuteReader();   

while(dr.Read())   

{  

  for(int i=0;i<dr.FieldCount;i++)  

  {     this.Response.Write(dr.GetValue(i).ToString()+dr[i].ToString());   

 }   

}   

SqlConnection conn=new SqlConnection("server=.;database=DB_MyZone;uid=sa;psw=0");  

 SqlDataAdapter sda=new SqlDataAdapter("select vc_URL from tb_MyMusic",conn);   

conn.Open();   

DataTable dt=new DataTable();   

sda.Fill(dt);   

for(int i=0;i<=dt.Rows.Count;i++)  

 {    this.Response.Write(dt.Rows[i][0].ToString());  

 } 

 }