Vb.net questionRSS

2 replies

Last post Mar 01, 2018 02:27 AM by Brando ZWZ

‹ Previous Thread|Next Thread ›

Shortcuts

Related Links

- Reply
MOHIIMRAN
None

0 Points

3 Posts

Vb.net question

Feb 28, 2018 09:08 PM|MOHIIMRAN|LINK
protected Sub Submit_Click(sender As Object, e As EventArgs) Handles Submit.Click
Dim Billpp As String = String.Empty
If rbYes.Checked Then
Billpp = "Y"
ElseIf rbNo.Checked Then
Billpp = "N"
End If
Dim constr As String = ConfigurationManager.ConnectionStrings("Cong").ConnectionString
Using con As New SqlConnection(constr)
Using cmd As New SqlCommand("INSERT INTO Tbillpp(Billpp,ClaimID,JobID) VALUES(@Billpp,@ClaimID,@JobID)")
cmd.Connection = con
cmd.Parameters.AddWithValue("@Billpp", Billpp)
cmd.Parameters.AddWithValue("@ClaimID", Request.QueryString("ClaimID"))
cmd.Parameters.AddWithValue("@JobID", Request.QueryString("JobID"))
con.Open()
cmd.ExecuteNonQuery()
con.Close()
End Using
End Using
End Sub
End Class

how can I change the code so it deplays the current radio button valve?

mgebhard

All-Star

42811 Points

18209 Posts

Re: Vb.net question

Feb 28, 2018 09:40 PM|mgebhard|LINK

MOHIIMRAN
how can I change the code so it deplays the current radio button valve?

The way the code is written it appears you have two different radio button. You should use a radio button list.

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="default.aspx.cs" Inherits="WebFormsDemo._default" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Default</title>
</head>
<body>
    <form id="form1" runat="server" method="post">

        <asp:RadioButtonList ID="YesNo" runat="server">
            <asp:ListItem Text="Yes" Value="Y"></asp:ListItem>
            <asp:ListItem Text="No" Value="N"></asp:ListItem>
        </asp:RadioButtonList>
        <hr /> 
        <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
        <div>
            <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
        </div>
    </form>

</body>
</html>

namespace WebFormsDemo
{  
    public partial class _default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {


        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            Label1.Text = "You selected " + YesNo.Text;
        }
    }


}

- Reply
Brando ZWZ
Star

9501 Points

2979 Posts
Re: Vb.net question

Mar 01, 2018 02:27 AM|Brando ZWZ|LINK
Hi MOHIIMRAN,

As mgebhard says, I suggest you could try to use radiobutton list.

If you use two radio button, we could select both two button.

More details, you could refer to below codes:
```
        <asp:RadioButtonList ID="YesNo" runat="server">
            <asp:ListItem Text="Yes" Value="Y"></asp:ListItem>
            <asp:ListItem Text="No" Value="N"></asp:ListItem>
        </asp:RadioButtonList>
```
Codebehind:
```
    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Response.Write(YesNo.SelectedItem.Value.ToString())
    End Sub
```
Result:

Best Regards,

Brando
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

‹ Previous Thread|Next Thread ›