j'ai une base de donnée Admin et une autre PersonneActive et je souhaiterais recuperer les info dela table Admin pour l'inserer dans la table PersonneActive mais mon soucis c'est qu'il s'enregistre duex et je ne c'est pourquoi.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If TxtUser.Text = Nothing Or TxtPassWord.Text = Nothing Then
MsgBox("Veuillez renseigner tous les champs", MsgBoxStyle.Exclamation)
If cnx.State = ConnectionState.Closed Then
'VERIFER LES ENREGISTREMENTS DANS LA BASE DE DONNEE
Dim searchQuery As String = "select count(*) from Admin WHERE RefAdmin=? and MotDePasse=?"
Dim Command As New OleDbCommand(searchQuery, cnx)
Command.Parameters.AddWithValue("@1", OleDbType.VarChar).Value = TxtUser.Text
Command.Parameters.AddWithValue("@2", OleDbType.VarChar).Value = TxtPassWord.Text
Dim count = Convert.ToInt32(Command.ExecuteScalar())
If (count > 0) Then
MsgBox("Mot de passe validé avec succès'" & TxtUser.Text & "'", MsgBoxStyle.Information)
'DECLARATION DES VARIABLES
Dim motpass, nom, dateactive As String
motpass = TxtPassWord.Text
nom = TxtUser.Text
dateactive = DateAndTime.Now()
Dim insert2 As String = "INSERT INTO [PersonneActive] ([MotPasseActive], [NomActive], [DateActive]) VALUES (@motpass, @nom, @dateactive)"
Using cmd As New OleDbCommand(insert2, cnx)
cmd.Parameters.AddWithValue("@1", OleDbType.VarChar).Value = TxtPassWord.Text
cmd.Parameters.AddWithValue("@2", OleDbType.VarChar).Value = TxtUser.Text
cmd.Parameters.AddWithValue("@3", OleDbType.VarChar).Value = DateAndTime.Now()
TxtUser.Text = ""
TxtPassWord.Text = ""
MsgBox("Problème avec le mot de passe ou Compte intouvable... Veuillez contacter l'administrateur AGO KOUAME BERTRAND", MsgBoxStyle.Critical)
TxtUser.Text = ""
TxtPassWord.Text = ""
'Dim adapter As New OleDbDataAdapter(Command)
'Dim ds As New DataSet
'Dim table As New DataTable
'DataGridView1.DataSource = ds.Tables("CERTIFICAT")
Catch ex As Exception
i am thinking of developing a restaurant billing system.
here is how my set up going to be.
1 desktop PC(SQLServer) to run SQL server. OS windows server.
2 desktop PCs(Cashier1,Cashier2) for cashiers.
SQLServer, Cashier1 and Cashier2 will be connected to local network(wired)
5 Tablet for waiters to take orders (enter orders to SQLServer). These Tablets will have wifi connections to enter customer orders into SQLServer
bills will be printed from Cashier1 and Cashier2
5 Tablets will be using unique user logins to take orders.
now my question is. will it be too slow or the system will hang when staffs use tablets to take orders?
Only one client can use "remote desktop" at a time, AFAIK. Use wi-fi with the tablets. "Food orders" are trivial compared to "side-loading" apps over wi-fi (which works fine). It should be trivial to arrange a demo of a PC, router and tablets.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
I am not English, so please Hello everybody!
forgive the translation!
Tell me please, who can, how do I programmatically (vb, vba) copy ALL the pictures of the DESKTOP icons (Windows 7) into an MS WORD document in about this format:
Icon1 - name Icon1
Icon2 - name Icon2
IconN - name IconN
Or what is the same thing to do a list of C: \ Users \ xxxx \ Desktop directory files in the format:
File Icon1 - file name 1
File Icon 2 - File Name 2
File icon N - file name N
I've been using VB since VB6 almost 20 years ago and have used it to build full blown accounting systems and many other business applications. I have never found it lacking for anything I needed to do but what bugs me is that whenever I read articles about Visual Studio, the focus is on c++ and c# and VB is relegated to footnotes or sometimes entirely forgotten.
Many times I've thought of switching to one of the C based languages but is there actually a reason for me to delve into this?
C# and VB.NET mostly share the same language features, and, of course, they both have access to the entire .NET Framework.
The problem with VB.NET is it's verbose, and it's currently not really supported by .NET Core 3.x yet. There's console app and unit test support, but nothing for WPF or WinForms, though that is in development.
If I were you, I would pickup C#. It's really not that much different from VB.NET. You already know most of it. You just don't realize it. You get to replace the verbosity with curly braces and semi-colons!
I used to use VB and then VB.Net but most jobs are looking for C# so I switched. The switch was very easy, but part of that was because I started out in Pascal and C to begin with.
I do miss some of the easier things in VB but switching to C# was easy to do.
A lot of developers seem to have a superior view of themselves and C#, likely because of the word "Basic" in VB, but as you said, I never had a business requirement not be able to be met by VB. Years ago I wrote a chat application and chat server that interfaced with an Avaya phone system and did that in VB.
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.