Hi,
I am doing bulk insert in Asp.Net but I am getting bellow error
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
bellow is my code
public void InsertIntoDatabase()
{
SqlConnection SqlConn = new SqlConnection();
SqlConn.ConnectionString = dboDB.GetConnection(Session["Client"].ToString());
SqlConn.Open();
SqlTransaction Trans = SqlConn.BeginTransaction();
try
{
string sClearSQL = "truncate table mstScheduler";
SqlCommand SqlCmd = new SqlCommand(sClearSQL, SqlConn, Trans);
SqlCmd.ExecuteNonQuery();
if (dt.Rows.Count > 0)
{
SqlBulkCopy bulkCopy = new SqlBulkCopy(SqlConn);
//bulkCopy.BulkCopyTimeout = 3000;
bu ...
Go to the complete details ...