Click here to Skip to main content
15,912,977 members
Home / Discussions / C#
   

C#

 
AnswerRe: Incomplete data after trapping Date Pin
Richard Deeming8-Dec-15 6:11
mveRichard Deeming8-Dec-15 6:11 
Robert Kamarowski wrote:
What am I doing wrong?

Well, the most obvious thing is that you're writing code which is vulnerable to SQL Injection[^].

The ID should be passed as a parameter. Table and column names can't be passed as parameters, so you should verify that the name is one of the expected values, and cannot be modified by the user. Alternatively, since you only seem to have four tables, use a specific query for each table.

DataTables can accept null values in columns of any type. You shouldn't get an error when you try to load a null date into a DataTable, so I'm not sure that your FillError handler is actually doing anything.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: Incomplete data after trapping Date Pin
Robert Kamarowski8-Dec-15 6:18
Robert Kamarowski8-Dec-15 6:18 
GeneralRe: Incomplete data after trapping Date Pin
OriginalGriff8-Dec-15 6:37
mveOriginalGriff8-Dec-15 6:37 
GeneralRe: Incomplete data after trapping Date Pin
Dave Kreskowiak8-Dec-15 7:43
mveDave Kreskowiak8-Dec-15 7:43 
GeneralRe: Incomplete data after trapping Date Pin
Richard Deeming8-Dec-15 7:51
mveRichard Deeming8-Dec-15 7:51 
GeneralRe: Incomplete data after trapping Date Pin
Robert Kamarowski8-Dec-15 8:17
Robert Kamarowski8-Dec-15 8:17 
GeneralRe: Incomplete data after trapping Date Pin
Richard Deeming8-Dec-15 8:30
mveRichard Deeming8-Dec-15 8:30 
GeneralRe: Incomplete data after trapping Date Pin
OriginalGriff8-Dec-15 8:33
mveOriginalGriff8-Dec-15 8:33 
GeneralRe: Incomplete data after trapping Date Pin
Robert Kamarowski8-Dec-15 8:43
Robert Kamarowski8-Dec-15 8:43 
GeneralRe: Incomplete data after trapping Date Pin
Robert Kamarowski8-Dec-15 10:25
Robert Kamarowski8-Dec-15 10:25 
GeneralRe: Incomplete data after trapping Date Pin
Richard Deeming9-Dec-15 2:56
mveRichard Deeming9-Dec-15 2:56 
GeneralRe: Incomplete data after trapping Date Pin
Robert Kamarowski9-Dec-15 5:07
Robert Kamarowski9-Dec-15 5:07 
QuestionTask.ContinueWith Return Value Pin
Kevin Marois8-Dec-15 5:19
professionalKevin Marois8-Dec-15 5:19 
AnswerRe: Task.ContinueWith Return Value Pin
Richard Deeming8-Dec-15 6:04
mveRichard Deeming8-Dec-15 6:04 
GeneralRe: Task.ContinueWith Return Value Pin
Dave Kreskowiak8-Dec-15 6:09
mveDave Kreskowiak8-Dec-15 6:09 
GeneralRe: Task.ContinueWith Return Value Pin
Kevin Marois8-Dec-15 6:22
professionalKevin Marois8-Dec-15 6:22 
AnswerRe: Task.ContinueWith Return Value Pin
Dave Kreskowiak8-Dec-15 6:08
mveDave Kreskowiak8-Dec-15 6:08 
GeneralRe: Task.ContinueWith Return Value Pin
Kevin Marois8-Dec-15 6:23
professionalKevin Marois8-Dec-15 6:23 
GeneralRe: Task.ContinueWith Return Value Pin
Dave Kreskowiak8-Dec-15 7:20
mveDave Kreskowiak8-Dec-15 7:20 
QuestionMessage Removed Pin
7-Dec-15 15:59
Eilson Tang7-Dec-15 15:59 
AnswerMessage Removed Pin
7-Dec-15 16:38
professionalBillWoodruff7-Dec-15 16:38 
GeneralMessage Removed Pin
7-Dec-15 16:43
Eilson Tang7-Dec-15 16:43 
GeneralMessage Removed Pin
7-Dec-15 16:56
professionalBillWoodruff7-Dec-15 16:56 
QuestionThreads and Dispatcher Pin
Member 121764286-Dec-15 6:23
Member 121764286-Dec-15 6:23 
AnswerRe: Threads and Dispatcher Pin
Richard Deeming7-Dec-15 1:22
mveRichard Deeming7-Dec-15 1:22 

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.