how to import updated pipe separated text file's data using?

Ankit Agarwal

13y2.5kVisual Basic .NET

Hello,

I am using this code for export datagridview's data to pipe separated txt file.

StreamWriter sw = new StreamWriter(filePath, false);

int iColCount = dataTable.Columns.Count;

//for (int i = 0; i < iColCount; i++)

//{

// sw.Write(dataTable.Columns[i]);

// if (i < iColCount - 1)

// {

// sw.Write("|");

// }

//}

//sw.Write(sw.NewLine);

foreach (DataRow row in dataTable.Rows)

{

for (int i = 0; i < iColCount; i++)

{

if (!Convert.IsDBNull(row[i]))

{

sw.Write(row[i].ToString());

}

if (i < iColCount - 1)

{

sw.Write("|");

}

sw.Write(sw.NewLine);

}

sw.Close();

It's code running successfully, i mean to say, successfully exported in pipe separated file but when we update any value in it's export's file and then import same file in to the database using c# .net so,my database did not update from this file.

Please help me.

Thanks in Advance

Ankit Agarwal

Software Engineer

5 Replies

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

Nitesh Kejriwal13y ago
Did you check for cosntraint validations in your DB. Try inserting your updated file on a blank Db structure and see if it is inserted. I have the feeling, your code is working fine but the data is not being inserted or updated because of some SQL errors. Show a sample text file.
Ankit Agarwal13y ago
No,error.
I am importing txt file through sql

N'BULK INSERT dbo.abc FROM ''' +
@UUSItemMasterPath +
N''' WITH (FIELDTERMINATOR = ''|'', ROWTERMINATOR = ''\n'')'
Nitesh Kejriwal13y ago
Are you getting any error while importing your pipe separated file to DB? How are you doing this. Share some code!
Ankit Agarwal13y ago
No, when we update exported txt file manualy and then import txt file to database through c# code, so my database did not update.
Nitesh Kejriwal13y ago
Do you mean to say your text file is updated when you make changes to gridview but your database is not updated?