Tuesday, July 30, 2013

Reading data from a Dataset(*.csv) file and saving saving it to mysql database

first create the database and tables.to read a csv(comma seperated value )file see here:


http://social.msdn.microsoft.com/Forums/en-US/887e6153-fb24-4ea0-892b-596a43b6b8b3/recommended-way-to-read-csv-file-in-64bit-environment


read a csv file into datatable then insert into database table using simple inser querey or use bulk insert.



you can read the csv file using ado.net also. see here:


http://gyansangrah.com/ArticleContent.aspx?ID=reading_csv_files_in_ado_net


No comments:

Post a Comment