ODBC 连接的使用

来源：互联网发布：猎豹浏览器 for mac 编辑：程序博客网时间：2024/05/01 22:24

string strSQL = sqlStr;

ConnectionClass objBPOCn = new ConnectionClass();

objBPOCn.Open2(common.BPOSever, UserSession.Current.LoginAccount, UserSession.Current.LoginPwd,

common.BPOPort, true, true);

BPOLib.IDSCClass cc = new IDSCClass();

cc.Open(objBPOCn, strBindDatabase);

string strCon = @"DSN=" + cc.DSN + ";Uid=" + cc.UID + ";Pwd=" + cc.Pwd;

Response.Write(" <script> alert( ' " + strSQL + " '); </script> ");

System.Data.Odbc.OdbcConnection testq = new System.Data.Odbc.OdbcConnection(strCon);

//SqlConnection testq = new SqlConnection(strCon);

testq.Open();

OdbcDataAdapter sda = new OdbcDataAdapter();

sda.SelectCommand = new OdbcCommand();

sda.SelectCommand.Connection = testq;

sda.SelectCommand.CommandText = "exec P_MediaModPayeeAccount ?";

sda.SelectCommand.CommandType = CommandType.StoredProcedure;

//string[] arr1 = parms.Split(',');

//string[] arr2 = parmsvalue.Split(',');

sda.SelectCommand.Parameters.Add("@TvMedia_ID", OdbcType.VarChar, 20);

sda.SelectCommand.Parameters[0].Value = "1";

OdbcParameter p = new OdbcParameter("@TvMedia_ID", OdbcType.NVarChar, 20, "1");

sda.SelectCommand.Parameters.Add(p);

DataSet ds = new DataSet();

sda.Fill(ds);

testq.Close();

objBPOCn.Close();