How to identify columns and db name in VB.net

jana
jana used Ask the Experts™
on
We have a series of VB.net code that we can't find the databases was designed for.  We would like to know what area to look at in the code where databases and fields are being coded.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Note: we have someone searching other computers for the database.  With the data identify we can relate code and db (also note, and forgot to put in the question, the database are in MS SQL2005)
Does the vb code contain a connection string? that the only place that "needs" a database reference.

Author

Commented:
Don't know... how can we identify these area of connection string?

Also, these connection strings, are they called everytime the table are being read or written?
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Retired
Distinguished Expert 2017
Commented:
Hi rayluvs;

See if you can do a global search for one of these types in the code SqlDataAdapter, SqlConnection, SelectCommand, or SqlCommand.

To your question, "Also, these connection strings, are they called everytime the table are being read or written?", no they are used when the program needs to connect to the database before any data can be passed back and forth.

Author

Commented:
Thanx!!

Author

Commented:
Last question, what command in the code does an actual write or read to the tables?
Fernando SotoRetired
Distinguished Expert 2017

Commented:
That depends on the technology that is being used. You can look for SqlDataAdapter.Update command to see if you find it.

Author

Commented:
Thanx!
Fernando SotoRetired
Distinguished Expert 2017

Commented:
Not a problem rayluvs, glad to help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial