zareei_ta
چهارشنبه 23 آذر 1390, 16:25 عصر
من کد زیر را نوشتم که سطرهای گرید را دیتابیس ذخیره کنه. اما فقط سطر آخر گرید را ذخیره میکنه.مشکلش چیه
foreach (GridViewRow r in GridView1.Rows)
{
lblSoftName = (Label)r.Cells[0].FindControl("lblSoftName");
//lblSoftPrice = (Label)r.Cells[0].FindControl("lblTotalPrice");
lblSoftId = (Label)r.Cells[0].FindControl("lblSoftId");
}
for (int i = 0; i < GridView1.Rows.Count; i++)
{
cn.ConnectionString = StrConnection;
cmd.CommandType = CommandType.Text;
cmd.Connection = cn;
cmd.CommandText = "insert into Sells(InvoiceNumber,InvoiceDate,TransactionId,User Id,SoftwareId) values(N'" + lblInvNumber.Text.Trim() + "',N'" + lblInvDate.Text.Trim() + "',N'" + lblRefNumber.Text.Trim() + "',N'" + lblUserId.Text.Trim() + "',N'" + lblSoftId.Text.Trim() + "')";
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
foreach (GridViewRow r in GridView1.Rows)
{
lblSoftName = (Label)r.Cells[0].FindControl("lblSoftName");
//lblSoftPrice = (Label)r.Cells[0].FindControl("lblTotalPrice");
lblSoftId = (Label)r.Cells[0].FindControl("lblSoftId");
}
for (int i = 0; i < GridView1.Rows.Count; i++)
{
cn.ConnectionString = StrConnection;
cmd.CommandType = CommandType.Text;
cmd.Connection = cn;
cmd.CommandText = "insert into Sells(InvoiceNumber,InvoiceDate,TransactionId,User Id,SoftwareId) values(N'" + lblInvNumber.Text.Trim() + "',N'" + lblInvDate.Text.Trim() + "',N'" + lblRefNumber.Text.Trim() + "',N'" + lblUserId.Text.Trim() + "',N'" + lblSoftId.Text.Trim() + "')";
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}