コード例 #1
0
ファイル: studentinfo.cs プロジェクト: jaychem/studentinfor
        public void load_dataGridView1()
        {
            try
            {
                Cursor.Current = Cursors.WaitCursor;
                //BindingSource bindingsource = new BindingSource();
                dataGridView1.Rows.Clear();
                List <DBstuinfo> rec = DBstuinfo.GetData();
                foreach (DBstuinfo data in rec)
                {
                    string[] row = new string[] { data.Id.ToString(), data.FirstName, data.LastName, data.MiddleName, data.Course, data.Year.ToString(), data.Address };
                    dataGridView1.Rows.Add(row);
                    dataGridView1.Refresh();
                }

                //   bindingsource.Add(data);

                //this.dataGridView1.Refresh();
                //this.dataGridView1.AutoGenerateColumns = false;
                //this.dataGridView1.DataSource = bindingsource;
                //this.dataGridView1.ClearSelection();

                Cursor.Current = Cursors.Default;
            }
            catch (Exception ex)
            {
                ex.ToString();
            }
        }
コード例 #2
0
        public static List <DBstuinfo> GetData()
        {
            List <DBstuinfo> data = new List <DBstuinfo>();

            MySqlConnection con = stuinfocon.ConnectDatabase();

            try
            {
                MySqlCommand    cmd    = new MySqlCommand("SELECT * FROM " + tablename, con);
                MySqlDataReader reader = cmd.ExecuteReader();

                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        DBstuinfo rawData = new DBstuinfo();
                        rawData.Id         = reader.GetInt32(0);
                        rawData.FirstName  = reader.GetString(1);
                        rawData.LastName   = reader.GetString(2);
                        rawData.MiddleName = reader.GetString(3);
                        rawData.Course     = reader.GetString(4);
                        rawData.Year       = reader.GetInt32(5);
                        rawData.Address    = reader.GetString(6);

                        data.Add(rawData);
                    }
                }

                reader.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                con.Close();
            }

            return(data);
        }
コード例 #3
0
        public static DBstuinfo GetDataID(int id)
        {
            DBstuinfo data = null;

            MySqlConnection con = stuinfocon.ConnectDatabase();

            try
            {
                MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + tablename + " WHERE id=" + id, con);

                MySqlDataReader reader = cmd.ExecuteReader();

                if (reader.HasRows)
                {
                    reader.Read();

                    data            = new DBstuinfo();
                    data.Id         = reader.GetInt32(0);
                    data.FirstName  = reader.GetString(1);
                    data.LastName   = reader.GetString(2);
                    data.MiddleName = reader.GetString(3);
                    data.Course     = reader.GetString(4);
                    data.Year       = reader.GetInt32(5);
                    data.Address    = reader.GetString(6);
                }

                reader.Close();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                con.Close();
            }

            return(data);
        }
コード例 #4
0
ファイル: studentinfo.cs プロジェクト: jaychem/studentinfor
        private void buttonS_Click(object sender, EventArgs e)
        {
            enAbleButton();
            if (isAdd == true)
            {
                DBstuinfo add = new DBstuinfo(textBoxF.Text, textBoxL.Text, textBoxM.Text, comboBoxC.Text, Convert.ToInt32(comboBoxY.Text), textBoxA.Text);
                add.Add();

                load_dataGridView1();

                MessageBox.Show("Added successfuly");
            }
            else if (isAdd == false)
            {
                try
                {
                    int idx = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString());

                    DBstuinfo cards = DBstuinfo.GetDataID(idx);

                    cards.FirstName  = textBoxF.Text;
                    cards.LastName   = textBoxL.Text;
                    cards.MiddleName = textBoxM.Text;
                    cards.Course     = comboBoxC.Text;
                    cards.Year       = Convert.ToInt32(comboBoxY.Text);
                    cards.Address    = textBoxA.Text;

                    cards.Update();
                    load_dataGridView1();
                    MessageBox.Show("Edited successfuly");
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error updating record " + ex.Message);
                }
            }
        }
コード例 #5
0
ファイル: studentinfo.cs プロジェクト: jaychem/studentinfor
        private void buttonD_Click(object sender, EventArgs e)
        {
            try
            {
                int idx = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString());

                DBstuinfo cards = DBstuinfo.GetDataID(idx);

                if (cards != null)
                {
                    DialogResult dialogResult = MessageBox.Show(" Do you want to delete this record?", "Delete", MessageBoxButtons.YesNo);

                    if (dialogResult == DialogResult.Yes)
                    {
                        cards.Delete();
                        load_dataGridView1();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error deleting record " + ex.Message);
            }
        }