How to identify columns and db name in VB.net

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.
rayluvsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Fernando SotoConnect With a Mentor RetiredCommented:
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.
0
 
rayluvsAuthor 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)
0
 
funwithdotnetCommented:
Does the vb code contain a connection string? that the only place that "needs" a database reference.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
rayluvsAuthor 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?
0
 
rayluvsAuthor Commented:
Thanx!!
0
 
rayluvsAuthor Commented:
Last question, what command in the code does an actual write or read to the tables?
0
 
Fernando SotoRetiredCommented:
That depends on the technology that is being used. You can look for SqlDataAdapter.Update command to see if you find it.
0
 
rayluvsAuthor Commented:
Thanx!
0
 
Fernando SotoRetiredCommented:
Not a problem rayluvs, glad to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.