请用VB来写,在datagrid中如何从radiobuttonlist取值出来更新数据库中某一字段.
帮帮忙!!!
帮帮忙!!!
解决方案 »
- 一个SQL面试题,没有思路,求助大侠们~~~~~~~!!
- 求高手帮忙 Extjs、asp.net打印报表问题
- 一个神奇的接口--------------------进来真的不会后悔--------------------还有80分哦
- 正则表达试问题
- 用 net 连接 远程 ORACLE 数据库
- 又来问简单的问题,关于datagrid中的值的显示的,很简单!
- 如何解决,点击按钮弹出新窗口时,之前窗口的table控件中的数据就不显示了!
- 关于用户控件获值的问题!
- 包含Google Map API的js能在服务器端执行成功么?
- 在asp.net的企业模板中添加新层的问题
- DataGrid的问题请各位帮帮忙!!!!!!!!!!!!!谢谢
- Asp.Net中DataGrid效率问题
<asp:datagrid id="DataGrid1" style="Z-INDEX: 103; LEFT: 16px; POSITION: absolute; TOP: 40px" runat="server">
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
<asp:RadioButtonList id="RadioButtonList2" runat="server">
<asp:ListItem Value="AAA">AAA</asp:ListItem>
<asp:ListItem Value="BBB">BBB</asp:ListItem>
<asp:ListItem Value="CCC">CCC</asp:ListItem>
</asp:RadioButtonList>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid>
----------------------------------------------
Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim radlst As RadioButtonList = Me.DataGrid1.Items(0).Cells(0).FindControl("RadioButtonList1")
Dim tmp As String = radlst.SelectedValue
'...... End Sub
<asp:datagrid id="DataGrid1" style="Z-INDEX: 103; LEFT: 16px; POSITION: absolute; TOP: 40px" runat="server">
<Columns>
<asp:TemplateColumn>
<EditItemTemplate>
<asp:RadioButtonList id="RadioButtonList1" runat="server">
<asp:ListItem Value="AAA">AAA</asp:ListItem>
<asp:ListItem Value="BBB">BBB</asp:ListItem>
<asp:ListItem Value="CCC">CCC</asp:ListItem>
</asp:RadioButtonList>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:EditCommandColumn ButtonType="PushButton" UpdateText="更新" CancelText="取消" EditText="编辑"></asp:EditCommandColumn>
</Columns>
</asp:datagrid>
-----------------------
Private Sub DataGrid1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.UpdateCommand
Dim radlst As RadioButtonList = e.Item.Cells(0).FindControl("RadioButtonList1")
Dim tmp As String = radlst.SelectedValue
dim curID as string = e.Item.Cells(1).Text
dim sql as string = "update table1 set field1='" & tmp & "' where id='" & curID & "'"
'......保存到数据库
End Sub
Dim rdbl As System.Web.UI.WebControls.RadioButtonList
Dim tbxh As System.Web.UI.WebControls.TextBox
Dim xh As String
' Dim xh As String = datagrid1.DataKeys(e.item.ItemIndex).ToString()
Dim lb As String
'取出radiobuttonlist的值
For Each item As System.Web.UI.WebControls.DataGridItem In datagrid1.Items
If (item.ItemType <> ListItemType.Footer And item.ItemType <> ListItemType.Header And item.ItemType <> ListItemType.Pager And item.ItemType <> ListItemType.Separator) Then
rdbl = CType(item.FindControl("radiobuttonlist1"), System.Web.UI.WebControls.RadioButtonList)
lb = rdbl.SelectedValue
'更新数据库
...........................'我这里的lb取到了值,但不知如何来更新数据库,
End If
Next
帮忙看一下?