这是我的代码
public static string GetUserName(String userId)
{
using (OracleConnection conn = DBHelp.GetConnection())
{
string sql = "select UserName from Users where userId = '2010'";
OracleCommand cmd = conn.CreateCommand();
sql = string.Format(sql, userId);
cmd.CommandText = sql;
conn.Open(); OracleDataReader dr = cmd.ExecuteReader(); if (dr.Read())
{
return dr["UserName"].ToString();
} //Users u = PopUserFromDataReader(dr); dr.Close();
conn.Close(); return "";
}
}
DBHelp.GetConnection()这个是sqlclient的方法,怎么把它转换成Oracleclient啊
我原来用的sql的数据库,现在换成了Oracle问题挺多的?怎么办 求大神指教!!!
public static string GetUserName(String userId)
{
using (OracleConnection conn = DBHelp.GetConnection())
{
string sql = "select UserName from Users where userId = '2010'";
OracleCommand cmd = conn.CreateCommand();
sql = string.Format(sql, userId);
cmd.CommandText = sql;
conn.Open(); OracleDataReader dr = cmd.ExecuteReader(); if (dr.Read())
{
return dr["UserName"].ToString();
} //Users u = PopUserFromDataReader(dr); dr.Close();
conn.Close(); return "";
}
}
DBHelp.GetConnection()这个是sqlclient的方法,怎么把它转换成Oracleclient啊
我原来用的sql的数据库,现在换成了Oracle问题挺多的?怎么办 求大神指教!!!
很简单,写代码实现GetConnection功能。