Int16 campo1 = 0;
                String campo2 = string.Empty;
                String campo3 = string.Empty;
               
                connetionString = @"Data Source=(LocalDB)\v11.0;...";

                connection = new SqlConnection(connetionString);
             
             
                xmlFile = XmlReader.Create("Tabella.xml");

               
                ds.ReadXml(xmlFile);

                connection.Open();

                for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
                {

                    vcampo1 = Convert.ToInt16(ds.Tables[0].Rows[i].ItemArray[0]);
                    vcampo2 = Convert.ToString(ds.Tables[0].Rows[i].ItemArray[1]);
                    vcampo3 = Convert.ToString(ds.Tables[0].Rows[i].ItemArray[2]);
                    .....

                 

                    command = new SqlCommand("Insert", connection);
                    command.CommandType = CommandType.StoredProcedure;

                    command.Parameters.AddWithValue("@Rcampo1", campo1); //smallint,
                    command.Parameters.AddWithValue("@Rcampo2", campo2);  //varchar,
                    command.Parameters.AddWithValue("@Rcampo3", campo3);  //varchar,
                    .......

                    adpter.InsertCommand = command;
                    adpter.InsertCommand.ExecuteNonQuery();

using (SqlConnection con = new SqlConnection(cs))
            {
                //Thread.CurrentThread.CurrentCulture = new CultureInfo("it-IT");

                DataSet ds = new DataSet();
                ds.ReadXml("tabella.xml");
                DataTable dtTab = ds.Tables["tabella"];
                con.Open();
                using (SqlBulkCopy bc = new SqlBulkCopy(con))
                {
                    bc.DestinationTableName = "tabella";
                    
                    for (int col = 0; col <= 81; col++)
                    {
                        bc.ColumnMappings.Add(col, col);                        
                    }
                    
                    bc.WriteToServer(dtTab);
                }
            }

String constr = ConfigurationManager.ConnectionStrings["XXX"].ConnectionString;
        using (SqlConnection conn = new SqlConnection(constr))
        {
            String select = "SELECT ...
                        " FROM ...";
            using (SqlCommand com = new SqlCommand(select,conn))

            {
                
                conn.Open();
                SqlDataReader reader =  com.ExecuteReader();
                DataTable dt = new DataTable();
                dt.Load(reader);
            
                using (var file = File.OpenWrite(Server.MapPath("~/App_data/file.bin")))
                {
                    var formatter = new BinaryFormatter();
                    dt.RemotingFormat = SerializationFormat.Binary;
                    formatter.Serialize(file, dt);
                }
            }
        }