Click here to Skip to main content
15,906,335 members
Home / Discussions / Database
   

Database

 
Questionhow to insert datatable rows into database ??????? Pin
md_azy17-Mar-08 0:29
md_azy17-Mar-08 0:29 
GeneralRe: how to insert datatable rows into database ??????? Pin
Mark J. Miller17-Mar-08 4:25
Mark J. Miller17-Mar-08 4:25 
GeneralERROR ON UPDATE QUERY Pin
Sadaf Naeem16-Mar-08 19:15
Sadaf Naeem16-Mar-08 19:15 
GeneralRe: ERROR ON UPDATE QUERY Pin
Khawar Abbas116-Mar-08 19:55
Khawar Abbas116-Mar-08 19:55 
GeneralRe: ERROR ON UPDATE QUERY Pin
pmarfleet16-Mar-08 22:10
pmarfleet16-Mar-08 22:10 
GeneralRe: ERROR ON UPDATE QUERY Pin
Khawar Abbas116-Mar-08 22:42
Khawar Abbas116-Mar-08 22:42 
GeneralRe: ERROR ON UPDATE QUERY Pin
Sadaf Naeem16-Mar-08 23:10
Sadaf Naeem16-Mar-08 23:10 
GeneralRe: ERROR ON UPDATE QUERY Pin
pmarfleet17-Mar-08 10:17
pmarfleet17-Mar-08 10:17 
There are two major flaws in your code:

1. Generating SQL statements on the fly is generally considered bad practice. It leaves you exposed to SQL injection attacks. Instead, consider writing a stored procedure to perform your update and call it from your .NET code.

2. You appear to be storing your user's passwords in clear text. This is very insecure. You should consider encrypting your password using a 1-way salted hash algorithm.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush


GeneralRe: ERROR ON UPDATE QUERY Pin
sumit703417-Mar-08 0:00
sumit703417-Mar-08 0:00 
GeneralRe: ERROR ON UPDATE QUERY Pin
Blue_Boy17-Mar-08 3:32
Blue_Boy17-Mar-08 3:32 
GeneralRe: ERROR ON UPDATE QUERY Pin
Pete O'Hanlon18-Mar-08 12:41
mvePete O'Hanlon18-Mar-08 12:41 
GeneralRe: ERROR ON UPDATE QUERY Pin
Blue_Boy19-Mar-08 7:24
Blue_Boy19-Mar-08 7:24 
GeneralRe: ERROR ON UPDATE QUERY Pin
Pete O'Hanlon21-Mar-08 11:53
mvePete O'Hanlon21-Mar-08 11:53 
GeneralRe: ERROR ON UPDATE QUERY Pin
Blue_Boy29-Mar-08 13:01
Blue_Boy29-Mar-08 13:01 
GeneralMaking Multiple "Copies" of a Database Pin
Brendan Vogt16-Mar-08 0:42
Brendan Vogt16-Mar-08 0:42 
GeneralRe: Making Multiple "Copies" of a Database Pin
pmarfleet16-Mar-08 0:47
pmarfleet16-Mar-08 0:47 
AnswerRe: Making Multiple "Copies" of a Database Pin
Brendan Vogt16-Mar-08 0:53
Brendan Vogt16-Mar-08 0:53 
QuestionRe: Making Multiple "Copies" of a Database Pin
Brendan Vogt16-Mar-08 1:00
Brendan Vogt16-Mar-08 1:00 
GeneralRe: Making Multiple "Copies" of a Database Pin
pmarfleet16-Mar-08 1:50
pmarfleet16-Mar-08 1:50 
GeneralRe: Making Multiple "Copies" of a Database Pin
Syed Mehroz Alam18-Mar-08 9:47
Syed Mehroz Alam18-Mar-08 9:47 
Questionhow to ON/OFF identity field through sql script? Pin
combo_ci15-Mar-08 23:48
combo_ci15-Mar-08 23:48 
AnswerRe: how to ON/OFF identity field through sql script? Pin
Mark J. Miller17-Mar-08 4:40
Mark J. Miller17-Mar-08 4:40 
GeneralJet DB Error on Windows 2000 [modified] Pin
Dr.Walt Fair, PE15-Mar-08 15:26
professionalDr.Walt Fair, PE15-Mar-08 15:26 
AnswerRe: Jet DB Error on Windows 2000 Pin
Dr.Walt Fair, PE17-Mar-08 5:12
professionalDr.Walt Fair, PE17-Mar-08 5:12 
GeneralNeed to execute a very time consuming Stored procedure on a remote machine. Pin
Rocky#15-Mar-08 1:10
Rocky#15-Mar-08 1:10 

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.