index > Visual Basic Express Edition > how to save file?

how to save file?

hi there... my problem is.. how to save a file (text, excel or doc) based on datagrid output

pinoyz Wednesday, February 07, 2007 10:14 AM

You can use Classes in System.IO like Stream Reader/Writer, TextReader/Writer etc to Save files

Akbar Khan Wednesday, February 07, 2007 10:31 AM

Dim sw As System.IO.StreamWriter = New System.IO.StreamWriter("C:\abc.txt")

sw.WriteLine("This is my text")

sw.Close()

Dim swExcel As System.IO.StreamWriter = New System.IO.StreamWriter("C:\abc.csv")

swExcel.WriteLine("Akbar khan,akbar@akbar.com,www.akbarbuneri.googlepages.com")

swExcel.Close()

Akbar Khan Wednesday, February 07, 2007 11:50 AM

DataTable dt = (DataTable) dataGrid1.DataSource;

DataSet ds = new DataSet();

ds.Tables.Add(dt);

ds.WriteXml(@"C:\akbar.xls");

Thank you

Akbar Khan Thursday, February 08, 2007 8:26 AM

It is just a format specifier .. without using you have to place // instead of a single in path.

Akbar Khan Thursday, June 21, 2007 8:10 AM

You can use Classes in System.IO like Stream Reader/Writer, TextReader/Writer etc to Save files

Akbar Khan Wednesday, February 07, 2007 10:31 AM

how? i dont know how to save a single file... provide some examples... much better in excel/text

pinoyz Wednesday, February 07, 2007 10:33 AM

Dim sw As System.IO.StreamWriter = New System.IO.StreamWriter("C:\abc.txt")

sw.WriteLine("This is my text")

sw.Close()

Dim swExcel As System.IO.StreamWriter = New System.IO.StreamWriter("C:\abc.csv")

swExcel.WriteLine("Akbar khan,akbar@akbar.com,www.akbarbuneri.googlepages.com")

swExcel.Close()

Akbar Khan Wednesday, February 07, 2007 11:50 AM

details in the datagridand save as excel file........HOW?

pinoyz Thursday, February 08, 2007 6:40 AM

DataTable dt = (DataTable) dataGrid1.DataSource;

DataSet ds = new DataSet();

ds.Tables.Add(dt);

ds.WriteXml(@"C:\akbar.xls");

Thank you

Akbar Khan Thursday, February 08, 2007 8:26 AM

is "@" sign is really in the code? is this the best way to save datagridview into excel file?

pinoyz Friday, February 16, 2007 6:35 AM

It is just a format specifier .. without using you have to place // instead of a single in path.

Akbar Khan Thursday, June 21, 2007 8:10 AM

You can use google to search for other answers

Custom Search

More Threads

• WebBrowser, disabling images from loading

• Download Manager

• Can not publish application

• Buttons and form collect data..

• Problem with Db not saving--Solution is here!

• Replacing letters in txt files

• Vb 2008 browser link question?

• VB not changing the records in the database

• How to get caption of active window?

• Help with Questionaire type form thing ( main problem is send button)