FROM 'C:\Data\Employees.txt'----------select Dynamic Path--------
WITH
(
FIELDTERMINATOR = '|',
CHECK_CONSTRAINTS,
KEEPIDENTITY,
BATCHSIZE = 50
)
but how to add parameters and i should browse for any other selected path
Can please any one help me out
sayeed BAGBANPosted Mar 22, 2013, 3:15 AM
//Button Click Event...
private void btn_Scan_Click(object sender, EventArgs e)
{
try
{
using (var stream = File.OpenRead("D:\\aaa\\Software \\ssss - DE\\Sample Input File\\12086-20121023_254598\\aaa.DAT"))
using (var reader = new StreamReader(stream))
{
string line;
while ((line = reader.ReadLine()) != null)
{
var data = line.Split(new[] { '|' }, 17);
string DocHeaderID = data[0].Trim();
string DocTypeID = data[1].Trim();
string BookType = data[2].Trim();
int BookNo = Convert.ToInt32(data[3].Trim().ToString());
string PageNo = data[4].Trim();
string ClerkNo = data[5].Trim();
string RDate = data[6].Trim();
int NumberofTiffs = Convert.ToInt32(data[7].Trim().ToString());
string HasExtensions = data[8].Trim();
string Consideration = data[9].Trim();
string NotUsed1 = data[10].Trim();
string NotUsed2 = data[11].Trim();
string CaseNumber = data[12].Trim();
string NotUsed3 = data[13].Trim();
string NotUsed4 = data[14].Trim();
string UDT = data[15].Trim();
string UST = data[16].Trim();
StoreRecord(DocHeaderID, DocTypeID, BookType, BookNo, PageNo, ClerkNo, RDate, NumberofTiffs, HasExtensions, Consideration, NotUsed1, NotUsed2, CaseNumber, NotUsed3, NotUsed4, UDT, UST);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
//Stored procedure to be called
private void StoreRecord(string DocHeaderID, string DocTypeID, string BookType, int BookNo, string PageNo, string ClerkNo, string RDate, int NumberofTiffs, string HasExtensions, string Consideration, string NotUsed1, string NotUsed2, string CaseNumber, string NotUsed3, string NotUsed4, string UDT, string UST)
{
var conStr = "server=(local); database=abcde; password=abcde; User Id=123123;";
using (var connection = new SqlConnection(conStr))
using (var command = connection.CreateCommand())
{
connection.Open();
command.CommandText ="UpdateTable";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@DocHeaderID", DocHeaderID);
command.Parameters.AddWithValue("@DocTypeID", DocTypeID);
command.Parameters.AddWithValue("@BookType", BookType);
command.Parameters.AddWithValue("@BookNo", BookNo);
command.Parameters.AddWithValue("PageNo", PageNo);
command.Parameters.AddWithValue("@ClerkNo", ClerkNo);
command.Parameters.AddWithValue("@RDate", RDate);
command.Parameters.AddWithValue("@NumberofTiffs", NumberofTiffs);
command.Parameters.AddWithValue("@HasExtensions", HasExtensions);
command.Parameters.AddWithValue("@Consideration", Consideration);
command.Parameters.AddWithValue("@NotUsed1", NotUsed1);
command.Parameters.AddWithValue("@NotUsed2", NotUsed2);
command.Parameters.AddWithValue("@CaseNumber", CaseNumber);
command.Parameters.AddWithValue("@NotUsed3", NotUsed3);
command.Parameters.AddWithValue("@NotUsed4", NotUsed4);
command.Parameters.AddWithValue("@UDT", UDT);
command.Parameters.AddWithValue("UST", UST);
command.ExecuteNonQuery();
}
}