I want to disable radio button list item if system current time is more than radiobutton list item.

Question

0.00/5 (No votes)

See more:

i am facing issue i have radiobutton with different time slot and i want to disable radio button list item if system current time is more than radiobutton list item.

I am getting error input string is not in correct format..

What I have tried:

<pre>  string id = Request.QueryString["id"];
        txtdate.Text = Calendar1.SelectedDate.ToShortDateString();
        Calendar1.Visible = false;
       
      //  DateTime txtMyDate = DateTime.Parse(txtdate.Text);
        SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        string Query = "select slot from appoint where selectdate = @date and doc_id='"+id+"'";
        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)
        {
            string[] slots = dtAdmin.Rows.OfType<DataRow>().Select(k => k["slot"].ToString()).ToArray();
            string time = DateTime.Now.ToString("HH:mm tt");

            foreach (ListItem item in RadioButtonList1.Items)
                if (slots.Contains(item.Text) && Convert.ToInt32(item.Text) < Convert.ToInt32(time))
                {
               
                        item.Enabled = false;
                    
                }
                else
                {
                    item.Enabled = true;
                    
                }

        }

Posted 14-Nov-17 18:55pm

ADI@345

Updated 14-Nov-17 19:29pm

v2

Add a Solution

Comments

ADI@345 15-Nov-17 1:00am

foreach (ListItem item in RadioButtonList1.Items)
if (slots.Contains(item.Text) && Convert.ToInt32(item.Text) < Convert.ToInt32(time)) i am getting error in this line only ..

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-14T19:29:00

Solution 1

try

foreach (ListItem item in RadioButtonList1.Items)
            { 
                DateTime dt =  DateTime.ParseExact(item.Text, "HH:mm tt", CultureInfo.CurrentCulture);
                item.Enabled = DateTime.Now > dt; 
            }

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

Posted 14-Nov-17 19:29pm

Karthik_Mahalingam

Comments

ADI@345 15-Nov-17 1:41am

item.Enabled = DateTime.Now.ToString("HH:mm tt") > dt;

i need only hour and minute but datetime.now format is different .i am using above code but getting error.

Karthik_Mahalingam 15-Nov-17 1:45am

DateTime.ParseExact(item.Text, "HH:mm tt", CultureInfo.CurrentCulture); --> it gives you Today's Date and Time from the ListItem
hope you got this logic?

ADI@345 15-Nov-17 1:45am

DateTime dt = DateTime.ParseExact(item.Text, "HH:mm tt", CultureInfo.CurrentCulture);

GETTING ERROR IN THIS LINE..
String was not recognized as a valid DateTime.

Karthik_Mahalingam 15-Nov-17 1:46am

what is the value you are getting in item.Text

ADI@345 15-Nov-17 1:49am

In dt = 01-01-0001 00:00:00 value i am getting and item.text="9:00 AM"

Karthik_Mahalingam 15-Nov-17 1:51am

ok got the issue, its because of 9 which is not HH, its H. will give a generic solution.

ADI@345 15-Nov-17 1:53am

what would be correct solution..

Karthik_Mahalingam 15-Nov-17 1:55am

try

DateTime dt = DateTime.ParseExact(item.Text, new string[] { "HH:mm tt", "H:mm tt", "HH:m tt", "H:m tt" }, CultureInfo.CurrentCulture, DateTimeStyles.None);

ADI@345 15-Nov-17 1:58am

String was not recognized as a valid DateTime.
again getting same error.

my radibutton listitem contain:
<asp:ListItem Text="9:00 AM" >9:00 AM
<asp:ListItem Text="9:15 AM">9:15 AM
<asp:ListItem Text="9:30 AM">9:30 AM
<asp:ListItem Text="9:45 AM">9:45 AM

ADI@345 15-Nov-17 1:53am

foreach (ListItem item in RadioButtonList1.Items)
{
DateTime dt = DateTime.Parse(item.Text);

if (slots.Contains(item.Text) && DateTime.Now.ToString("HH:mm tt")>dt)
{

item.Enabled = false;

}

i am using this code but again getting error..operator > cannot be applied to operands of type 'string' and 'system.datetime'

Karthik_Mahalingam 15-Nov-17 1:55am

this is invalid syntax DateTime.Now.ToString("HH:mm tt")>dt
you cannot compare a string with datetime.

ADI@345 15-Nov-17 2:14am

still i am getting the same error.. String was not recognized as a valid DateTime.

Karthik_Mahalingam 15-Nov-17 2:20am

post your updated code and show the list items being displayed in the control

ADI@345 15-Nov-17 2:25am

string id = Request.QueryString["id"];
txtdate.Text = Calendar1.SelectedDate.ToShortDateString();
Calendar1.Visible = false;

// DateTime txtMyDate = DateTime.Parse(txtdate.Text);
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string Query = "select slot from appoint where selectdate = @date and doc_id='" + id + "'";
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)
{
string[] slots = dtAdmin.Rows.OfType<datarow>().Select(k => k["slot"].ToString()).ToArray();

foreach (ListItem item in RadioButtonList1.Items)
{

DateTime dt= DateTime.ParseExact(item.Text, "h:mm tt" , CultureInfo.InvariantCulture);

if (slots.Contains(item.Text) && DateTime.Now >dt)
{

item.Enabled = false;

}
else
{
item.Enabled = true;

}

}
}

In dt , i am getting {01-01-0001 00:00:00}..

Karthik_Mahalingam 15-Nov-17 2:27am

use this line

DateTime dt = DateTime.ParseExact(item.Text, new string[] { "HH:mm tt", "H:mm tt", "HH:m tt", "H:m tt" }, CultureInfo.CurrentCulture, DateTimeStyles.None);

ADI@345 15-Nov-17 2:28am

i am using this line but the getting same error.

Karthik_Mahalingam 15-Nov-17 2:30am

am getting

 //{11/15/2017 09:00:00}
            DateTime dt = DateTime.ParseExact("9:00 AM", new string[] { "HH:mm tt", "H:mm tt", "HH:m tt", "H:m tt" }, CultureInfo.CurrentCulture, DateTimeStyles.None);

ADI@345 15-Nov-17 2:33am

yes, but in dt= 01-01-0001 00:00:00

Karthik_Mahalingam 15-Nov-17 2:34am

you run this line separately and tell what value you are getting in dt

DateTime dt = DateTime.ParseExact("9:00 AM", new string[] { "HH:mm tt", "H:mm tt", "HH:m tt", "H:m tt" }, CultureInfo.CurrentCulture, DateTimeStyles.None);

Karthik_Mahalingam 15-Nov-17 2:39am

try

 foreach (ListItem item in RadioButtonList1.Items)
            {
                string time = item.Text;
                string day = DateTime.Now.ToString("MM-dd-yyyy");
                string text = day + " " + time;
                DateTime dt = DateTime.ParseExact(text, new string[] { "MM-dd-yyyy HH:mm tt", "MM-dd-yyyy H:mm tt", "MM-dd-yyyy HH:m tt", "MM-dd-yyyy H:m tt" }, CultureInfo.CurrentCulture, DateTimeStyles.None);
                item.Enabled = DateTime.Now > dt;
            }

ADI@345 15-Nov-17 2:35am

I actually dont know why i am not getting this, i read everywhere in google for this..i dont what mistake i made here...

ADI@345 15-Nov-17 2:37am

in dt i am getting this when i run separately {15-11-2017 09:00:00}

Karthik_Mahalingam 15-Nov-17 2:39am

on in loop check for which item you are getting the error

ADI@345 15-Nov-17 2:45am

i am getting error initially after entering to the loop for first item

Karthik_Mahalingam 15-Nov-17 2:48am

ok what is the first item text

ADI@345 15-Nov-17 2:52am

<asp:RadioButtonList ID="RadioButtonList1" runat="server" Width="100%" CssClass="rbl" RepeatColumns="2" RepeatLayout="Flow" RepeatDirection="Horizontal" >

<asp:ListItem Text="9:00AM" >9:00AM
<asp:ListItem Text="9:15AM">9:15AM
<asp:ListItem Text="9:30AM">9:30AM
<asp:ListItem Text="9:45AM">9:45AM

<asp:ListItem Text="10:00AM">10:00AM
<asp:ListItem Text="10:15AM">10:15AM
<asp:ListItem Text="10:30AM" >10:30AM
<asp:ListItem Text="10:45AM">10:45AM

Karthik_Mahalingam 15-Nov-17 3:00am

earlier you have posted with space and now you have posted without space between the minutes and "AM/PM"

ADI@345 15-Nov-17 2:53am

9:00AM

Karthik_Mahalingam 15-Nov-17 2:58am

space issue, try this

  DateTime dt = DateTime.ParseExact(item.Text, new string[] { "HH:mmtt", "H:mmtt", "HH:mtt", "H:mtt" }, CultureInfo.CurrentCulture, DateTimeStyles.None);

ADI@345 15-Nov-17 3:01am

actually i made changes by using google help..

Karthik_Mahalingam 15-Nov-17 3:05am

can you post the screenshot of the control and the code you have written

ADI@345 15-Nov-17 3:39am

sir there is no option in codeproject to post screenshot..

ADI@345 15-Nov-17 3:02am

same issue

Karthik_Mahalingam 15-Nov-17 3:07am

can you run this code and tell me the value you are getting in s

 List<string> lst = new List<string>();
            foreach (ListItem item in RadioButtonList1.Items)
            {
                lst.Add(item.Text);
            }
            string s = string.Join("|", lst);

ADI@345 15-Nov-17 3:39am

S= "9:00AM |9:15AM |9:30AM |9:45AM |10:00AM |10:15AM |10:30AM|10:45AM|11:00AM|11:15AM|11:30AM|11:45AM|12:00PM|12:15PM|12:30PM|12:45PM|1:00PM|1:15PM|1:30PM|1:45PM|2:00PM|2:15PM|2:30PM|2:45PM"

Karthik_Mahalingam 15-Nov-17 3:56am

try

DateTime dt = DateTime.ParseExact(item.Text.Trim(), new string[] { "HH:mmtt", "H:mmtt", "HH:mtt", "H:mtt" }, CultureInfo.CurrentCulture, DateTimeStyles.None);

ADI@345 15-Nov-17 4:03am

Finally it work , but give error in this time slot "1:00PM"

Karthik_Mahalingam 15-Nov-17 4:12am

ok add one format.

ADI@345 15-Nov-17 4:12am

sir i change HH to hh , it works fine..

Karthik_Mahalingam 15-Nov-17 4:13am

cool,

Karthik_Mahalingam 15-Nov-17 4:21am

item.Enabled = DateTime.Now < dt;

ADI@345 15-Nov-17 4:21am

i think my code work..i solved this issue..Thanks a lot...

Karthik_Mahalingam 15-Nov-17 4:21am

welcome.