Question

求求各位大虾，帮我看看下面这个在ASP.NET里的SQL语句，，哪里错了？谢谢！！

1-》
if (IsNumberic(tb_sj.Text) == true) { this.tb_sj.Text = string.Format("{0:F0}", Convert.ToDouble(tb_sj.Text)); Etextbox("Dplansell", "DPSSJ", tb_sj.Text, "DPSdatetime",lbldate.Text); } else { Response.Write("<script>alert(' 抱歉！只能输入数字！')</script>"); this.tb_sj.Text = ""; this.tb_sj.Focus(); }
2-》
public void Etextbox(string Stable,string Stextbox,string strtbox,string Sdatetime,string strdate) { //根据日期查询是否有数据存在！！ string sql = "select * from '" + Stable + "' where '" + Sdatetime + "'='" + strdate + "'"; SqlConnection con = pub.createCon(); con.Open(); SqlCommand com = new SqlCommand(); com.Connection = con; com.CommandText = sql; SqlDataReader dr = com.ExecuteReader();

Answer 1

表名是不需要 【‘】这个符号的，你的SQL语句写错了。

更正如下：

string sql = "select * from  " + Stable + " where " + Sdatetime + "='" + strdate + "'";

Answer 2

string sql = "select * from '" + Stable + "' where '" + Sdatetime + "'='" + strdate + "'";
改成
string sql = "select * from " + Stable + " where " + Sdatetime + "='" + strdate + "'";
或者 这样更清新
string sql = string.Format("select * from {0} where {1} = '{2}'", Stable, Sdatetime, strdate);

Answer 3

from table 的 table 无需引号