关于调试带参数的sql语句-优快云博客

本文链接：https://blog.youkuaiyun.com/overmind/article/details/271587

博客给出了一个SQL命令跟踪函数TraceErrorSql，用于替换SQL参数。还展示了一个根据产品类型和名称查询产品的方法getProductsByName，使用SqlConnection、SqlCommand等进行数据库操作，将查询结果填充到DataSet中并返回DataTable。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Definition---------------------------------------------

public static string TraceErrorSql(string strSqlCmd, SqlParameterCollection SqlParamsCollection)
  {
   if(SqlParamsCollection != null)
    for(int i=0;i<SqlParamsCollection.Count;i++)
    {
     if(SqlParamsCollection[i] != null)
      strSqlCmd = strSqlCmd.Replace(SqlParamsCollection[i].ParameterName, "'" + SqlParamsCollection[i].Value + "'");
    }
   return strSqlCmd;
  }
}

Usage------------------------------------------------------------

  public DataTable getProductsByName(string productType,string productName) {
   SqlConnection l_SqlConnenction = new SqlConnection();
   l_SqlConnenction.ConnectionString = "workstation id=OVERMIND;packet size=4096;user id=sa;password=sa;data source=OVERMIND;persist security info=False;initial catalog=wztj";
   l_SqlConnenction.Open();
   string SelectCommandText = "select * from Product where productType=@productType and name like @produtName";
   SqlCommand l_SqlCommand = new SqlCommand(SelectCommandText,l_SqlConnenction);


   l_SqlCommand.Parameters.Add("@productType",productType);
   SqlParameter par1 = new SqlParameter("@produtName",SqlDbType.VarChar,500);
   par1.Value ="%"+ productName+"%";
   l_SqlCommand.Parameters.Add(par1);

string sql = TestSQL.TraceErrorSql(SelectCommandText,l_SqlCommand.Parameters);

   DataSet dataset = new DataSet();
   SqlDataAdapter adapter = new SqlDataAdapter();
   adapter.SelectCommand = l_SqlCommand;
   adapter.Fill(dataset,"product");
   DataTable dt = dataset.Tables["product"];
   l_SqlConnenction.Close();
   return dt;
  }