阅读背景:

如何使用通配符搜索参数化?

来源:互联网 
public DataTable Search()
{
    DataTable dt = new DataTable();
    SqlCommand searchcommand = new SqlCommand(
        "Select * from [ITEM MASTER] WHERE Item_Description LIKE  '%' @Item_Description  '%' ", con);

    searchcommand.Parameters.Add("@Item_Description", SqlDbType.NVarChar).Value = search;
    SqlDataAdapter da = new SqlDataAdapter(searchcommand);
    da.Fill(dt);
    return dt;
}
public DataTable Search()
{
    DataTable dt = 



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: