CS文件中,如何获取textbox中的数据进行数据库查询
aspx文件内容:<asp:TableRow>
<asp:TableCell >起<asp:TextBox ID="txtStart" runat="server" Width="95px"></asp:TextBox> <img onclick="WdatePicker({el:$dp.$('txtStart')})" src="My97DatePicker/skin/datePicker.gif" _fcksavedurl="My97DatePicker/skin/datePicker.gif" width="16" height="22" align="absmiddle"/></asp:TableCell>
</asp:TableRow>
<asp:TableRow>
<asp:TableCell >止<asp:TextBox ID="txtEnd" runat="server" Width="95px"></asp:TextBox> <img onclick="WdatePicker({el:$dp.$('txtEnd')})" src="My97DatePicker/skin/datePicker.gif" _fcksavedurl="My97DatePicker/skin/datePicker.gif" width="16" height="22" align="absmiddle"/></asp:TableCell>
</asp:TableRow>
<asp:TableRow >
<asp:TableCell ><asp:Button ID="Button4" Text ="查询" OnClick ="Search_Bill" runat ="server" /></asp:TableCell>
</asp:TableRow>
aspx.cs文件内容:
public DataSet Z_GetMessages()
{
StringBuilder sql = new StringBuilder();
string connectionString = ConfigurationManager.ConnectionStrings["CONNECTIONSTRINGS"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
sql.Append("SELECT DISTINCT a.TG001 AS 单别, a.TG002 AS 单号, a.TG042 AS 单据日期, b.TH007 AS 仓库, (SELECT MC002 FROM CMSMC WHERE MC001 = b.TH007) AS 仓库名称,(SELECT MF002 FROM ADMMF WHERE MF001 = a.CREATOR) AS 录入人 FROM COPTG a INNER JOIN COPTH b ON a.TG001 = b.TH001 AND a.TG002 = b.TH002 WHERE (a.TG042 >= '" +txtStart .Text + "')");
sql.Append("AND (a.TG042 <= '" +txtEnd.Text + "') AND (a.TG023 = 'N') ORDER BY 单据日期 DESC");
SqlDataAdapter da = new SqlDataAdapter(sql.ToString(), conn);
DataSet ds1_Z = new DataSet();
try
{
conn.Open();
da.Fill(ds1_Z, "DataTable");
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
conn.Close();
}
return ds1_Z;
} --------------------编程问答-------------------- sql.Append("SELECT DISTINCT a.TG001 AS 单别, a.TG002 AS 单号, a.TG042 AS 单据日期, b.TH007 AS 仓库, (SELECT MC002 FROM CMSMC WHERE MC001 = b.TH007) AS 仓库名称,(SELECT MF002 FROM ADMMF WHERE MF001 = a.CREATOR) AS 录入人 FROM COPTG a INNER JOIN COPTH b ON a.TG001 = b.TH001 AND a.TG002 = b.TH002 WHERE (a.TG042 >= '" +txtStart .Text + "')");
sql.Append(" AND (a.TG042 <= '" +txtEnd.Text + "') AND (a.TG023 = 'N') ORDER BY 单据日期 DESC");
TG042 是什么类型?
注意红色部分空格 --------------------编程问答-------------------- 不是空格的问题,TG042只是数据库表中的一个字段,
将" +txtStart .Text + "和" +txtEnd.Text + "改成数值的话是正常的
--------------------编程问答-------------------- 我建议调试,把sql的字符串拿出来,然后放到你的数据库中,看看有没有sql错误,就一目了然了。主要是告诉你解决问题的方法,具体还得你去做。 --------------------编程问答-------------------- 看了看,<=后面跟的是一个字符类型。貌似这样是错滴
补充:.NET技术 , C#