Index Out of Range Exception

See more:

C#

Hi,

I am working on this program for work where a user scans in a serial # and and they enter in a part # to be replace and it populates a grid. For ex, The grid would look like:

[0].DESCRIPTION [1].REFURB PART # [2].QTY [3]. COMPLETED [4].REFURB RATE

[0]. Cover
[1].CE-4014495
[2.]1
[3].(Check
Would
Appear
Here)
The Refurb Rate Column is the column I'm currently working on.Every time I try to debug the program, it gives me the Index Out of Range Exception when trying to add the refurb rate to the grid. I have some coding experience, but not in object arrays and adding values to a grid. Is their any individual or individuals that can help me. Thank you.

Justin

Here is some of my code to look at:

//This is where I call the methods

int refRate = GetRefurbRate();
grdRefurb.Enabled = true;

ADDRefurbRate();

}
}
//Get the Refurb Rate for the day
private int GetRefurbRate()
{
string sql = "";
//bool ret = true;
int Refurb_Rate = 0;

//string error_msg = "";

//grdRefurbChoices.Rows.Clear();
sql = "SELECT COUNT(*) " +
"FROM " + schema + ".repair_part r " +
"WHERE r.repair_ord = '" + txtRO.Text + "' ";

while (true)
{
string error_msg = "";

if (!myDb.RunSql(sql, true))
{
error_msg = "DBError for getting Refurb_Rate";
break;
}
int totalRefurb = 5;// the 5 and 10 are ex values that I entered
int totalUnits = 10;//because the refurb rate was throwing an exception of 0 first.

while (myDb.dbRdr.HasRows)
{
if (!myDb.dbRdr.Read())
break;

try
{
Refurb_Rate = (totalRefurb / totalUnits * 100);
}
catch (Exception e)
{
Console.WriteLine(e);
}

if (myDb.dbRdr.Read())
{
Refurb_Rate = Convert.ToInt32(myDb.dbRdr.GetValue(4));
}
}

break;
}

myDb.dbRdr.Close();
return Refurb_Rate;
}
// add refurb rate to the grid
//I commented out all of the database code b/c I assumed I didn't need them.
private bool ADDRefurbRate()
{

//string sql = "";
bool ret = true;
int Refurb_Rate = 0;
Int32 selectedRowCount = grdRefurbChoices.Rows.GetRowCount(DataGridViewElementStates.Selected);

string error_msg = "";

// grdRefurbChoices.Rows.Clear();
//sql = "SELECT COUNT(.repair_ord, .ref_desig,.part_nbr_inst,.part_nbr_rmvd) " +
// "FROM " + schema + ".repair_part " +
// "WHERE repair_ord = '" + txtRO.Text + "' ";

while (true)
{

//if (!myDb.RunSql(sql, true))
//{
// error_msg = "DBError for getting Refurb_Rate";
// break;
//}

//int totalRefurb = 0;
//int totalUnits = 0;

//while (myDb.dbRdr.HasRows)
{
//if (!myDb.dbRdr.Read())
// break;

//Refurb_Rate = (totalRefurb / totalUnits * 100);

Refurb_Rate++;

//object[] values = new object[myDb.dbRdr.FieldCount];
object[] grd_values = new object[4];

// Add refurb rate information on the lower-right grid
//string part_nbr = myDb.dbRdr.GetValue(4).ToString();
//Refurb_Rate = Convert.ToInt32(myDb.dbRdr.GetValue(4));

if (part_completed && Refurb_Rate <= 0)
{
MessageBox.Show("Refurb Rate, " + Refurb_Rate + ", is zero.",
"Get Refurb Rate",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);

ret = false;
break;
}

grd_values[4] = Refurb_Rate;
grdRefurbChoices.Rows.Add(grd_values);// this is where the error comes in.
grdRefurbChoices.Rows[0].Selected = true;

ret = true;

if (!ret) break;

int found_index = 0;

for (int i = 0; i < grdRefurb.Rows.Count; i++)
{
grdRefurb.Rows.Add(grd_values);
grdRefurb.Visible = true;
found_index = i;

break;

//return found_index;

//return found_index;
}

//myDb.dbRdr.Close();

if (error_msg != String.Empty)
{
MessageBox.Show(error_msg, "Get Refurb Rate",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}

break;

}

}
return ret;
}

Let me know if you need the whole program to further help.Thank you.

[added code block]