private void btnBDelete_Click(object sender, EventArgs e) { string sql = "delete Buses where BusID=@BusID"; SqlParameter[] para = { new SqlParameter("@BusID", txtBusID.Text) }; DBHelperSQL.TableChange(sql, para); BusesShow(); }
private void btnDDelete_Click(object sender, EventArgs e) { string sql = @"DELETE FROM [test2011].[dbo].[Driver] WHERE [EmpID] =@EmpID"; SqlParameter[] para = { new SqlParameter("@EmpID", txtEmpID.Text) }; DBHelperSQL.TableChange(sql, para); DriverShow(); }
private void btnBUpdate_Click(object sender, EventArgs e) { string sql = "update Buses set Supplier=@Supplier where BusID=@BusID"; SqlParameter[] para = { new SqlParameter("@BusID", txtBusID.Text), new SqlParameter("@Supplier", txtSupplier.Text) }; DBHelperSQL.TableChange(sql, para); BusesShow(); }
private void btnBAdd_Click(object sender, EventArgs e) { string sql = "insert into Buses values(@BusID,@Supplier)"; SqlParameter[] para = { new SqlParameter("@BusID", txtBusID.Text), new SqlParameter("@Supplier", txtSupplier.Text) }; DBHelperSQL.TableChange(sql, para); BusesShow(); }
private void btnLDelete_Click(object sender, EventArgs e) { string sql = @"DELETE FROM [test2011].[dbo].[Lines] WHERE [LineID] = @LineID"; SqlParameter[] para = { new SqlParameter("@LineID", txtLineID.Text) }; DBHelperSQL.TableChange(sql, para); LinesShow(); }
private void btnTDelete_Click(object sender, EventArgs e) { string sql = @"DELETE FROM [test2011].[dbo].[Timetable] WHERE [LineID] = @LineID And [BusID] = @BusID and [EmpID] =@EmpID"; SqlParameter[] para = { new SqlParameter("@LineID", txtLineIDT.Text), new SqlParameter("@EmpID", txtEmpIDT.Text), new SqlParameter("@BusID", txtBusIDT.Text) }; DBHelperSQL.TableChange(sql, para); TimetableShow(); }
private void btnTUpdate_Click(object sender, EventArgs e) { string sql = @"UPDATE [test2011].[dbo].[Timetable] SET [EmpID] =@EmpID ,[BusID] = @BusID ,[StartTime] =@StartTime WHERE [LineID] = @LineID"; SqlParameter[] para = { new SqlParameter("@LineID", txtLineIDT.Text), new SqlParameter("@EmpID", txtEmpIDT.Text), new SqlParameter("@BusID", txtBusIDT.Text), new SqlParameter("@StartTime", txtStartTime.Text) }; DBHelperSQL.TableChange(sql, para); TimetableShow(); }
private void btnLUpdate_Click(object sender, EventArgs e) { string sql = @"UPDATE [test2011].[dbo].[Lines] SET [StartP] = @StartP ,[EndP] = @EndP ,[Distance] = @Distance WHERE [LineID] = @LineID"; SqlParameter[] para = { new SqlParameter("@LineID", txtLineID.Text), new SqlParameter("@StartP", txtStart.Text), new SqlParameter("@EndP", txtEnd.Text), new SqlParameter("@Distance", txtDistance.Text) }; DBHelperSQL.TableChange(sql, para); LinesShow(); }
private void btnTAdd_Click(object sender, EventArgs e) { string sql = @"INSERT INTO [test2011].[dbo].[Timetable] ([LineID] ,[EmpID] ,[BusID] ,[StartTime]) VALUES(@LineID,@EmpID,@BusID,@StartTime)"; SqlParameter[] para = { new SqlParameter("@LineID", txtLineIDT.Text), new SqlParameter("@EmpID", txtEmpIDT.Text), new SqlParameter("@BusID", txtBusIDT.Text), new SqlParameter("@StartTime", txtStartTime.Text) }; DBHelperSQL.TableChange(sql, para); TimetableShow(); }
private void btnLAdd_Click(object sender, EventArgs e) { string sql = @"INSERT INTO [test2011].[dbo].[Lines] ([LineID] ,[StartP] ,[EndP] ,[Distance]) VALUES(@LineID,@StartP,@EndP,@Distance)"; SqlParameter[] para = { new SqlParameter("@LineID", txtLineID.Text), new SqlParameter("@StartP", txtStart.Text), new SqlParameter("@EndP", txtEnd.Text), new SqlParameter("@Distance", txtDistance.Text) }; DBHelperSQL.TableChange(sql, para); LinesShow(); }
private void btnDUpdate_Click(object sender, EventArgs e) { string sql = @"UPDATE [test2011].[dbo].[Driver] SET [DName] = @DName, [Sex] =@Sex, [Age] = @Age, [Tel] = @Tel, [Pwd] = @Pwd WHERE [EmpID] =@EmpID"; SqlParameter[] para = { new SqlParameter("@EmpID", txtEmpID.Text), new SqlParameter("@DName", txtDName.Text), new SqlParameter("@Sex", txtSex.Text), new SqlParameter("@Age", txtAge.Text), new SqlParameter("@Tel", txtTel.Text), new SqlParameter("@Pwd", txtPwd.Text) }; DBHelperSQL.TableChange(sql, para); }
private void btnDAdd_Click(object sender, EventArgs e) { string sql = @"INSERT INTO [test2011].[dbo].[Driver] ([EmpID] ,[DName] ,[Sex] ,[Age] ,[Tel] ,[Pwd]) VALUES(@EmpID,@DName,@Sex,@Age,@Tel,@Pwd)"; SqlParameter[] para = { new SqlParameter("@EmpID", txtEmpID.Text), new SqlParameter("@DName", txtDName.Text), new SqlParameter("@Sex", txtSex.Text), new SqlParameter("@Age", txtAge.Text), new SqlParameter("@Tel", txtTel.Text), new SqlParameter("@Pwd", txtPwd.Text) }; DBHelperSQL.TableChange(sql, para); DriverShow(); }