Comments by The Cool Cat

The Cool Cat 2-Aug-21 4:23am View

You should prevent this from happening, it's in your hands. First things first, do not allow different users to have the same username, you should block it right away in user registration or find any way so users can't register with the same username.

The Cool Cat 21-May-20 4:48am View

Thank you so much, this helped me alot. :)

The Cool Cat 21-Feb-19 1:35am View

Yes Member 14156756. We won't be able to help you if you won't explain what you want.

The Cool Cat 11-Feb-19 4:22am View

Your table is kinda confusing.

The Cool Cat 6-Feb-19 19:29pm View

The form itself would be great, but if he puts another checkbox that was not included to be passed in the query then other container can be used. But it also depends on how he will use it. It's his choice though.

The Cool Cat 6-Feb-19 4:27am View

Try this link:
https://www.codeproject.com/Answers/1275460/How-to-save-the-checkboxes-that-is-beeing-checked#answer1

The Cool Cat 3-Feb-19 22:02pm View

This Part:

"INSERT INTO pr_fingerprint(EMployee_ID, Finger_ID, Img, template)" & _
" VALUES(@EMployee_ID, @Finger_ID, @Img, @template)"
.Parameters.AddWithValue("@Employee_ID=", EmployeeID.Text)
.Parameters.AddWithValue("@Finger_ID=", fingerPosition)
.Parameters.AddWithValue("@Img", fp)
.Parameters.AddWithValue("@template", fingerprint)
.Parameters.Clear()
.ExecuteNonQuery()

The Cool Cat 31-Jan-19 19:40pm View

Go to your Dataset which is the .xsd file in your project. Find for the Data table which you are using in your Datagridview and add your update Query there.

The Cool Cat 31-Jan-19 19:36pm View

Are you using Datasets for your datagridview?

The Cool Cat 31-Jan-19 1:57am View

Deleted

So You Mean once the user selected Yes then it will be saved as 1 in the Database and same for the No, and when it is unchecked it'll remain 0?

The Cool Cat 31-Jan-19 1:54am View

Once you Update the datagridview and save it, Unchecked checkboxes will automatically have a Value of 0 and Checked will be 1.

The Cool Cat 31-Jan-19 1:54am View

Deleted

Once you Update the datagridview and save it, Unchecked checkboxes will automatically have a Value of 0 and Checked will be 1.

The Cool Cat 31-Jan-19 1:48am View

What do you mean by Getting the Checkbox value? Check if it is Check or Unchecked?

The Cool Cat 30-Jan-19 4:26am View

The code for deserializing the XML?

The Cool Cat 30-Jan-19 4:24am View

If you want to save your data like this :
10
20
30
Then try using Text as your datatype.
Because when you use Integer or any numeric datatype the output will be like this:
10 20 30 or 102030

The Cool Cat 27-Jan-19 22:36pm View

Try using this code for Looping :
https://www.codeproject.com/Questions/1275368/How-to-save-the-checkboxes-that-is-beeing-checked

In the Solution 1

The Cool Cat 27-Jan-19 21:57pm View

https://www.codeproject.com/Answers/1275600/How-to-save-checkbox-in-SQL-server#answer1

The Cool Cat 27-Jan-19 21:03pm View

What datatypes are you using for the data you are saving?

The Cool Cat 10-Jan-19 4:12am View

My Bad, now I'm more confused with the question.

The Cool Cat 10-Jan-19 3:47am View

"Select Amortization, Principal, Interest, Principal-Balance AS NewBalance from yourtablename"

The Cool Cat 10-Jan-19 3:31am View

Deleted

How do you want it to be? Do you want to add another Column in your datagridview for the Balance? If so you can Just Edit your SQL Code, go to your dataset which is the .xsd file and add into your datatable a select statement something like 'Select Amortization, Principal, Interest, Principal-Interest AS Balance from your table, then add a Column to your datatable and reload your datagridview.

The Cool Cat 10-Jan-19 2:39am View

Thank You OriginalGriff! That solved my Problem! I'm working on a Payroll System Project and that's my only problem in Tallying the System Output to the Manual Payroll.

The Cool Cat 29-Jun-18 20:27pm View

Reply Modify the comment. Delete the comment.
I have a problem in comparing the templates, and I found out that the XML was not fully saved in the DB which what causes the trouble. I changed the datatype from Text to Varchar(MAX), and it solved the problem.

The Cool Cat 29-Jun-18 20:27pm View

Deleted

I have a problem in comparing the templates, and I found out that the XML was not fully saved in the DB which what causes the trouble. I changed the datatype from Text to Varchar(MAX), and it solved the problem.

The Cool Cat 5-Jun-18 21:53pm View

ROW_NUMBER() and OVER() never works with lower versions of MySQL, i'm using MySQL 5.7. But anyway thank you for the tips and answer Chill60. :)

Comments by The Cool Cat (Top 25 by date)