Link to home
Start Free TrialLog in
Avatar of GlobaLevel
GlobaLevelFlag for United States of America

asked on

vb.net - How do I find the sql connection string is set

I took over site and I dont see where they are setting up this sql connection string in the code..

 sample_val = abcComp.DataAccess.Database.ExecuteNonQuery(CommandType.StoredProcedure, "ABCcomp", SelectParameter)


i think that 'SelectParameter' is a variable that is actually being sent over to the sproc correct?
Avatar of GlobaLevel
GlobaLevel
Flag of United States of America image

ASKER

theres a namespace called...

Imports abcComp.Company
Avatar of Nasir Razzaq
I would think so. Do you have access to abcComp.DataAccess.Database.ExecuteNonQuery?

Are you able to attach to the website and step through the code?
ALSO

  Dim ds As DataSet = abcCOMP.DataAccess.Database.ExecuteDataset(CommandType.Text, SQLQuery)

How does it know what stored procedure to send to?.."CommandType.Text" ?
I would think so. Do you have access to abcComp.DataAccess.Database.ExecuteNonQuery?


>>> yeah,its somewhere buried in this massive thing....I think its pulling from that custom namespace...Imports abcComp.Company
That would be a function of the abcComp class..
if its in a .vb file under app_code folder how could I find that when there are too many to look individually? I want to look at the actual code...
Can you right-click on it and "Go to definition"?
ASKER CERTIFIED SOLUTION
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial