Solved

How to identify columns and db name in VB.net

Posted on 2016-08-14
9
28 Views
Last Modified: 2016-08-19
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
Comment
Question by:rayluvs
  • 5
  • 3
9 Comments
 

Author Comment

by:rayluvs
Comment Utility
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
 
LVL 12

Expert Comment

by:funwithdotnet
Comment Utility
Does the vb code contain a connection string? that the only place that "needs" a database reference.
0
 

Author Comment

by:rayluvs
Comment Utility
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
 
LVL 62

Accepted Solution

by:
Fernando Soto earned 500 total points
Comment Utility
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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:rayluvs
Comment Utility
Thanx!!
0
 

Author Comment

by:rayluvs
Comment Utility
Last question, what command in the code does an actual write or read to the tables?
0
 
LVL 62

Expert Comment

by:Fernando Soto
Comment Utility
That depends on the technology that is being used. You can look for SqlDataAdapter.Update command to see if you find it.
0
 

Author Comment

by:rayluvs
Comment Utility
Thanx!
0
 
LVL 62

Expert Comment

by:Fernando Soto
Comment Utility
Not a problem rayluvs, glad to help.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now