EDN Admin
Well-known member
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa Hello everyone!<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa I have three problems with the local http://www.vbforums.com/#" id="x_itxthook0 " style="color:#417394; text-decoration:initial; border:0px none transparent; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:transparent; padding:0px; display:inline <span id="x_itxthook0p" style="height:auto; right:auto; bottom:auto; border:0px; background-color:transparent; font-family:inherit; font-size:inherit; float:none!important; display:inline!important; white-space:nowrap!important; padding:0px!important; margin:0px!important <span id="x_itxthook0w" style="float:none; height:auto; right:auto; bottom:auto; border-width:0px 0px 1px; border-style:none none solid; border-color:#00cc00; background-color:transparent; display:inline; white-space:normal; font-family:inherit; color:#009900; padding:0px 0px 1px!important; margin:0px!important; text-decoration:underline!important database<img height="NaN" id="x_itxthook0icon" src="http://images.intellitxt.com/ast/adTypes/icon1.png" width="NaN" style="right:auto; bottom:auto; background-color:transparent; white-space:normal; max-height:none; max-width:800px; border:0px!important; float:none!important; padding:0px 0px 0px 4px!important; margin:0px!important; display:inline!important; vertical-align:baseline!important <span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa in
VB.NET that I would like some help with. (Im new to using Local Databases in VB.NET...)<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa The first is about programatically writing to the database. Im sure this is pretty simple, so it shouldnt
take too much thought. Haha.<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa The user will start the program by clicking ready. It will send a string to the Serial Port telling a microcontroller
to begin. It will be http://www.vbforums.com/#" id="x_itxthook1 " style="color:#417394; text-decoration:initial; border:0px none transparent; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:transparent; padding:0px; display:inline <span id="x_itxthook1p" style="height:auto; right:auto; bottom:auto; border:0px; background-color:transparent; font-family:inherit; font-size:inherit; float:none!important; display:inline!important; white-space:nowrap!important; padding:0px!important; margin:0px!important <span id="x_itxthook1w" style="float:none; height:auto; right:auto; bottom:auto; border-width:0px 0px 1px; border-style:none none solid; border-color:#00cc00; background-color:transparent; display:inline; white-space:normal; font-family:inherit; color:#009900; padding:0px 0px 1px!important; margin:0px!important; text-decoration:underline!important monitoring<img height="NaN" id="x_itxthook1icon" src="http://images.intellitxt.com/ast/adTypes/icon1.png" width="NaN" style="right:auto; bottom:auto; background-color:transparent; white-space:normal; max-height:none; max-width:800px; border:0px!important; float:none!important; padding:0px 0px 0px 4px!important; margin:0px!important; display:inline!important; vertical-align:baseline!important <span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa a
small infrared and waiting for the beam to be broken. Next it will start a timer, and when something breaks the beam again, stop the timer. It will then send the information to the vb.net program, displayed in a label. The user will then enter the correct
ID for the information, and click send to database. This will need to send the ID and the Time to the Database. If the user needs to edit the information, they will do so in DataGrid view.<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa The next involves a database searching for dates and then sending the information to certain labels for the
user to see.<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa The program will automatically update the labels every Monday at 12am, by using the system clock. A database
will have three columns. Date, Event Title, and Door Opening Time. The dates will only be on Saturdays and the program will only search for the next Saturday by using .AddDays. The program will then need to run a query for that date. If there is nothing then
it will stop searching. If there is something, it needs to display the event title and date in those labels. So basically I need to know how to run a query for that certain date and instead of displaying that info in DataGrid view, displaying it in Labels. <br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa The final is about the first problem (with the IDs and Times).<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa I need the program to be able to invert the 6 fastest times. The user will view (and edit) the information
in DataGrid view and all of the information will be sorted by the Time column. (Fastest time first.) I need the top 6 IDs to become inverted. So the first place will be 6th, and so on. How would I do this??<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa Hope this makes sense! If you have any questions, just ask!<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa Thanks for all of your help. <br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa - Ryan
View the full article
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa I have three problems with the local http://www.vbforums.com/#" id="x_itxthook0 " style="color:#417394; text-decoration:initial; border:0px none transparent; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:transparent; padding:0px; display:inline <span id="x_itxthook0p" style="height:auto; right:auto; bottom:auto; border:0px; background-color:transparent; font-family:inherit; font-size:inherit; float:none!important; display:inline!important; white-space:nowrap!important; padding:0px!important; margin:0px!important <span id="x_itxthook0w" style="float:none; height:auto; right:auto; bottom:auto; border-width:0px 0px 1px; border-style:none none solid; border-color:#00cc00; background-color:transparent; display:inline; white-space:normal; font-family:inherit; color:#009900; padding:0px 0px 1px!important; margin:0px!important; text-decoration:underline!important database<img height="NaN" id="x_itxthook0icon" src="http://images.intellitxt.com/ast/adTypes/icon1.png" width="NaN" style="right:auto; bottom:auto; background-color:transparent; white-space:normal; max-height:none; max-width:800px; border:0px!important; float:none!important; padding:0px 0px 0px 4px!important; margin:0px!important; display:inline!important; vertical-align:baseline!important <span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa in
VB.NET that I would like some help with. (Im new to using Local Databases in VB.NET...)<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa The first is about programatically writing to the database. Im sure this is pretty simple, so it shouldnt
take too much thought. Haha.<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa The user will start the program by clicking ready. It will send a string to the Serial Port telling a microcontroller
to begin. It will be http://www.vbforums.com/#" id="x_itxthook1 " style="color:#417394; text-decoration:initial; border:0px none transparent; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:transparent; padding:0px; display:inline <span id="x_itxthook1p" style="height:auto; right:auto; bottom:auto; border:0px; background-color:transparent; font-family:inherit; font-size:inherit; float:none!important; display:inline!important; white-space:nowrap!important; padding:0px!important; margin:0px!important <span id="x_itxthook1w" style="float:none; height:auto; right:auto; bottom:auto; border-width:0px 0px 1px; border-style:none none solid; border-color:#00cc00; background-color:transparent; display:inline; white-space:normal; font-family:inherit; color:#009900; padding:0px 0px 1px!important; margin:0px!important; text-decoration:underline!important monitoring<img height="NaN" id="x_itxthook1icon" src="http://images.intellitxt.com/ast/adTypes/icon1.png" width="NaN" style="right:auto; bottom:auto; background-color:transparent; white-space:normal; max-height:none; max-width:800px; border:0px!important; float:none!important; padding:0px 0px 0px 4px!important; margin:0px!important; display:inline!important; vertical-align:baseline!important <span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa a
small infrared and waiting for the beam to be broken. Next it will start a timer, and when something breaks the beam again, stop the timer. It will then send the information to the vb.net program, displayed in a label. The user will then enter the correct
ID for the information, and click send to database. This will need to send the ID and the Time to the Database. If the user needs to edit the information, they will do so in DataGrid view.<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa The next involves a database searching for dates and then sending the information to certain labels for the
user to see.<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa The program will automatically update the labels every Monday at 12am, by using the system clock. A database
will have three columns. Date, Event Title, and Door Opening Time. The dates will only be on Saturdays and the program will only search for the next Saturday by using .AddDays. The program will then need to run a query for that date. If there is nothing then
it will stop searching. If there is something, it needs to display the event title and date in those labels. So basically I need to know how to run a query for that certain date and instead of displaying that info in DataGrid view, displaying it in Labels. <br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa The final is about the first problem (with the IDs and Times).<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa I need the program to be able to invert the 6 fastest times. The user will view (and edit) the information
in DataGrid view and all of the information will be sorted by the Time column. (Fastest time first.) I need the top 6 IDs to become inverted. So the first place will be 6th, and so on. How would I do this??<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa Hope this makes sense! If you have any questions, just ask!<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa Thanks for all of your help. <br style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa
<span style="color:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; line-height:normal; background-color:#fafafa - Ryan
View the full article