Disabling radio buttons in radiobuttonlist

Question

0.00/5 (No votes)

See more:

I have a single RadioButtonList control with 4 ListItems within it.  At run time, based on a condition in my database, I may need to disable one or more of those ListItems.

What I have tried:

void bind()
   {
       SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
       string Query = "select slot from appoint where selectdate ='" + txtdate.Text + "'";
       DataTable dtAdmin = new DataTable();
       SqlDataAdapter da;
       da = new SqlDataAdapter(Query, cnn);
       da.Fill(dtAdmin);
       if (dtAdmin.Rows.Count > 0)
       {
           foreach (ListItem item in RadioButtonList1.Items)
           {
               if (item.Text == Query)
               {

                   item.Enabled = false;
               }

               else
               {
                   item.Enabled = true;
               }
           }
       }
   }

Posted 6-Nov-17 22:25pm

ADI@345

Updated 6-Nov-17 23:37pm

v5

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Accepted Answer · 2017-11-06T22:34:00

Solution 1

refer this example

<asp:RadioButtonList ID="RadioButtonList1" runat="server">
          <asp:ListItem Text="one" Value="1" />
          <asp:ListItem Text="two" Value="2" />
          <asp:ListItem Text="three" Value="3" />
          <asp:ListItem Text="four" Value="4" />
      </asp:RadioButtonList>

Quote:
I may need to disable one or more of those ListItems.

string[] itemsToDisable = { "1", "2" };
          foreach (string item in itemsToDisable)
          {
             var listItem =  RadioButtonList1.Items.FindByValue(item);
             if (listItem != null)
                 listItem.Enabled = false;
          }

Note : Formatting the sql Query string is vulnerable to SQL Injection[^] attacks
always use Parameterized queries to prevent SQL Injection Attacks in SQL Server[^]

use FindByText[^] or FindByValue[^] based on how you are populating the list items.
Correction to your code

SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
           string Query = "select slot from appoint where selectdate =@date";
           SqlCommand cmd = new SqlCommand(Query, cnn);
           cmd.Parameters.Add("@date", txtdate.Text);
           DataTable dtAdmin = new DataTable();
           SqlDataAdapter da = new SqlDataAdapter(cmd);
           da.Fill(dtAdmin);
           RadioButtonList1.Enabled = dtAdmin.Rows.Count > 0;

Posted 6-Nov-17 22:34pm

Karthik_Mahalingam

Updated 6-Nov-17 22:39pm

v4

Comments

ADI@345 8-Nov-17 0:14am

txtdate.Text = Calendar1.SelectedDate.ToString("dd/MM/yyyy");
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string Query = "select slot from appoint where selectdate =@date";
DataTable dtAdmin = new DataTable();
SqlDataAdapter da;
da = new SqlDataAdapter(Query, cnn);
da.Fill(dtAdmin);
if (dtAdmin.Rows.Count > 0)
{
foreach (ListItem item in RadioButtonList1.Items)
{
if (item.Text == Query)
{

item.Enabled = false;
}

else
{
item.Enabled = true;
}
}
}

ADI@345 8-Nov-17 0:15am

how can i disable radiobuttonlist 2 or 3 listitem based on database condition..

Karthik_Mahalingam 8-Nov-17 0:27am

If(item.Text == dtadmin.Rows[o]["slot"].To string())
{

ADI@345 8-Nov-17 0:38am

txtdate.Text = Calendar1.SelectedDate.ToString("dd/MM/yyyy");
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string Query = "select slot from appoint where selectdate = @date";
SqlCommand cmd = new SqlCommand(Query, cnn);
cmd.Parameters.Add("@date", txtdate.Text);
DataTable dtAdmin = new DataTable();
SqlDataAdapter da;
da = new SqlDataAdapter(cmd);
da.Fill(dtAdmin);
if (dtAdmin.Rows.Count > 0)
{
foreach (ListItem item in RadioButtonList1.Items)
{
if(item.Text == dtAdmin.Rows[0]["slot"].ToString())
{

RadioButtonList1.Items[0].Enabled = false;
}

else
{
RadioButtonList1.Items[0].Enabled = true;
}
}
}

i change my code but in dtAdmin.Rows.Count >0 it doesnot count , alwys show 0,but i have one record in my database

Karthik_Mahalingam 8-Nov-17 0:42am

try

   da.Fill(dtAdmin);
            if (dtAdmin.Rows.Count > 0)
            {
                DataTable dtAdmin = null;
                foreach (ListItem item in RadioButtonList1.Items)
                    item.Enabled = item.Text == dtAdmin.Rows[0]["slot"].ToString();
            }

Karthik_Mahalingam 8-Nov-17 0:43am

convert the text to a datetime object and pass to the command parameter
txtdate.Text
refer DateTime.TryParseExact Method (System)[^]

ADI@345 8-Nov-17 0:50am

My design :-
<asp:RadioButtonList ID="RadioButtonList1" runat="server" Width="100%">

<asp:ListItem Text="9:00 AM" Value="1">9:00 AM
<asp:ListItem Text="9:15 AM" Value="2">9:15 AM
<asp:ListItem Text="9:30 AM" Value="3">9:30 AM
<asp:ListItem Text="9:45 AM" Value="4">9:45 AM

<asp:ListItem Text="10:00 AM" Value="5">10:00 AM
<asp:ListItem Text="10:15 AM" Value="6">10:15 AM
<asp:ListItem Text="10:30 AM" Value="7">10:30 AM
<asp:ListItem Text="10:45 AM" Value="8">10:45 AM

<asp:ListItem Text="11:00 AM" Value="9">11:00 AM
<asp:ListItem Text="11:15 AM" Value="10">11:15 AM
<asp:ListItem Text="11:30 AM" Value="11">11:30 AM
<asp:ListItem Text="11:45 AM" Value="12">11:45 AM

<asp:ListItem Text="12:00 PM" Value="13">12:00 PM
<asp:ListItem Text="12:15 PM" Value="14">12:15 PM
<asp:ListItem Text="12:30 PM" Value="15">12:30 PM
<asp:ListItem Text="12:45 PM" Value="16">12:45 PM

<asp:ListItem Text="1:00 PM" Value="17">1:00 PM

Code:-
txtdate.Text = Calendar1.SelectedDate.ToString("dd/MM/yyyy");
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string Query = "select slot from appoint where selectdate = @date";
SqlCommand cmd = new SqlCommand(Query, cnn);
cmd.Parameters.AddWithValue("@date", txtdate.Text);
DataTable dtAdmin = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dtAdmin);
if (dtAdmin.Rows.Count > 0)
{
foreach (ListItem item in RadioButtonList1.Items)
{
if(item.Text == dtAdmin.Rows[0]["slot"].ToString())
{

item.Enabled = item.Text == dtAdmin.Rows[0]["slot"].ToString();
}

}
}

i dont know my mistake.. when i debug it doesnot count any row from database, thats why it doenot move inside if(dtAdmin.Rows.Count >0)..

Karthik_Mahalingam 8-Nov-17 1:11am

run this query and see what value you are getting in db
select slot from appoint where selectdate = 'your date'

ADI@345 8-Nov-17 1:54am

txtdate.Text = Calendar1.SelectedDate.ToString();
DateTime txtMyDate = DateTime.Parse(txtdate.Text);
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string Query = "select slot from appoint where selectdate = @date";
SqlCommand cmd = new SqlCommand(Query, cnn);
cmd.Parameters.AddWithValue("@date", txtMyDate);
DataTable dtAdmin = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dtAdmin);
if (dtAdmin.Rows.Count > 0)
{
foreach (ListItem item in RadioButtonList1.Items)
{
if(item.Text == dtAdmin.Rows[0]["slot"].ToString())
{

RadioButtonList1.Items[0].Enabled = false;
}

else
{
RadioButtonList1.Items[0].Enabled = true;
}
}
}
after parsing date , it work fine but doesnot disable radiobutton selected listitem..

Karthik_Mahalingam 8-Nov-17 2:04am

  da.Fill(dtAdmin);
            if (dtAdmin.Rows.Count > 0)
            {
                DataTable dtAdmin = null;
                foreach (ListItem item in RadioButtonList1.Items)
                    item.Enabled = item.Text == dtAdmin.Rows[0]["slot"].ToString();
            }

ADI@345 8-Nov-17 2:18am

Now my code work fine, thanks for help but still facing some problem. i.e if i have two slot in my database then it will disable two radiobutton listitem , right now only single listitem get disable.

txtdate.Text = Calendar1.SelectedDate.ToString();
DateTime txtMyDate = DateTime.Parse(txtdate.Text);
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string Query = "select slot from appoint where selectdate = @date";
SqlCommand cmd = new SqlCommand(Query, cnn);
cmd.Parameters.AddWithValue("@date", txtMyDate);
DataTable dtAdmin = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dtAdmin);
if (dtAdmin.Rows.Count > 0)
{
foreach (ListItem item in RadioButtonList1.Items)
if (item.Text == dtAdmin.Rows[0]["slot"].ToString())
{

item.Enabled = false;
}

else
item.Enabled = true;
}

this code work fine , but it disable only one time slot even if i have two two time slot in my database

Karthik_Mahalingam 8-Nov-17 2:33am

that simple, do the for loop to iterate the rows in the datatable. and enable it based on the row value.

ADI@345 8-Nov-17 2:36am

oky

Karthik_Mahalingam 8-Nov-17 3:04am

check the below code.

Karthik_Mahalingam 8-Nov-17 2:35am

  da.Fill(dtAdmin);
            string[] slots = dtAdmin.Rows.OfType<datarow>().Select(k=>k["slot"].ToString()).ToArray();
            if (dtAdmin.Rows.Count > 0)
            {
                foreach (ListItem item in RadioButtonList1.Items)
                    if ( slots.Contains( item.Text ))
                    {

                        item.Enabled = false;
                    }

                    else
                        item.Enabled = true;
            }

ADI@345 8-Nov-17 3:05am

Thanks a lot sir, finally my code work as per my requirement. but i didn't understand this code..
string[] slots = dtAdmin.Rows.OfType<datarow>).Select(k=>k["slot"].ToString()).ToArray();

Karthik_Mahalingam 8-Nov-17 3:07am

simplified version

 List<string> lst = new List<string>();

            foreach (DataRow row in dtAdmin.Rows)
            {
                lst.Add(row["slot"].ToString());
            }
            string[] slots = lst.ToArray();

ADI@345 8-Nov-17 3:18am

oky thank you sir for help..

Karthik_Mahalingam 8-Nov-17 3:21am

Welcome