Spaces are important. Try changing this: set sqlQuery="Select * from CountryMaster_tb" + whereData ; To this: set sqlQuery="Select * from CountryMaster_tb " + whereData ; But ... be aware that that is very dangerous. You shouldnNever...

MySQL

workbench

Deploy a New Application in Azure Blockchain Workbench

26 Jul 2018 by didourebai

In this article, we will describe how we can deploy a new application in Azure Blockchain Workbench.

Azure

workbench

blockchain

Making a database in mysql workbench

21 Jun 2019 by CHill60

Firstly do not store passwords on a database. See this article Password Storage: How to do it.[^] You might also find this useful User Login For WinForm Applications[^] If it was me I would have a single table for the ads with a type column for 'cat','dog'. That makes it easily extensible if...

MySQL

workbench

application

Vb.net case sensitive using mysql workbench

25 Jan 2020 by Wendelius

Don't do like this. Never ever concatenate values directly to an SQL statament. It leaves you open to SQL injection. Instead, use MySqlParameter Class[^] Another thing that never must be done, don't store the password as plain text in the database. To do this correctly, see Password Storage:...

VB12

MySQL

workbench

Vb.net case sensitive using mysql workbench

25 Jan 2020 by Richard MacCutchan

First point, do not use string concatenation to create SQL statements, it leaves your system vulnerable to SQL injection. Use parameterised queries always. Second point, do not store passwords in clear text, use salted hash values always. See Secure Password Authentication Explained Simply[^] ...

VB12

MySQL

workbench

HELP! ! With my reader = cm.executereader invalid operation exception was un handled

25 Jan 2020 by Wendelius

As said earlier, in order to make your SQL statement work safely and correctly, you need to use parameters. For an example, see MySQL :: MySQL Connector/NET Developer Guide :: 5.6.1 Preparing Statements in Connector/NET[^] Also, you still try to save the password as plain text. There is no...

MySQL

workbench

Vb.net case sensitive using mysql workbench

25 Jan 2020 by Patrice T

query = "Select * from login where Username= '" & txtuser.Text & "' AND Password = '" & txtpass.Text & "'" Not necessary a solution to your question, but another problem you have. Never build an SQL query by concatenating strings. Sooner or later, you will do it with user inputs, and this opens...

VB12

MySQL

workbench

HELP! ! With my reader = cm.executereader invalid operation exception was un handled

25 Jan 2020 by Patrice T

uery = "Select * from login where Username= '" & EscapeQuote(txtuser.Text) & "' AND Password = '" & EscapeQuote(txtpass.Text) & "'" Not necessary a solution to your question, but another problem you have. Never build an SQL query by concatenating strings. Sooner or later, you will do it with...

MySQL

workbench

HELP! ! With my reader = cm.executereader invalid operation exception was un handled

25 Jan 2020 by Richard MacCutchan

Please read again all the suggestions in your previous question on this subject: Vb.net case sensitive using mysql workbench[^]. As long as you continue to do it the wrong way you are more likely to have problems. The changes you made above do not correct any of the issues.

MySQL

workbench

How to create a login history in VB.NET and saves it into mysql workbench database?

1 Nov 2021 by OriginalGriff

Never store passwords in clear text - it is a major security risk. There is some information on how to do it here: Password Storage: How to do it.[^] And remember: if this is web based and you have any European Union users then GDPR applies and...

workbench

C# VB17 how to autosearch when ever I type somethings in the textbox?

18 Jan 2019 by FelixWen

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using MySql.Data.MySqlClient; namespace FileManagerTool { public partial...

SQL

workbench

C# VB17 how to autosearch when ever I type somethings in the textbox?

18 Jan 2019 by OriginalGriff

See here: Autocomplete in C# | PHP MYSQL learners[^] Or here: TextBox.AutoCompleteCustomSource Property (System.Windows.Forms) | Microsoft Docs[^] Or even here: autosuggest textbox c# - Google Search[^]

SQL

workbench

How can I use my applications in any machine without building the databse and its tables every time in the new machine?

27 Jan 2019 by EngAb1989

I have developed application which mainly uses sql databases to store and save data. My problem is, the application works well in my machine because MySQL Workbench installed locally in my machine and no problem with connections between the application and my sql. However once I installed the...

Designing your Azure MySQL DB with a UWP Demo

15 Apr 2019 by Abdelrahman El Kinani

Azure MySQL DB, how to design it, basic UWP todo demo

How to pass where clause as a parameter to the stored procedure?

6 Apr 2020 by hareshdgr8

CREATE PROCEDURE sp_MasterCountry (IN whereData longtext) begin declare sqlQuery longtext; set sqlQuery="Select * from CountryMaster_tb" + whereData ; call sqlQuery; end; I Need to Pass full where clause from my page because some time ill...

MySQL

workbench

How do I complete my database project - mysql

11 Apr 2020 by Member 14007867

Hi yall! This is a small database for MySQL. My company is a bakery store where I have to develop a simple database for them. I have to start from the beginning. Right now I have set up my ER diagrams and Business rules. But somehow it makes me...

MySQL

workbench

How do I complete my database project - mysql

11 Apr 2020 by MadMyche

This is similar to a basic eCommerce schema; and there are a few things you may want to consider in your setup. The first would be in your Order table. Often times places will have discounts or coupons, so you may want to have columns for those...

MySQL

workbench

How can I find apprenticeship / job

19 Sep 2021 by Member 15363972

Hello everyone, my name is Georges and I'm 25 years old. I currently have a bachelor degree in engineering sciences. I want to join a bachelor degree in apprenticeship for the next year. I wanted to know on what kind of projects and on what kind...

Java

Javascript

workbench

How can I find apprenticeship / job

19 Sep 2021 by OriginalGriff

A degree in "engineering sciences" is unlikely to help you get a job in software development: and that's pretty much the only field this site is involved with. To be honest, without a pretty solid background in software (degree or experience,...

Java

Javascript

workbench

How to create a login history in VB.NET and saves it into mysql workbench database?

4 Nov 2021 by Myln29

I only know few knowledge about vb.net and I am trying to understand it as much as I can. I've tried the code below for login button to save the login date, and it works. Yet, I'm not sure what code to input for logout button. Please help me...

workbench

How do I create a workflow for a website with camunda ?

20 Jul 2022 by Richard MacCutchan

Quote: someone told me to use cammunda because it's the best solution and I really do not know from where to start . Then you should ask that person for more information, or just go to The Universal Process Orchestrator | Camunda[^].

How would I go about doing this question

19 Oct 2022 by OriginalGriff

Use a JOIN instead of SELECT ... FROM Table1, Table2, Table3 The latter combines all rows from all tables, the former returns matching rows based on a relationship between them: SQL Joins[^]

Making a database in mysql workbench

21 Jun 2019 by User 14475602

I am a beginner in mySQL, just to be clear. So, I have to make this database that is going to be connected to c# application. The idea is to make an application for adopting a dog or cat. You can log in or register then when signed in you can navigate through menu where you one button is home...

MySQL

workbench

application

How can I use my applications in any machine without building the databse and its tables every time in the new machine?

27 Jan 2019 by OriginalGriff

MySQL is a multiuser database - which means it is installed on a server, and various client applications (such as yours) connect to it and they all access the same database. This is fine, but it requires a substantial investment on a single computer to support the DB server, and it requires new...

How can I use my applications in any machine without building the databse and its tables every time in the new machine?

27 Jan 2019 by RickZeeland

Here is an overview of lightweight databases, with their pros and cons: https://www.slant.co/topics/69/~best-lightweight-databases[^]

How would I go about doing this question

19 Oct 2022 by chilly45

create table customer ( CustomerID int primary key, FtName varchar (48), LtName varchar(48), Email varchar (75), Town varchar (75), Parish varchar(75) ); create table Vehicle( LicensePlate varchar(48) primary key, /*Primary key for...

Vb.net case sensitive using mysql workbench

25 Jan 2020 by Marky Angel Kevin Garcia

hi im new here just want to seek some help on my project i need my log in form to accept only what the users registered credentials and yes they can login using there credentials but the thing is even if the password is on uppercase letters the user can access it by only using lowercase letter...

VB12

MySQL

workbench

HELP! ! With my reader = cm.executereader invalid operation exception was un handled

25 Jan 2020 by Marky Angel Kevin Garcia

can someone help me with this error i can't still figure it out why it gives a runtime error message qoute "An unhandled exception of type 'System.InvalidOperationException' occurred in MySql.Data.dll" can someone correct my code please TIA What I have tried: Imports MySql.Data.MySqlClient ...

MySQL

workbench

How to create a log history with mysql workbench?

4 Nov 2021 by Myln29

Hi. Below is the code for my login button. I am confused on what code to input for logout button. I'm planning to record the login date and logout date in same row. Thank you! :) Btw, this is my database table: - Student ID(VarChar) - DateIn...

workbench

How do I create a workflow for a website with camunda ?

20 Jul 2022 by beginner developper

I have a project in which I have to create a workflow of an existent website , someone told me to use cammunda because it's the best solution and I really do not know from where to start . What I have tried: i tried watching youtube playlist...