c#winform winform接続oracleデータベース
private void button1_Click(object sender, EventArgs e)
{
MessageBox.Show(groupBox1, " !");
int count = 0;
try
{
string ConnectionString = "Data Source=dzjc_2005;user=kk;password=kk;";//
OracleConnection conn = new OracleConnection(ConnectionString);//
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from kk.kkyh";// sql
OracleDataReader odr = cmd.ExecuteReader();// OracleDateReader
while (odr.Read())// , odr.Read() false ,
{
count++;
MessageBox.Show(odr.GetOracleString(1).ToString());// 1, ,
}
odr.Close();
if (count > 0)
{
MessageBox.Show(groupBox1, " !");
this.Close();
}
else
{
MessageBox.Show(groupBox1, " !");
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message.ToString());
}
}
USing Systemを導入する必要がある.Data.OracleClient;
テストとしてのみ使用
黒い髪http://heisetoufa.iteye.com