How to send selected data to an ftp server

Question

I am developing a project in c# and right now I have to select a line from a Datagridview that I created, create a text file with that data and send the created file to an ftp server. I’ve done some research, but I couldn’t find anything useful to me.If you want a code or a screenshot of my project I can make it available. This is the code of Datagridview:

SqlConnection myConnection = new SqlConnection(@"Data source = **** ; Database=**** ; User Id=****; Password=*****");
myConnection.Open();
SqlCommand objcmd = new SqlCommand("SELECT TransDocument, TransSerial, TransDocNumber, PartyName, PartyLocalityID, TotalAmount, ShipToPostalCode FROM dbo.UXMenu WHERE Estado = 0", myConnection);
objcmd.ExecuteNonQuery();
SqlDataAdapter adp = new SqlDataAdapter(objcmd);
DataTable dt = new DataTable();
adp.Fill(dt);
dataGridViewEnviarDados.DataSource = dt;
dataGridViewEnviarDados.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;

UPDATE:

I’m using this code:

FtpWebRequest request = (FtpWebRequest)WebRequest.Create("ftp://123.321.123" + arquivo.Name);
request.Method = WebRequestMethods.Ftp.UploadFile;
request.Credentials = new NetworkCredential("usuario", "password");
StreamReader sourceStream = new StreamReader(arquivo.FullName);
byte[] fileContents = Encoding.UTF8.GetBytes(sourceStream.ReadToEnd());
sourceStream.Close();
request.ContentLength = fileContents.Length;
Stream requestStream = request.GetRequestStream();
requestStream.Write(fileContents, 0, fileContents.Length);
requestStream.Close();
FtpWebResponse response = (FtpWebResponse)request.GetResponse();
MessageBox.Show("Arquivo " + arquivo.Name + " foi enviado com sucesso. " + response.StatusDescription);
response.Close();`  

But I have this mistake:

Answer 1

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Net;
using System.Web;

namespace Examples.System.Net
{
    public class EnvioFtp
    {
        /// <summary>
        /// Atributo para lib
        /// </summary>
        private FtpWebRequest FtpClient { get; set; }
        /// <summary>
        /// Atribui valores iniciais para envio e conexão
        /// </summary>
        private void ConectaFtp()
        {
            this.FtpClient = (FtpWebRequest)WebRequest.Create("ftp://endereco.com/teste.txt");
            this.FtpClient.Credentials = new NetworkCredential("usuario", "senha");
        }

        /// <summary>
        /// Realiza envio, utilizando o atributo já iniciado(FtpClient)
        /// </summary>
        public void EnviaProjetoFtp()
        {

            this.ConectaFtp();
            FileInfo arquivoInfo = new FileInfo("teste.txt");
            this.FtpClient.Method = WebRequestMethods.Ftp.UploadFile;
            this.FtpClient.UseBinary = true;
            this.FtpClient.ContentLength = arquivoInfo.Length;

            using (FileStream fs = arquivoInfo.OpenRead())
            {
                byte[] buffer = new byte[2048];
                int bytesSent = 0;
                int bytes = 0;

                using (Stream stream = this.FtpClient.GetRequestStream())
                {
                    while (bytesSent < arquivoInfo.Length)
                    {
                        bytes = fs.Read(buffer, 0, buffer.Length);
                        stream.Write(buffer, 0, bytes);
                        bytesSent += bytes;
                    }
                }
            }
        }
    }
}

Answer 2

Step by step:

1- Checks for selected lines on the grid.

2- Traverse the selected lines one by one.

2.1 - Generates the text file, and writes to it with the class TextWriter running through each grid column, and separating the fields with a ;

2.2 - Close the object TextWriter

2.3 - Using the class FtpWebRequest next to a Stream to send the file to the FTP server.

Follows code:

    private void buttonEnviar_Click(object sender, EventArgs e)
    {
        if (dataGridView1.SelectedRows.Count > 0)
        {
            foreach (DataGridViewRow r in dataGridView1.SelectedRows)
            {
                FileInfo arquivo = new FileInfo("C:\\arquivoDeTexto_"+r.Index+".txt");

                using (TextWriter tw = new StreamWriter(arquivo.FullName, false, Encoding.Default))
                {
                    foreach (DataGridViewColumn c in dataGridView1.Columns)
                    {
                        tw.Write(r.Cells[c.Name].Value.ToString()+";");
                    }

                    tw.Close();
                }

                FtpWebRequest request = (FtpWebRequest)WebRequest.Create("ftp://seuservidorftp.com/"+ arquivo.Name);
                request.Method = WebRequestMethods.Ftp.UploadFile;

                request.Credentials = new NetworkCredential("usuario", "senha");

                StreamReader sourceStream = new StreamReader(arquivo.FullName);
                byte[] fileContents = Encoding.UTF8.GetBytes(sourceStream.ReadToEnd());
                sourceStream.Close();
                request.ContentLength = fileContents.Length;

                Stream requestStream = request.GetRequestStream();
                requestStream.Write(fileContents, 0, fileContents.Length);
                requestStream.Close();

                FtpWebResponse response = (FtpWebResponse)request.GetResponse();

                MessageBox.Show("Arquivo " + arquivo.Name + " foi enviado com sucesso. " + response.StatusDescription);

                response.Close();
            }
        }

    }

Answer 3

This example shows how to load a file to an FTP server. Example C#

using System;
using System.IO;
using System.Net;
using System.Text;

namespace Examples.System.Net
{
    public class WebRequestGetExample
    {
        public static void Main ()
        {
            // Get the object used to communicate with the server.
            FtpWebRequest request = (FtpWebRequest)WebRequest.Create("ftp://www.contoso.com/test.htm");
            request.Method = WebRequestMethods.Ftp.UploadFile;

            // This example assumes the FTP site uses anonymous logon.
            request.Credentials = new NetworkCredential ("anonymous","[email protected]");

            // Copy the contents of the file to the request stream.
            StreamReader sourceStream = new StreamReader("testfile.txt");
            byte [] fileContents = Encoding.UTF8.GetBytes(sourceStream.ReadToEnd());
            sourceStream.Close();
            request.ContentLength = fileContents.Length;

            Stream requestStream = request.GetRequestStream();
            requestStream.Write(fileContents, 0, fileContents.Length);
            requestStream.Close();

            FtpWebResponse response = (FtpWebResponse)request.GetResponse();

            Console.WriteLine("Upload File Complete, status {0}", response.StatusDescription);

            response.Close();
            }
        }
    }
}

Source: https://msdn.microsoft.com/pt-br/library/ms229715(v=vs.110). aspx