C#Á¬½ÓORACLEʲô·½Ê½Ð§ÂÊ±È½Ï - .NET¼¼Êõ / C#

ÈçÌâ

---

¹Ø×¢£¬¶¥!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

---

C# code:

string queryString = "SELECT USERINFO.USERNAME from USERINFO WHERE UESERID='" + uid + "'";
using (OracleConnection connection = new OracleConnection(connectionString))
{
OracleCommand command = new OracleCommand(queryString, connection);
connection.Open();
MySqlDataAdapter mysqlda = new MySqlDataAdapter(command, connection);
DataSet dataset = new DataSet();
mysqlda.Fill(dataset, "tablename");
if(dataset != null)
{
DataTable dt = dataset.Tables["tablename"];
string username = dt.Rows[0][0].ToString();
}

---

ÒýÓÃ

C# code

string queryString = "SELECT USERINFO.USERNAME from USERINFO WHERE UESERID='" + uid + "'";
using (OracleConnection connection = new OracleConnection(connectionString))
{
¡­¡­

¸úSQL²î²»¶àµÄ

---

net×Ô´øµÄ·½Ê½°É¡£

---

ûÓÐÕâÖָоõ

---

ÎÒÓõÄÒ»Ö±ÊÇÄǸöoracleClient

---

ÎÒÓÃODP.NET,¸Ð覺±ÈMSµÄºÃÓÃ