| |
|
|
| 19 Jul 2012 09:32 AM |
| Any visual Basic'ers out their? |
|
|
| Report Abuse |
|
|
| |
|
|
| 19 Jul 2012 10:19 AM |
I believe Scripting Helpers is for help on ROBLOX Lua coding.
Jellyfish403, Administrator of Jellure Studios |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 10:24 AM |
@Jellyfish403
No you can ask about other scripting languages as well. |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 10:41 AM |
| Okay, well I didn't know that. |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 10:43 AM |
| You mean that there are no tables or? |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 10:43 AM |
Some noob: Good... Good... Vit, show him that force... Good... Good... Jelly fish USE THE FORCE...
Other guy: SHUT THE * * * * NOOB! |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 10:44 AM |
@ceaselesssoul
Okey???????!!! |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 10:45 AM |
Some noob: MUAHAHAHAHA...
Other guy: Man, Imma bash your skull in, get over here!
Some noob: HOLY CRAP DA POPO AFTER MEH AGAIN! IT HAPPENIN AGAIN! |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 11:49 AM |
@Triston
I mean like no entries in, well my case a users table.
So to check if my table is empty. |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 11:51 AM |
| SELECT Count(Column_Name) FROM table |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 11:56 AM |
Try this:: Dim reader as SqlCeDataReader = command.ExecuteReader() While(reader.Read()) if reader("NameCount") = 0 then 'Redirect to Admin Form
else 'Run all your current logic here to find the user from the DB end if End While |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 12:17 PM |
@Triston
How am I suppose to use that to tell if a table is empty? |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 12:19 PM |
| @stuart6854 He's thinking of MySQL not Microsoft SQL server's. |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 12:21 PM |
| I'm using the Visual Basic 2010 built in local database. |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 12:42 PM |
| That Databse is Microsoft SQL database, it comes with Visual Basic, i think its Microsoft SQL Server Compact 3.5ENU |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 12:43 PM |
@ triston & ghostleader
In fact it does work, but how do I use the query in an If/else? |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 12:46 PM |
Again doesn't matter, worked it out.
Thanks Ghost and triston! |
|
|
| Report Abuse |
|
|
|
| 19 Jul 2012 01:02 PM |
I was more than positive you could execute queries. :P
I'm glad that I could help. :) |
|
|
| Report Abuse |
|
|
| |
|
|
| 19 Jul 2012 01:27 PM |
I have manually add users to my table but it is giving me errors?
Error:
Now Row was updated.
The data in row 1 was not committed. Error Source: Microsoft.VisualStudio.DataTools. Error Message: The row value(s) updated or delted either do not make the row unique or they alter multiple rows(2 rows).
How do I fix it? |
|
|
| Report Abuse |
|
|
| |
|