calling SQLLDR from C# (ASP.NET) - Oracle Server
来源:互联网 发布:食品淘宝怎么上传 编辑:程序博客网 时间:2024/05/17 01:54
version 1:---------------String strRunCommand = "SQLLDR "+p_DbConnection+" data='"+p_LoadSourcePath+strTxtFileName+"' control="+strFileType+".ctl log="+strLogFileName+" SKIP=1 ERRORS=10BINDSIZE=1048576";System.IO.File.Create(p_LoadDestinationPath+"load_run.bat").Close);StreamWriter sw = newStreamWriterp_LoadDestinationPath+"load_run.bat");sw.WriteLine(strRunCommand);sw.Close();System.Diagnostics.Process p = new Process();p.StartInfo.RedirectStandardOutput=false;p.StartInfo.FileName = p_LoadDestinationPath+"load_run.bat";p.StartInfo.UseShellExecute = false;p.StartInfo.WorkingDirectory = p_LoadDestinationPath;p.StartInfo.RedirectStandardError = true;p.Start();p.WaitForExit();//wait with no time limitp.Dispose();---------------version 2:---------------String strRunCommand = "SQLLDR "+p_DbConnection+" data='"+p_LoadSourcePath+strTxtFileName+"' control="+strFileType+".ctl log="+strLogFileName+" SKIP=1 ERRORS=10BINDSIZE=1048576";System.IO.File.Create(p_LoadDestinationPath+"load_run.bat").Close);StreamWriter sw = newStreamWriterp_LoadDestinationPath+"load_run.bat");sw.WriteLine(strRunCommand);sw.Close();System.Diagnostics.ProcessStartInfo psi = newSystem.Diagnostics.ProcessStartInfo("cmd.exe");psi.UseShellExecute = false;psi.RedirectStandardOutput = true;psi.RedirectStandardInput = true;psi.RedirectStandardError = true;System.Diagnostics.Process proc =System.Diagnostics.Process.Start(psi);System.IO.StreamReader strm =System.IO.File.OpenText(p_LoadDestinationPath+"load_run.bat");System.IO.StreamReader sOut = proc.StandardOutput;System.IO.StreamWriter sIn = proc.StandardInput;while(strm.Peek() != -1){sIn.WriteLine(strm.ReadLine());}sIn.WriteLine("EXIT");proc.Close();sIn.Close();sOut.Close();
- calling SQLLDR from C# (ASP.NET) - Oracle Server
- Calling Oracle stored procedures from Microsoft.NET
- Calling an Oracle function from SQL Server Linked Server
- Calling JavaScript from ASP.NET Master Page and Content Pages
- Calling Managed .NET C# COM Objects from Unmanaged C++ Code
- Calling Java program from C#
- Calling C# Methods From C++
- Calling Oracle 10g Stored Proc with Assoc Array from C# VS 2008
- Calling C++ Unmanaged Class from C#
- Calling C++ Unmanaged Class from C#
- Calling C/C++ functions from C#
- Calling Java Classes Directly From .Net
- Calling C Code From Mono/.NET
- asp.net/C#连接sql server,oracle.access,my sql数据库
- asp.net/C#连接sql server,oracle.access,my sql数据库
- C#操作SQL Server数据库 Asp.net
- sqlldr oracle
- oracle sqlldr
- 新的开始~
- 电脑硬件兼容性知识
- USB移动硬盘故障排除
- 路由事件 之 e.OriginalSource
- WINVER _WIN32_IE define
- calling SQLLDR from C# (ASP.NET) - Oracle Server
- C语言详解-枚举类型
- Oracle分区表常用命令
- hdoj 1753 大明A+B (大数)
- MFC如何设置对话框的背景和字体颜色
- 如何看懂摄橡机技术指标
- 20个PHP常用类库
- ora-12154 TNS 无法处理服务名
- MapInfo技术社区