string qurrey = "select Dtime as 时间,OpName as 姓名,Status_door as 门,Status_okey as 1号,Status_tkey as 2号,Status_ockey as 1#,Status_tckey as 2# from Pro_dact left join KeyPassword on Pro_dact.Password=KeyPassword.Password ";//order by Dtime desc";
DataTable dtb = sql.GetDataTable(qurrey);public DataTable GetDataTable(String sqlstr)
{
DataTable DT = new DataTable();
//try
{
conn.Close();
conn.Open();
SqlCommand SCD = new SqlCommand(sqlstr, conn);
SDA.SelectCommand = SCD;
SDA.Fill(DT);
return DT;
}
//catch (System.Exception e)
//{
// return null;
//}
}
error message Incorrect syntax near '1'. why??
as [1号],Status_tkey as [2号],Status_ockey as [1#],Status_tckey as [2#] from Pro_dact
Wait
{
DataTable DT = new DataTable();
try
{
conn.Close();
conn.Open();
SqlDataAdapter sqlSvrDbAdp = new SqlDataAdapter(sSql, conn)
SqlDataAdapter.Fill(DT);
return DT;
}
catch (System.Exception e)
{
return null;
}
}