Hi guys, This is my first post and so glad to start sharing the knowledge. I am using Mysql database with VB.NET and I have this code : Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim str As String = "Server=localhost;Port=3306;Database=testdb;Uid=root;Pwd=password" Using con As New MySqlConnection(str) Dim query As String = "select * from testdata where rfid_tag='" & TextBox3.Text & "' and Date_serve<= '" & Date.Now.ToString("yyyy-MM-dd ") & "' and Start_Time<= '" & Date.Now.ToString("HH:mm:ss ") & "' and End_Time>= '" & Date.Now.ToString("HH:mm:ss ") & "' or amount_serve='' " Dim cm As New MySqlCommand(query, con) con.Open() Dim rd …

Member Avatar
Member Avatar
+1 forum 2

I am doing a team project with some people that prefer Linux and some people prefer Windows. We are also not allowed to share code for security reasons. One thing the Windows people love to whine about is a way to hold the window open. So the way they usually solve the problem is with: #include <conio.h> getch(); This creates a problem for the Linux users since we do not have that library. I have been looking for ways to solve this problem and I really like this idea. https://www.dreamincode.net/forums/topic/30581-holding-the-execution-window-open/page__st__30__p__575874&#entry575874 #include <stdlib.h> //For system commands //Detect and define which command …

Member Avatar
Member Avatar
+0 forum 1

Once harm has been done, even a fool understands it. -- Homer

Member Avatar
Member Avatar
+12 forum 1,106

I think I finally understand why Trump is doing so well (he recently pulled even with Hillary Clinton). It's only after years of shows like American Idol and America's Got Talent that his rise is possible. These shows got Americans used to the idea that they could vote with no actual consequences. In most cases (with very few exceptions), people with minimal talent are voted on and selected as "the winner", then almost immediately return to obscurity. In some cases (remember Sanjaya Malakar) there was an actual campaign to rig the vote so that a thoroughly undeserving candidate would win. …

Member Avatar
Member Avatar
+1 forum 261

Confession time: I'm a born again smartwatch fan. I used to not see the point, and then somehow managed to buy a Samsung Gear S3 Frontier and everything changed. That this thing looked like a watch, had an innovative rotating bezel as an input control mechanism and worked so smoothly with my newly purchased Samsung Galaxy S8+ were the main reasons for that. Having been a very happy smartwatch bunny for the past 18 months or so, I was both interested and annoyed when the next-gen of the Samsung Gear watch family hit the market. I know, I know, there's …

Member Avatar
Member Avatar
+2 forum 4

Hello Daniweb Community, I have been talking on a couple [Facebook](http://www.facebook.com) groups such as sale pages where you post your own stuff for people to buy. Most groups like this have rules about bumping like once per day, every 12 hours etc... So it got to the point where it became annoying to have to bump my posts every so oftern so I managed to construct this script that'll do it automatically with the help of a cronjob that can be set to bump at whatever time you like. So I have made a simple easy to use (ha may …

Member Avatar
Member Avatar
+3 forum 29

Hello everybody, I`ve been away for some time, but I`m back now! I have question to ask you all. I need help in making a decision. So, I decide to get into this kind of online business, and I decided to make an e-shop for selling mountain gear, like skis, snowboards, clothes and stuff like that. Now, the problem is that I need to chose the best e-shop engine right ? Basically, what I`m interested in when making this choice would be as follows: - I need the best one on SEO of course. From your experience, as I beleive …

Member Avatar
Member Avatar
+1 forum 48

To all in the last week or so who received a private message from me consisting only of the phrase, `Noli Mentula`, I sincerely apologize. In the previous incarnation of Daniweb, sending a private message was considerably different than in the new version. I had assumed that a message would not be sent unless/until I composed it, then clicked some equivalent of `Send`. You know. Like practically every other text messaging system ever invented. While trying to work through the new system with Dani I inadvertantly started conversations with several users. To further explain `noli mentula`... It fall into the …

Member Avatar
Member Avatar
+1 forum 6

There are a lot of members of Daniweb who run their own websites, and even many members who run SEO firms. I've given SEO a lot of thought, and I can only conclude this: [b]SEO is totally unethical. At it's foundation, all you are doing is artificially effecting your search engine rankings - it's not occuring naturally.[/b] To me, the best type of SEO is popularity. The more popular your site is, the higher ranked you would be (based on backlinks, etc). Simple and clear :o . I really feel that SEO is comparable with changing an unborn child's genetic …

Member Avatar
Member Avatar
+2 forum 31

On my android device I get no dropdown menu at all from the hamburger. Chat and profile image on the titlebar work fine as does the main dw logo. Also while creating this post. The continue button on the first screen (deciding forum and thread type) was unresponsive. As does Continue to last step button. I have to click on the progress titles at the top to go on

Member Avatar
Member Avatar
+2 forum 28

Hi, I am using Windows 10 and there is a lot of space in my system. But still its working too slow. Any app could take several minutes to open and even any website. also while I was try using any app it shows me message that, "App not responding". I dont know whether it is a hardware or software problem. I have licensed anti virus in my system so I ams ure its not because ofvirus as I hve scanned it thoroughly. Please help me guys what could be the problem and how to resolve the same?

Member Avatar
Member Avatar
-2 forum 17

Windows10 New Updates are not Installing in My PC. Can you guys please suggest me the process to do the activation in my windows 10.

Member Avatar
Member Avatar
+2 forum 7

what is the use of seo in digital marketing?

Member Avatar
Member Avatar
-1 forum 6

I am on the latest version of Windows 10, running with SWI-Prolog 7.6.4, and trying to get JPL (Java <->Prolog) running for a school project. I've not had to deal with path issues much but I have done my best to understand the problem. I've added the necessary import statements to my java class file, and the necessary environment variables to my system as per the page here: https://jpl7.org/DeploymentWindows However it *still* does not show up as a valid java package. I've just realized as I write this that maybe I need to reboot. I will try that after posting …

Member Avatar
Member Avatar
+1 forum 3

So I'm trying to create a UI that allows multiple buttons in the same window. All of the are toggles to control GPIO outputs to control relays. I've managed to get them to all work individually in their own files, but when put into the same file is all on or all off. There is only 4 toggles for now, as a demonstration for my boss, but there will be many more on the final product.` Below is the code I've come up with so far. (keep in mind I only started learning Python and coding in general yesterday) I'm …

Member Avatar
Member Avatar
+1 forum 4

Can you tell me how to burn a DVD DL using Windows 10 and Cyberlink Media Suite, IMGBurn, Express Burn, Winx DVD Author, Wondershare or Windows 10 own burning software. Since I installed the Windows 10 update in April it stoppped working.

Member Avatar
Member Avatar
+1 forum 3

**HELLO GUYS!** I'm Sergey Romanenko a web-developer with strong will for learning and researching new technologies and architectural solutions. I like creating and using specialised tools for making development processes as efficient as possible. Let me introduce my pet project - Flextype! Flextype is Open Source, fast and flexible file-based Content Management System. That's Easy to install, upgrade and use. Flextype provides amazing API's for plugins, themes and core developers! **FEATURES** Simple Easy to install, upgrade and use. No installation needed, just copy files to your server! Fast Flextype is realy fast and lightweight! No database required, flat files only! …

Member Avatar
+1 forum 0

What's the difference between LCASE() and LOWER() in MySQL? I found places on the web that said they're similar but not a synonym for each other, so I'm not sure what the differences are?

Member Avatar
Member Avatar
+0 forum 1

Backstory. A member messaged me about a moderator action so I wanted to see their discussions. How to find their discussions looked elusive. Here's how to get to their discussions. Click on their avator to get their Dazah page and information then click on Member Stats to see their discussions. Now you know.

Member Avatar
+0 forum 0

If you are using your iPhone XS as a music player, then you probably know how to transfer music from computer to iPhone. The default way of transferring between your PC and iPhone is by using iTunes. This is the most common way of sharing music and other media to your iPhone. But there are also other easy ways which are worth considering. Take a look at the simple methods below and discover how fast and easy it is to move music from your computer to your iPhone XS. ** ApowerManager** The first tool to help you transfer music to …

Member Avatar
+0 forum 0

Comparing a discussion with the home page. When I see the Home Page, top and center of each card is the member who did something such as Viewed, Gave Reputation, Endorsed and so on. Now you head to a discussion and who wrote this? Example at https://www.daniweb.com/programming/software-development/code/385622/google-map-control-vb-net The author is nowhere in sight. I could be wrong but I could not find the post's author. Replies are formatted well so you know who replied and when, but something is truly strange with the original post there. Reviews are slightly better like https://www.daniweb.com/hardware-and-software/hardware/mobile-and-wearables/reviews/518478/i-bought-a-galaxy-watch-on-black-friday-here-s-what-i-got-for-my-money but if a post's author is going to …

Member Avatar
Member Avatar
+0 forum 8

I can't seem to find a way to send a PM. I tried going to the member's profile page but the PM area is gone.

Member Avatar
Member Avatar
+0 forum 34

I am traying to filter Datagrid view based on user type in TbxGlCode (TextBox) Initialy Datatable is populated from SQL table to TempTable (DataTable) getting error at **runtime** at below line Dim Rows As DataRow() = TempTable.[Select]("Code like '%" & VerCode & "%'") Exception Unhandled **System.Data.EvaluateException: 'Cannot perform 'Like' operation on System.Int32 and System.String** How to filter datatable with** Like ** option *My Code* Dim TempTable As DataTable Private Sub FrmGLCodeList_Load(sender As Object, e As EventArgs) Handles MyBase.Load ' Dim TempTable As DataTable 'Create New Table Instance TempTable = New DataTable TempTable.Columns.Add("Code", GetType(Integer)) TempTable.Columns.Add("Name", GetType(String)) 'Adding Rows to TempTable from …

Member Avatar
Member Avatar
+0 forum 5

hi I have datagridview which i want to add on several forms. Number of columons and all ather functionality remains the same. to avoid creating size, columns, column names each time, i am trying to create class control for datagridview which will give me by default number of columns and size once i add the datagrid to form. i have tried this . **But it shows ten columns instead of five** . attached picture Public Class ClsDgvJournal Inherits DataGridView Public Sub New() Width = 500 Height = 200 Dim Col1 = New DataGridViewTextBoxColumn With {.HeaderText = "AAA", .Name = "A", …

Member Avatar
Member Avatar
+0 forum 10

The day that Americans will decide if they want to step on the brakes or drive off the cliff.

Member Avatar
Member Avatar
+0 forum 9

Hello, Recently I am using phpexcel and afer many tries I wasn't able to find out how to make a document with a image in its header. Here is a simplified code that I am using. Can someone helps me with this issue?! <?php require_once 'PHPExcel.php'; $objPHPExcel = new PHPExcel(); $objDrawing = new PHPExcel_Worksheet_HeaderFooterDrawing(); $objDrawing->setPath('header.jpg'); $objPHPExcel->getActiveSheet()->getHeaderFooter()->addImage($objDrawing, PHPExcel_Worksheet_HeaderFooter::IMAGE_HEADER_RIGHT); $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader("&C&G"); $objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('A1', 'CODICE PRATICA'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); $objWriter->save('test.xlsx'); ?>

Member Avatar
Member Avatar
+0 forum 3

Hello everybody, I knew this question might be stupid question. But still i really want to know about which is the best tool for using seo, smo activity tracking, link checking, density checking, visitors checking, bounce rate checking, ip checking, etc. Please Experts opinion will be recommendable. Thanks

Member Avatar
Member Avatar
+0 forum 67

Pretty neat text-based RPG that I made. Currently my first game.

Member Avatar
Member Avatar
+0 forum 18

When booting up my Acer Aspire 1690 laptop the fan starts but then quits after about 5 seconds. The system starts up nicely (OS starts up) it just doesn't have a fan anymore which basically renders the laptop useless. I already tried to clean the fan with compressed air and I even ordered a new fan, but to no avail. Anyone who had a similar problem? Or any idea how to fix it?

Member Avatar
Member Avatar
+0 forum 16

Is it possible to store a certain function as a variable? If not, is it okay to make a class, and define a function. Store the class as the variable and invoke that function?

Member Avatar
Member Avatar
+1 forum 7

The End.