Click here to Skip to main content
15,922,894 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionCapture image in VB.Net through Webcamera Pin
Pratap Chowdary9-Dec-05 17:50
Pratap Chowdary9-Dec-05 17:50 
Questionobject not set to instance Pin
ibigpapa9-Dec-05 15:36
ibigpapa9-Dec-05 15:36 
AnswerRe: object not set to instance Pin
Joshua Quick9-Dec-05 17:10
Joshua Quick9-Dec-05 17:10 
AnswerRe: object not set to instance Pin
ibigpapa9-Dec-05 21:07
ibigpapa9-Dec-05 21:07 
GeneralRe: object not set to instance Pin
Joshua Quick12-Dec-05 9:09
Joshua Quick12-Dec-05 9:09 
GeneralRe: object not set to instance Pin
ibigpapa12-Dec-05 13:20
ibigpapa12-Dec-05 13:20 
GeneralRe: object not set to instance Pin
Joshua Quick12-Dec-05 13:46
Joshua Quick12-Dec-05 13:46 
QuestionCondition in WHERE clause in SQL Pin
andy389-Dec-05 15:26
andy389-Dec-05 15:26 
HI, VB Net used.I have this form that has tree View on the left and a data grid
On the right being fill by a Database Access from a dataset. I have
Already set the connection with Oledb 4.0 making a dataset, and using the following
Request requete = "SELECT * FROM PRODUITS WHERE CATEGORIE = 'Inventaire\Bushing';"
Up to hire OK. I would like to know if it is possible to replace the condition in the WHERE clause like this example 'Inventaire\Bushing';" by a variable like this 'lb1Path.Text. I try this, but it doesn’t work see my example: request
requete = "SELECT * FROM PRODUITS WHERE CATEGORIE = 'lb1Path.Text';"
As you can see what I am trying to do is when I click on one of the tree nodes who
Are by the way Category to put up trough the variable lb1Path.Text. May be there are other ways to do that, if so a lot of help will be appreciate. Thank you
See my code sorry for the French.

Private Sub se_connecter(ByVal requete As String, ByVal table As String)
Dim base, chemin As String
'Chemin d'accès à la b.d. située dans le dossier bin
chemin = Application.StartupPath & "\INVENTAIRE.MDB"
base = "provider=microsoft.jet.oledb.4.0;data source=" + chemin

Dim connexion As OleDbConnection = New OleDbConnection(base)
connexion.Open()
'Lien entre la base et la requête
Dim Liaison As New OleDbDataAdapter(requete, base)
Dim Memoire As New DataSet
'Charge la table en mémoire
Liaison.Fill(Memoire, table)

Dim Vue As New DataView(Memoire.Tables(table))
grille.DataSource = Vue
connexion.Close()

Private Sub TreeView1_AfterSelect(ByVal sender As System.Object, ByVal e As System.Windows.Forms.TreeViewEventArgs) Handles TreeView1.AfterSelect

Dim node As System.Windows.Forms.TreeNode
node = TreeView1.SelectedNode

lb1Path.Text = sender.SelectedNode.FullPath

'MessageBox.Show(TreeView1.SelectedNode.ToString)

'Dim choix As Byte
Dim requete, table As String

'Sélectionne tout
requete = "SELECT * FROM PRODUITS WHERE CATEGORIE = 'Inventaire\Bushing';"
table = "PRODUITS"
se_connecter(requete, table)

'J’essaiyé ceci mais ca marche pas
requete = "SELECT * FROM PRODUITS WHERE CATEGORIE = 'lb1Path.

AnswerRe: Condition in WHERE clause in SQL Pin
uktrips0079-Dec-05 19:07
uktrips0079-Dec-05 19:07 
QuestionSaving Outsidefiles Pin
Luke_Nava9-Dec-05 13:03
Luke_Nava9-Dec-05 13:03 
AnswerRe: Saving Outsidefiles Pin
Joshua Quick9-Dec-05 13:34
Joshua Quick9-Dec-05 13:34 
QuestionDate conversion problem!!!! Pin
Omar Mallat9-Dec-05 12:13
professionalOmar Mallat9-Dec-05 12:13 
AnswerRe: Date conversion problem!!!! Pin
Omar Mallat9-Dec-05 12:56
professionalOmar Mallat9-Dec-05 12:56 
GeneralRe: Date conversion problem!!!! Pin
Joshua Quick9-Dec-05 13:30
Joshua Quick9-Dec-05 13:30 
GeneralRe: Date conversion problem!!!! Pin
Omar Mallat9-Dec-05 18:33
professionalOmar Mallat9-Dec-05 18:33 
Questionpdf 2 image with itextsharp ?? Pin
darth_toni9-Dec-05 9:25
darth_toni9-Dec-05 9:25 
QuestionHi ! Pin
abhishk2001@yahoo.com9-Dec-05 8:03
abhishk2001@yahoo.com9-Dec-05 8:03 
AnswerRe: Hi ! Pin
Brent Lamborn9-Dec-05 10:53
Brent Lamborn9-Dec-05 10:53 
Questionadd chars to text at KEYPRESS Pin
Greeky9-Dec-05 2:45
Greeky9-Dec-05 2:45 
AnswerRe: add chars to text at KEYPRESS Pin
Roy Heil9-Dec-05 7:33
professionalRoy Heil9-Dec-05 7:33 
GeneralRe: add chars to text at KEYPRESS Pin
Roy Heil9-Dec-05 7:54
professionalRoy Heil9-Dec-05 7:54 
AnswerRe: add chars to text at KEYPRESS Pin
George B Gilbert9-Dec-05 9:30
George B Gilbert9-Dec-05 9:30 
Questionsetup wizard and registry handling Pin
Asim N.8-Dec-05 23:17
Asim N.8-Dec-05 23:17 
AnswerRe: setup wizard and registry handling Pin
George B Gilbert9-Dec-05 9:39
George B Gilbert9-Dec-05 9:39 
AnswerRe: setup wizard and registry handling Pin
Curtis Schlak.9-Dec-05 10:28
Curtis Schlak.9-Dec-05 10:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.