sc.aspx.cs
资源名称:web.rar [点击查看]
上传用户:xrffrp
上传日期:2022-03-25
资源大小:22155k
文件大小:2k
源码类别:
OA系统
开发平台:
ASP/ASPX
- using System;
- using System.Data;
- using System.Configuration;
- using System.Collections;
- using System.Data.SqlClient;
- using System.Web;
- using System.Web.Security;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Web.UI.WebControls.WebParts;
- using System.Web.UI.HtmlControls;
- public partial class web_personnel_sc : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- }
- /* protected void File1_onclick()
- {
- SqlCommand comm2 = new SqlCommand(" SELECT * into OA_KAOQIN FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source='"+ File1_onclick +")User ID=sa;Password=lerado");
- }*/
- private void BtnInsert_Click(object sender, System.EventArgs e)
- {
- string fPath = this.fName.PostedFile.FileName;//获得要导入的文本文件
- string extName = fPath.Substring(fPath.LastIndexOf(".") + 1);//获得文件的扩展名
- SqlConnection con = new SqlConnection("server=.;database=pubs;uid=sa;pwd=;");//数据库连接对象
- con.Open();
- try
- {
- SqlCommand com = new SqlCommand("BULK INSERT pubs.dbo.txtInsert FROM '" + fPath + "' WITH (FIELDTERMINATOR = ',',ROWTERMINATOR= 'n')", con);
- //其中的FIELDTERMINATOR=','指明字段间所使用的分隔符为逗号
- //其中ROWTERMINATOR= 'n'指明记录间所使用的分隔符为回车
- com.ExecuteNonQuery();
- Response.Write("<script language=javascript>alert('数据导入成功!')</script>");
- }
- catch (SqlException SQLexc)
- {
- Response.Write("导入数据库时出错:" + SQLexc.ToString());
- }
- con.Close();
- }
- }