110,536
社区成员
发帖
与我相关
我的任务
分享
public partial class Form1 : Form
{
private DataTable routerDataTable;
private BindingSource bs = new BindingSource();
// DataGridView绑定显示的是第一公共属性,所以结构体不能作为绑定对象,只有类才有属性
private class stringArray
{
private string s;
public string S
{
get { return s; }
}
public stringArray(string sa)
{
s = sa;
}
}
private stringArray[] sa = new stringArray[] { new stringArray("a"), new stringArray("b") };
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void buttonBind_Click(object sender, EventArgs e)
{
routerDataTable = DbHelperOleDb.QueryDataTable("select * from router");
dataGridView1.DataSource = routerDataTable;
}
// 删除一行的话必须先选中那一行,然后再按delete键
private void saveButton_Click(object sender, EventArgs e)
{
using (OleDbConnection connection = new OleDbConnection(DbHelperOleDb.connectionString))
{
OleDbDataAdapter da = new OleDbDataAdapter("select * from router", connection);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
da.Update(routerDataTable);
}
}
private void buttonBindArray_Click(object sender, EventArgs e)
{
bs.DataSource = sa;
dataGridView1.DataSource = bs;
}
}