DataTableWithParameters

DataTableWithParameters.cs

public DataTable ExecuteQuery(string sql, string connectionString, object param = null)
{
    using var conn = new SqlConnection(connectionString);
    using var cmd = new SqlCommand(sql, conn);

    if (param != null)
    {
        foreach (var prop in param.GetType().GetProperties())
        {
            var value = prop.GetValue(param);
            cmd.Parameters.AddWithValue("@" + prop.Name, value ?? DBNull.Value);
        }
    }

    using var adapter = new SqlDataAdapter(cmd);

    var dt = new DataTable();
    adapter.Fill(dt);

    return dt;
}