Page Private con As New Sql Connection("Data Source=.; Initial Catalog=pubs; User ID=sa; Password=*****") Protected Sub Page_Load(By Val sender As Object, By Val e As System. Load If Not Is Post Back Then load Stores() End If End Sub Protected Sub load Stores() con.

Data Bind() Dim columncount As Integer = grid View.

Find Control("txtcity"), Text Box) Dim state As Text Box = Direct Cast(grid View.

Find Control("txtstate"), Text Box) Dim zip As Text Box = Direct Cast(grid View.

Empty; You are looking for the C# coalesce operator: ??

If the left hand side of the operator is null or a nullable with no value it will return the right argument.

To String("update stores set stor_name='" stor_name.

Edit Index = -1 load Stores() End Sub Protected Sub grid View_Row Deleting(By Val sender As Object, By Val e As Grid View Delete Event Args) Dim stor_id As String = grid View.

Find Control("txtname"), Text Box) Dim stor_address As Text Box = Direct Cast(grid View.

Find Control("txtaddress"), Text Box) Dim city As Text Box = Direct Cast(grid View.

Edit Index = -1 load Stores() End Sub Protected Sub grid View_Row Canceling Edit(By Val sender As Object, By Val e As Grid View Cancel Edit Event Args) grid View.