how to write the data from the database into the textfile??

Question

Good Morning, how to write the data from the database into the textfile in the windows web application into the local desktop,not in the server? Thank you

Amit Gupta · Answer

Web applications cannot access the local files directly, if it is an windows application (client side) then you can

Preetham Thangamma · Answer

Hello Amit Gupta, I am not looking to download here but to replace an existing file.....Thank you..

Amit Gupta · Answer

You are writing to d drive which is obviously not your server path, see below link for writing and allow downloading to user drive. https://stackoverflow.com/a/19166333

Preetham Thangamma · Answer

This is the Program i have followed string constr6 = ConfigurationSettings.AppSettings[ "MS" ]; string physicalPath = @ "D:\FlashdataLabel	ext.txt" ; File.WriteAllText(physicalPath, String.Empty); FileStream stream = new FileStream(physicalPath, FileMode.Open, FileAccess.ReadWrite); StreamWriter writer = new StreamWriter(stream); SqlConnection con6 = new SqlConnection(constr6); con6.ConnectionString = constr6; SqlCommand com = new SqlCommand( " select PMax,VOC,ISC,VPM,IPM,PSV,AssignMSN,MSN_Mat,PSN from [LabelMSN2222]where PSN='" + txtpsn.Text + "' order by id desc" , con6); con6.Open(); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { writer.Write(reader[ "PMax" ].ToString()); writer.Write( "," ); writer.Write(reader[ "VOC" ].ToString()); writer.Write( "," ); writer.Write(reader[ "ISC" ].ToString()); writer.Write( "," ); writer.Write(reader[ "VPM" ].ToString()); writer.Write( "," ); writer.Write(reader[ "IPM" ].ToString()); writer.Write( "," ); writer.Write(reader[ "PSV" ].ToString()); writer.Write( "," ); writer.Write(reader[ "AssignMSN" ].ToString()); writer.Write( "," ); writer.Write(reader[ "MSN_Mat" ].ToString()); writer.Write( "," ); writer.Write(reader[ "PSN" ].ToString()); //writer.WriteLine(); } reader.Close(); writer.Close(); stream.Close(); con6.Close(); } Server Error in '/' Application. Access to the path 'D:\FlashdataLabel	ext.txt' is denied.

Amit Gupta · Answer

Share your code, how you are trying to write into a text file.

Preetham Thangamma · Answer

Hello Amit Gupta, we are facing issue to write into the textfile from the server but we can write into the textfile locally... Thank you

Amit Gupta · Answer

what's the issue? fetch data from db and write those in a file and write code to download them

how to write the data from the database into the textfile??

Answers (7)