我用winform做了一个linq to sql的简单查询,增删改是窗体原来的控件,那我想问一下,怎么样把操作后的数据更新到数据库中呢?
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;namespace linq_demo
{
public partial class Form1 : Form
{
DataClasses1DataContext aresData = new DataClasses1DataContext();
public Form1()
{
InitializeComponent();
} private void Form1_Load(object sender, EventArgs e)
{
studentBindingSource.DataSource = aresData.student;
} private void studentBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
aresData.SubmitChanges();
} }
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;namespace linq_demo
{
public partial class Form1 : Form
{
DataClasses1DataContext aresData = new DataClasses1DataContext();
public Form1()
{
InitializeComponent();
} private void Form1_Load(object sender, EventArgs e)
{
studentBindingSource.DataSource = aresData.student;
} private void studentBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
aresData.SubmitChanges();
} }
}
C#语法不懂,大概就是
1、在数据库中建表
2、拼接连接串,用ADO建立到数据库的连接
3、SubmitChanges()中引用连接句柄,执行更新语句