private void TestSQLCommand()
{
// Debug.Listeners.Add(listener);
SqlDataAccess sql = new SqlDataAccess();
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@cement_id", 100);
var value = sql.ExecuteDeleteQuery("DELETE FROM cement where cement_id=@cement_id", para);
Debug.WriteLine("Query result: " + value);
/*
* param = new SqlParameter("@cement_id", 2);
* SqlParameter[] para = new SqlParameter[1];
* para[0] = param;
*
* DataTable results = sql.ExecuteSelectQuery("select * from cement where cement_id = @cement_id", para);
* for (int i = 0; i < results.Count; i++)
* {
* Debug.WriteLine(results.GetElementAt(i).Value("cement_id").ToString());
* Debug.WriteLine(results.GetElementAt(i).Value("name").ToString());
* Debug.WriteLine(results.GetElementAt(i).Value("symbol").ToString());
* }
* Debug.Flush();
* List<SqlParameter> para2 = new List<SqlParameter>();
* para2.Add(new SqlParameter("cement_id", 102));
* para2.Add(new SqlParameter("symbol", "LINH"));
* para2.Add(new SqlParameter("name", "No"));
* sql.ExecuteInsertOrUpdateQuery("insert into cement values(@cement_id,@symbol,@name)", para2.ToArray());
*/
return;
}