1:SELECT * FROM 表名 where 日期字段 like date_format(now(),"%X/%U%")
2:
前台:
div class="form-search">
<input class="input-medium search-query" type="text" ID="inputMatDcode" runat="server"/>
<asp:button type="submit" class="btn" ID="BtnmatDcodeQ" runat="server" OnClick="BtnmatDcodeQ_Click" Text="查询编辑材料代码"/>
</div>
台后 C#:
DB db = new DB();
//定义SQL语句
//declare @MatDcodeCha nvarchar(40);
string MatDcodeCha = this.inputMatDcode.Value;
string sqlstr = "SELECT ..........where BaMatDCode.matDCode LIKE '%" + MatDcodeCha + "%' ORDER BY