c# error : the name 'dt' does not exist in current context

Ankit Rohatgi

11y7.1kVisual Basic .NET

using System;

using System.Data;

using Microsoft.SqlServer.Dts.Runtime;

using System.Windows.Forms;

using System.Data.SqlClient;

using System.IO;

namespace ST_37ea42e2bf564f4f9a848267124b45f1.csproj

{

[System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]

public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase

{

#region VSTA generated code

enum ScriptResults

{

Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,

Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure

};

#endregion

public void Main()

{ // TODO: Add your code here

String sDatabaseConnectionString = @"PUNITP347138D.Ankit";

// Here I trying to use Variable Instead of C:\HCS\Data\cd_catalog.xml for file location

String sXMLFile = @"C:\Users\ankit_rohatgi\Desktop\Output 5-25-2015 6-53-01 PM - Copy.xml";

try

{

using (SqlConnection oConn = new SqlConnection(sDatabaseConnectionString))

{ // Open the Connection to the database oConn.Open();

// Instanciate a new DataSet using (DataSet dsTemp = new DataSet())

{ //Read the XML file into the DataSet dsTemp.ReadXml(sXMLFile);

// Instante a datatable from the DataSet using (DataTable dt = dsTemp.Tables[0])

// Instanciate a new SqlBulkCopy object using the connection using (

SqlBulkCopy sb = new SqlBulkCopy(oConn);

{ // Assign BatchSize

sb.BatchSize = 50;

// Assign Destination Table Name

// Here I trying to use Variable Instead of C:cd_catalog for table

sb.DestinationTableName = "TableName";

sb.WriteToServer(dt); //error the name 'dt' does not exist in current context, please help

}

// Catch any SQL errors first

catch (SqlException ex)

{

}

Dts.TaskResult = (int)ScriptResults.Success;

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;
namespace ST_37ea42e2bf564f4f9a848267124b45f1.csproj
{
[System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]
public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
{
DataTable dt = new DataTable();
#region VSTA generated code
enum ScriptResults
{
Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
};
#endregion
public void Main()
{ // TODO: Add your code here
String sDatabaseConnectionString = @"PUNITP347138D.Ankit";
// Here I trying to use Variable Instead of C:\HCS\Data\cd_catalog.xml for file location
String sXMLFile = @"C:\Users\ankit_rohatgi\Desktop\Output 5-25-2015 6-53-01 PM - Copy.xml";
try
{
using (SqlConnection oConn = new SqlConnection(sDatabaseConnectionString))
{ // Open the Connection to the database oConn.Open();
// Instanciate a new DataSet using (DataSet dsTemp = new DataSet())
{ //Read the XML file into the DataSet dsTemp.ReadXml(sXMLFile);
// Instante a datatable from the DataSet using (DataTable dt = dsTemp.Tables[0])
// Instanciate a new SqlBulkCopy object using the connection using (
SqlBulkCopy sb = new SqlBulkCopy(oConn);
{ // Assign BatchSize
sb.BatchSize = 50;
// Assign Destination Table Name
// Here I trying to use Variable Instead of C:cd_catalog for table
sb.DestinationTableName = "TableName";
sb.WriteToServer(dt); //error the name 'dt' does not exist in current context, please help
}
}
}
}
// Catch any SQL errors first
catch (SqlException ex)
{
}
Dts.TaskResult = (int)ScriptResults.Success;
}
}
}

use this.

Mark is correct answer if helpful.
Dipankar Biswas11y ago
hi...
I think..
You need to declare ...
as example...
DataTable dt;
try
{
dt = new DataTable();
}
catch (Exception exp)
{
//Handle Exception
}
finally
{
dt.Dispose();
}

thanks...
Khargesh Rajput11y ago
Please check your code

You have commented code when you create instance of datatable dt

below red line

using (SqlConnection oConn = new SqlConnection(sDatabaseConnectionString))
{ // Open the Connection to the database oConn.Open();
// Instanciate a new DataSet using (DataSet dsTemp = new DataSet())
{ //Read the XML file into the DataSet dsTemp.ReadXml(sXMLFile);
// Instante a datatable from the DataSet using (DataTable dt = dsTemp.Tables[0])
// Instanciate a new SqlBulkCopy object using the connection using (
SqlBulkCopy sb = new SqlBulkCopy(oConn);
{ // Assign BatchSize
sb.BatchSize = 50;
// Assign Destination Table Name
// Here I trying to use Variable Instead of C:cd_catalog for table
sb.DestinationTableName = "TableName";
sb.WriteToServer(dt)