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..