can't update data using gridview

[wsyeager]

In my page_load event, I have the following code:

<code>

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

Try
If Not Page.IsPostBack Then
BindGrid()
Else
GridView1.DataSource = DirectCast(Session.Item("dtCustomers"), DataTable)
End If
Catch ex As Exception
Response.Write(ex.Message)
End Try

End Sub

</code>

While debugging, I have the following in the Immediate Window after the postback:

?GridView1.Rows.Count
10



Once I clicked the Edit button, it fired the RowEditing event which I have the following code:

<code>
Protected Sub GridView1_RowEditing(ByVal sender As Object, ByVal e As

System.Web.UI.WebControls.GridViewEditEventArgs) Handles GridView1.RowEditing

GridView1.EditIndex = e.NewEditIndex
GridView1.DataBind()

End Sub

</code>

Right at the End Sub, I had another breakpoint to examine the rows in the gridview to make sure they

were still there as follows:

?GridView1.Rows.Count
10



My html of the gridview looks like this:

<code>

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False">
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:TemplateField HeaderText="CustomerID" SortExpression="CustomerID">
<ItemTemplate>
<asp:HyperLink ID="hylCustomerID" runat="server" Target="_blank" Text=<%#

Bind("CustomerID") %>></asp:HyperLink>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="CompanyName" HeaderText="CompanyName" />
<asp:BoundField DataField="ContactName" HeaderText="ContactName"

SortExpression="ContactName" />
<asp:BoundField DataField="ContactTitle" HeaderText="ContactTitle" />
<asp:BoundField DataField="Address" HeaderText="Address" />
<asp:BoundField DataField="City" HeaderText="City" />
<asp:BoundField DataField="Region" HeaderText="Region" />
<asp:BoundField DataField="PostalCode" HeaderText="PostalCode" />
<asp:BoundField DataField="Country" HeaderText="Country" />
<asp:BoundField DataField="Phone" HeaderText="Phone" />
<asp:BoundField DataField="Fax" HeaderText="Fax" />
</Columns>
</asp:GridView>

</code>



Inside the RowUpdating event, I have the following code (which was shortened for brevity):

<code>

Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As

System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridView1.RowUpdating

Dim dtCustomers As New DataTable

Try
Dim dr As DataRow = dtCustomers.NewRow
dr.Item("CustomerID") = GridView1.Rows(e.RowIndex).Cells(0).Text
dr.Item("CompanyName") = GridView1.Rows(e.RowIndex).Cells(1).Text
........
dtCustomers.Rows.Add(dr)
dtCustomers.Rows(0).SetModified()
Dim cls1 As New Class1
Dim intRecdsAffected As Int16 = cls1.UpdateCustomer(dtCustomers)
cls1 = Nothing
GridView1.EditIndex = -1
BindGrid()
Catch ex As Exception
Response.Write(ex.Message)
End Try

End Sub

</code>


When I try to examine the following line of code in the above event

"GridView1.Rows(e.RowIndex).Cells(0).Text", I get an empty string. Note below:

?gridview1.Rows(e.RowIndex).Cells(1).Text
""
?gridview1.Rows(e.RowIndex).Cells(0).Text
""
?gridview1.Rows(e.RowIndex).Cells(2).Text
""
?gridview1.Rows(e.RowIndex).Cells(3).Text
""
?gridview1.Rows(e.RowIndex).Cells(4).Text
""
?gridview1.Rows(e.RowIndex).Cells(5).Text
""

?GridView1.Rows.Count
10



Notice that I still have the 10 records in the gridview count at this point. I am not using any

DataSource controls, so I cant use the "NewValues" property of the gridview.

How can I properly retrieve the values inside the grid at this point? It seems very simple, but I am

obviously missing something here.

 

[dinoboy]

Do you want to update the existing row or add a new row?
If you are trying to update, then you should use
Dim dr As DataRow = dtCustomers.Rows[dtCustomers.EditItemIndex]
which returns the row which you are editing
Right now you are using
Dim dr As DataRow = dtCustomers.NewRow
which returns the newly added row and of course in case of update, cells have no values.

 

[wsyeager]

You are correct. However, the following code snippet:
<code>
GridView1.Rows(e.RowIndex).Cells(0).Text
</code>
should return the row being edited in the actual gridview. The above code gives me an empty string when it should give me the value in the gridview cell.

How come I am getting an empty string value for the gridview cell?

 

[criminallawyer]

Now, I can update the data as expecting.
But I still have one problem.
When using ntext type and updating, an unhandled exception occurred: The data types ntext and nvarchar are incompatible in the equal to operator.
But when I change ntext type to nvarchar(max) everything goes fine.
How can I solve this problem without changing ntext to nvarchar(max)

 

[shae marks]

You must go to in this direction

DataRow = dtCustomers.Rows[dtCustomers.EditItemIndex]


Regards