save textbox with control radiobutton using vb.net

Question

4.00/5 (1 vote)

See more:

hi guys..need favor..
after clicking checkbox in gridview,
i also save the datetime in textbox once tick the radiobutton which retrieve from computer current time, i have 4 textbox and 4 radiobutton,
all the datetime should save to database,
so now i cannot save or insert the datetime that i retrieve from radiobutton into database.

this part of my coding:

If RadioButton4.Checked = True Then
                    If ExitTimeOut1 = TextBox4.Text Then
                       
                    Else
                        MyComm2.CommandText = "update ExitPassDetails set ExitTimeOut1 = '" & ExitTimeOut1 & "', Remarks = '" & Reason & "' where ExitID = '" & id & "' "

                        sqlconnect2.Open()

                        Dim result2 As Data.SqlClient.SqlDataReader = MyComm2.ExecuteReader(Data.CommandBehavior.CloseConnection)

                        result2.Read()
                        

                        sqlconnect2.Close()
                    End If

Regards
Aleesya

Posted 8-May-11 20:04pm

Reena Aleesya

Updated 8-May-11 20:08pm

Toniyo Jackson

v2

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2011-05-08T20:20:00

What are you writing?!!

VB

If RadioButton4.Checked = True Then '...

Formally, not a bug, but do you really understand what are you doing?!
You compare Boolean with True which is always equal to the same Boolean.
This is approximately the same as writing If 2=2. Must be:

VB

If RadioButton4.Checked = True Then '...

How come you compare

VB

If ExitTimeOut1 = TextBox4.Text Then '...

???

Why the next condition depends on Text? It can be anything. You should understand what do you want. Don't even explain it… understand yourself…

Do you use Debugger? You should.

[EDIT]

Now you explained what you compare. Dreadful!!! It won't work.

The condition

VB

If ExitTimeOut1 = TextBox4.Text Then '...

may never be true, or will happen with low probability. In one tick time can be less, another time more. Isn't that obvious?

Therefore, you always need to use ">=".

Convert text to System.DateTime trigger, compare If System.DateTime >= trigger Then '....

—SA