How to fix “There is no row at position 1”

Question

I arranging and extracting data from database to the datagrid, i am trying to custom the column and rows to display the data desired, through the looping i tried to match the data from the one of the datatable to get another data to fill into the datagrid, unfortunately i keep getting "There is no row at position 1 error". I've attached attachment to illustrate the problems faced by me.

I've gone through some of the posts in stackoverflow to resolve the problems,i can't find the problems. 1. Error There is no row at position 1 2. there is no row at position 1

private void generate_view1(DataTable search_data1)
{
DataTable sample_data1 = new DataTable();
sample_data1 = search_data1.Copy();
sample_data1.Columns.Add("Item_Number");
sample_data1.Columns.Add("Min_Tolerance");
sample_data1.Columns.Add("Max_Tolerance");
var database_select = new DatabaseSelect();
string OrderNo = Order_NO.Text.ToString();
DataTable result_data = new DataTable();
result_data = database_select.LoadTable_DOHEAD(OrderNo);
string SalesNO = result_data.Rows[0]["EAORNO"].ToString();
string Del_index = result_data.Rows[0]["EADLIX"].ToString();
var database_select1 = new DatabaseSelect();
DataTable result_weight = new DataTable();
result_weight = database_select.LoadTable_MITTRA(SalesNO, Del_index);
dataGrid1.ItemsSource = null;
dataGrid1.ItemsSource = sample_data1.DefaultView;
DataGridTextColumn Weight1 = new DataGridTextColumn();
dataGrid1.DisplayMemberPath = sample_data1.Columns["MTTRQT"].ToString();
Decimal sum = Convert.ToDecimal(sample_data1.Compute("SUM(MTTRQT)", string.Empty));
Weight.Text = (sum * -1).ToString();
//******Problems occur in below this part*********//
for (int i = 0; i < sample_data1.Rows.Count; i++)
{
string itemcode = sample_data1.Rows[i]["MTITNO"].ToString();
String ItemNumber = result_weight.Rows[i]["MTITNO"].ToString();
if (itemcode != " ")
{
sample_data1.Rows[i]["Item_Number"] = result_weight.Rows[i]["MTITNO"].ToString();
var database_select2 = new DatabaseSelect();
DataTable result_tolerance = new DataTable();
result_tolerance = database_select.LoadUser_Tolerance(ItemNumber); //** i've include my loadUser Tolerance query in here as well***//
sample_data1.Rows[i]["Min_Tolerance"] = result_tolerance.Rows[i]["Min_Tol"].ToString(); //*** this is the line where i face the problems***//
string MINTOL = result_tolerance.Rows[i]["Min_Tol"].ToString(); //*** i've put in this to illustrate the problems**//
MessageBox.Show(MINTOL); //*** i've put in this to illustrate the problems**//
}
}

LoadUser_Tolerance variable query( i am trying to select min tolerance from this query to insert it into my datagrid) For the results desired( you can refer the illustrations above), i only having this issues whenever i tried to get MinTolerance to display in my DataGrid. i can't figure out how to make this right.

public DataTable LoadUser_Tolerance(string ItemNO)
{
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = ConString;
conn.Open();
CmdString = "SELECT Item_NO, Min_Tol, Max_Tol FROM MasTolerance where Item_NO ='" + ItemNO + "'";
OdbcCommand cmd = new OdbcCommand(CmdString, conn);
OdbcDataAdapter sda = new OdbcDataAdapter(cmd);
DataTable dt = new DataTable("MasTolerance");
sda.Fill(dt);
return dt;
}

Debugging Attempts Tried.

if (result_tolerance.Rows.Count > i)
{
sample_data1.Rows[i]["Min_Tolerance"] = result_tolerance.Rows[i]["Min_Tol"].ToString();
string MINTOL = result_tolerance.Rows[i]["Min_Tol"].ToString();
MessageBox.Show(MINTOL + i);
}
else
{
MessageBox.Show("Error"); //** i can display the Item number in row 1, but Min tolerance for the Row 1 can't be display**//
}

Sorry to make the whole thing this long, but I have no choice.

lye nian · Answer

Dear amit, I will try it out later. Thanks man, and will update you soon

Amit Kumar · Answer

Hi,I saw you code on stackoverflow Code error line is.sample_data1.Rows[i]["Min_Tolerance"] = result_tolerance.Rows[i]["Min_Tol"].ToString(); In this line column Nin_Tol contains null Value and then u r using. ToString (). It always throw an error.Solve this issue first check if Min_Tol column contains null or empty.Use this code. First check your sample_data1 & result_tolerance != null and row is greater than 1. sample_data1.Rows[i]["Min_Tolerance"] = convert.IsDbnull (result_tolerance.Rows[i]) ?string (default) : ["Min_Tol"].ToString(); I hope this will help you.

Mohsin Arif · Answer

bro please debug and check that either it goes on if condition or not in seond time ??

lye nian · Answer

Dear Mohsin, I've tried your solutions, but it's not working. Thank you by the way.

Mohsin Arif · Answer

hi ihave read out your problem. please try to do this mine if (itemcode !=string.Empty) yours if (itemcode != " ") issue is this that there is no data on row no 1 of Itemcode thats why its goes in this condition . you have apply above condition which do some time confusion beacuse some time db have null and during executing it not diffrentiate either " " or null so best practice is this string.empty try this. otherwise debug the code and check on second row it goes into if condition or not.