#region 執(zhí)行查詢?nèi)縎QL語句,返回DataTable;查詢?nèi)?/p>

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();//Console.WriteLine(ex.ToString());

return null;

}finally{

connection.Close();

}

}#endregion#region執(zhí)行插入或修改SQL語句,返回True& false;if(OracleHelper.UpdateOpera(updateStr))

{

MessageBox.Show("成功")

}public static bool UpdateOpera(string sql, paramsOracleParameter[] parameters)

{

OracleConnection connection= newOracleConnection(connStr);

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

{

connection.Open();

}

cmd.CommandText=sql;return cmd.ExecuteNonQuery() > 0;

}catch(System.Exception ex)

{

connection.Close();//Console.WriteLine(ex.ToString());

return false;

}finally{

connection.Close();

}

}#endregion#region執(zhí)行查詢SQL語句,返回是否存在;

OracleDataReader reader=OracleHelper.ExecuteReader(sqlCount);while(reader.Read())

{//存在去修改

}public static OracleDataReader ExecuteReader(string strSQL, paramsOracleParameter[] parameters)

{

connection= newOracleConnection(connStr);

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

{

connection.Open();

}

OracleDataReader myReader=cmd.ExecuteReader();returnmyReader;

}catch(OracleException e)

{

connection.Close();throw newException(e.Message);

}//finally//{//connection.Close();//}

}#endregion

總結(jié)

以上是生活随笔為你收集整理的mysql 数据库dbhelp_C# VS连接数据库DBhelp的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。