Example #1
0
        private void button2_Click(object sender, EventArgs e)
        {
            DataTable dt  = (DataTable)dataGridView1.DataSource;
            V9        obj = new V9();

            foreach (DataRow row in dt.Rows)
            {
                if (row.RowState == DataRowState.Added)
                {
                    StudentDTO dto = new StudentDTO();
                    dto.Name = (String)row["Name"];
                    dto.DOB  = (DateTime)row["DOB"];

                    obj.Save(dto);
                }
                else if (row.RowState == DataRowState.Modified)
                {
                    StudentDTO dto = new StudentDTO();
                    dto.StudentID = (int)row["StudentID"];
                    dto.Name      = (String)row["Name"];
                    dto.DOB       = (DateTime)row["DOB"];

                    obj.Update(dto);
                }
                else if (row.RowState == DataRowState.Deleted)
                {
                    var sid = (int)row["StudentID", DataRowVersion.Original];
                    obj.Delete(sid);
                }
            }

            dt.AcceptChanges();
        }
Example #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            V9  obj = new V9();
            var dt  = obj.GetAllStudents();

            dataGridView1.DataSource = dt;
        }