private void insert_Click(object sender, EventArgs e) { StudentDB db = new StudentDB(); try { db.istudentNum = db.primarykey(); db.iname = tbName.Text.ToString(); db.iphone = tbPhone.Text.ToString(); db.insert(); tbName.Text = ""; tbPhone.Text = ""; MessageBox.Show("register a book."); } catch (FormatException) { MessageBox.Show("error"); tbName.Text = ""; tbPhone.Text = ""; } catch (OverflowException) { MessageBox.Show("error"); tbName.Text = ""; tbPhone.Text = ""; } }
private void button1_Click(object sender, EventArgs e) { StudentDB db = new StudentDB(); db.DBOpen(); DataSet ds = db.GetData(Convert.ToInt32(tbStudentNumber.Text), tbName.Text.ToString()); dataGridView1.DataSource = ds.Tables[0]; }