Member Avatar for Istw

Hello boys.. I'm here for an advice.. I have table 'users' with : ID , USER.. And 'activities' with : USER_ID , activity..
I want to select the USER_ID from 'activities' to find the user ID in the 'users' table..
I am using the VB database..
On php i know how to do this , but in VB i can't imagine how to select a row from a table , and to find it on anoter table..
I hope you understand , and you can help me .

Edited by Istw because: n/a
  • 4 Contributors
  • 7 Replies
  • 145 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by adam_k

Recommended Answers

All 7 Replies

Member Avatar for Istw

Nobody knows ?

Member Avatar for kvprajapati

Do you know ADO.NET? Using ADO.NET classes you may establish database connection and execute queries.

Member Avatar for Istw

Do you know ADO.NET? Using ADO.NET classes you may establish database connection and execute queries.

I don't know.. i don't know how to start.. A website that explains good , can you give me please ?

Member Avatar for kvprajapati

Start learning ADO.NET from MSDN.

Edit:
Corrected it.

Edited by kvprajapati because: Corrected it.
Member Avatar for Istw

Start learning ADO.NET from MSDN.

You mean this http://msdn.microsoft.com/en-us/library/e80y5yhx(v=vs.80).aspx ? ... the link that you gave me isn't a valid one. If this is the right one..
Thank you , man.

Edited by Istw because: n/a
Member Avatar for Netcode

first of all, to have a matching 'user_id' with a matching 'iD' in the users table, there has to be a relationship between the two tables in order to avoid conflicts or avoid the return of nulls.

Member Avatar for adam_k

first of all, to have a matching 'user_id' with a matching 'iD' in the users table, there has to be a relationship between the two tables in order to avoid conflicts or avoid the return of nulls.

Not necessarily. Null is a value and it is not always possible to have a relationship between the tables. That's why joins exist.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.