using System.Text;
public DataTable Select(string A,string B)
{
StringBuilder sb=new StringBuilder("SELECT * FROM tablename WHERR 1=1");
sb.Append(A==String.Empty? "":"AND Column1='"+A+"'");
sb.Append(B==String.Empty? "":"AND Column2='"+B+"'");
//如果有更多的查詢參數,可以繼續Append;
string sqlSelect=sb.ToString();
//下面就是傳回你按條件查詢得的DataTable了
}