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();