Use Below code
ASPX code for first page(Insertions):
<table>
<tr>
<td>
Name:
</td>
<td>
<asp:TextBox ID="txtName" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Age:
</td>
<td>
<asp:TextBox ID="txtAge" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Yes/No:
</td>
<td>
<asp:RadioButtonList ID="RadioButtonList1" runat="server">
<asp:ListItem Selected="False" Value="1">Yes</asp:ListItem>
<asp:ListItem Selected="False" Value="0">No</asp:ListItem>
</asp:RadioButtonList>
</td>
</tr>
<tr>
<td colspan="2">
<asp:Button ID="btnSave" runat="server" Text="Save" OnClick="btnSave_Click" />
</td>
</tr>
</table>
CS CODE:
protected void btnSave_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Your Connection String");
con.Open();
SqlCommand cmd = new SqlCommand("Insert into tablename values('" + txtName.Text + "'," + txtAge.Text + "," + RadioButtonList1.SelectedValue + ")", con);
cmd.ExecuteNonQuery();
con.Close();
Response.Redirect("~/DisplayGrid.aspx");
}
ASPX Code for Display grid page:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField HeaderText="Name" DataField="Name" />
<asp:BoundField HeaderText="Age" DataField="Age" />
<asp:TemplateField HeaderText="Yes/No">
<ItemTemplate>
<%# (Eval("Yes/No").ToString()) == "1" ? "Yes" : "No" %>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
CS CODE:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlConnection con = new SqlConnection("Your connection String");
SqlDataAdapter da = new SqlDataAdapter("select * from tablename", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}