如何将单选按钮值存储到SQL Server数据库中 [英] how to store radiobutton value into sql server database
本文介绍了如何将单选按钮值存储到SQL Server数据库中的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有2个用于男性和女性的单选按钮，C#代码将存储在数据库中什么?
检查任何一个按钮后...
i have 2 radio button for male and female,what will C# code to store in database?
after checking any one button...
推荐答案
标记中:
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" />
</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 Server数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
