How to change the following code in VB.net in order to use it in asp.net using VB

Question

User803642803 posted

 , I got the following errors:

1. row is not member of GridView

2. Me.Qty.Index in not member of GridView

   For Each rows As DataGridViewRow In Me.InvoiceDetailsDataGridView.row
       If Row.Cells(Me.Qty.Index).Value = "" Then Exit For
   
       strSQL = "INSERT INTO InvoiceDetails (InvoiceID, Qty, ProductName, Price) VALUES(" & identity & ", " & Row.Cells(Me.Qty.Index).Value & ",'" & Row.Cells(Me.ProductName.Index).Value & "'," & Row.Cells(Me.Price.Index).Value & ")"
   
       cmd = New SqlCommand(strSQL, conn)
       cmd.ExecuteNonQuery()
   Next Row

Answer 1

User753101303 posted

Hi,

ASP.NET uses GridView and GridViewRow types. Not sure in which object you have this (typed dataset).

You likely have better ways to do that. You could consider having a look at http://www.asp.net/web-forms/overview/presenting-and-managing-data/model-binding/retrieving-data

Answer 2

User1724605321 posted

HI Ayman Qadah ,

Also see below code samples (not use model binding ) .You could perform CRUD in GridView like :

http://www.encodedna.com/gridview/tutorial/perform-crud-operation-using-gridview-aspdotnet.htm 

using Stored Procedure with SQL Server database backend in ASP.Net like :

http://www.aspsnippets.com/Articles/GridView-CRUD-Select-Insert-Edit-Update-Delete-using-Single-Stored-Procedure-in-ASPNet.aspx 

Best Regards,

Nan Yu