Esempio n. 1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            String     query   = "SELECT * from [dbo].[Posts] order by PostedDate";
            SqlCommand command = new SqlCommand(query, conn);

            conn.Open();
            SqlDataAdapter sda = new SqlDataAdapter(command);
            DataTable      dt  = new DataTable();

            sda.Fill(dt);
            RepBlogDetails.DataSource = dt;
            RepBlogDetails.DataBind();
            conn.Close();
        }
Esempio n. 2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string        mainconn = ConfigurationManager.ConnectionStrings["Myconnection"].ConnectionString;
            SqlConnection sqlconn  = new SqlConnection(mainconn);
            string        sqlquery = "select * from [dbo].[blog] where Bcategory='Movies'";

            sqlconn.Open();
            SqlCommand     sqlcomm = new SqlCommand(sqlquery, sqlconn);
            SqlDataAdapter sda     = new SqlDataAdapter(sqlcomm);
            DataTable      dt      = new DataTable();

            sda.Fill(dt);
            RepBlogDetails.DataSource = dt;
            RepBlogDetails.DataBind();
            sqlconn.Close();
        }