http://dotnet.aspx.cc/ShowDetail.aspx?id=C673E2CD-3F1E-4919-8CE0-D69B894A0599
解决方案 »
- 请问这段代码如何处理
- 使用Label显示按钮控件,如何实现单击事件?
- 如何实现在WinForm中弹出新窗体时,旧窗体自动关闭!
- 怎樣寫 RecordSelectionFormula 的篩選語句啊!
- 163登录框中的文字是怎样弄的啊???
- DropDownList的SelectedItem.Text总为第一条的内容
- 两个虚拟目录间能共享session么?如过我想让两个网站间能传递信息(比如登录的用户信息)的话该怎么做?
- 数据绑定如果不在DATALIST等的模板中使用而直接在页面中使用,象ASP那样,可以么》?如果不绑定到控件可以吗?最好给个例子。
- 父页面刷新的时候能否不让iframe子页面刷新
- runat=server 的form的提交問題,請進!
- 水晶报表安装不能正常预览!
- 关于校验控件中的ClientValidationFunction事件的参数的问题
Dim strFullName As String = Me.btn_GetFileName.PostedFile.FileName
Dim strFileName As String = strFullName.Substring(strFullName.LastIndexOf("\") + 1)
If strFullName = "" Then
RegisterStartupScript("提示", "<script>alert('请选择文件!');</script>")
Exit Sub
End If
Dim dir As New System.IO.DirectoryInfo(ViewState("folder").ToString)
Dim fileinfo As System.IO.FileInfo() = dir.GetFiles(strFileName)
If fileinfo.Length Then
RegisterStartupScript("提示", "<script>alert('存在同名文件,请更名存储!');</script>")
Exit Sub
End If ViewState.Item("FileName") = ViewState("folder").ToString + "\" + strFileName
btn_GetFileName.PostedFile.SaveAs(ViewState.Item("FileName").ToString)
dgRight.DataSource = GetXLS(ViewState.Item("FileName").ToString)
dgRight.DataBind()
btn_DB.Visible = True
End Sub Function GetXLS(ByVal strFileName As String) As DataTable
If strFileName = "" Then
Return Nothing
End If
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFileName + ";Extended Properties=Excel 8.0;"
Dim sql As String = "Select 电脑序号,社会保障号,工号,姓名,所属年度,月平均工资 from [sheet1$]"
Dim adp As New OleDb.OleDbDataAdapter(sql, strConn)
Dim dt As New DataTable()
Try
adp.Fill(dt)
Catch
RegisterStartupScript("提示", "<script>alert('文件打开失败,该文件将被删除,请修改文件内容后再上传!');</script>")
DelFile()
End Try
Return dt
End Function
Dim dt As DataTable = GetXLS(ViewState.Item("FileName").ToString)
If dt Is Nothing Then
Exit Sub
End If Dim dr As DataRow
Dim comm As New OleDb.OleDbCommand("", New OleDb.OleDbConnection(Application.Item("ConnStr").ToString))
comm.Connection.Open()
Dim dtError As New DataTable()
Dim col As DataColumn
For Each col In dt.Columns
dtError.Columns.Add(col.ColumnName)
Next For Each dr In dt.Rows
Try
comm.CommandText = " insert into base (id,insureid,wagetime,avgwage) values(" + dr("电脑序号").ToString + ",'" + dr("社会保障号").ToString + "','" + dr("所属年度").ToString + "'," + dr("月平均工资").ToString + ")"
If comm.Connection.State = ConnectionState.Closed Then
comm.Connection.Open()
End If
comm.ExecuteNonQuery()
Catch
dtError.ImportRow(dr)
End Try
Next
comm.Connection.Close()
comm.Dispose()
dt.Dispose()
RegisterStartupScript("提示", "<script>alert('数据已成功导入数据库!');</script>")
dgRight.DataBind()
End Sub