protected void btnSubmit_Click(object sender, EventArgs e) { string aID; int iD = 1; iD = iD + 1; aID = iD.ToString(); int pNum = Convert.ToInt32(txPH.Text); string firstName = txFname.Text; string lastName = txLname.Text; string email = txMail.Text; string passWord = txPw.Text; //string adminID = Convert.ToString(aID); BusLayer busLayer = new BusLayer(); try { busLayer.InsertAdminDet(aID, firstName, lastName, email, pNum, passWord); GridTest.DataSource = busLayer.SelectAdminDet(); GridTest.DataBind(); if (Page.IsValid) { Response.Redirect("AdminLogIn.aspx"); } } catch { Response.Redirect("ErrorPage.aspx"); } }
/// <summary>绑定Grid列表 /// 绑定Grid列表 /// </summary> /// <param name="OrderRegisterList">数据源LIST集合</param> private void BindGridTest(List <OrderRegister> OrderRegisterList) { GridTest.DataSource = OrderRegisterList; try { GridTest.DataBind(); } catch (Exception) { } }
/// <summary>绑定Grid列表 /// 绑定Grid列表 /// </summary> /// <param name="OrderRegisterList">数据源LIST集合</param> private void BindGridTest(List <OrderRegister> OrderRegisterList) { ViewState["GridTest"] = OrderRegisterList; GridTest.Rows.Clear(); GridTest.DataSource = OrderRegisterList; try { GridTest.DataBind(); } catch (Exception) { } }
public void loaddata() { try { ds = new DataSet(); ds = dm.GetTestDetails(); GridTest.DataSource = ds; GridTest.DataBind(); } catch (SqlException ex) { ShowMessageBox("Remote Acess Not Available"); } }
private void gridTestShow() { string sql = "select * from Courses where Teacher=@teach and Duration <@dur"; OleDbCommand myCmdTest = new OleDbCommand(sql, myCon); //OleDbParameter myPar = new OleDbParameter("teach", "Houria Houmel"); //myCmdTest.Parameters.Add(myPar); myCmdTest.Parameters.AddWithValue("teach", "Houria Houmel"); myCmdTest.Parameters.AddWithValue("dur", 50); OleDbDataReader rdTest = myCmdTest.ExecuteReader(); GridTest.DataSource = rdTest; GridTest.DataBind(); }
/// <summary> /// 绑定Grid列表 /// </summary> /// <param name="OrderRegisterList">数据源LIST集合</param> private void BindGridTest(List <OrderRegister> OrderRegisterList) { ViewState["GridTest"] = OrderRegisterList; GridTest.DataSource = OrderRegisterList; GridTest.DataBind(); }
protected void GridTest_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridTest.PageIndex = e.NewPageIndex; loaddata(); GridTest.DataBind(); }