protected void Button2_Click(object sender, EventArgs e) { if (DropDownList2.SelectedValue == "Insert") { if (DropDownList1.SelectedValue == "Users") { string[] insertcol = { "License", "Privilege", "CreateDate", "WhoCreate" }; string[] insertcolp = { "@License", "@Privilege", "@CreateDate", "@WhoCreate" }; List <string> userinsert = new List <string>(); userinsert.Add(Text1.Text); userinsert.Add(Text2.Text); userinsert.Add(Text3.Text); userinsert.Add(Text4.Text); DBTool.InsertTable("Users", insertcol, insertcolp, userinsert); Label7.Text = "插入資料完成"; string[] readcol = { "UserID", "Account", "Name", "Phone", "Mail", "LineID", "License", "Privilege", "CreateDate", "WhoCreate" }; this.Repeater1.DataSource = DBTool.readTable("Users", readcol); this.Repeater1.DataBind(); } else if (DropDownList1.SelectedValue == "Projects") { string[] insertcol = { "ProjectName", "TeamID", "TeamName", "DeadLine", "CreateDate", "WhoCreate" }; string[] insertcolp = { "@ProjectName", "@TeamID", "@TeamName", "@DeadLine", "@CreateDate", "@WhoCreate" }; List <string> userinsert = new List <string>(); userinsert.Add(Text1.Text); userinsert.Add(Text2.Text); userinsert.Add(Text3.Text); userinsert.Add(Text4.Text); userinsert.Add(Text5.Text); userinsert.Add(Text6.Text); DBTool.InsertTable("Projects", insertcol, insertcolp, userinsert); Label7.Text = "插入資料完成"; string[] readcol = { "ProjectID", "ProjectName", "TeamID", "TeamName", "DeadLine", "CreateDate", "WhoCreate" }; this.Repeater1.DataSource = DBTool.readTable("Projects", readcol); this.Repeater1.DataBind(); } } else if (DropDownList2.SelectedValue == "Update") { if (DropDownList1.SelectedValue == "Users") { string[] updatecol = { "Account=@Account", "Name=@Name", "Phone=@Phone", "Mail=@Mail", "LineID=@LineID" }; string wherep = "License=@License"; string[] updatecolp = { "@Account", "@Name", "@Phone", "@Mail", "@LineID", "@License" }; List <string> userupdate = new List <string>(); userupdate.Add(Text1.Text); userupdate.Add(Text2.Text); userupdate.Add(Text3.Text); userupdate.Add(Text4.Text); userupdate.Add(Text5.Text); userupdate.Add(Text6.Text); DBTool.UpdateTable("Users", updatecol, wherep, updatecolp, userupdate); Label7.Text = "更新資料完成"; string[] readcol = { "UserID", "Account", "Name", "Phone", "Mail", "LineID", "License", "Privilege", "CreateDate", "WhoCreate" }; this.Repeater1.DataSource = DBTool.readTable("Users", readcol); this.Repeater1.DataBind(); } else if (DropDownList1.SelectedValue == "Projects") { string[] updatecol = { "ProjectName=@ProjectName", "TeamID=@TeamID", "TeamName=@TeamName", "DeadLine=@DeadLine" }; string wherep = "ProjectID=@ProjectID"; string[] updatecolp = { "@ProjectName", "@TeamID", "@TeamName", "@DeadLine", "@ProjectID" }; List <string> userupdate = new List <string>(); userupdate.Add(Text1.Text); userupdate.Add(Text2.Text); userupdate.Add(Text3.Text); userupdate.Add(Text4.Text); userupdate.Add(Text5.Text); DBTool.UpdateTable("Projects", updatecol, wherep, updatecolp, userupdate); Label7.Text = "更新資料完成"; string[] readcol = { "ProjectID", "ProjectName", "TeamID", "TeamName", "DeadLine", "CreateDate", "WhoCreate" }; this.Repeater1.DataSource = DBTool.readTable("Projects", readcol); this.Repeater1.DataBind(); } } else if (DropDownList2.SelectedValue == "Delete") { if (DropDownList1.SelectedValue == "Users") { string rdbVal = this.RadioButtonList1.SelectedValue; DBTool.DeleteTable("Users", "UserID", "@UserID", rdbVal); string[] readcol = { "UserID", "Account", "Name", "Phone", "Mail", "LineID", "License", "Privilege", "CreateDate", "WhoCreate" }; this.Repeater1.DataSource = DBTool.readTable("Users", readcol); this.Repeater1.DataBind(); this.RadioButtonList1.Items.Clear(); string[] readcol2 = { "UserID", "Account", "Name" }; string wantdelete = ""; foreach (DataRow item in DBTool.readTable("Users", readcol).Rows) { wantdelete = $"ID:{item[0]} 帳號:{item[1]} 姓名:{item[2]}"; RadioButtonList1.Items.Add(new ListItem($"{wantdelete}", $"{item[0]}")); } } else if (DropDownList1.SelectedValue == "Projects") { string rdbVal = this.RadioButtonList1.SelectedValue; DBTool.DeleteTable("Projects", "ProjectID", "@ProjectID", rdbVal); string[] readcol = { "ProjectID", "ProjectName", "TeamID", "TeamName", "DeadLine", "CreateDate", "WhoCreate" }; this.Repeater1.DataSource = DBTool.readTable("Projects", readcol); this.Repeater1.DataBind(); this.RadioButtonList1.Items.Clear(); string[] readcol2 = { "ProjectID", "ProjectName", "TeamName" }; string wantdelete = ""; foreach (DataRow item in DBTool.readTable("Projects", readcol).Rows) { wantdelete = $"ID:{item[0]} 專案:{item[1]} 負責組:{item[2]}"; RadioButtonList1.Items.Add(new ListItem($"{wantdelete}", $"{item[0]}")); } } } }