[HELP] Adding records in sql using c#

[Yowwww]

Pa-help naman po sa may mga alam kung paano po mag-add ng records with a limited set of numbers based sa column po

Example po:

Mag-aadd ako ng user and ang department po niya ay IT_Dept which has 30 users lang po ang pede dito then pag na-reach niya na ang 30 users, ma-momove siya next department and so on..

Kahit idea lang po sana

Maraming salamat po.

 

[jhefreyzz]

you can use the COUNT function to determined the current number of IT_Dept users;

ito example on how you could possibly solved your problem

first: try this query , "SELECT count(*) from `users` where `department` = IT_Dept;
second: gawin mong stored procedure o kaya gawa ka ng function to return the result
third: compare the result
like,
if (countNum > 30) {
//insert new users to next department
}

Note lang: flow at idea lang ibinigay ko. sana matapos mo po ang ginagawa niyo