代码如下。
class DBConnect
{
public DBConnect()
{
}
public void conntest()
{
OdbcConnection conn = new OdbcConnection("DSN=CenterDB;UID=xxxx;Pwd=123456;");
OdbcCommand catCMD = conn.CreateCommand();
catCMD.CommandText = "select site_no,site_name from TSM_SITE";
conn.Open();
OdbcDataReader myReader = catCMD.ExecuteReader();
while (myReader.Read())
{
Console.WriteLine("{0} {1}", myReader.GetString(0),myReader.GetString(1));
}
myReader.Close(); conn.Close();
} }
site_no在数据库里面的类型是VARCHAR2(20)
site_name 是VARCHAR2(164)
程序运行在OdbcDataReader myReader = catCMD.ExecuteReader();这句报“算术运算导致溢出”错误。各位大神。这是咋回事啊。c# RACLE OracleC#
class DBConnect
{
public DBConnect()
{
}
public void conntest()
{
OdbcConnection conn = new OdbcConnection("DSN=CenterDB;UID=xxxx;Pwd=123456;");
OdbcCommand catCMD = conn.CreateCommand();
catCMD.CommandText = "select site_no,site_name from TSM_SITE";
conn.Open();
OdbcDataReader myReader = catCMD.ExecuteReader();
while (myReader.Read())
{
Console.WriteLine("{0} {1}", myReader.GetString(0),myReader.GetString(1));
}
myReader.Close(); conn.Close();
} }
site_no在数据库里面的类型是VARCHAR2(20)
site_name 是VARCHAR2(164)
程序运行在OdbcDataReader myReader = catCMD.ExecuteReader();这句报“算术运算导致溢出”错误。各位大神。这是咋回事啊。c# RACLE OracleC#
conn.Open();
string sql = "select * from tbl_aa ";
OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds, "ds");
dataGridView1.DataSource = ds.Tables[0];