示例#1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                var dbConString = ConfigurationManager.ConnectionStrings["CustomerDB"].ConnectionString;
                var con         = new SqlConnection(dbConString);

                string sql = "SELECT * FROM Customers";
                sql = "SELECT * FROM Customers WHERE firstName LIKE @firstName +'%'";

                var cmd = new SqlCommand();
                cmd.CommandText = sql;
                cmd.Connection  = con;

                // If including Parameters
                SqlParameter p1 = new SqlParameter();
                p1.ParameterName = "firstName";
                p1.Direction     = System.Data.ParameterDirection.Input;
                p1.Value         = Request.Form["firstName"]; // must not be empty
                p1.Size          = 100;

                // don't forget to add parameter to query
                cmd.Parameters.Add(p1);

                // open the con and run the query
                con.Open();

                var r = cmd.ExecuteReader();
                if (r.HasRows)
                {
                    GVCustomers.DataSource = r;
                    GVCustomers.DataBind();
                }
            }
        }
 protected void FillUsers()
 {
     using (PTCLEntities db = new PTCLEntities())
     {
         var Users = db.GetPtclUsers().ToList();
         GVCustomers.DataSource = Users;
         GVCustomers.DataBind();
         GVCustomers.UseAccessibleHeader = true;
         if (GVCustomers.Rows.Count > 0)
         {
             GVCustomers.HeaderRow.TableSection = TableRowSection.TableHeader;
         }
         else
         {
             lblCustomersMsg.Text = "No Record to Show";
         }
     }
 }