Click here to Skip to main content
14,698,483 members
Home » Discussions » C#
   

C#

 
AnswerRe: VS 2005 Server Explorer Pin
Paul Conrad2-Aug-08 9:15
professionalPaul Conrad2-Aug-08 9:15 
GeneralRe: VS 2005 Server Explorer Pin
benjamin yap2-Aug-08 9:19
Memberbenjamin yap2-Aug-08 9:19 
GeneralRe: VS 2005 Server Explorer Pin
Paul Conrad2-Aug-08 9:23
professionalPaul Conrad2-Aug-08 9:23 
GeneralRe: VS 2005 Server Explorer Pin
benjamin yap2-Aug-08 9:25
Memberbenjamin yap2-Aug-08 9:25 
GeneralRe: VS 2005 Server Explorer Pin
Paul Conrad2-Aug-08 10:38
professionalPaul Conrad2-Aug-08 10:38 
GeneralRe: VS 2005 Server Explorer Pin
benjamin yap2-Aug-08 20:44
Memberbenjamin yap2-Aug-08 20:44 
GeneralRe: VS 2005 Server Explorer Pin
Paul Conrad2-Aug-08 20:48
professionalPaul Conrad2-Aug-08 20:48 
GeneralRe: VS 2005 Server Explorer Pin
benjamin yap2-Aug-08 21:06
Memberbenjamin yap2-Aug-08 21:06 
Ok when i created a new Query, they asked me Type of SQL query to use.

SELECT which return rows
SELECT which return single value
UPDATE
DELETE
INSERT

At first, i selected "SELECT which return rows" and they asked for 3 arguement. dataTable, string nric and string password.


So i change to "SELECT which return single value"

string result = sa.ValidateLogin(txtUsername.Text, txtPassword.Text);
MessageBox.Show(result.ToString());


When i key the correct username and password, the messagebox shows the username. If i enter a wrong username and password, the whole program ended and point to my code and says, NullReferenceException was unhandled.

If the correct username was found, i want to store the results of other columm to my variable i declared. Because my staff table have

nric, name, [password], dob, address, tel_mobile, tel_home, catalogueAccess, inventoryAccess, orderAccess, adminAccess, staffAccess


if the username and password matches, i want to store all the values to the variable i create at the top of my LoginForm.cs

private bool catManager;
private bool inventManager;
private bool orderManager;
private bool administrator;
private bool user;


how do i do that?
GeneralRe: VS 2005 Server Explorer Pin
Paul Conrad2-Aug-08 21:11
professionalPaul Conrad2-Aug-08 21:11 
GeneralRe: VS 2005 Server Explorer [modified] Pin
benjamin yap2-Aug-08 21:25
Memberbenjamin yap2-Aug-08 21:25 
GeneralRe: VS 2005 Server Explorer Pin
Paul Conrad2-Aug-08 21:50
professionalPaul Conrad2-Aug-08 21:50 
GeneralRe: VS 2005 Server Explorer Pin
benjamin yap3-Aug-08 3:29
Memberbenjamin yap3-Aug-08 3:29 
QuestionThreading, just professionall please... Pin
mr.mohsen2-Aug-08 7:32
Membermr.mohsen2-Aug-08 7:32 
AnswerRe: Threading, just professionall please... Pin
Mark Salsbery2-Aug-08 8:30
MemberMark Salsbery2-Aug-08 8:30 
AnswerRe: Threading, just professionall please... Pin
User 66582-Aug-08 8:41
MemberUser 66582-Aug-08 8:41 
QuestionDNS issue Pin
George_George2-Aug-08 4:45
MemberGeorge_George2-Aug-08 4:45 
QuestionDownload .css and script files on downloading aspx page [modified] Pin
Medha jha2-Aug-08 2:12
MemberMedha jha2-Aug-08 2:12 
QuestionDNS access error? Pin
George_George2-Aug-08 2:10
MemberGeorge_George2-Aug-08 2:10 
AnswerRe: DNS access error? Pin
S. Senthil Kumar2-Aug-08 8:54
MemberS. Senthil Kumar2-Aug-08 8:54 
GeneralRe: DNS access error? Pin
George_George3-Aug-08 18:22
MemberGeorge_George3-Aug-08 18:22 
QuestionSql Transactions Pin
mrcooll2-Aug-08 0:56
Membermrcooll2-Aug-08 0:56 
AnswerRe: Sql Transactions Pin
mrcooll2-Aug-08 3:53
Membermrcooll2-Aug-08 3:53 
AnswerRe: Sql Transactions Pin
PIEBALDconsult2-Aug-08 6:24
professionalPIEBALDconsult2-Aug-08 6:24 
QuestionHow to forbid a control to get focus ? Pin
xu_xuthus2-Aug-08 0:55
Memberxu_xuthus2-Aug-08 0:55 
AnswerRe: How to forbid a control to get focus ? Pin
PIEBALDconsult2-Aug-08 6:18
professionalPIEBALDconsult2-Aug-08 6:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.