ASP源码
PHP源码
.NET源码
JSP源码
using Sy***m.Data.SqlClient;
using Sy***m.Data.OleDb;
private void tsmiImportTeacherInfo_Click(object sender, EventArgs e)
{
DataSet ds;
if (of***port.ShowDialog()==***logResult.OK)
{
ds = ImportExcel(th***ofdImport.FileName); //获得Excel
}
else
{
return;
}
int odr = 0;
SqlConnection cn = db***lconnection();
try
{
cn.Open();
string str = "insert into Teacher (TeacherId,Pwd,eachCourse,TeacherName) values(@TeacherId,@Pwd,@TeachCourse,@TeacherName)";
SqlCommand cmd = db***lcommand(str,cn);
int dsLength = ds***bles[0].R***.Count; //获得Excel中数据长度
for (int i = 0; i < dsLength; i++)
{
cm***arameters.Add("@TeacherId", Sq***Type.VarChar, 50).Value = ds***bles["Teacher "].Rows[i][0];
cm***arameters.Add("@Pwd", Sq***Type.VarChar, 50).Value = ds***bles["Teacher "].Rows[i][1];
cm***arameters.Add("@TeachCourse", Sq***Type.VarChar, 300).Value = ds***bles["Teacher "].Rows[i][2];
cm***arameters.Add("@TeacherName", Sq***Type.VarChar, 50).Value = ds***bles["Teacher "].Rows[i][3];
odr = cm***xecuteNonQuery();//提交
cm***arameters.Clear(); //清除前的赋值
}
//如果查到了数据,才使控制分页按钮生效
if (odr > 0)
{
Me***geBox.Show("导入成功!", "系统提示", Me***geBoxButtons.OK, Me***geBoxIcon.Information);
}
cn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
public static DataSet ImportExcel(string file)
{
FileInfo FileInfo = new FileInfo(file);
if (!Fi***nfo.Exists)
{
return null;
}
string strcn = @"Pr***der=Microsoft.ACE.OLEDB.12.0;Data Source=" + file + ";Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1;'";
OleDbConnection cn = new OleDbConnection(strcn);
DataSet ds = new DataSet();
try
{
cn.Open();
string strcmd = "select * from [Sheet1$]";
OleDbDataAdapter da = new OleDbDataAdapter(strcmd,cn);
da.Fill(ds, "Teacher ");
return ds;
}
catch (Exception ex)
{
throw ex;
}
}
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/crx05/archive/2009/12/17/5023589.aspx
-