All pastes #991140 Raw Edit

nubby mcnubnub

public text v1 · immutable
#991140 ·published 2008-04-20 19:14 UTC
rendered paste body
protected void Page_Load(object sender, EventArgs e)
    {

        //Opens the connection using 
        string Conn = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\db.mdf;Integrated Security=True;User Instance=True";
        using (SqlConnection con = new SqlConnection(Conn))
{
        con.Open();

        string sql = "select * from RSS";
        SqlCommand cmd = new SqlCommand(sql, con);
        SqlDataReader reader = cmd.ExecuteReader();
        int count = 0;
        while (reader.Read())
        {
            string url = reader[1].ToString();
            string name = reader[2].ToString();
            
            results.InnerHTML(name + ": " + url + "<br />");
        }
        reader.Close();

        con.Close();
}

    }