vs2005的代码运行时报错：第 1 行: '0' 附近有语法错误。

Question

public void bindgrid()
{
string str = ConfigurationSettings.AppSettings["dsn"];
SqlConnection cn = new SqlConnection(str);
cn.Open();
string order = "Select kaoqin.kid,kaoqin.uid,kaoqin.uname,kaoqin.kqdate,kaoqin.dgdate,kaoqin.cq,kaoqin.sj,kaoqin.bj,kaoqin.gj,kaoqin.kg,kaoqin.hj,kaoqin.sj1,kaoqin.gxj,kaoqin.tqj,kaoqin.pc,kaoqin.cc,kaoqin.dx,user1.uid from kaoqin,user1 where kaoqin.uid=user1.Uid";
if (DropDownList4.SelectedValue.ToString()!="-1")
{
order=order + DropDownList4.SelectedValue.ToString();

}
String date = DropDownList1.SelectedValue.ToString();
order = order + date;
SqlDataAdapter da=new SqlDataAdapter(order ,cn);

DataTable tb = new DataTable();
da.Fill(tb);
this.GridView1.DataSourceID = null;
this.GridView1.DataSource = tb;
this.GridView1.DataBind();
cn.Close();
} protected void Button6_Click(object sender, EventArgs e)
{
bindgrid();
}

}

说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.SqlClient.SqlException: 第 1 行: '0' 附近有语法错误。

源错误:

行 52:
行 53: DataTable tb = new DataTable();
行 54: da.Fill(tb);
行 55: this.GridView1.DataSourceID = null;
行 56: this.GridView1.DataSource = tb;

源文件: e:\Documents and Settings\Administrator\My Documents\Visual

Answer 1

用try{}catch(){}包起来.