列名无效

[ab83328523]

String ID1 = Request.QueryString["did"].ToString();
int ID = Convert.ToInt32(ID1);
string sql = "select reply,ISreply from SL_daily where daily_id=ID"; SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connstr"]);
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(sql, con);
//SqlDataAdapter sda = new SqlDataAdapter("select reply,ISreply from SL_daily where daily_id"=+ID, con);
DataSet ds = new DataSet();

sda.Fill(ds, "daily");

报错 列名无效 ，怎么回事

[ab83328523]

错出在下面这行

sda.Fill(ds, "daily");

[cpp2017]

string sql = "select reply,ISreply from SL_daily where daily_id=ID";

==>
string sql = "select reply,ISreply from SL_daily where daily_id="+ID.ToString()
;

[oec2003]

string sql = "select reply,ISreply from SL_daily where daily_id="+ID.ToString();     

[ab83328523]

问题解决 了 ，谢谢了