Login Form Based on User Type using C# and MySQL

[@omgpotpot]

Hi same code lang din po ba kung gamit ko is sql server?

[@drpt]

Hello! Yes same lang. 😊

[@omgpotpot]

@@drpt Hi thank you po akala ko di na kayo updated dito. . pwede po ba kayo gumawa ng tutorial para sa case sensitive ng username and password.

[@drpt]

Sure, sure! Hehe. Pero I'll give a sample code na rin baka need mo right now. Gamit ka ng collation.
SELECT * FROM [tablename]
WHERE Username=@username COLLATE SQL_Latin1_General_CP1_CS_AS
AND Pass=@userpass COLLATE SQL_Latin1_General_CP1_CS_AS

[@omgpotpot]

@@drpt thank you po ng madami.. And sa mabilis nyo pong pagreply..

[@omgpotpot]

@@drpt hi po my error po sa code ko hehehe di pala pwede mag comment ng image dito hehehe
"must declare scalar variable @idno" yan po yung error. Idno. po kasi yunug gamit na pang login.