private void rdtp_refresh_Click(object sender, EventArgs e) { data_readertype.DataBindings.Clear(); data_readertype.DataSource = ReaderType_ad.br_data(); rdtp_select_choose.Text = "rdType"; rdtp_choose.Text = "查询"; }
private void rdtp_excutebtn_Click(object sender, EventArgs e) { tbox2rdtp(); string choose = rdtp_choose.Text; try { switch (choose) { case "插入": ReaderType_ad.run_insql(rt, 0); rdtp_refresh_Click(null, null); MessageBox.Show("Success", "lol", MessageBoxButtons.OK); break; case "更新": ReaderType_ad.run_insql(rt, 1); rdtp_refresh_Click(null, null); MessageBox.Show("Success", "lol", MessageBoxButtons.OK); break; case "删除": ReaderType_ad.run_insql(rt, 2); rdtp_refresh_Click(null, null); MessageBox.Show("Success", "lol", MessageBoxButtons.OK); break; case "查询": rdtp_select(string.Format("select * from dbo.readertype where {0} like '{1}'", rdtp_select_choose.Text, rdtp_select_text.Text)); break; } } catch { MessageBox.Show("Fail", "qoq", MessageBoxButtons.OK); } }
private void data_readertype_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e) { rt = ReaderType_ad.Row2rdtp((data_readertype.CurrentRow.DataBoundItem as DataRowView).Row); rdtp2tbox(rt); }
private void rdtp_select(string sql) { data_readertype.DataBindings.Clear(); data_readertype.DataSource = ReaderType_ad.runsql(sql); }