SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["sql"]);
SqlCommand GetCmd=new SqlCommand("select top 5 * from test order by id desc",conn);
SqlDataReader dr;
conn.Open();
dr=GetCmd.ExecuteReader();
while (dr.Read())
{   
int newsid=Convert.ToInt16(dr["id"]); 
id.Text+="<table border=1><tr><td>";
        id.Text+= dr["id"].ToString();
username.Text+="</tr></td><tr><td>";
username.Text+=dr["userName"].ToString();
pwds.Text+="</tr></td><tr><td>";
pwds.Text+=dr["pwd"].ToString();
pwds.Text+="</td></tr></table>";
}
conn.Close();