How to use radiobuttonlist value to show data from database

Hi,

Try like this

step 1: In aspx design page for radiobutton list give the value of each button with its responsive table names and AutoPostBack="true"

ex:
            onselectedindexchanged="rbtn_SelectedIndexChanged">
            annual leave
            emergency leave
            medical leave
            maternity leave
       

Step2: In .cs file on "rbtn_SelectedIndexChanged" event call the page you required like this with parameters "Table name" and "Item Name"

 if (rbtn.SelectedIndex > 0)
        {
            Response.Redirect("~/result.aspx?tblname=" + rbtn.SelectedValue.ToString() + "&&itemname=" + rbtn.SelectedItem.Text + "");
        }

Step 3: In Result page or ur required page make a function to call your required database using the table name parameter

public void getTable(string tablename)
    {
        string Qry = "select * from "+tablename+"";
....
.....


....

    }

step 4: In Result on load page

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.QueryString["itemname"] != "" && Request.QueryString["tblname"] != "")
            {
                getTable(Request.QueryString["tblname"].ToString());
            }
        }
    }

Try in this formate...

Hi ,
Please find the sample app attached for above requirement.

Abhishek