CodeSnip: How to Create a DataGrid in ASP.NET with Multiple Radio Buttons Per Row
page 2 of 5
by Nidal Arabi
Feedback
Average Rating: 
Views (Total / Last 10 Days): 21954/ 39

Solution

You will need to create a website using Visual Basic .NET by following the steps given below.

1.      Name the project MultipleRadioButtons.

2.      Now take a DataGrid from the toolbox and post it on webform1.

3.      Add a template column to the DataGrid.

4.      Enter template editing mode for the template column.

5.      Add a label in the template item field and name it LblStatus.

6.      End template editing.

7.      Go back to the web form and create a button and name it BtnProcess.

8.      Drag a textbox from toolbox, place it on the web form and name it TxtProcess.  Then set the TextMode property to Multiline.

For a complete WebForm design take a look to figure below.

Figure 2

Now, for the page load event you have the following code that should be inserted.

Listing 1

Dim MySQLConnection As New SqlClient.SqlConnection
Dim MySQLCommand As New SqlClient.SqlCommand
Dim MyDataAdapter As New SqlClient.SqlDataAdapter
Dim MyDataSet As New Data.DataSet
MySQLConnection.ConnectionString = _
"Data Source=.; Initial Catalog=Northwind; User ID=sa; Password=pass@word1"
MySQLConnection.Open()
MySQLCommand.Connection = MySQLConnection
MySQLCommand.CommandType = CommandType.Text
MySQLCommand.CommandText = "Select TOP 10 ProductId, ProductName From Products"
MyDataAdapter.SelectCommand = MySQLCommand
MyDataAdapter.Fill(MyDataSet, "Products")
DataGrid1.DataSource = MyDataSet
DataGrid1.DataMember = "Products"
DataGrid1.DataBind()

Remember that you have to change the connection string as to connect to your database server. Now to create the multiple radio buttons on the fly, add the following code on a clean part of your code page.

Listing 2

Private Sub DataGrid1_ItemDataBound(ByVal sender As Object, _
ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) _
Handles DataGrid1.ItemDataBound
  If e.Item.ItemType = ListItemType.AlternatingItem Or e.Item.ItemType =
    ListItemType.Item Then
    Dim r As Label
    r = e.Item.FindControl("LblStatus")
    r.Text = "<input type='radio' name='" & "mycheckoption" & e.Item.ItemIndex & "'
    Value = 'APPROVED' checked>Accept" & _
    "<input type='radio' name='" & "mycheckoption" & e.Item.ItemIndex & "' value='REJECTED'>Reject" & _
      "<input type='radio' name='""mycheckoption" & e.Item.ItemIndex & "' value='CANCELLED'>Cancel"
  End If
End Sub

View Entire Article

User Comments

Title: CodeSnip: How to Create a DataGrid in ASP.NET with Multiple Radio Buttons Per Row   
Name: Naina
Date: 2009-02-20 3:07:29 PM
Comment:
This was very useful...but can you please tell me how to maintain the selection between page post backs

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-04-19 11:23:58 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search