protected void Button4_Click(object sender, EventArgs e) { string inNum = this.txtinNum.Text; ListB_Tax.DataSource = DataBaseExecutor.SearchTable(inNum);//不同於增刪修,查詢須回傳datatable並讓gridview直接做連接,才不會又重抓一次SQL Sever中的資料 ListB_Tax.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { string inNum = this.txtinNum.Text; string inDate = this.txtinDate.Text; string inAmt = this.txtinAmt.Text; string inE_R = this.drpE_R.Text; DataBaseExecutor.InsertTable(inNum, inDate, inAmt, inE_R); //DataTable dt = new DataTable(); //dt.Columns.Add("invoiceNumber"); //dt.Columns.Add("invoiceDate"); //dt.Columns.Add("invoiceAmount"); //dt.Columns.Add("Reven_Expen"); //DataRow dw1 = dt.NewRow(); //dw1["invoiceNumber"] = txtinAmt.Text; //dw1["invoiceDate"] = txtinDate.Text; //dw1["invoiceAmount"] = txtinAmt.Text; //dw1["Reven_Expen"] = drpE_R.Text; //dt.Rows.Add(dw1); ListB_Tax.DataSource = DataBaseExecutor.ShowAllTable(); ListB_Tax.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { ListB_Tax.DataSource = DataBaseExecutor.ShowAllTable(); ListB_Tax.DataBind(); } }
protected void Button2_Click(object sender, EventArgs e) { string inNum = this.txtinNum.Text; DataBaseExecutor.DeleteTable(inNum); ListB_Tax.DataSource = DataBaseExecutor.ShowAllTable(); ListB_Tax.DataBind(); }
protected void Button3_Click(object sender, EventArgs e) { string inNum = this.txtinNum.Text; string inDate = this.txtinDate.Text; string inAmt = this.txtinAmt.Text; string inE_R = this.drpE_R.Text; DataBaseExecutor.UpdateTable(inNum, inDate, inAmt, inE_R); ListB_Tax.DataSource = DataBaseExecutor.ShowAllTable(); ListB_Tax.DataBind(); }