string sql = "SELECT * FROM xyz WHERE col1 = @val1 AND col2 = @val2";
SqlParameter para1 = new SqlParameter("@val1", DBNull.Value)
string sql = "SELECT * FROM xyz WHERE col1 IS NULL AND col2 = @val2";
SELECT * FROM xyz WHERE (@VAL1 IS NULL OR col1 IS NULL OR col1 = @val1) AND col2 = @val2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)