private void btnsave_Click(object sender, EventArgs e) { enTimeTable enTimeTable = new enTimeTable(); comTimeTable comTimeTable=new comTimeTable(); int rowcount = gridtimetable.Rows.Count; int i = 1; if (rowcount != 0) { foreach (DataGridViewRow row in gridtimetable.Rows) { Double tick = (100.0/rowcount)*i; progressBarX1.Value =Convert.ToInt32(Math.Ceiling(tick)); enTimeTable.personalCard=row.Cells["_personalIDCard"].Value.ToString(); enTimeTable.timetable = row.Cells["_timetable"].Value.ToString(); enTimeTable.onduty = row.Cells["_onduty"].Value.ToString(); enTimeTable.offduty = row.Cells["_offduty"].Value.ToString(); enTimeTable.clockIn = row.Cells["_clockIn"].Value.ToString(); enTimeTable.clockOut = row.Cells["_clockOut"].Value.ToString(); comTimeTable.insertTimeTable(enTimeTable); i++; } if (progressBarX1.Value >= 100) { MessageBox.Show("บันทึกข้อมูลเรียบร้อยแล้ว"); gridtimetable.Rows.Clear(); progressBarX1.Value = 0; txttextfile.Text = string.Empty; } } else { MessageBox.Show("ไม่พบข้อมูลที่ต้องการบันทึก"); } }
public Boolean insertTimeTable(enTimeTable enTimeTable) { try { str = "INSERT INTO timetable (personalCard,timetable,onduty,offduty,clockIn,clockOut)VALUES(@personalCard,@timetable,@onduty,@offduty,@clockIn,@clockOut);"; Dbcmd = db.GetSqlStringCommand(str); db.AddInParameter(Dbcmd, "@personalCard", DbType.String, enTimeTable.personalCard); db.AddInParameter(Dbcmd, "@timetable", DbType.String, enTimeTable.timetable); db.AddInParameter(Dbcmd, "@onduty", DbType.String, enTimeTable.onduty); db.AddInParameter(Dbcmd, "@offduty", DbType.String, enTimeTable.offduty); db.AddInParameter(Dbcmd, "@clockIn", DbType.String, enTimeTable.clockIn); db.AddInParameter(Dbcmd, "@clockOut", DbType.String, enTimeTable.clockOut); db.ExecuteNonQuery(Dbcmd); return true; } catch (Exception ex) { throw new Exception(ex.Message); } }