Read txt array on c#

Sousa Pambo

Hi fellows, I need your help on this I have a ..... "Index was out of range. Must be non-negative and less than the size of the collection.\r\nParameter name: index"}..... Error

public ArrayList lineAccess=new ArrayList();

public void configTxt(string ficheiro)

{

StreamReader conjLines;

string lines;

try

{

conjLines = new StreamReader(ficheiro);

lines = conjLines.ReadLine();

while (lines != null)

{

lineAccess.Add(lines);

lines = conjLines.ReadLine();

}

conjLines.Close();

}

catch (Exception erro)

{

throw erro;

}

-----------------------------------------------------------------------------------------------

this is my connection method, and I get the server name at some txt file

public string conectaSql(int i)

{

//string connectionString = Properties.Settings.Default.ConnectionString;

string dv = "";

try

{

string mysql = "select configura from conStringTbl where id= '" + i + "'";

using (SqlConnection myconn = new SqlConnection("Persist Security Info=False;Server=" + lineAccess[0] +"; DataBase=dbconString; user=ka; password =newbegining"))

{

myconn.Open();

using (SqlCommand comand = new SqlCommand(mysql, myconn))

{

SqlDataReader dtreader = comand.ExecuteReader();

if (dtreader.Read())

{

dv = dtreader[0].ToString();

}

return dv;

}

catch (Exception erro)

{

throw erro;

}

______________________________________________

on form login load I get the parameter

private void frmLogin_Load(object sender, EventArgs e)

{

CG.configTxt(@"c:\program Files\a.txt");

}

Thanks!!!!!

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted answer
Well, I've just tried the following console app which is essentially a cut-down version of the problem code and it's working fine, showing just a dot in the MessageBox which is the only thing in the file:

using System;
using System.IO;
using System.Collections;
using System.Windows.Forms;

class Program
{
public ArrayList lineAccess=new ArrayList();
public void configTxt(string ficheiro)
{
StreamReader conjLines;
string lines;

try
{
conjLines = new StreamReader(ficheiro);

while ((lines = conjLines.ReadLine()) != null)
{
lineAccess.Add(lines);
}

conjLines.Close();
}
catch (Exception erro)
{
throw erro;
}

MessageBox.Show((string)lineAccess[0]);
}

static void Main()
{
Program p = new Program();
p.configTxt("sousa.txt");
}
}

So I'm totally mystified as to why it's still not working :-/

You might try inserting the MessageBox line in your own code to see what you get.

0
Sousa Pambo12y ago
Hi Vulpes, sorry to take long to answer, but I found the solution. using the msg lines I saw that the code was unreachable in side the public string conectaSql(int i) I had to add configTxt(@"c:\program Files\a.txt") and its now working, but I still do not understand why it was unreachable while its a public method. Any way its now work, Thank you and Biswa, I could give up without your help.
0
Sousa Pambo12y ago
Hi thank again but its still showing the same msg. At the method ("public string conectaSql(int i)"), lineAccess[0] it is showing that the propriety Count=0, Capacity=0, etc. It's finding nothing on the file. I do not understand WHY!!!!!!

Is there some more ideia, i'm empty now....
0
Vulpes12y ago
Doh, I think I've spotted the problem and why I didn't see it before I don't know :(

If there's only one line, then this code is not adding it to the ArrayList which will therefore be empty:

try
{
conjLines = new StreamReader(ficheiro);
lines = conjLines.ReadLine();
//while (lines != null)
while ((lines =conjLines.ReadLine()) != null)
{
lineAccess.Add(lines);
//lines = conjLines.ReadLine();
}
conjLines.Close();
}
catch (Exception erro)
{
throw erro;
}

If you change it to this then it should work OK:

try
{
conjLines = new StreamReader(ficheiro);

while ((lines = conjLines.ReadLine()) != null)
{
lineAccess.Add(lines);
}

conjLines.Close();
}
catch (Exception erro)
{
throw erro;
}
0
Sousa Pambo12y ago
Hi Vulpes, thanks again for helping, be pacient please

I have one declaration .... here is the code

public class ConexaoGeral
{
public ArrayList lineAccess=new ArrayList();
public string conectaSql(int i)
{
//string connectionString = Properties.Settings.Default.ConnectionString;
string dv = "";
try
{
string mysql = "select configura from conStringTbl where id= '" + i + "'";
using (SqlConnection myconn = new SqlConnection("Persist Security Info=False;Server="+ lineAccess[0] +"; DataBase=dbconString; user=ka; password =newbegining"))
{
myconn.Open();
using (SqlCommand comand = new SqlCommand(mysql, myconn))
{
SqlDataReader dtreader = comand.ExecuteReader();
if (dtreader.Read())
{
dv = dtreader[0].ToString();
}

return dv;
}
}
}
catch (Exception erro)
{
throw erro;
}
}
public void FillComb(ComboBox comb, ArrayList arrlst)
{
try
{
comb.DataSource = arrlst;
comb.DisplayMember = "Display";
comb.ValueMember = "Value";
comb.Text = "";
comb.SelectedValue = "";

}
catch (Exception erro)
{ throw erro; }
}

public ArrayList FillCombGr(string tbl, string start)
{
string mySql = "select * from " + tbl + " where cbx like '%" + start + "%' order by cbx asc";
ArrayList Arrl = new ArrayList();
SqlConnection cnn = new SqlConnection(stringConexaoRH());
try
{
cnn.Open();
SqlCommand cmnd = new SqlCommand(mySql, cnn);
SqlDataReader dtR = cmnd.ExecuteReader();
while (dtR.Read())
{
Arrl.Add(new CombAdd((dtR["cbx"]).ToString(), (dtR["id"]).ToString()));
}
}
catch (Exception erro)
{ throw erro; }

return Arrl;

}
public string stringConexaoRH()
{
return conectaSql(1);
}

public void configTxt(string ficheiro)

{
StreamReader conjLines;
string lines;

try
{
conjLines = new StreamReader(ficheiro);
lines = conjLines.ReadLine();
//while (lines != null)
while ((lines =conjLines.ReadLine()) != null)
{
lineAccess.Add(lines);
//lines = conjLines.ReadLine();
}
conjLines.Close();
}
catch (Exception erro)
{
throw erro;
}

}

}

}

---------------------------------------------------------------------------------------
public partial class frmLogin : Form
{
//public String namUser;
DAL.Funcionario FuncDal = new DAL.Funcionario();
DAL.ConexaoGeral CG = new DAL.ConexaoGeral();

public frmLogin()
{
InitializeComponent();
}

public class UserClass
{
public string UserString;
}

private void btCancelar_Click(object sender, EventArgs e)
{
this.Close();
}

private void btEntra_Click(object sender, EventArgs e)
{
DAL.loginDal ldDal = new DAL.loginDal();


if(ldDal.podLogar(tbUser.Text,tbPw.Text))
{

UserClass UC = new UserClass();
UC.UserString = tbUser.Text;
this.Hide();
UIL.frmMain fm = new UIL.frmMain(UC);
UIL.frmFunc Ffunc = new UIL.frmFunc(UC);
fm.ShowDialog();
this.Close();
}

else
{
MessageBox.Show("Usuário ou Senha Errados");
}
}

private void frmLogin_Load(object sender, EventArgs e)
{

CG.configTxt(@"c:\program Files\a.txt");
}

}

}

Please check where I'm doing wrong!!!!!!
0
Vulpes12y ago
Can you just clarify where this code has been placed.

I notice that in frmLogin_Load you call the configTxt method like this:

CG.configTxt(@"c:\program Files\a.txt");

which suggests that it's in a different class to the form itself.

If so, is the declaration of the lineAccess ArrayList and the conectaSql method in the same class as configTxt or are they in the form itself?

What I'm wondering here is whether you might have inadvertently declared two ArrayLists one in the form and one in the class and that one of these is getting populated but the other one is still empty.

0
Sousa Pambo12y ago
Hi vulpes, thanks for help.

- I made some tests to see if it reads the file or not and I found it does (I changed the "a.txt" to "b.txt" the msg was "b" doesn't exist, this bug doesn't show for "a" file name).

- In the file ("a.txt") I only have "." because for while I testing my application with the local server, it means I have only one line to be read in the file.

So I don't understand the error.

Please help me on this!!!!!!!!!
0
Vulpes12y ago
Well, on the face of it, the only thing it can be is lineAccess[0].

If an index of 0 can't be found, then that would suggest that either there are no lines in the file or the file can't be found at all.
0
Sousa Pambo12y ago
Hi Biswa, thanks for help, but unfortunatly I still having a bug on.....

public string conectaSql(int i)
{
//string connectionString = Properties.Settings.Default.ConnectionString;
string dv = "";
try
{
string mysql = "select configura from conStringTbl where id= '" + i + "'";
using (SqlConnection myconn = new SqlConnection("Persist Security Info=False;Server="+ lineAccess[0] +"; DataBase=dbconString; user=ka; password =newbegining"))
{
myconn.Open();
using (SqlCommand comand = new SqlCommand(mysql, myconn))
{
SqlDataReader dtreader = comand.ExecuteReader();
if (dtreader.Read())
{
dv = dtreader[0].ToString();
}

return dv;
}
}
}
catch (Exception erro)
{
throw erro;
}
}

Error is ..... {"Index was out of range. Must be non-negative and less than the size of the collection.\r\nParameter name: index"}
0
Biswa Pujarini Mohapatra12y ago
check this code, also let me know if it does not solve your problem. please let me know the exact line where you are getting error

public ArrayList lineAccess=new ArrayList();

public void configTxt(string ficheiro)
{
StreamReader conjLines;
string lines;
try
{
conjLines = new StreamReader(ficheiro);
lines = conjLines.ReadLine();
while (lines =conjLines.ReadLine()) != null)
{
lineAccess.Add(lines);
//lines = conjLines.ReadLine();
}
conjLines.Close();
}
catch (Exception erro)
{
throw erro;
}
}

-----------------------------------------------------------------------------------------------
this is my connection method, and I get the server name at some txt file

public string conectaSql(int i)
{
//string connectionString = Properties.Settings.Default.ConnectionString;
string dv = "";
try
{
string mysql = "select configura from conStringTbl where id= '" + i + "'";
using (SqlConnection myconn = new SqlConnection("Persist Security Info=False;Server=" + lineAccess[0] +"; DataBase=dbconString; user=ka; password =newbegining"))
{
myconn.Open();
using (SqlCommand comand = new SqlCommand(mysql, myconn))
{
SqlDataReader dtreader = comand.ExecuteReader();
while (dtreader.Read())
{
dv = dtreader[0].ToString();
}
return dv;
}
}
}
catch (Exception erro)
{
throw erro;
}
}
______________________________________________
on form login load I get the parameter

private void frmLogin_Load(object sender, EventArgs e)
{
CG.configTxt(@"c:\program Files\a.txt");
}
0