exception unhandled

Question

string cellvalue = dataGridView1[customer_id index].Value.ToString(); SqlCommand cmdd = new SqlCommand(SELECT * FROM bike_sales WHERE customer_id=' + cellvalue + ' my); SqlDataReader rdd = cmd.ExecuteReader(); rdd.Read(); up.textBox26.Text = rdd[stock_id].ToString();here i got error index out of range exception unhandled whats wrong with it hlp plz

ta mu · Answer

after a long time i found the error and that is i am using am executinting first command with all data reader.

ta mu · Answer

i tried all in upper cases but still that error.

Vulpes · Answer

I've just checked the SqlDataReader.Item property (indexer in C#) on MSDN to see what it says about finding columns by name: http://msdn.microsoft.com/en-us/library/f01t4cfy(v=vs.110).aspx In view of what it says in the Remarks section I think the safest thing to do is to use the same casing (i.e. upper case) for the column names as in the database table itself just in case this could be causing a problem somewhere along the line.

Vulpes · Answer

I'd have thought that this line: SqlCommand cmdd = new SqlCommand(SELECT * FROM bike_sales WHERE STOCK_ID=' + cellvalue + ' my); should be: SqlCommand cmdd = new SqlCommand(SELECT * FROM bike_sales WHERE CUSTOMER_ID =' + cellvalue + ' my); which appears to be what you had in the first place but otherwise it looks OK on a first read through.

ta mu · Answer

this is complete code of event. i want to populate data in a form from diffrent tables. may be this procedure is wrong . relationship is shown in the pic a uploaded plz help private void dataGridView1_DoubleClick(object sender EventArgs e) { my.Open(); string cellvalue = dataGridView1[customer_id index].Value.ToString(); SqlCommand cmd = new SqlCommand(SELECT * FROM addcustomer WHERE customer_id='+cellvalue+'my); SqlDataReader rd = cmd.ExecuteReader(); rd.Read(); up.textBox1.Text = rd[customer_id].ToString(); up.textBox2.Text = rd[Name].ToString(); up.textBox3.Text = rd[Father_name].ToString(); up.textBox4.Text = rd[CNIC_No].ToString(); up.textBox5.Text = rd[Phone_No].ToString(); up.textBox6.Text = rd[Occupation].ToString(); up.textBox7.Text = rd[Address].ToString(); up.textBox17.Text = rd[Refrence_1_Name].ToString(); up.textBox18.Text = rd[Refrence_1_Father_name].ToString(); up.textBox19.Text = rd[Refrence_1_Phone_No].ToString(); up.textBox20.Text = rd[Refrence_1_Address].ToString(); up.textBox21.Text = rd[Refrence_2_Name].ToString(); up.textBox22.Text = rd[Refrence_2_Father_name].ToString(); up.textBox23.Text = rd[Refrence_2_Phone_No].ToString(); up.textBox24.Text = rd[Refrence_2_Address].ToString(); rd.Close(); SqlCommand cmdd = new SqlCommand(SELECT * FROM bike_sales WHERE STOCK_ID=' + cellvalue + ' my); SqlDataReader rdd = cmd.ExecuteReader(); rdd.Read(); up.textBox26.Text = rdd[STOCK_ID].ToString(); up.textBox12.Text = rdd[Advance].ToString(); up.textBox13.Text = rdd[Due_amount].ToString(); up.textBox14.Text = rdd[One_installment_price].ToString(); up.textBox15.Text = rdd[No_of_installments].ToString(); up.dateTimePicker1.Value = System.Convert.ToDateTime(rdd[sale_date]); rdd.Close(); SqlCommand cmds = new SqlCommand(SELECT * FROM add_stock WHERE stock_id=' + up.textBox26 + ' my); SqlDataReader rds = cmd.ExecuteReader(); rds.Read(); up.textBox16.Text = rds[bike_model].ToString(); up.textBox8.Text = rds[Engine_No].ToString(); up.textBox9.Text = rds[Frame_No].ToString(); up.textBox25.Text = rds[purchase_price].ToString(); up.textBox10.Text = rds[Registration_No].ToString(); up.textBox11.Text = rds[Sale_price].ToString(); rds.Close(); my.Close(); }

Vulpes · Answer

On the face of it the bike_sales table doesn't have a column called stock_id. So are you sure that the name of this column is correct?