private void button3_Click(object sender, EventArgs e)
{
string connectionString = "server=localhost;database=Train;integrated security=SSPI";
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
string sql = "with abc(a,b) as " +
"(select 车次,max([2]) " +
"from tmp " +
"group by 车次)" +
"select * " +
"from tmp,abc" +
"where tmp.车次=abc.a and tmp.发站='北京' and tmp.[2]=abc.b";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter dadpter = new SqlDataAdapter(cmd);
DataSet myDataSet = new DataSet();
int numberOfRows = dadpter.Fill(myDataSet,"one");
dataGridView1.DataSource = myDataSet.Tables["one"];
conn.Close();
}
每次点击button3 是就提示 "."附近有语法错
错误是在int numberOfRows = dadpter.Fill(myDataSet,"one");这句
{
string connectionString = "server=localhost;database=Train;integrated security=SSPI";
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
string sql = "with abc(a,b) as " +
"(select 车次,max([2]) " +
"from tmp " +
"group by 车次)" +
"select * " +
"from tmp,abc" +
"where tmp.车次=abc.a and tmp.发站='北京' and tmp.[2]=abc.b";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter dadpter = new SqlDataAdapter(cmd);
DataSet myDataSet = new DataSet();
int numberOfRows = dadpter.Fill(myDataSet,"one");
dataGridView1.DataSource = myDataSet.Tables["one"];
conn.Close();
}
每次点击button3 是就提示 "."附近有语法错
错误是在int numberOfRows = dadpter.Fill(myDataSet,"one");这句
"where tmp.车次=abc.a and tmp.发站='北京' and tmp.[2]=abc.b"你跟一下这句中的sql串是什么,
SqlCommand cmd = new SqlCommand(sql, conn);要是没问题,再打开SQLSERVER的工具PROFILE跟踪一下发的SQL就知道哪里错了。