将csv文件导入mssql数据库 [英] importing csv file into a mssql database

问题描述

我的代码在visual studio中运行得非常好但是当我在我的网站（godaddy）上使用它时，没有数据插入到数据库中。我意识到数据表读取为空。请保存我的一天

My code below works very fine in visual studio but when I use it on my website (godaddy), no data is inserted into the database. I realised the datatable reads empty. please save my day

Using con As New SqlConnection(ConfigurationManager.ConnectionStrings("connection").ConnectionString)
                    con.Open()
                    Dim cmd As SqlCommand = con.CreateCommand()
                Using transaction As SqlTransaction = _
                  con.BeginTransaction()
 
                    Using bulkCopy As SqlBulkCopy = New _
                 
     SqlBulkCopy(con, _
                         SqlBulkCopyOptions.KeepIdentity, transaction)
                        bulkCopy.BatchSize = 10
                        bulkCopy.DestinationTableName = _
                         "trycsv" 
                        cmd.Connection = connection
                        cmd.Transaction = transaction
 
                        Try
						
                            bulkCopy.WriteToServer(reader)
							    cmd.CommandText = _"UPDATE trycsv  SET level = @level  where level =@updlevel"
							   cmd.Parameters.AddWithValue("@level", "1")
                              cmd.Parameters.AddWithValue("@updlevel", "O")
							  cmd.ExecuteNonQuery()
							
                            transaction.Commit()
                                
                        Catch ex As Exception
                            
                            transaction.Rollback()
 
                        Finally
                            con.Close()
                        End Try 
                    End Using 
                End Using 
            End Using

推荐答案

工作是正确的，是godaddy permision设置

works correct, was godaddy permision settings

这篇关于将csv文件导入mssql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！