Click here to Skip to main content
15,907,001 members
Home / Discussions / C#
   

C#

 
AnswerRe: What is wrong with the structure of this code? Pin
Ron Nicholson24-Mar-15 3:20
professionalRon Nicholson24-Mar-15 3:20 
GeneralRe: What is wrong with the structure of this code? Pin
Dave Kreskowiak24-Mar-15 3:48
mveDave Kreskowiak24-Mar-15 3:48 
GeneralRe: What is wrong with the structure of this code? Pin
Member 1147801824-Mar-15 11:06
Member 1147801824-Mar-15 11:06 
GeneralRe: What is wrong with the structure of this code? Pin
Ron Nicholson24-Mar-15 11:43
professionalRon Nicholson24-Mar-15 11:43 
AnswerRe: What is wrong with the structure of this code? Pin
Gerry Schmitz24-Mar-15 12:14
mveGerry Schmitz24-Mar-15 12:14 
Questionc# Pin
Member 1133602722-Mar-15 8:40
Member 1133602722-Mar-15 8:40 
AnswerRe: c# Pin
Afzaal Ahmad Zeeshan22-Mar-15 8:53
professionalAfzaal Ahmad Zeeshan22-Mar-15 8:53 
Questionusing usage (IDisposable) Pin
TMattC22-Mar-15 6:15
TMattC22-Mar-15 6:15 
AnswerRe: using usage (IDisposable) Pin
phil.o22-Mar-15 6:38
professionalphil.o22-Mar-15 6:38 
AnswerRe: using usage (IDisposable) Pin
OriginalGriff22-Mar-15 6:41
mveOriginalGriff22-Mar-15 6:41 
AnswerRe: using usage (IDisposable) Pin
manchanx22-Mar-15 6:54
professionalmanchanx22-Mar-15 6:54 
AnswerRe: using usage (IDisposable) Pin
jschell22-Mar-15 9:40
jschell22-Mar-15 9:40 
AnswerRe: using usage (IDisposable) Pin
TMattC22-Mar-15 9:49
TMattC22-Mar-15 9:49 
AnswerMessage Closed Pin
22-Mar-15 14:22
mveGerry Schmitz22-Mar-15 14:22 
GeneralRe: using usage (IDisposable) Pin
Richard Deeming23-Mar-15 3:17
mveRichard Deeming23-Mar-15 3:17 
GeneralMessage Closed Pin
23-Mar-15 4:21
mveGerry Schmitz23-Mar-15 4:21 
GeneralRe: using usage (IDisposable) Pin
Richard Deeming23-Mar-15 4:26
mveRichard Deeming23-Mar-15 4:26 
GeneralMessage Closed Pin
23-Mar-15 4:30
mveGerry Schmitz23-Mar-15 4:30 
GeneralRe: using usage (IDisposable) Pin
Richard Deeming23-Mar-15 4:34
mveRichard Deeming23-Mar-15 4:34 
GeneralMessage Removed Pin
23-Mar-15 4:49
mveGerry Schmitz23-Mar-15 4:49 
SuggestionRe: using usage (IDisposable) Pin
Richard Deeming23-Mar-15 3:28
mveRichard Deeming23-Mar-15 3:28 
QuestionSQLite encryption types for data Pin
DPaul199422-Mar-15 6:03
DPaul199422-Mar-15 6:03 
I have an application in C# which uses a SQLite database. In this database I have a table where I inserted a value encrypted with sha1, via sql query. Te problem is that I want to select that data and use it like:
C#
cmd.CommandText = "Select * from accounts where (username=@username and password=sha1(@password));";
cmd.Parameters.AddWithValue("@password", password);

OR
C#
cmd.CommandText = "Select * from accounts where (username=@username and password=@password);";
cmd.Parameters.AddWithValue("@password", sha1(password));

But from what I heard, I can't use sha1 like this, I have to use a function like this one, but it doesn't work:
C#
string sha1(string password) {
            byte[] byteArray = Encoding.UTF8.GetBytes(password);
            return Convert.ToBase64String(sha1.ComputeHash(byteArray);
        }

I receive error:
C#
sha1(string) is a method, which is not valid in the given context

The other thing, I heard about KDF ( key definition function) which it seems to be a better encryption type but I don't really know how to use it. Can anybody help me with that?

modified 22-Mar-15 12:11pm.

SuggestionRe: SQLite encryption types for data Pin
Richard MacCutchan22-Mar-15 6:12
mveRichard MacCutchan22-Mar-15 6:12 
GeneralRe: SQLite encryption types for data Pin
manchanx22-Mar-15 6:42
professionalmanchanx22-Mar-15 6:42 
GeneralRe: SQLite encryption types for data Pin
DPaul199422-Mar-15 7:14
DPaul199422-Mar-15 7:14 

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.