Question

C#中 winform dataGridview 如何写入数据库？mdf文件。下面是代码和保存按钮下的代码

private student_dbmlDataContext database = new student_dbmlDataContext();
private void studentBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
Validate();
studentBindingSource.EndEdit();
database.SubmitChanges();
}
求linq高手

Answer 1

//连接数据库
static string str = "server=(local);database=saleDB;integrated security=true";
SqlConnection conn = null;
SqlCommand comm = null;
//创建一个适配器
SqlDataAdapter da;
private void btnShow_Click(object sender, EventArgs e)
{
conn = new SqlConnection(str);
//SQL语句
comm = new SqlCommand("SELECT * FROM productInfo", conn);
//读取数据库中的文件,然后写入da中
da = new SqlDataAdapter(comm);
//在内存中创建一个临时的表table
DataTable table = new DataTable();
//读取数据库,填充表
da.Fill(table);
dataGridView的文件源DataSource为那个临时表table
this.dataGridView.DataSource = table;

}

Answer 2

我在你远程计算机上写吧？

Answer 3

要用到sqlconnection sqlcommand 这2个对象 去查吧