ใช้ String.Format ค้นหาจาก TextBox สามารถเพิ่มเงื่อนไขได้ไหมครับ

clsMyFilter.Update("yourTable", new { PK1 = 1, PK2=2 }, new { Value1 = "Update1", Value2="Update2" });

    public static class clsMyFilter
    {
        private static string CommaSeparated(IEnumerable<string> list) => string.Join(",", list);
        private static string SeparatedByAndStatement(IEnumerable<string> list) => string.Join(" AND ", list);
        public static async Task Update(this IDbConnection con, string tableName, object identityParameters, object parametersObject)
        {
            IEnumerable<PropertyInfo> propertyInfo = parametersObject.GetType().GetProperties();
            IEnumerable<PropertyInfo> identityPropertyInfo = identityParameters.GetType().GetProperties();
            IEnumerable<string> columnsEqualToParameter = propertyInfo.Select(p => $"[{p.Name}] = @{p.Name}");
            IEnumerable<string> identityColumnsEqualToParameter = identityPropertyInfo.Select(p => $"[{p.Name}] = @{p.Name}");

            string sql = new StringBuilder()
               .Append("UPDATE " + tableName + " SET ")
               .Append(CommaSeparated(columnsEqualToParameter))
               .Append($" WHERE ")
               .Append(SeparatedByAndStatement(identityColumnsEqualToParameter))
               .Append(";")
               .ToString();

            IDictionary<string, object> allParameters = new ExpandoObject();

            foreach (PropertyInfo info in propertyInfo)
                allParameters.Add(info.Name, parametersObject.GetType().GetProperty(info.Name).GetValue(parametersObject));

            foreach (PropertyInfo info in identityPropertyInfo)
                allParameters.Add(info.Name, identityParameters.GetType().GetProperty(info.Name).GetValue(identityParameters));

            await con.ExecuteAsync(sql, allParameters);
        }
    }