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];
}
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];
}
