Click here to Skip to main content
15,906,626 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
AnswerRe: Is there a need for separate SignInManager<TUser> and UserManager<TUser>? Pin
Sardar Mudassar Ali Khan SSE10-Mar-23 6:33
professionalSardar Mudassar Ali Khan SSE10-Mar-23 6:33 
QuestionVb.net FlowLayoutPanel with MS Access: System.InvalidCastException error. Pin
sdfsdfsdfewrew3feff26-Feb-23 6:37
sdfsdfsdfewrew3feff26-Feb-23 6:37 
AnswerRe: Vb.net FlowLayoutPanel with MS Access: System.InvalidCastException error. Pin
Richard Deeming26-Feb-23 22:31
mveRichard Deeming26-Feb-23 22:31 
GeneralRe: Vb.net FlowLayoutPanel with MS Access: System.InvalidCastException error. Pin
sdfsdfsdfewrew3feff27-Feb-23 6:55
sdfsdfsdfewrew3feff27-Feb-23 6:55 
GeneralRe: Vb.net FlowLayoutPanel with MS Access: System.InvalidCastException error. Pin
Richard Deeming27-Feb-23 21:17
mveRichard Deeming27-Feb-23 21:17 
AnswerRe: Vb.net FlowLayoutPanel with MS Access: System.InvalidCastException error. Pin
Dave Kreskowiak27-Feb-23 3:14
mveDave Kreskowiak27-Feb-23 3:14 
GeneralRe: Vb.net FlowLayoutPanel with MS Access: System.InvalidCastException error. Pin
sdfsdfsdfewrew3feff27-Feb-23 8:36
sdfsdfsdfewrew3feff27-Feb-23 8:36 
AnswerRe: Vb.net FlowLayoutPanel with MS Access: System.InvalidCastException error. Pin
jschell13-Mar-23 6:30
jschell13-Mar-23 6:30 
sdfsdfsdfewrew3feff wrote:
"select * from MyTable"


Using the asterisk means the database is free to return the columns (all columns) in any order that it wants.

So if your table as more than one column then you have no idea at all what the first column actually is.

Thus if you assume that the first column is of a certain type like a varchar but you use it like an int, and code it that way, then you will get errors. Very like a cast error.

Your SQL should look like the following.

select col1, col2, col3 from MyTable


If you only want one column then of course only specify those.
QuestionXML view to display in grid view Pin
Member 1592502915-Feb-23 5:30
Member 1592502915-Feb-23 5:30 
QuestionSystem.Design - Not enough memory resources Pin
JoshWilliams5-Jan-23 10:37
JoshWilliams5-Jan-23 10:37 
AnswerRe: System.Design - Not enough memory resources Pin
Dave Kreskowiak5-Jan-23 14:25
mveDave Kreskowiak5-Jan-23 14:25 
GeneralRe: System.Design - Not enough memory resources Pin
trønderen5-Jan-23 15:09
trønderen5-Jan-23 15:09 
GeneralRe: System.Design - Not enough memory resources Pin
Dave Kreskowiak5-Jan-23 15:35
mveDave Kreskowiak5-Jan-23 15:35 
GeneralRe: System.Design - Not enough memory resources Pin
trønderen5-Jan-23 17:54
trønderen5-Jan-23 17:54 
GeneralRe: System.Design - Not enough memory resources Pin
Eddy Vluggen5-Jan-23 23:55
professionalEddy Vluggen5-Jan-23 23:55 
GeneralRe: System.Design - Not enough memory resources Pin
Pete O'Hanlon6-Jan-23 2:11
mvePete O'Hanlon6-Jan-23 2:11 
GeneralRe: System.Design - Not enough memory resources Pin
Dave Kreskowiak6-Jan-23 11:44
mveDave Kreskowiak6-Jan-23 11:44 
GeneralRe: System.Design - Not enough memory resources Pin
jschell10-Jan-23 6:46
jschell10-Jan-23 6:46 
GeneralRe: System.Design - Not enough memory resources Pin
Dave Kreskowiak10-Jan-23 6:47
mveDave Kreskowiak10-Jan-23 6:47 
GeneralRe: System.Design - Not enough memory resources Pin
jschell15-Jan-23 7:40
jschell15-Jan-23 7:40 
GeneralRe: System.Design - Not enough memory resources Pin
Dave Kreskowiak15-Jan-23 8:07
mveDave Kreskowiak15-Jan-23 8:07 
GeneralRe: System.Design - Not enough memory resources Pin
trønderen15-Jan-23 12:29
trønderen15-Jan-23 12:29 
GeneralRe: System.Design - Not enough memory resources Pin
Dave Kreskowiak15-Jan-23 13:50
mveDave Kreskowiak15-Jan-23 13:50 
AnswerRe: System.Design - Not enough memory resources Pin
Randor 5-Jan-23 16:10
professional Randor 5-Jan-23 16:10 
AnswerRe: System.Design - Not enough memory resources Pin
jschell10-Jan-23 7:05
jschell10-Jan-23 7:05 

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.