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

.NET (Core and Framework)

 
AnswerRe: ASP.NET Core on Linux Web Space Pin
BillWoodruff30-May-23 18:56
professionalBillWoodruff30-May-23 18:56 
GeneralRe: ASP.NET Core on Linux Web Space Pin
temuco30-May-23 23:06
professionaltemuco30-May-23 23:06 
QuestionMy code keeps inserting duplicate records and I can't figure out why. Pin
Ihechi Alozie12-Mar-23 19:53
Ihechi Alozie12-Mar-23 19:53 
AnswerRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Pete O'Hanlon13-Mar-23 0:38
mvePete O'Hanlon13-Mar-23 0:38 
GeneralRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Ihechi Alozie13-Mar-23 3:58
Ihechi Alozie13-Mar-23 3:58 
AnswerRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Gerry Schmitz13-Mar-23 7:24
mveGerry Schmitz13-Mar-23 7:24 
GeneralRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Ihechi Alozie13-Mar-23 7:37
Ihechi Alozie13-Mar-23 7:37 
GeneralRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Gerry Schmitz13-Mar-23 9:24
mveGerry Schmitz13-Mar-23 9:24 
AnswerRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Eddy Vluggen13-Mar-23 9:37
professionalEddy Vluggen13-Mar-23 9:37 
GeneralRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Ihechi Alozie13-Mar-23 9:56
Ihechi Alozie13-Mar-23 9:56 
GeneralRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Eddy Vluggen13-Mar-23 10:11
professionalEddy Vluggen13-Mar-23 10:11 
QuestionIs there a need for separate SignInManager<TUser> and UserManager<TUser>? Pin
hpjchobbes26-Feb-23 8:24
hpjchobbes26-Feb-23 8:24 
AnswerRe: Is there a need for separate SignInManager<TUser> and UserManager<TUser>? Pin
Dave Kreskowiak26-Feb-23 9:45
mveDave Kreskowiak26-Feb-23 9:45 
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 

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.