Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 52
  • Last Modified:

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.
0
rayluvs
Asked:
rayluvs
  • 5
  • 3
1 Solution
 
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
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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.
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now