如何将单选按钮值存储到SQL Server数据库中

更新时间：2023-01-12 11:12:02

标记中:

in markup:

<asp:radiobuttonlist id="myradio1" runat="server">
        <asp:listitem id="option1" runat="server" value="male" />
        <asp:listitem id="option2" runat="server" value="female" />
<asp:radiobuttonlist />

在后面的代码中:

in code behind:

void Page_Load()
  { 
    if (Page.IsPostBack)
     { 
        Message.Text = "You have selected the " + radio1.SelectedItem.Value;
     }
  }

希望对您有所帮助:)

hope it helps :)

使用位数据类型存储单选按钮值.
如果选中了男性"单选按钮，则将"1"存储在男性"列中的数据库中.
当您将其恢复时，取决于值，请选中单选按钮.

Use Bit Data type to store radio button values.
if male radio button is checked then store "1" in database in male column.
when you fecth it back, depends upon values check radio buttons.

if (drReader("rbMale") == "1")
    rbMale.checked = true;
else
   rbFemale.checked = true;

嗨苏尼尔，

我正在通过示例示例解释您的问题.
在标记中:

Hi sunil,

i am explaining your question through a sample example.
in markup:

<body>
    <form id="form1" runat="server">
    <div>

        <table align="center" class="style1">
            <tr>
                <td colspan="2">
                    <h3>
                        Sample Registraion</h3>
                </td>
            </tr>
            <tr>
                <td class="style3">
                    Name:</td>
                <td>
                    <asp:TextBox ID="txtName" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td class="style3">
                    Email</td>
                <td>
                    <asp:TextBox ID="txtEmail" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td class="style3">
                    Gendere</td>
                <td>
                    <asp:RadioButtonList ID="rbtGender" runat="server" RepeatDirection="Horizontal">
                        <asp:ListItem>Male</asp:ListItem>
                        <asp:ListItem>Female</asp:ListItem>
                    </asp:RadioButtonList>
                </td>
            </tr>
            <tr>
                <td align="center" class="style2" colspan="2">
                    <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Submit" />
&nbsp;&nbsp;
                </td>
            </tr>
            <tr>
                <td align="center" class="style2" colspan="2">
                    <asp:Label ID="lblmsg" runat="server"></asp:Label>
                </td>
            </tr>
        </table>

    </div>
    </form>
</body>

在代码绑定中:

in code bind:

protected void Button1_Click(object sender, EventArgs e)
   {
       string cs = ConfigurationManager.ConnectionStrings["srinivasdb"].ConnectionString;
       SqlConnection cn = new SqlConnection(cs);
       SqlCommand cmd = new SqlCommand();
       cmd.Connection = cn;
       cmd.CommandType = CommandType.Text;
       cmd.CommandText = "insert into GenderSample values(@Name,@Email,@Gender)";
       cmd.Parameters.Clear();
       cmd.Parameters.AddWithValue("@Name", txtName.Text);
       cmd.Parameters.AddWithValue("@Email", txtEmail.Text);
       cmd.Parameters.AddWithValue("@gender", rbtGender.SelectedValue);
       if (cn.State == ConnectionState.Closed)
           cn.Open();
       cmd.ExecuteNonQuery();
       cn.Close();
       lblmsg.Text = "Data entered successfully!!!";
   }<pre>

我希望这个例子可以解决您的问题.
祝你有美好的一天！！！

I hope this example clears your problem.
Have a good day!!!

上一篇 : ：检查Sql Database中是否存在表下一篇 : 将图像从数据网格保存到Sql DataBase

如何将单选按钮值存储到SQL Server数据库中

相关阅读

技术问答最新文章