ERROR [42S22] [MySQL][ODBC 5.1 Driver][mysqld-5.1.55-community]Unknown column 'id' in 'where clause'
id为我定义的变量的 用一个DetailsView显示有关id的详细信息的;Label1.Text = Request.QueryString["ID"]; string id = Label1.Text;
DetailsView的数据源是这样的??????
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString24 %>"
ProviderName="<%$ ConnectionStrings:ConnectionString24.ProviderName %>"
SelectCommand="SELECT PRODUCTID, TESTTIME, TESTRESULT, TEST_PASSED, TEST_NG, STEP00_VALUE, STEP00_RESULT, STEP01_VALUE, STEP01_RESULT, STEP02_VALUE, STEP02_RESULT, STEP03_VALUE, STEP03_RESULT, STEP04_VALUE, STEP04_RESULT, STEP05_VALUE, STEP05_RESULT, STEP06_VALUE, STEP06_RESULT, STEP07_VALUE, STEP07_RESULT, STEP08_VALUE, STEP08_RESULT, STEP09_VALUE, STEP09_RESULT, STEP10_VALUE, STEP10_RESULT, STEP11_VALUE, STEP11_RESULT, STEP12_VALUE, STEP12_RESULT, STEP13_VALUE, STEP13_RESULT, STEP14_VALUE, STEP14_RESULT, STEP15_VALUE, STEP15_RESULT, STEP16_VALUE, STEP16_RESULT, STEP17_VALUE, STEP17_RESULT, STEP18_VALUE, STEP18_RESULT, STEP19_VALUE, STEP19_RESULT, STEP20_VALUE, STEP20_RESULT, STEP21_VALUE, STEP21_RESULT, STEP22_VALUE, STEP22_RESULT, STEP23_VALUE, STEP23_RESULT, STEP24_VALUE, STEP24_RESULT, STEP25_VALUE, STEP25_RESULT, STEP26_VALUE, STEP26_RESULT, STEP27_VALUE, STEP27_RESULT, STEP28_VALUE, STEP28_RESULT FROM sd200 WHERE (PRODUCTID = id)">
</asp:SqlDataSource>
id为我定义的变量的 用一个DetailsView显示有关id的详细信息的;Label1.Text = Request.QueryString["ID"]; string id = Label1.Text;
DetailsView的数据源是这样的??????
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString24 %>"
ProviderName="<%$ ConnectionStrings:ConnectionString24.ProviderName %>"
SelectCommand="SELECT PRODUCTID, TESTTIME, TESTRESULT, TEST_PASSED, TEST_NG, STEP00_VALUE, STEP00_RESULT, STEP01_VALUE, STEP01_RESULT, STEP02_VALUE, STEP02_RESULT, STEP03_VALUE, STEP03_RESULT, STEP04_VALUE, STEP04_RESULT, STEP05_VALUE, STEP05_RESULT, STEP06_VALUE, STEP06_RESULT, STEP07_VALUE, STEP07_RESULT, STEP08_VALUE, STEP08_RESULT, STEP09_VALUE, STEP09_RESULT, STEP10_VALUE, STEP10_RESULT, STEP11_VALUE, STEP11_RESULT, STEP12_VALUE, STEP12_RESULT, STEP13_VALUE, STEP13_RESULT, STEP14_VALUE, STEP14_RESULT, STEP15_VALUE, STEP15_RESULT, STEP16_VALUE, STEP16_RESULT, STEP17_VALUE, STEP17_RESULT, STEP18_VALUE, STEP18_RESULT, STEP19_VALUE, STEP19_RESULT, STEP20_VALUE, STEP20_RESULT, STEP21_VALUE, STEP21_RESULT, STEP22_VALUE, STEP22_RESULT, STEP23_VALUE, STEP23_RESULT, STEP24_VALUE, STEP24_RESULT, STEP25_VALUE, STEP25_RESULT, STEP26_VALUE, STEP26_RESULT, STEP27_VALUE, STEP27_RESULT, STEP28_VALUE, STEP28_RESULT FROM sd200 WHERE (PRODUCTID = id)">
</asp:SqlDataSource>
Request.QueryString["InduId"]