Friday, 23 August 2013

Create filename on FTP same as local name

Create filename on FTP same as local name

i have this code, where i generate xml file from sql database:
int counter;
int counter2;
private void GenerovaniVse()
{
SqlConnection con = new SqlConnection("Data Source=****");
string strSQL = "select w.KOD_....";
SqlDataAdapter dt = new SqlDataAdapter(strSQL, con);
DataSet ds = new DataSet("ITEMS");
dt.Fill(ds, "ITEM");
FileStream strFileName = File.Create(@"C:\\Users\\L\\Desktop\\" +
(counter++) + ".xml");
XmlWriterSettings settings = new XmlWriterSettings();
settings.Encoding = Encoding.Unicode;
using (XmlWriter xmlWriter = XmlWriter.Create(strFileName, settings))
{
ds.WriteXml(xmlWriter);
xmlWriter.Close();
}
}
And This code from upload this file to ftp:
private void Upload()
{
FileInfo f = new FileInfo("C:\\Users\\L\\Desktop\\" + (counter2) +
".xml");
long original_vel = f.Length;
FtpWebRequest request = (FtpWebRequest)WebRequest.Create(??????);
request.Method = WebRequestMethods.Ftp.GetFileSize;
request.Method = WebRequestMethods.Ftp.UploadFile;
request.Credentials = new NetworkCredential("testftp", "vilenin");
StreamReader sourceStream = new StreamReader(??????);
byte[] fileContents = Encoding.UTF8.GetBytes(sourceStream.ReadToEnd());
sourceStream.Close();
request.ContentLength = fileContents.Length;
long ftp_vel = request.ContentLength; //velikost souboru na ftp
Stream requestStream = request.GetRequestStream();
requestStream.Write(fileContents, 0, fileContents.Length);
requestStream.Close();
FtpWebResponse response = (FtpWebResponse)request.GetResponse();
counter2++;
response.Close();
}
I dont know how i could load the same name of xml file, which i generate
in previsous code. Any ideas?

No comments:

Post a Comment