Пример #1
0
        public student_details()
        {
            InitializeComponent();
            //gvStudent.Columns.Add("studentId", "Student Id");
            //gvStudent.Columns.Add("name", "Name");
            //gvStudent.Columns.Add("dob", "DOB");
            //gvStudent.Columns.Add("gpa", "GPA");
            //gvStudent.Columns.Add("active", "Active");
            //gvStudent.Columns.Add("copy", "copy");
            //gvStudent.Columns["copy"].Visible = false;
            try
            {
                DataSet ds = new DataSet();
                student_b stu = new student_b();
                ds = stu.records();

                DataTable dtAll = ds.Tables[0].Copy();
                for (var i = 1; i < ds.Tables.Count; i++)
                {
                    dtAll.Merge(ds.Tables[i]);
                }
                gvStudent.AutoGenerateColumns = true;
                gvStudent.DataSource = dtAll;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Пример #2
0
        private void txtSave_Click(object sender, EventArgs e)
        {
            student_b student = new student_b();

            for (int i = 0; i < gvStudent.Rows.Count; i++)
            {
                student.StudnetId =gvStudent.Rows[i].Cells[0].Value.ToString();
                student.Name = gvStudent.Rows[i].Cells[0].Value.ToString();
                student.Dob = gvStudent.Rows[i].Cells[0].Value.ToString();
                student.Gpa = Convert.ToDouble(gvStudent.Rows[i].Cells[0].Value.ToString());
                student.Active =Convert.ToInt32( gvStudent.Rows[i].Cells[0].Value.ToString());
                if (student.insertStudnetInfo())
                {
                   lbMsg.Text=i+"Record Inserted";
                }
            }
        }