I have a login page where users authenticate against an SQL database. They login using their traderID and their password. A session variable is stored using the traderID entered. I use this to display orders and sales relating to that traderID. This works fine.
What I want to do is rather then just display "Welcome back TraderID 12345", I want to display "Welcome back Firstname Lastname" where the Firstname and surname are looked up in the same SQL table as the TraderID field.
How would I populate the labels with this information. Or which is the best way of achieving this.
Thanks
What I want to do is rather then just display "Welcome back TraderID 12345", I want to display "Welcome back Firstname Lastname" where the Firstname and surname are looked up in the same SQL table as the TraderID field.
How would I populate the labels with this information. Or which is the best way of achieving this.
Thanks