sqlbulkcopy
-
Hi friends, I am new in asp.net2.0, How sqlbulkcopy class use in sqlserver2000. I use sqlserver2000,It's show some error. thanks
rajmani wrote:
It's show some error.
What error?
SSK.
-
Hi friends, I am new in asp.net2.0, How sqlbulkcopy class use in sqlserver2000. I use sqlserver2000,It's show some error. thanks
rajmani wrote:
It's show some error.
Please quote the error message. :)
Vasudevan Deepak Kumar Personal Homepage Tech Gossips
-
rajmani wrote:
It's show some error.
Please quote the error message. :)
Vasudevan Deepak Kumar Personal Homepage Tech Gossips
Dim cb As New OleDbConnectionStringBuilder cb.Provider = "microsoft.jet.oledb.4.0" cb.DataSource = "c:/sample.mdb" Dim cnn As New OleDbConnection(cb.ConnectionString) Dim cmd As New OleDbCommand("select * from tablename", cnn) cnn.Open() Dim rdr As OleDbDataReader = cmd.ExecuteReader Dim sbc As New SqlBulkCopy("server=localhost;database=sample;" + "integrated security=sspi") sbc.DestinationTableName = "tablename" sbc.WriteToServer(rdr) sbc.Close() rdr.Close() cnn.Close this my code,what is the problem in this code,check out thanks