insert text files data in server using stored procedure c#

Question

BULK INSERT dbo.Employees
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 BAGBAN · Answer

I have found it on my own...Thanks for viewers //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(); } }

insert text files data in server using stored procedure c#

Answers (1)