如题,以下是vb.net代码,可否修改一些使得可以把viewstate("excel_ds")这个对象保存到tbl_wf_app_SkuCost_cache2这个表中?
'把预览的数据导入数据库
Dim conn As SqlConnection = New SqlConnection(SqlHelper.conString)
conn.Open()
Dim ds As DataSet = ViewState("excel_ds")
Dim da As SqlDataAdapter = New SqlDataAdapter("select top 1 * from tbl_wf_app_SkuCost_cache2", conn)
da.FillSchema(ds, SchemaType.Source, "tbl_wf_app_SkuCost_cache2")
da.Fill(ds, "tbl_wf_app_SkuCost_cache2") conn.Close()