During the development process of an ASP.NET web application, the number of
stored procedures used can grow alarmingly. More often than not, I forget to
document
which stored procedures are being used and which are redundant. So, I decided
to build a little utility that searched through my source code to find all
instances of stored procedures being used.
My goal was to have a web page that listed the procedures being used on each
page. In IE6, I could then right-click on the table and export the list to
Excel. Useful for future documentation.
First of all we start by looping through directories in our root folder:
private string FileTypes="*.cs";
private void DirSearch(string Dir)
{
try
{
foreach (string f in Directory.GetFiles(Dir, FileTypes))
{
ReadFile(f);
}
foreach (string d in Directory.GetDirectories(Dir))
{
DirSearch(d);
}
}
catch (Exception e)
{
Response.Write(e.Message);
}
}
Like many other, all my stored procedures begin with “sp”, so we can read
each file and look for all instances of “sp*” and store them in a datatable.
private string SearchExpression="\"(sp[^\"]+)\"";
private void ReadFile(string fn)
{
StreamReader s = new StreamReader(fn);
string read = s.ReadToEnd();
s.Close();
Regex r = new Regex(SearchExpression);
MatchCollection mc=r.Matches(read);
foreach (Match m in mc)
{
DataRow dr=dt.NewRow();
dr["SP"]=m.Groups[1];
dr["Page"]=fn.Substring(Folder.Length+1);
dt.Rows.Add(dr);
}
}
Next, we can bind the Datatable to a Datagrid:
private string Folder=@"c:\mywebsite";
private void BindData()
{
dt=new DataTable();
dt.Columns.Add("SP");
dt.Columns.Add("Page");
DirSearch(Folder);
DataView dv=dt.DefaultView;
dv.Sort=SortColumn;
DataGrid1.DataSource=dv;
DataGrid1.DataBind();
}
And then bring it all together when the pages loads:
private void Page_Load(Object src,EventArgs e)
{
if (!IsPostBack)
{
SortColumn="SP";
BindData();
}
}
Your comment is awaiting moderation.
Regards! Valuable information.
http://viagrapego.com/
kamagra or vega viagra
generic viagra 100mg
g postmessage viagra smiley remember
buy viagra
Your comment is awaiting moderation.
Thanks! I value this!
http://viagrapego.com/
floater eye problems and viagra generic viagra 100mg cheap inexpensive viagra generic viagra 100mg
kamagra viagra silden
viagra super p-force
viagra rectile bleeding
viagra prescribing information
viagra funny adds
prescription viagra without
Your comment is awaiting moderation.
Amazing content, Thanks a lot.
http://viagrapego.com/
viagra and testosterone pills viagra without a doctor prescription free viagra 2010 jelsoft enterprises ltd generic viagra 100mg
viagra vs levitra
viagra and indigestion
testimonials viagra treatment
viagra free sites results search
generic viagra with money order
when should i take viagra
Your comment is awaiting moderation.
You said it nicely..
http://viagrawithoutadoctorsntx.com/
viagra condom machine uk viagra 100mg drug generic generic viagra cheap viagra
overnight delivery viagra
persuasive essay viagra
easybuy viagra
viagra vending laws
like viagra
viagra cialis levitra online
Your comment is awaiting moderation.
You actually mentioned that well.
http://viagrawithoutadoctormsn.com/
one line jokes viagra viagra pills viagra high blood sugar viagra pills
calcium channel blockers viagra
viagra cialis without doctors prescription
viagra chemists
viagra levitra cialis stuffy nose
number of viagra prescriptions united states
viagra cheap prescription
Your comment is awaiting moderation.
Wow quite a lot of useful facts!
http://viagrapego.com/
edinburgh uk viagra find sites posted buy generic viagra effects of viagra and cialis [url=http://viagrawithoutadoctormsn.com/]buy generic viagra[/url]
edinburgh uk viagra href pages computer
viagra sweden
viagra super active plus
compare levitra cialis viagra
new viagra
female viagra alternative
Your comment is awaiting moderation.
Nicely put, Cheers.
http://viagrapego.com/
viagra online mastercard accepted generic viagra online viagra extended release viagra without a doctor prescription
viagra teens teenager
taking old viagra symptoms
ordering viagra from uk
viagra wp
male enhancements viagra and cialis
q cheap viagra generic lowest pri
Your comment is awaiting moderation.
Thank you. An abundance of information!
http://viagrawithoutadoctormsn.com/
herb works as well as viagra cheap viagra v ritable viagra cheap viagra
prescriptions men viagra rxtobuy
2cialis comparison levitra viagra
does viagra make your penis larger
football player busted with viagra
generic viagra paypal
viagra the other drug
Your comment is awaiting moderation.
Superb data. Kudos!
http://viagrawithoutadoctormsn.com/
viagra prescription on line buy generic viagra does generic viagra less sildenafil citrate viagra for women
viagra atheletes
viagra approved for
what does viagra target
blog viagra use
<a href="http://www.bryandornan.com/index.php/2010/02/search-engine-optimization-overview/#comments?form2mailerror&inquiry=Business+Development&fname=Howarditala&lname=Howarditala&email=zittel020eejf%40songwriter.net&company=google&phone1=81165293468&phone2=89353854855&phone3=89539955831&comments=+Cheers%21+A+lot+of+data%21++https://nicktambone.com/+mexican+pharmacies+%3Ca+href=%22http://canadianonlinepharmacynnm.com/%22%3Ecanadian+pharmacies-24h%3C/a%3E+cialis+canadian+pharmacy+%3Ca+href=http://canadianpharmaciescubarx.com/%3Ecanada+pharmaceuticals+online%3C/a%3E?form2mailerror&inquiry=Business Development&fname=Brendanlib&lname=Brendanlib&email=stolzenberg334ziz@dutchmail.com&company=google&phone1=86891733399&phone2=88423532441&phone3=83252487268&comments=You actually mentioned this very well! http://viagrawithoutadoctorsntx.com/ viagra 100 pic generic viagra 100mg continuing medil edution lifornia viagra viagra without a doctors prescription“>unnecessary viagra use
pfizer viagra free trial
Your comment is awaiting moderation.
You actually reported this effectively!
http://viagrapego.com/
cheapest price viagra viagra generic viagra commercial blues song viagra without a doctors prescription
viagra theme
cheap viagra tablet
can older men and viagra
viagra usa
viagra and woman
sideeffects of viagra
Your comment is awaiting moderation.
You expressed this terrifically!
http://viagrapego.com/
viagra xxx generic viagra viagra next day shipment viagra online
viagra generic sildenafil
the woman’s viagra
amiodarone and viagra
ellis viagra
precautions for viagra users
viagra solid fod
Your comment is awaiting moderation.
Superb facts, Thanks.
http://viagrawithoutadoctormsn.com/
card com viagra generic viagra online cheapest viagra homepage generic viagra online
can viagra cure performance anxiety
viagra additative
doctors north central wisconsin viagra
what color is the viagra pill
viagra vision
altro che viagra
Your comment is awaiting moderation.
This is nicely expressed. !
http://viagrapego.com/
viagra sex games viagra for sale uk how to order viagra online buy viagra online
viagra mixers
levitra compare viagra
viagra canadain
vasotec and viagra interactions
pas viagra
viagra fruit
Your comment is awaiting moderation.
Incredible a lot of valuable info!
http://viagrapego.com/
how to make viagra generic viagra 100mg pharmacy on line viagra buy viagra online
compro viagra
viagra after eating
where to get viagra
bob dole and viagra
does doxazosin react to viagra
viagra buy 1
Your comment is awaiting moderation.
Cheers! Loads of postings.
http://viagrapego.com/
clarisa nora doctorovich viagra generic viagra online viagra from china fake viagra online
buy chinese herbal viagra duro
edinburgh 17 find viagra sites pages
viagra side effects warnings
is viagra covered by insurance
viagra mexico
price of viagra in hyderabad
Your comment is awaiting moderation.
You said it adequately.!
http://viagrawithoutadoctorsntx.com/
edinburgh pages find search viagra viagra online viagra tablets generic viagra
viagra alternetives
viagra 100 pic
beer viagra
viagra ad on rush limbaugh
compare levitra viagra cialis
order viagra no perscription
Your comment is awaiting moderation.
Awesome facts. Many thanks!
http://viagrawithoutadoctorsntx.com/
viagra sales france buy generic viagra charles linskaill find viagra free viagra without a doctor prescription
husband takes viagra
opposite reaction to viagra
men with erectile dysfunction l-arginine viagra
where to purchase viagra
ups shipping viagra
are porn stars using viagra
Your comment is awaiting moderation.
You said it terrifically!
http://viagrapego.com/
viagra super active viagra for sale uk free mail viagra viagra generic
walmart viagra cost
viagra maxium dosage
viagra age
pulmonary hypertension viagra and
viagra pastilles
viagra blushing
Your comment is awaiting moderation.
Nicely put. With thanks!
http://viagrawithoutadoctormsn.com/
natural herbs that act like viagra generic viagra amoxicillin interaction viagra viagra online
viagra at wallmart
discount viagra prescription
viagra fraudster
viagra cheap no prescription
how many men take viagra
viagra party
Your comment is awaiting moderation.
Position effectively regarded..
http://viagrawithoutadoctorsntx.com/
synthesis of viagra and nitroglycerin viagra online 1cialis comparison levitra viagra viagra without a doctor prescription
pros and cons of generic viagra
purchase viagra online canada
canadian viagra
pfizer viagra new indication approval 2009
does ptrx cover viagra
buy viagra online in canada
Your comment is awaiting moderation.
Very good information. Kudos.
http://viagrapego.com/
viagra today for women viagra pills legit viagra viagra online
viagra prices
conseguir viagra
buy viagra by pill
half price viagra
edinburgh uk viagra search cialis charles
aurochem viagra
Your comment is awaiting moderation.
Thank you, Fantastic stuff.
http://viagrawithoutadoctorsntx.com/
viagra home office photo buy generic viagra viagra psuedo generic viagra 100mg
women viagra arousal
need something better than viagra
is viagra available on the nhs
viagra stories real people’s experiences
alpha blockers viagra
generic viagra india review
Your comment is awaiting moderation.
Nicely put, Many thanks!
http://viagrawithoutadoctormsn.com/
initial use for viagra cheap viagra what is viagra used for buy viagra
global systems viagra
does boots sell viagra
combine viagra and cialis effects
ultram viagra renova nexium
viagra use and instructions
viagra use and instructions
Your comment is awaiting moderation.
You actually stated that exceptionally well!
http://viagrawithoutadoctorsntx.com/
viagra orders viagra without a doctors prescription daili viagra free enewsletter buy viagra
drug class of viagra
jaime randall viagra
condoms viagra
mnner potenzmittel viagra cialis online
web viagra
dogs and viagra
Your comment is awaiting moderation.
Thanks a lot! I like this.
http://viagrapego.com/
injections in lieu of viagra buy viagra generico de viagra buy generic viagra
fast working viagra
headaches viagra
ladys viagra
over the counter viagra australia
effect of viagra
europian union viagra vs us viagra
Your comment is awaiting moderation.
Regards, Plenty of stuff!
http://viagrawithoutadoctormsn.com/
viagra type medication viagra pills viagra western union viagra online
viagra refill
viagra from food
penegra silagra generic viagra cumwithuscom
proper use of viagra
<a href="http://www.bryandornan.com/index.php/2010/02/search-engine-optimization-overview/#comments?form2mailerror&inquiry=Business+Development&fname=Howarditala&lname=Howarditala&email=zittel020eejf%40songwriter.net&company=google&phone1=81165293468&phone2=89353854855&phone3=89539955831&comments=+Cheers%21+A+lot+of+data%21++https://nicktambone.com/+mexican+pharmacies+%3Ca+href=%22http://canadianonlinepharmacynnm.com/%22%3Ecanadian+pharmacies-24h%3C/a%3E+cialis+canadian+pharmacy+%3Ca+href=http://canadianpharmaciescubarx.com/%3Ecanada+pharmaceuticals+online%3C/a%3E?form2mailerror&inquiry=Business Development&fname=Brendanlib&lname=Brendanlib&email=stolzenberg334ziz@dutchmail.com&company=google&phone1=86891733399&phone2=88423532441&phone3=83252487268&comments=You actually mentioned this very well! http://viagrawithoutadoctorsntx.com/ viagra 100 pic generic viagra 100mg continuing medil edution lifornia viagra viagra without a doctors prescription“>how viagra affect women
viagra for doggies
Your comment is awaiting moderation.
Nicely put. Thanks a lot!
http://viagrawithoutadoctormsn.com/
viagra no perscibtion viagra without a doctor prescription generic viagra usa canada generic viagra online
generic viagra zenegra
viagra headache is aspring ok
viagra ok scuba diving nitrogen
active ingredient in viagra
natural viagra alteratives
legitimate viagra online
Your comment is awaiting moderation.
You mentioned this effectively!
http://viagrawithoutadoctorsntx.com/
don’t mix viagra wih steroids photo viagra for sale uk female women viagra generic viagra
viagra pages edinburgh girl manson
usa online pharmacies viagra
viagra how soon before sex
seduced boys viagra
kanye west stay up viagra lyrics
effectiveness of viagra
Your comment is awaiting moderation.
Valuable material. Thanks a lot.
http://viagrapego.com/
viagra side effects four hour erection viagra 100mg viagra and steroids viagra pills
viagra free sites edinburgh search find
viagra idiots
chinese herbal viagra
why doesnt viagra work
buy viagra in bangkok
viagra genetic
Your comment is awaiting moderation.
Regards. Great information!
http://viagrapego.com/
viagra cartoons cheap viagra can viagra maintain erection after ejaculation generic viagra
viagra trial
generic viagra scam
viagra arginine
viagra on prescription in the uk
<a href="http://www.bryandornan.com/index.php/2010/02/search-engine-optimization-overview/#comments?form2mailerror&inquiry=Business+Development&fname=Howarditala&lname=Howarditala&email=zittel020eejf%40songwriter.net&company=google&phone1=81165293468&phone2=89353854855&phone3=89539955831&comments=+Cheers%21+A+lot+of+data%21++https://nicktambone.com/+mexican+pharmacies+%3Ca+href=%22http://canadianonlinepharmacynnm.com/%22%3Ecanadian+pharmacies-24h%3C/a%3E+cialis+canadian+pharmacy+%3Ca+href=http://canadianpharmaciescubarx.com/%3Ecanada+pharmaceuticals+online%3C/a%3E?form2mailerror&inquiry=Business Development&fname=Brendanlib&lname=Brendanlib&email=stolzenberg334ziz@dutchmail.com&company=google&phone1=86891733399&phone2=88423532441&phone3=83252487268&comments=You actually mentioned this very well! http://viagrawithoutadoctorsntx.com/ viagra 100 pic generic viagra 100mg continuing medil edution lifornia viagra viagra without a doctors prescription“>pfiser free viagra
viagra 2 day delivery
Your comment is awaiting moderation.
Cheers. A good amount of forum posts!
http://viagrawithoutadoctorsntx.com/
products like viagra generic viagra online subaction showcomments viagra smile remember viagra without a doctor prescription
natural alternatives and viagra
viagra pulmonary hypertension and dogs
levitra and viagra compare
viagra dealers
sildenafil viagra
ref hth q viagra
Your comment is awaiting moderation.
You explained that fantastically!
http://viagrawithoutadoctormsn.com/
viagra generic form viagra without a doctor prescription risks blood clots viagra medline generic viagra online
drunk erection viagra
instant natural viagra
viagra picture
buy viagra online cheap
viagra recipe
when viagra dosent work
Your comment is awaiting moderation.
Whoa a good deal of awesome tips!
http://viagrawithoutadoctorsntx.com/
viagra in phoenix arizona viagra generic viagra lawyers generic viagra 100mg
viagra canadian prescriptions
u 5672 viagra
generic order viagra
viagra health risk
viagra slaes
<a href="http://www.bryandornan.com/index.php/2010/02/search-engine-optimization-overview/#comments?form2mailerror&inquiry=Business+Development&fname=Howarditala&lname=Howarditala&email=zittel020eejf%40songwriter.net&company=google&phone1=81165293468&phone2=89353854855&phone3=89539955831&comments=+Cheers%21+A+lot+of+data%21++https://nicktambone.com/+mexican+pharmacies+%3Ca+href=%22http://canadianonlinepharmacynnm.com/%22%3Ecanadian+pharmacies-24h%3C/a%3E+cialis+canadian+pharmacy+%3Ca+href=http://canadianpharmaciescubarx.com/%3Ecanada+pharmaceuticals+online%3C/a%3E?form2mailerror&inquiry=Business Development&fname=Brendanlib&lname=Brendanlib&email=stolzenberg334ziz@dutchmail.com&company=google&phone1=86891733399&phone2=88423532441&phone3=83252487268&comments=You actually mentioned this very well! http://viagrawithoutadoctorsntx.com/ viagra 100 pic generic viagra 100mg continuing medil edution lifornia viagra viagra without a doctors prescription“>viagra online canadiain
Your comment is awaiting moderation.
Cheers. Lots of content!
http://viagrawithoutadoctormsn.com/
viagra cheap canada northwest viagra generic viagra logo viagra generic
viagras lowest price on the internet
russian viagra death video
viagra samples scam
stay up viagra models name
generic viagra 3a caverta cialis cheap
viagra legal status in russia
Your comment is awaiting moderation.
You actually suggested that exceptionally well.
http://viagrawithoutadoctormsn.com/
3.43 n online order viagra buy generic viagra is viagra for me viagra generic
viagra
viagra license
cheap cheap viagra
viagra uses
supplements that replaces viagra
buy viagra 100mg
Your comment is awaiting moderation.
You actually expressed this adequately!
http://viagrapego.com/
male enhancement viagra and cialis buy generic viagra by money order viagra generic viagra 100mg
mixing vicodin valium viagra
viagra orders
viagra pill on line
viagra cialis better
explain viagra
viagra super active plus
Your comment is awaiting moderation.
Thanks! I appreciate this.
http://viagrawithoutadoctorsntx.com/
viagra being ineffective over time buy viagra what does generic viagra look like viagra for women
buy viagra online inu
using viagra on the water
generic viagra in united state
instant cheapest viagra
using viagra in women
generic viagra buy
Your comment is awaiting moderation.
Amazing material. Cheers.
http://viagrawithoutadoctorsntx.com/
online pharmacy canada viagra viagra 100mg viagra pay pal viagra for women
viagra for hard erection
viagra online doma
amazon viagra
effects of viagra 25 mg
cheap generic india viagra
celery and viagra
Your comment is awaiting moderation.
Awesome info. Kudos!
http://viagrapego.com/
viagra a 30 euros generic viagra online fda approved viagra paypal viagra generic
does viagra help ejaculation
red bull and viagra
facts on viagra
viagra discount online
geneic viagra
viagra made by
Your comment is awaiting moderation.
Great advice. With thanks.
http://viagrapego.com/
dosing equivalence beween viagra and cialis viagra for sale uk watermelon viagra substitute viagra without a doctor prescription
peyronies disease and viagra
cracking knuckles viagra
cheapest viagra prices without a prescription
is india viagra real
viagra without prescription us pharmacy
viagra lost erection
Your comment is awaiting moderation.
You actually said this wonderfully!
http://viagrawithoutadoctormsn.com/
viagra delivered on saturday by fedex buy viagra louisville commercial viagra buy generic viagra
keywords generic viagra
prescribe viagra
viagra 50mg soft tab generic
cialis and viagra together
canada and drug and viagra
viagra interactions
Your comment is awaiting moderation.
Many thanks. I appreciate this!
http://viagrawithoutadoctorsntx.com/
buy viagra caverta viagra pills name acquisto viagra buy viagra
wal-mart generic viagra
flintstone’s viagra song
el viagra retarda la eyaculaci n
female viagra released
genuine viagra low prices
how does viagra work for women
Your comment is awaiting moderation.
You actually said it exceptionally well.
http://viagrapego.com/
find sites computer viagra edinburgh search buy generic viagra url viagra url cheap viagra
cuba gooding viagra
young adults viagra
time-release viagra
from generic india viagra
viagra dosage best taken when
viagra low cos
Your comment is awaiting moderation.
Fantastic content, Thanks a lot!
http://viagrawithoutadoctormsn.com/
printable free viagra certificate viagra without a doctor prescription find viagra edinburgh pages search charles viagra pills
can you take viagra and phentermine
buy viagra online online href
does viagra come in a drink
find sites computer shop viagra edinburgh
kamagra or viagra
mail order for viagra tablets
Your comment is awaiting moderation.
Useful tips. Thanks!
http://viagrawithoutadoctormsn.com/
viagra vending laws u k generic viagra 100mg uk buy online viagra generic viagra online
viagra use for enlarged heart
viagra online diagnosis
viagra online no rx comparison
viagra in the uk
viagra women depressed statistics
cialis viagra combo
Your comment is awaiting moderation.
Many thanks! Helpful information.
http://viagrawithoutadoctormsn.com/
viagra istambul viagra for women viagra blurred vision viagra online
wedding viagra
cialis viagra levitra comparrison
does viagra help with premature ejaculation
generic viagra australia
where to buy generic viagra
cheap testosterone viagra href foro
Your comment is awaiting moderation.
You said it nicely..
http://viagrawithoutadoctormsn.com/
viagra online with consultation generic viagra online viagra lavitra cialis viagra online
idoser viagra
generic viagra purchase
viagra prescription buy
best deals on viagra
cialas lavitra viagra
viagra hydroxyurea interaction
Your comment is awaiting moderation.
Kudos, Loads of content!
http://viagrawithoutadoctormsn.com/
viagras ad campaign with smiling bob buy viagra greg lang viagra viagra generic
delaware caverta generic viagra veega
viagra for pulmonary hypertension
viagra stuffy nose
viagra uk prescription
girl on viagra
viagra user dicks gal porn photos
Your comment is awaiting moderation.
Seriously quite a lot of excellent info!
http://viagrawithoutadoctorsntx.com/
people who smoke viagra viagra pills viagra cheap uk buy purchase generic viagra
when viagra doesnt work
mark martin viagra jacket
altitude sickness viagra
get caught ordering viagra online
viagra blog
viagra generic pharmacy iframe