Click here to Skip to main content
14,739,439 members
Home » Discussions » C#
   

C#

 
GeneralRe: Is my program idea possible? Pin
Dioxazine28-Nov-20 9:09
MemberDioxazine28-Nov-20 9:09 
GeneralRe: Is my program idea possible? Pin
OriginalGriff28-Nov-20 9:22
mveOriginalGriff28-Nov-20 9:22 
GeneralRe: Is my program idea possible? Pin
Liktor Janos11-Dec-20 8:42
MemberLiktor Janos11-Dec-20 8:42 
GeneralRe: Is my program idea possible? Pin
Gerry Schmitz28-Nov-20 8:51
mveGerry Schmitz28-Nov-20 8:51 
QuestionError in SQL Light Compact 4 Pin
Alex Dunlop23-Nov-20 4:47
MemberAlex Dunlop23-Nov-20 4:47 
AnswerRe: Error in SQL Light Compact 4 Pin
Victor Nijegorodov23-Nov-20 4:56
MemberVictor Nijegorodov23-Nov-20 4:56 
GeneralRe: Error in SQL Light Compact 4 Pin
Alex Dunlop23-Nov-20 5:04
MemberAlex Dunlop23-Nov-20 5:04 
GeneralRe: Error in SQL Light Compact 4 Pin
Richard Deeming23-Nov-20 5:18
mveRichard Deeming23-Nov-20 5:18 
Quote:
dataGridView1.Rows[i].Cells[10].Value.ToString()
If the cell's Value is null, what do you think the result of calling the ToString method on the value will be? Smile | :)

Remove those .ToString() calls, and pass the cell values directly to the parameters.
myCommand.Parameters.AddWithValue("@Number", dataGridView1.Rows[i].Cells[0].Value);
myCommand.Parameters.AddWithValue("@CostCenter", dataGridView1.Rows[i].Cells[1].Value);
myCommand.Parameters.AddWithValue("@pType", dataGridView1.Rows[i].Cells[2].Value);
myCommand.Parameters.AddWithValue("@ServiceType", dataGridView1.Rows[i].Cells[3].Value);
myCommand.Parameters.AddWithValue("@Receiver", dataGridView1.Rows[i].Cells[4].Value);
myCommand.Parameters.AddWithValue("@WorkCenter", dataGridView1.Rows[i].Cells[5].Value);
myCommand.Parameters.AddWithValue("@Start", dataGridView1.Rows[i].Cells[6].Value);
myCommand.Parameters.AddWithValue("@End", dataGridView1.Rows[i].Cells[7].Value);
myCommand.Parameters.AddWithValue("@Remaining", dataGridView1.Rows[i].Cells[8].Value);
myCommand.Parameters.AddWithValue("@Status", dataGridView1.Rows[i].Cells[9].Value);
myCommand.Parameters.AddWithValue("@ReceiveDate", dataGridView1.Rows[i].Cells[10].Value);




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

GeneralRe: Error in SQL Light Compact 4 Pin
OriginalGriff23-Nov-20 5:29
mveOriginalGriff23-Nov-20 5:29 
GeneralRe: Error in SQL Light Compact 4 Pin
Alex Dunlop23-Nov-20 8:38
MemberAlex Dunlop23-Nov-20 8:38 
GeneralRe: Error in SQL Light Compact 4 Pin
OriginalGriff23-Nov-20 8:53
mveOriginalGriff23-Nov-20 8:53 
GeneralRe: Error in SQL Light Compact 4 Pin
Alex Dunlop23-Nov-20 9:10
MemberAlex Dunlop23-Nov-20 9:10 
GeneralRe: Error in SQL Light Compact 4 Pin
OriginalGriff23-Nov-20 9:19
mveOriginalGriff23-Nov-20 9:19 
GeneralRe: Error in SQL Light Compact 4 Pin
Alex Dunlop23-Nov-20 9:28
MemberAlex Dunlop23-Nov-20 9:28 
GeneralRe: Error in SQL Light Compact 4 Pin
Richard Deeming23-Nov-20 18:43
mveRichard Deeming23-Nov-20 18:43 
GeneralRe: Error in SQL Light Compact 4 Pin
Alex Dunlop24-Nov-20 7:06
MemberAlex Dunlop24-Nov-20 7:06 
GeneralRe: Error in SQL Light Compact 4 Pin
Dave Kreskowiak24-Nov-20 9:52
mveDave Kreskowiak24-Nov-20 9:52 
AnswerRe: Error in SQL Light Compact 4 Pin
Dave Kreskowiak23-Nov-20 6:58
mveDave Kreskowiak23-Nov-20 6:58 
Questioninteresting issue with SortedSet and ElementAt Pin
BillWoodruff22-Nov-20 19:59
mveBillWoodruff22-Nov-20 19:59 
AnswerRe: interesting issue with SortedSet and ElementAt Pin
Sandeep Mewara22-Nov-20 21:06
mvaSandeep Mewara22-Nov-20 21:06 
GeneralRe: interesting issue with SortedSet and ElementAt Pin
BillWoodruff22-Nov-20 23:19
mveBillWoodruff22-Nov-20 23:19 
GeneralRe: interesting issue with SortedSet and ElementAt Pin
Sandeep Mewara22-Nov-20 23:38
mvaSandeep Mewara22-Nov-20 23:38 
GeneralRe: interesting issue with SortedSet and ElementAt Pin
BillWoodruff22-Nov-20 23:46
mveBillWoodruff22-Nov-20 23:46 
GeneralRe: interesting issue with SortedSet and ElementAt Pin
Sandeep Mewara22-Nov-20 23:51
mvaSandeep Mewara22-Nov-20 23:51 
AnswerRe: interesting issue with SortedSet and ElementAt Pin
Richard Deeming22-Nov-20 23:15
mveRichard Deeming22-Nov-20 23:15 

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.