Ascii text file

Question

i have a table in sqlserver having following fields
name,age,dateofborth,phonenumber
now i want to convert it into text file
how can i do this,
it is very urgent

plz provide a code for the same

i am using vs2005

Himanshu · Answer

can u please tell me how to write this code into vb.net

James Tomar · Answer

To export a table from sqlserver to text file you can use DTS wizard. If you want to do it through code you can try the following: FileStream fileStream = File .Open( @C:\Temp\NewText.txt  FileMode .Create FileAccess .Write FileShare .None); StreamWriter streamWriter = new StreamWriter (fileStream); foreach ( DataRow dr in dataSet.Tables[0]) //datSet having your required records { //change /t to required formatting you want streamWriter.WriteLine(dr[ ColumnName1 ].ToString() + /t + dr[ ColumnName2 ].ToString()); } streamWriter.Close(); fileStream.Close(); Hope this will help..