public void TestSqlInsertCreater() { string expected = "INSERT INTO Test (field1,field2) VALUES (10,20)"; List <SqlFieldValuePair> fieldValuePairs = new List <SqlFieldValuePair>() { new SqlFieldValuePair( new KeyValuePair <string, object>("field1", 10), SqlCompareOperator.Equal), new SqlFieldValuePair( new KeyValuePair <string, object>("field2", 20), SqlCompareOperator.Equal), }; string result = SqlCommandCreater.CreateInsertCommand("Test", fieldValuePairs); Assert.AreEqual(expected, result); }
private string CreateCommand() { var row = dataGridView_AddRow.Rows[0]; List <SqlFieldValuePair> pairs = new List <SqlFieldValuePair>(); foreach (DataGridViewColumn column in dataGridView_AddRow.Columns) { int index = column.Index; if (row.Cells[index].Value != null) { pairs.Add(new SqlFieldValuePair( new KeyValuePair <string, object>(column.Name, row.Cells[index]), SqlCompareOperator.Equal)); } } return(SqlCommandCreater.CreateInsertCommand(CurrentTable.Name, pairs)); }