MysqlConnection conn = new MysqlConnection("...");
DataTable dt = conn.GetSchema("Tables");

//foreach table

DataTable dt = conn.GetSchema("Columns",column_res);

//generate prepared statement sql by the columns.

DataTable dt = conn.GetSchema("Columns",column_res);