Return to Snippet

Revision: 2385
at February 7, 2007 05:32 by gndprx


Updated Code
private void bindSomething()
    {
        string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString_From_WebConfig"].ConnectionString;
        SqlConnection conn = new SqlConnection(connectionString);
        string selectSQL = "Select * from tablename";
        SqlCommand getStuff = new SqlCommand(selectSQL, conn);

        try
        {
            conn.Open();
            SqlDataReader reader = getStuff.ExecuteReader();
            while (reader.Read() == true)
            {
                someLabel.Text = Convert.ToString(reader["column1"]);
                someLabel2.Text = Convert.ToString(reader["column2"]);
            }
            reader.Close();
        }
        catch
        {
            Response.Write("Error retrieving data");
        }
        finally
        {
            conn.Close();
        }
    }

Revision: 2384
at February 7, 2007 05:31 by gndprx


Initial Code
private void bindArticle()
    {
        string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString_From_WebConfig"].ConnectionString;
        SqlConnection conn = new SqlConnection(connectionString);
        string selectSQL = "Select * from tablename";
        SqlCommand getStuff = new SqlCommand(selectSQL, conn);

        try
        {
            conn.Open();
            SqlDataReader reader = getStuff.ExecuteReader();
            while (reader.Read() == true)
            {
                someLabel.Text = Convert.ToString(reader["column1"]);
                someLabel2.Text = Convert.ToString(reader["column2"]);
            }
            reader.Close();
        }
        catch
        {
            Response.Write("Error retrieving data");
        }
        finally
        {
            conn.Close();
        }
    }

Initial URL

                                

Initial Description

                                

Initial Title
Simple SqlDataReader C# / .Net 2.0

Initial Tags

                                

Initial Language
C#