Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › [VB.NET/MYSQL] Recordset troubles
New Posts  All Forums:Forum Nav:

[VB.NET/MYSQL] Recordset troubles

post #1 of 7
Thread Starter 
resolved.
post #2 of 7
Thread Starter 
bump
post #3 of 7
Thread Starter 
I left out alot of code that didn't matter btw. Such as the other imports etc.
post #4 of 7
Thread Starter 
___
post #5 of 7
I'll be quite honest with you because it is VB net i don't see this getting answered.
Lee XT
(17 items)
 
  
CPUMotherboardGraphicsRAM
AMD FX-6300 Asus M5A97 SAPPHIRE Radeon HD 7850 AMD 4GB DDR3 1333MHZ 
RAMRAMRAMHard Drive
AMD 4GB DDR3 1333MHZ AMD 4GB DDR3 1333MHZ AMD 4GB DDR3 1333MHZ OCZ Vertex 4 256GB 
CoolingOSMonitorKeyboard
Corsair H80 Windows 8.1 Pro MCE Dell P2414H WHXV7  Microsoft Generic 
PowerCaseMouseMouse Pad
Ultra 600W Limited Edition NZXT Black Steel Razer Deathadder Razer Goliath 
Audio
Realtek HD Audio 
  hide details  
Reply
Lee XT
(17 items)
 
  
CPUMotherboardGraphicsRAM
AMD FX-6300 Asus M5A97 SAPPHIRE Radeon HD 7850 AMD 4GB DDR3 1333MHZ 
RAMRAMRAMHard Drive
AMD 4GB DDR3 1333MHZ AMD 4GB DDR3 1333MHZ AMD 4GB DDR3 1333MHZ OCZ Vertex 4 256GB 
CoolingOSMonitorKeyboard
Corsair H80 Windows 8.1 Pro MCE Dell P2414H WHXV7  Microsoft Generic 
PowerCaseMouseMouse Pad
Ultra 600W Limited Edition NZXT Black Steel Razer Deathadder Razer Goliath 
Audio
Realtek HD Audio 
  hide details  
Reply
post #6 of 7
VB is the devil, but when I do this in C#, you normally need to set a SqlCommand and call it within the open connection with something like commandName.ExecuteNonQuery() or something like that. I do not understand how you are doing this?

something like:

SqlCommand sql = new SqlCommand(pre_set_connection, "SELECT count(*) FROM table");
int is_it_there = 0;
pre_set_connection.Open();
is_it_there = (int)sql.ExecuteScalar();
pre_set_connection.Close();

if(is_it_there>0) string Party = "let's party";
post #7 of 7
Thread Starter 
Resolved. Thanks guys.
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming
Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › [VB.NET/MYSQL] Recordset troubles