How to make columns invisible and still be able to reference the data in the column…

Protected Sub GridView1_RowCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowCreated

'Why this works? Because the event is called after the data is bound to the grid... This ensures that the column has been databound and then it is hidden.

e.Row.Cells(1).Visible = False 'id_bank

e.Row.Cells(3).Visible = False 'id_status

End Sub

How to adjust the column widths dynamically…

1. Ensure the Gridview width style attribute set on the html side to the total of the cells widths…

<asp:GridView… Width="1400px"

2. Add this code to the RowDataBound event for all of your comments…

a. e.Row.Cells(0).Width = 100

b. e.Row.Cells(1).Width = 500

c. e.Row.Cells(2).Width = 100

d. e.Row.Cells(3).Width = 100

e. e.Row.Cells(4).Width = 200

f. e.Row.Cells(5).Width = 200

g. e.Row.Cells(6).Width = 100

h. e.Row.Cells(7).Width = 100

3. Add this code to the page_Load event….

GridView1.Attributes.Add("style", "word-break:break-all;word-wrap:break-word")

How to disable editing a bound field…

Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound

e.Row.Cells(4).Enabled = False

End Sub

1. Drop the gridview on your aspx page

2. Add a “ButtonField” and change the CommandName to cmdAssign

3. Assign it’s Command Argument like this….

Protected Sub GridView1_RowCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowCreated

If e.Row.RowIndex > 0 Then

Dim btnAssign As Button = DirectCast(e.Row.FindControl("cmdAssign"), Button)

If Not btnAssign Is Nothing Then

btnAssign.CommandArgument = e.Row.RowIndex.ToString

End If

End Sub

4. Use the feature like this…

Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView1.RowCommand

Response.Write("id_passage=" & GridView1.Rows(e.CommandArgument).Cells(2).Text)

End Sub

The “Select” button is much more straight forward….

Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.SelectedIndexChanged

Response.Redirect("PassageEdit.aspx?id_passage=" & GridView1.SelectedRow.Cells(2).Text & "&Passage=" & GridView1.SelectedRow.Cells(4).Text)

End Sub

More Sample how to’s…

How to reference some text in a particular cell…

Private Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound

If e.Row.RowType = DataControlRowType.DataRow Then

If IsDate(e.Row.Cells(4).Text) Then

e.Row.Cells(4).Text = CType(e.Row.Cells(4).Text, Date).ToShortDateString

End If

End Sub

How to change the header….

Private Sub GridView1_RowCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowCreated

If e.Row.RowType = DataControlRowType.Header Then

e.Row.Cells(0).Text = "Exam Name"

e.Row.Cells(1).Text = "First"

e.Row.Cells(2).Text = "Last"

e.Row.Cells(3).Text = "Exam Date"

End If

End Sub

Another How to…

1. Drop a GridView on your webform

2. Through the GridView’s Gui, add a template , then add a button to the template column. Name the button “cmdMyButton”

Private Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView1.RowCommand

Response.Write(e.CommandName & " " & e.CommandArgument)

End Sub

Private Sub GridView1_RowCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowCreated

If e.Row.RowType = DataControlRowType.DataRow Then

Dim b As Button

b = e.Row.Cells(0).FindControl("cmdMyButton")

b.CommandArgument = e.Row.RowIndex

b.CommandName = "MyButton"

End If

End Sub