TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Ankit Rohatgi
NA
6
9k
c# error : the name 'dt' does not exist in current context
Jun 1 2015 3:58 AM
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;
}
}
}
Reply
Answers (
3
)
Textbox allows only numbers in radgrid.
create controls dynamically in master's child pages in C#?