Databases
StackOverflow2013
Postsdbo
POThe type or namespace name 'SqlBulkCopy' could not be found
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POThe type or namespace name 'SqlBulkCopy' could not be found
    text
    copied!<p>can someone help me please to fix that error. this is my code : </p> <pre><code>using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data.SqlClient; using System.Data.OleDb; using System.Data; using Microsoft.ApplicationBlocks.Data; using System.Configuration; OleDbConnection ExcelCon = new OleDbConnection(); ExcelCon.ConnectionString = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=C:\\Users\\pc\\Documents\\ExcellTest.xlsx;Extended Properties=\"Excel 12.0;HDR=Yes\""; SqlConnection SqlCon = new SqlConnection(); SqlCon.ConnectionString = @"workstation id = PC-PC; user id=sa;Password=sapassword; data source=pc-pc; persist security info=True; initial catalog=CleanPayrollTest2"; string sSQLTable = "TestExcell"; string sClearSQL = "DELETE FROM " + sSQLTable; SqlCommand SqlCmd = new SqlCommand(sClearSQL, SqlCon); SqlCon.Open(); SqlCmd.ExecuteNonQuery(); SqlCon.Close(); DataTable dtSchema; dtSchema = ExcelCon.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" }); OleDbCommand Command = new OleDbCommand ("select * FROM [" + dtSchema.Rows[0]["TABLE_NAME"].ToString() + "]", ExcelCon); OleDbDataAdapter da = new OleDbDataAdapter(Command); DataSet ds = new DataSet (); da.Fill(ds); dataGrid1.DataSource = ds.Tables[0]; OleDbDataReader dr = Command.ExecuteReader(); SqlBulkCopy bulkCopy = new SqlBulkCopy(sSqlConnectionString); bulkCopy.DestinationTableName = sSQLTable; while (dr.Read()) { bulkCopy.WriteToServer(dr); } </code></pre> <p>Errors:</p> <p>-The type or namespace name 'bulkCopy' could not be found (are you missing a using directive or an assembly reference?)</p> <p>-The type or namespace name 'SqlBulkCopy' could not be found (are you missing a using directive or an assembly reference?)</p> <p>-The type or namespace name 'OleDbConn' could not be found (are you missing a using directive or an assembly reference?)</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload