private static void InsertTest()
{
string sql = "insert into user(Id,Name) values(?Id,?Name);";
MySqlParameter[] spArr = new MySqlParameter[] {
new MySqlParameter("Id", 2),
new MySqlParameter("Name", "leaf")
};
int r = MySqlHelper1.ExecuteNonQuery(sql, spArr);
Console.WriteLine(r);
}
static void Main1(string[] args)
{
//TestConnection();
//InsertTest();
//ExecuteDataTableTest();
string sql = "select count(1) from user";
int rowCount = Convert.ToInt32(MySqlHelper1.ExecuteScalar(sql));
Console.WriteLine(rowCount);
Console.Read();
}
private static void ExecuteDataTableTest()
{
string sql = "select * from user";
DataTable dt = MySqlHelper1.ExecuteDataTable(sql);
foreach (DataRow dr in dt.Rows)
{
foreach (DataColumn dc in dt.Columns)
{
Console.Write("{0}:{1}\t", dc.ColumnName, dr[dc.ColumnName].ToString());
}
Console.WriteLine();
}
}