DB连接-SQLServer

   近来，有个项目出了点问题，需要写个工具。需要用到查数据库，然后做些处理。

   将自己写的范例附上，便于今后查阅。

private void recover_patient_id(String id ,ref String strResult)

{

string connStr = "Driver={"; connStr += SdbDriver; connStr += "};";

connStr += "Server="; connStr += sSdbIP; connStr += ";";

connStr += "Uid="; connStr += SdbUser; connStr += ";";

connStr += "Pwd="; connStr += SdbPassword; connStr += ";";

connStr += "Database="; connStr += SdbName; connStr += ";";

connStr += "Port="; connStr += SdbPort; connStr += ";";

OdbcConnection conn_test = new OdbcConnection(connStr);

//检验连接数据库是否成功

try

{

conn_test.Open();

String sql ="select * from temp where id = ?";

OdbcCommand com = new OdbcCommand(sql,conn_test);

com.Parameters.AddWithValue("@id", id);

using (OdbcDataReader reader = com.ExecuteReader())

    {

    while (reader.Read())

       {

        String str1 = reader.GetString(0);

        String str2 = reader.GetString(1);

        }

  } 

catch (OdbcException ex)

{

LogFile.SaveExLog("Error connecting to the server database: " + ex.Message);

}

conn_test.Close();

}