tag:blogger.com,1999:blog-2379842053067321961.post5013460128024835381..comments2024-03-29T00:14:01.927-07:00Comments on Welcome To TechBrothersIT: C# - How to Export Data from SQL Server Table or View to Text File in C SharpAamir Shahzadhttp://www.blogger.com/profile/16777994869678463807noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-2379842053067321961.post-59712919930278651812023-01-11T04:04:38.404-08:002023-01-11T04:04:38.404-08:00Perfectly works fine, I want destination file fiel...Perfectly works fine, I want destination file field data type to match with sql columns, Will this be possible? , If yes can you suggest please.<br />Vijayhttps://www.blogger.com/profile/02004450999943688703noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-13613319164701848482021-12-29T13:30:14.166-08:002021-12-29T13:30:14.166-08:00I have a question ?
I have table & 10000 rows ...I have a question ?<br />I have table & 10000 rows are affected In this table And I want to export table data to text file. But one condition.<br /> when 1 to 2000 rows export in one text file, next file create with 2001 to 4000 row, again next file create 4001 to 6000 rows... Etc. <br /> Basically I want to export data in 5 text file each file store 2000 rows only.Anonymoushttps://www.blogger.com/profile/15490016244138414499noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-8824842619912410222021-04-21T06:49:58.348-07:002021-04-21T06:49:58.348-07:00Excellent scriptExcellent scriptSergeyhttps://www.blogger.com/profile/11895261993275003111noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-72466970741661813402020-11-03T13:05:38.580-08:002020-11-03T13:05:38.580-08:00Excellent script but if I want the script to gener...Excellent script but if I want the script to generate the flat file without the header. What would I need to change?Anonymoushttps://www.blogger.com/profile/16489307171292835338noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-28218556862044621982019-09-10T21:02:02.505-07:002019-09-10T21:02:02.505-07:00Hi Bro
help fix error
Additional information: Co...Hi Bro<br /> help fix error<br /> Additional information: Could not find a part of the path 'C:\Log\ErrorLog_20190911110140.log'.Anonymoushttps://www.blogger.com/profile/10739254016534147393noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-19050583810121544432019-07-14T10:19:46.508-07:002019-07-14T10:19:46.508-07:00This code perfectly working , Thank you for that. ...This code perfectly working , Thank you for that. But I am facing issue with datetime field, can you please help for this.<br /><br />in Text files date format changed, how we can get same date format whatever we have in table.<br />Eg: Table contains datetime as yyyy-mm-dd hh:mm:ss<br />IN file populating as dd/mm/yyyy hh:mm:ss AMAnonymoushttps://www.blogger.com/profile/17510318454292629372noreply@blogger.com