索引超出了数组界限？？

[程序小海]

            SqlConnection conn = new SqlConnection("server=.;database=depot;uid=sa;pwd=hhh");
            conn.Open();
            string str="select p.name, o.number,o.ordersday,o.giveday,  p.id,p.name,p.how from particular as p join orders as o on p.id = o.id where   o.ordersday='"+dateTimePicker1.Text+"' and o.giveday='"+dateTimePicker2.Text+"' and name='"+comboBox1.Text+"'";
            SqlCommand cmd =new SqlCommand (str,conn);

            SqlDataReader sdr2 = cmd.ExecuteReader();
            while (sdr2.Read())
            {
                ListViewItem litem2 = new ListViewItem();
                litem2.Text=sdr2[4].ToString();
                litem2.SubItems.Add(sdr2[5].ToString());
                litem2.SubItems.Add(sdr2[6].ToString());
                litem2.SubItems.Add(sdr2[7].ToString());      //系统说超出了数组的界限
                listView1.Items.Add(litem2);
            }
            sdr2.Dispose();
            SqlDataReader sdr = cmd.ExecuteReader();
            while (sdr.Read())
            {
                ListViewItem litem = new ListViewItem();
                litem.Text = sdr[1].ToString();
                litem.SubItems.Add(sdr[2].ToString());
                listView2.Items.Add(litem);
            }

怎么解决 谢谢 各位！

[wuyq11]

只有7列。索引从0-6

[wuyq11]

ListViewItem litem2 = new ListViewItem();
litem2.Text=sdr2[3].ToString();
litem2.SubItems.Add(sdr2[4].ToString());
litem2.SubItems.Add(sdr2[5].ToString());
litem2.SubItems.Add(sdr2[6].ToString()); listView1.Items.Add(litem2);

[PandaIT]

错误太明显了！

索引是从0开始的!