C#

string connectionString = "Data Source=srv032k3; Initial Catalog=MuzeDB;Integrated Security=SSPI; User ID=sa; Password=;sa";
SqlConnection connection = new SqlConnection(connectionString);

try
{
    connection.Open();
    SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM students ORDER BY Id", connection);
    SqlCommandBuilder command = new SqlCommandBuilder(adapter);

    //create a dataset object
    DataSet ds = new DataSet("StudentsSet");
    adapter.Fill(ds, "students");

    //create a new datatable object
    DataTable dt = ds.Tables["students"];
    DataRow row = dt.NewRow();

    //give value for the new row
    int id;
    string name, address;
    id = 4;
    name = "Nadeem";
    address = "Layya";

    row["Id"] = id;
    row["Name"] = name;
    row["Address"] = address;
    dt.Rows.Add(row);

    adapter.Update(ds, "students");

    Console.WriteLine("A new row added: {0} {1} {2}", id, name, address);

    connection.Close();
}
catch (Exception ex)
{ Console.WriteLine(ex.Message); }

FileStream fs = new FileStream("C:\\Users\\Mauri\\Desktop\\" + item.Name, FileMode.Append, FileAccess.Write);
            BinaryWriter writer = new BinaryWriter(fs);
            bool continua = true;
            while (continua)
            {
                recibido = getSocket(numsock).socketRecv(); // This return the data converted to string.
                words = recibido.Split('|'); //We split "|mystring" to find the end of file.
                foreach (string s in words)
                {
                    if ((String.Compare(s, "mystring") != 0))                        
                        writer.Write(StringToBytes(s)); // Write converted data. 
                    else
                        continua = false; // if we find "mystring", end the action.
                }   
            }
            writer.Close();
            fs.Close();

// Convert string to bytes
public byte[] StringToBytes(String cadena)
        {
            System.Text.ASCIIEncoding codificador = new System.Text.ASCIIEncoding();
            return codificador.GetBytes(cadena);
        }