求助！

[niu_shu_zhan]

public partial class Form1 : Form
{

SqlConnection cn = new SqlConnection("Data Source=.;Initial Catalog=Student;Integrated Security=True");
SqlCommand command;

SqlDataAdapter adapter;

DataSet ds = new DataSet();

public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e) //查询
{
string sql = "select*from studentinfo";

command = new SqlCommand(sql,cn);

adapter = new SqlDataAdapter(command);




if (ds.Tables["stu"] != null)
{
ds.Tables["stu"].Clear();
}


adapter.Fill(ds, "stu");

dataGridView1.DataSource = ds.Tables["stu"];

}

private void button2_Click(object sender, EventArgs e) //修改
{

SqlCommandBuilder bulider = new SqlCommandBuilder(adapter);


adapter.Update(ds,"stu"); //此处编译不通过


}
}

[bdmh]

什么错误提示

[niu_shu_zhan]

提示sqlselectcoomend不能自动生成sql语句

[雨莫漠]

string sql = "select*from studentinfo";



楼主，你这里要不要空格下-->
string sql = "select * from studentinfo";

[niu_shu_zhan]

应该不是这原因吧

[Bule]

你adapter没有sql语句啊。

[Bule]

主键问题，你update没设置主键，就会报异常。 DataTable myDt=.Tables["stu"]; myDt.PrimaryKey=new DataColumn[]{myDt.Columns["id"]};