create txt to store up to 100 entries and continue in a new txt, I use c #

Question

2.00/5 (4 votes)

See more:

how i create txt to store up to 100 entries and continue in a new txt, I use c #

this is my code:

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using IntranetLima.Entities;
using IntranetLima.Business;
using System.Drawing;
using System.Collections;

namespace IntranetLima.WebApp.Compras
{
    public partial class ConsulRuc : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack && !Page.IsCallback)
            {
                Populate_Company();
            }  
        
        }

        private void Populate_Company()
        {
            ListItem item;
            item = new ListItem("<--Seleccione-->", "-1");

            CompanyController ctrl = new CompanyController();

            DataTable arr = ctrl.CompanySelect();

            ddlEmpresa.DataSource = arr;
            ddlEmpresa.DataTextField = "COMPANY";
            ddlEmpresa.DataValueField = "COMPANY";

            ddlEmpresa.DataBind();

            ddlEmpresa.Items.Insert(0, item);
        }

        protected string get_company()
        {
            string company = ddlEmpresa.SelectedValue;
            return company;
        }

        protected void btnConsulta_Click(object sender, EventArgs e)
        {

            ConsulRucController ctrl = new ConsulRucController();

            string compania = get_company();

            Select_Ruc();



        }

        private void Select_Ruc()
        {
            string strFilePath = null;
            StreamWriter stm = default(StreamWriter);
            int i=0;
            DataTable dt = new DataTable();
            ListItem item;
            item = new ListItem(txtAnio.Text);

            ConsulRucController ctrl = new ConsulRucController();

            DataTable arr = ctrl.ConsultaRuc(ddlEmpresa.SelectedValue, txtAnio.Text, ddlMes.SelectedValue);
            // Creando el archivo txt consulta de RUC
            strFilePath = "c://IPPRUC_FEB_2012_01txt";
            stm = new StreamWriter(strFilePath, false);

            for (i = 0; i <= dt.Columns.Count - 2; i++)
            {
                stm.Write(dt.Columns[i].ColumnName + ",");                      
            
            }

            stm.Write(dt.Columns[i].ColumnName);
            stm.WriteLine();

            foreach (DataRow row in dt.Rows)
            {
                object[] array = row.ItemArray;

                for (i = 0; i <= array.Length - 2; i++)
                {
                    stm.Write(array[i].ToString() + ",");
          
                }
            
                stm.Write(array[i].ToString());  
                            
            }

            stm.Close();
            //WebMsgBox("job done :D");


        } 
        //catch(Exception ex){

           
        //    }



            //jaime
            //txt_estado_actual.Text = Convert.ToString(arr.Rows[0][1]);
            
            
            
            //txt_empresa.Text = Convert.ToString(arr.Rows[0][3]);

            //txt_estado_actual.DataBind();


        }
    
    
    
    }

this is my new code:

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using IntranetLima.Entities;
using IntranetLima.Business;
using System.Drawing;
using System.Collections;

namespace IntranetLima.WebApp.Compras
{
    public partial class ConsulRuc : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack && !Page.IsCallback)
            {
                Populate_Company();
            }  
        
        }

        private void Populate_Company()
        {
            ListItem item;
            item = new ListItem("<--Seleccione-->", "-1");

            CompanyController ctrl = new CompanyController();

            DataTable arr = ctrl.CompanySelect();

            ddlEmpresa.DataSource = arr;
            ddlEmpresa.DataTextField = "COMPANY";
            ddlEmpresa.DataValueField = "COMPANY";

            ddlEmpresa.DataBind();

            ddlEmpresa.Items.Insert(0, item);
        }

        protected string get_company()
        {
            string company = ddlEmpresa.SelectedValue;
            return company;
        }

        protected void btnConsulta_Click(object sender, EventArgs e)
        {

            ConsulRucController ctrl = new ConsulRucController();

            string compania = get_company();

            Select_Ruc();
            

        }

        private void Select_Ruc()
        {
            string strFilePath = null;
            StreamWriter stm = default(StreamWriter);
            int i=0;
            //DataTable dt = new DataTable();
            ListItem item;
            item = new ListItem(txtAnio.Text);

            ConsulRucController ctrl = new ConsulRucController();

            DataTable arr = ctrl.ConsultaRuc(ddlEmpresa.SelectedValue, txtAnio.Text, ddlMes.SelectedValue);
            // Creando el archivo txt consulta de RUC
            //strFilePath = "c://IPPRUC_FEB_2012_01.txt";
            //strFilePath = ("c://IPPRUC_" & ddlMes.SelectedValue.ToString & txtAnio.Text & ".txt");
            

            for (i = 0; i <= arr.Columns.Count - 2; i++)
            {
                 // este stm.Write(arr.Columns[i].ColumnName + ",");
                //stm.WriteLine(arr.Columns[i].ColumnName + ",");    
            
            }

              //este stm.Write(arr.Columns[i].ColumnName);
            //stm.WriteLine(arr.Columns[i].ColumnName);
            //stm.WriteLine();
            int temp = 1;
            //int cont = 0;
            int cont = -1;
            
            strFilePath = "c://IPPRUC_" + ddlMes.SelectedValue + "_" + txtAnio.Text + "_" + temp + ".txt";
            stm = new StreamWriter(strFilePath, false);
            foreach (DataRow row in arr.Rows)
            {
                cont++;
                if(cont % 100==0){
                    stm.Close();
                    txtAnio.Text = txtAnio.Text + "-" + cont.ToString();
                    temp++;
                    strFilePath = "c://IPPRUC_" + ddlMes.SelectedValue + "_" + txtAnio.Text + "_" + temp + ".txt";
                    stm = new StreamWriter(strFilePath, false);
                }
                
                object[] array = row.ItemArray;

                //for (i = 0; i <= array.Length - 2; i++)
                for (i = 1; i <= array.Length - 2; i++)
                {
                    stm.WriteLine(array[i].ToString() + ",");
          
                }

                stm.WriteLine(array[i].ToString());

          
                
                {
                
                
                
                }


                
            }





            
            //WebMsgBox("job done :D");

            //WebMsgBox.Show("Se creo el txt");
        } 
        //catch(Exception ex){

        //    }

            //jaime
            //txt_estado_actual.Text = Convert.ToString(arr.Rows[0][1]);
                        
            //txt_empresa.Text = Convert.ToString(arr.Rows[0][3]);

            //txt_estado_actual.DataBind();
        }    
    }

the first txt is in black and the last txt too. The others ones are ok (100 registers)

Posted 27-Nov-12 11:14am

jaime durand

Updated 29-Nov-12 10:08am

André Kraak

v6

Add a Solution

Comments

Sergey Alexandrovich Kryukov 27-Nov-12 17:33pm

You got my permission. Next!
--SA

CPallini 27-Nov-12 18:06pm

5++.

Sergey Alexandrovich Kryukov 27-Nov-12 19:01pm

Thank you, Carlo.
--SA

fjdiewornncalwe 27-Nov-12 17:34pm

Simple. Maintain a counter of entries you have made. When you hit 100, move on to the next txt and start counting over again.

Nelek 27-Nov-12 17:58pm

This is not how it works. You are supposed to do your tasks. If you have an error that you can not solve, you are welcome to ask that concrete issue and you will get an answer.
Please read:
Homework[^]
what have you tried?[^]

_Natula 29-Nov-12 15:51pm

is the first txt black or blank?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Natula · Answer 1 · 2012-11-27T12:03:00

C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string sFile_dir = "C:\\CP";
            int FileIndex = 1;
            int RowCount = 1;
            for (int i = 1; i < 10000; i++)
            {
                if(RowCount % 100 == 0 ) { ++FileIndex; }
                writeToFile(sFile_dir, "File" + FileIndex, "File Content-" + i);
            RowCount ++; 
            }
        }


        public static void writeToFile(string sFile_dir, string sFileName, string sContent)
        {
            string FILE_NAME = sFile_dir + "\\" + sFileName + ".csv";
            if (!Directory.Exists(sFile_dir))
            {
                Directory.CreateDirectory(sFile_dir);
            }
            if (!File.Exists(FILE_NAME))
            {
                // Create a file to write to.
                using (StreamWriter sw = File.CreateText(FILE_NAME))
                {
                    if (!File.Exists(FILE_NAME))
                    {
                        return;
                    }
                }
            }
            using (StreamWriter sw = File.AppendText(FILE_NAME))
            {
                sw.WriteLine(sContent);
                sw.Flush();
                sw.Close();
            }
        }//End  writeToFile()
    }
}