mysql 数据库dbhelp_C# VS连接数据库DBhelp

#region 执行查询全部SQL语句,返回DataTable;查询全部

DataTable dt=OracleHelper.ExecuteDataTable(sqlString);for (int i = 0; i < dt.Rows.Count; i++)

{

DataRow mydr=dt.Rows[i];string email = mydr["email"].ToString();

}public static DataTable ExecuteDataTable(string sql, paramsOracleParameter[] parameters)

{

OracleConnection connection= newOracleConnection(connStr);

OracleCommand cmd= newOracleCommand(sql, connection);try{if (connection.State !=ConnectionState.Open)

{

connection.Open();

}

cmd.CommandText=sql;

cmd.Parameters.AddRange(parameters);

OracleDataAdapter adapter= newOracleDataAdapter(cmd);

DataTable datatable= newDataTable();

adapter.Fill(datatable);returndatatable;

}catch(System.Exception ex)

{

connection.Close()