private void AttendanceForm_Load(object sender, EventArgs e)
{
AttendanceClass a = new AttendanceClass();
DataTable dt = a.Select();
dataGridView.DataSource = dt;
}
public void Insert(AttendanceClass attendanceClass)
{
sqlQuery = "insert into Attendance (ma,thoigian, alias) " +
" values ('" + attendanceClass.ma + "','" + attendanceClass.attendanceTime + "', N'" + attendanceClass.alias + "')";
conString.ConString constring = new conString.ConString(); //this will hide the database info ... sort of
try
{
using (var con = new SqlConnection(constring.initString()))
{
using (var cmd = new SqlCommand(sqlQuery, con))
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
catch (SqlException ex)
{
}
}
