Click here to Skip to main content
11,709,033 members (62,105 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# WinForm
Hello, Good Day Code Project
I am using a RadListView for my project.. In my RdalistView i have 7 columns namely Category, Product, Quantity, Unit, Size, Unit Price, Amount. and in that listview i am populating data .. after i populated data from RdalistView, i want now to save it to Sql Database but i've got an exception ..

Here is my exception
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index



And Here is my Code..
 private void AddOrder_Click(object sender, EventArgs e)
        {
            int counter = radListView1.Items.Count();
            MessageBox.Show(""+counter);
            SqlConnection con = new SqlConnection(connection);
            con.Open();
            for (int i = 0; i < counter; i++)
            {
 
                SqlCommand cmd = new SqlCommand("insert into Sales_Order_Detailss (Category, ProductName, Quantity, Size, Unit, UnitPrice, Amount)values('" + radListView1.Items[i].SubItems[0].ToString() + "','" + radListView1.Items[i].SubItems[1].ToString() + "','" + radListView1.Items[i].SubItems[2].ToString() + "','" + radListView1.Items[i].SubItems[3].ToString() + "', '" + radListView1.Items[i].SubItems[4].ToString() + "','" + radListView1.Items[i].SubItems[5].ToString() + "','" + radListView1.Items[i].SubItems[6].ToString() + "','" + radListView1.Items[i].SubItems[7].ToString() + "')", con);
                cmd.ExecuteNonQuery();
 
            }
            con.Close();
}

when i click the button Add it shud add to database

please help me.. how to that.. Thank You Very Much
I'll appreciate if you help me..
Posted 26-Feb-13 15:45pm
Edited 26-Feb-13 16:11pm
(no name)18.9K
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 580
1 Maciej Los 235
2 Peter Leow 219
3 OriginalGriff 214
4 Mika Wendelius 170
0 OriginalGriff 9,348
1 Sergey Alexandrovich Kryukov 8,727
2 CPallini 5,189
3 Maciej Los 4,991
4 Mika Wendelius 3,856


Advertise | Privacy | Mobile
Web01 | 2.8.150819.1 | Last Updated 26 Feb 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100