Search results for query: *

I Initialized NpgsqlDataAdapter to the variable conDataAdapter but still can't connect to pass the command to my table

I updated the code above, I put all codes from the login button function

True, that's not a good practice I'm really aware of that, and I will going to fix that too.

I used $1 and $2 place holder, quite resolved but when I am bout to log in here saying: 08P01 bind message supply 0 parameters, but prepared statement "" requires 2

Thanks for your time in helping me.

I tried both but they have the same outcome:

Thank you, I tried both prefix $ and : it says syntax error at near"$". While prefix @, error says operator does not exist: @ character varying. Anyway I'm using Postgresql database.

I made a login with authentication in DotNet windows forms app and I'm trying to do my best to guard the database from SQL injection attacks, but it seems like there was a wrong logic in my code. Any help would be appreciated private void BtnLogin_Click(object sender, EventArgs e) //user login...

Thanks a lot I learned something, and I will be using this in my case study and thesis. Have a nice day

I don't know what is the exact word to say and I still learning about the depth of databases. But this came up the answer by jmoreno from db stackexchange.com : Reusing an identity value, should in general be discouraged. Either the value is used entirely internally, in which case it’s actual...

I mean automated function to save more time that's what I mean to say, sir not the whole thing automated. Yes, full control of the program is essential for us to make the programming more precise. Resetting identity in the column without thinking of it is a disaster It's not advisable right...

Yeah I can imagine doing that but I think the best way is to automate things right?

To automate everything not by doing more manual things, I knew it was a good concept but then just speculations inside my head rather than implementation.

Yeah, I think I messed something up in my database settings. But I want full control through writing codes.

Hello, I have here a simple CRUD system connected to my Postgres database. I noticed that every time I inserted a new record it will assign a new ID number next to the previous one, then after I deleted that record the ID number is no longer usable, when you add a new record it will assign the...