Click here to Skip to main content
15,900,495 members
Home / Discussions / C#
   

C#

 
AnswerMarshal.SizeOf won't work Pin
Daniel Turini28-Aug-05 22:40
Daniel Turini28-Aug-05 22:40 
QuestionC# Convert Cobol Copybook data into Excel Spreadsheet Pin
dsrao28-Aug-05 11:22
dsrao28-Aug-05 11:22 
QuestionUSB Port Pin
Shahin7728-Aug-05 11:05
Shahin7728-Aug-05 11:05 
AnswerRe: USB Port Pin
eggie528-Aug-05 12:34
eggie528-Aug-05 12:34 
GeneralRe: USB Port Pin
Shahin7728-Aug-05 13:26
Shahin7728-Aug-05 13:26 
GeneralRe: USB Port Pin
eggie528-Aug-05 18:22
eggie528-Aug-05 18:22 
GeneralRe: USB Port Pin
eggie529-Aug-05 8:29
eggie529-Aug-05 8:29 
AnswerRe: USB Port Pin
Daniel Turini28-Aug-05 22:49
Daniel Turini28-Aug-05 22:49 
QuestionRegarding Crystal report Pin
just4ulove728-Aug-05 10:32
just4ulove728-Aug-05 10:32 
Questionencoding problem Pin
snouto28-Aug-05 8:34
snouto28-Aug-05 8:34 
QuestionString reverse function in c# Pin
atifciit28-Aug-05 8:25
atifciit28-Aug-05 8:25 
AnswerRe: String reverse function in c# Pin
DavidNohejl28-Aug-05 8:45
DavidNohejl28-Aug-05 8:45 
AnswerRe: String reverse function in c# Pin
Guffa28-Aug-05 8:45
Guffa28-Aug-05 8:45 
AnswerRe: String reverse function in c# Pin
28-Aug-05 8:47
suss28-Aug-05 8:47 
Questionnetwork problem Pin
snouto28-Aug-05 7:37
snouto28-Aug-05 7:37 
AnswerRe: network problem Pin
Dave Kreskowiak28-Aug-05 9:39
mveDave Kreskowiak28-Aug-05 9:39 
QuestionDetecting mouse clicks Pin
zeihou28-Aug-05 2:59
zeihou28-Aug-05 2:59 
AnswerRe: Detecting mouse clicks Pin
Mohamad Al Husseiny28-Aug-05 3:38
Mohamad Al Husseiny28-Aug-05 3:38 
QuestionShuting down the garbage collector Pin
Gilad Kapelushnik28-Aug-05 1:23
Gilad Kapelushnik28-Aug-05 1:23 
AnswerRe: Shuting down the garbage collector Pin
Colin Angus Mackay28-Aug-05 4:58
Colin Angus Mackay28-Aug-05 4:58 
GeneralRe: Shuting down the garbage collector Pin
Gilad Kapelushnik28-Aug-05 20:10
Gilad Kapelushnik28-Aug-05 20:10 
AnswerRe: Shuting down the garbage collector Pin
Daniel Turini28-Aug-05 22:44
Daniel Turini28-Aug-05 22:44 
Questionpassword problems Pin
nidhelp28-Aug-05 1:00
nidhelp28-Aug-05 1:00 
AnswerRe: password problems Pin
Mohamad Al Husseiny28-Aug-05 3:14
Mohamad Al Husseiny28-Aug-05 3:14 
GeneralRe: password problems Pin
nidhelp28-Aug-05 4:59
nidhelp28-Aug-05 4:59 
hi

i got error when i tried StrComp Function --> Select * From Customers Where StrComp('ContactName','anyNamE',0)=0. it says something about YourPassword is not in Parameter collection. indeed it's not there. this line is what i wrote in OKbutton click event: oleDbDataAdapter2.SelectCommand.Parameters["YourPassword"].Value = textBox2.Text;

well, i tried to remove that line, but what i typed in password textbox did not successfully sense correct password (eg. hELLo23) and retrieve data from Access and display. It's supposed to sense hELLo23 from hello23 or HELLO23 or any other inputs that are different from that (hELLO23) in my database.

i also tried to do this --> Select * From Customers Where StrComp('ContactName','anyNamE',2)=2 as msdn says write '2' for Microsoft Access only. Performs a comparison based on information in your database. but it seems no difference as writing '0'.

loading of data is fine if i do this --> oleDbDataAdapter2.SelectCommand.Parameters["ID_Number_"].Value = textBox1.Text;
oleDbDataAdapter2.SelectCommand.Parameters["YourPassword"].Value = textBox2.Text;
dataSet41.Clear();
oleDbDataAdapter2.Fill(dataSet41);
if(this.BindingContext[dataSet41, "Table1"].Count == 0)
{
MessageBox.Show("Error Occured");
textBox1.Focus();
}
the only problem is that it's not case-sensitive in password textbox and it shows data even though password case is not the same as db.

i just want to ensure that for password any wrong case will not let user have access to get the data.

thanks a lot!

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.