How to identify columns and db name in

We have a series of 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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

janaAuthor 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.
janaAuthor 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?
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

Fernando SotoRetiredCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
janaAuthor Commented:
janaAuthor Commented:
Last question, what command in the code does an actual write or read to the tables?
Fernando SotoRetiredCommented:
That depends on the technology that is being used. You can look for SqlDataAdapter.Update command to see if you find it.
janaAuthor Commented:
Fernando SotoRetiredCommented:
Not a problem rayluvs, glad to help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.