Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Jun 9th, 2012  |  syntax: None  |  size: 0.85 KB  |  hits: 19  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using System.Web.UI;
  6. using System.Web.UI.WebControls;
  7. using System.Data;
  8. using System.Data.SqlClient;
  9. using System.Configuration;
  10. namespace WebApplication1
  11. {
  12.     public partial class Product : System.Web.UI.Page
  13.     {
  14.         protected void Page_Load(object sender, EventArgs e)
  15.         {
  16.             String connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
  17.             SqlConnection conn = new SqlConnection(connStr);
  18.             String sql = "SELECT * From Product";
  19.             DataSet Products = new DataSet();
  20.             SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
  21.             adapter.Fill(Products, "Product");
  22.             GridView1.DataSource = Products;
  23.             GridView1.DataBind();
  24.         }
  25.     }
  26. }