private void StudentDetails_Load(object sender, EventArgs e) { DalStDetails dsd1 = new DalStDetails(); dsd1.numGet();//Calls the numGet() method in Data Access Layer to get the next auto generated number table.Columns.Add("StId", typeof(string)); table.Columns.Add("StName", typeof(string)); table.Columns.Add("Dob", typeof(DateTime)); table.Columns.Add("Gpa", typeof(decimal)); table.Columns.Add("Active", typeof(int)); }
private void btnSave_Click(object sender, EventArgs e) { DalStDetails dsd = new DalStDetails(); //Validate the Grid data if (grdStDetails.Rows.Count != 0) { for (int i = 0; i < grdStDetails.Rows.Count; i++) { table.Rows.Add(grdStDetails[0, i].Value.ToString(), grdStDetails[1, i].Value.ToString(), grdStDetails[2, i].Value.ToString(), grdStDetails[3, i].Value, grdStDetails[4, i].Value); } dsd.saveStDetails(table);//Call the saveStDetails() method in Data Access Layer this.Dispose(); } else { MessageBox.Show("No Student Records to update???", "Error"); } }