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.
Perfectly voiced really. !
http://canadianonlinepharmacynnm.com/
trust pharmacy canada
canada drugs
canadian family pharmacy
canadian pharmacies online
Your comment is awaiting moderation.
Seriously many of awesome material!
https://nicktambone.com/
buying drugs canada canadian pharmacies canadian pharmacies shipping to usa canadian pharmaceuticals online
canadian pharcharmy online
prescription drugs without prior prescription
canadian prescription
onlinecanadianpharmacy.com
canadian online pharmacies prescription drugs
canadian prescription drugstore
Your comment is awaiting moderation.
You said it very well..
http://canadianpharmaciesnnm.com/
pain meds online without doctor prescription aarp approved canadian online pharmacies compare prescription prices canadian pharmacies without an rx
canadian drug store
canada pharmacies online pharmacy
canadian pharmacies shipping to usa
canada pharmacy online orders
canadian pharmacies online
canadian viagra
Your comment is awaiting moderation.
You actually explained that fantastically.
http://canadianpharmacyntx.com/
global pharmacy canada online pharmacies canada buy prescription drugs without doctor canada pharmacy online
online pharmacy no prescription needed
drugs without prescription
canadian pharmacy uk delivery
prescription drug
canadian pharmacies top best
buy prescription drugs online
Your comment is awaiting moderation.
Really many of good facts!
http://canadianpharmacyntx.com/
northwest pharmacy canadian pharmacies online prescription without a doctor’s prescription canada drug
costco pharmacy pricing
best online pharmacy
global pharmacy canada
online drugstore
best canadian online pharmacy
mexican pharmacy online
Your comment is awaiting moderation.
Thanks a lot, I value this!
http://canadianpharmaciesnnm.com/
medication costs online pharmacies of canada prescription without a doctor’s prescription canadianpharmacy
legitimate canadian mail order pharmacies
canadian pharmacies shipping to usa
reputable canadian mail order pharmacies
canadian pharmacy king
king pharmacy
prescription drug cost
Your comment is awaiting moderation.
Nicely put, Regards.
http://canadianpharmaciescubarx.com/
best price prescription drugs canadian pharmacy online canadian discount pharmacy top rated canadian pharmacies online
northwestpharmacy
medication costs
24 hour pharmacy
canadian pharmacy viagra
get prescription online
cheap drugs online
Your comment is awaiting moderation.
Thanks a lot! Quite a lot of write ups.
http://www.canadianpharmacymsn.com/
canadian viagra northwest pharmacy prescription drug assistance canadian viagra
prescription drugs online without doctor
meds online
legitimate online pharmacies
drugs from canada
canadian prescription drugs
prescription prices comparison
Your comment is awaiting moderation.
Terrific material. Thanks.
http://talahicc.com/
international pharmacy north west pharmacy canada pharmacy price compare trust pharmacy canada
canadian pharmacies online
international pharmacy
mexican pharmacy online
cialis canadian pharmacy
legitimate online pharmacies
canadian drugs without prescription
Your comment is awaiting moderation.
You revealed this well.
http://canadianpharmacyntx.com/
northwest pharmacy canada global pharmacy canada cheap drugs online canadianpharmacy
cheap prescription drugs online
board of pharmacy
web medical information
mexican pharmacies
no prior prescription required pharmacy
mexican pharmacy online
Your comment is awaiting moderation.
Kudos, A good amount of information.
http://canadianpharmaciescubarx.com/
canadian online pharmacies prescription drugs northwest pharmacy canadapharmacy com north west pharmacy canada
prescription drug price comparison
my canadian pharmacy
canadian pharmacy 365
canadian online pharmacies prescription drugs
online pharmacy without a prescription
canadian family pharmacy
Your comment is awaiting moderation.
Reliable knowledge. Many thanks.
http://www.canadianpharmacymsn.com/
pharmacy tech northwestpharmacy prescription drugs online without doctor global pharmacy canada
canadian drugstore online
canadian drugstore
canada pharmacies online
pharmacies in canada
compare prescription prices
prescription drugs online without
Your comment is awaiting moderation.
Thanks a lot! An abundance of material.
http://canadianpharmacymim.com/
no prescription online pharmacy canadian pharmacy canadian drugstore mexican pharmacies shipping to usa
canadian pharmacy viagra
mexican pharmacy online
no prior prescription required pharmacy
canadian online pharmacies
mexican pharmacies shipping to usa
prescription online
Your comment is awaiting moderation.
Perfectly spoken certainly! !
http://talahicc.com/
canada online pharmacies canadian pharmacies online get prescription online canadian viagra
best online pharmacy stores
king pharmacy
pharmacy online store
canada pharmacies online
online drugs
best canadian pharmacies
Your comment is awaiting moderation.
With thanks. Lots of write ups!
http://canadianpharmacymim.com/
canadian pharcharmy online canadian cialis best online canadian pharcharmy canadian pharmacies-24h
canada drugs
best canadian prescription prices
most reliable canadian pharmacies
canada pharmacy no prescription
online pharmacy
canada online pharmacy
Your comment is awaiting moderation.
Terrific content. Appreciate it.
http://canadianpharmacysilo.com/
canadian pharmacy no prescription online pharmacies of canada medical information online canadian drugs
trusted overseas pharmacies
safe canadian online pharmacies
canadian pharma companies
pharmacy canada
online canadian discount pharmacy
drugstore online
Your comment is awaiting moderation.
Information well regarded.!
http://canadianpharmaciescubarx.com/
mexican pharmacies canada pharmaceuticals online pharmacy near me canadian viagra
canadian mail order pharmacies
overseas pharmacies
canadian mail order pharmacies
drug costs
buying drugs canada
canadian drugstore reviews
Your comment is awaiting moderation.
You made your position very well!.
http://canadianpharmaciescubarx.com/
prescription pricing london drugs canada best price prescription drugs northwestpharmacy
best online pharmacies canada
drug stores near me
best canadian prescription prices
drugs from canada
best canadian prescription prices
mail order pharmacies
Your comment is awaiting moderation.
Nicely put, With thanks!
http://canadianonlinepharmacynnm.com/
drug stores near me canada pharmaceuticals online online pharmacy reviews canadian pharmacy
canadian pharmacies
best online canadian pharcharmy
prescription price comparison
prescription drugs canada
prescription without a doctor’s prescription
online pharmacy canada
Your comment is awaiting moderation.
Kudos, Great stuff.
http://talahicc.com/
canadianpharmacy canada pharmaceutical online ordering cheap drugs online canadian viagra
canadian pharmacy king
buying prescription drugs canada
cheap prescription drugs online
safeway pharmacy
prescription drugs without prior prescription
canada pharmacy no prescription
Your comment is awaiting moderation.
Wow plenty of terrific info!
https://nicktambone.com/
buy prescription drugs from canada canada pharmaceutical online ordering canadian pharmacy no prescription canadian pharcharmy
best price prescription drugs
canada meds
canadian pharmacy reviews
rx online
canada pharmacies online
online pharmacy without prescription
Your comment is awaiting moderation.
You’ve made your position pretty clearly!.
http://canadianpharmacyntx.com/
no prior prescription required pharmacy online pharmacies of canada online rx pharmacy northwest pharmacy
pharmacy without dr prescriptions
mexican pharmacies shipping to usa
pharmacies in canada
prescription cost comparison
discount pharmaceuticals
canadian pharmacy reviews
Your comment is awaiting moderation.
Helpful info. Appreciate it!
http://canadianpharmacyntx.com/
trusted overseas pharmacies canadian drugs canadapharmacy com canada drugs online
canadian pharcharmy online
prescription pricing
canadian pharmacies that ship to us
prescription drugs prices
canadian online pharmacy reviews
canadian pharmacy
Your comment is awaiting moderation.
Wow a lot of awesome tips.
http://talahicc.com/
online pharmacy no prescription canada pharmacy mail order pharmacy northwestpharmacy
canadian online pharmacy reviews
best canadian mail order pharmacies
buy prescription drugs from canada
pharmacy online mexico
canada drug
prescription drugs online without doctor
Your comment is awaiting moderation.
Effectively voiced genuinely! .
http://www.canadianpharmacymsn.com/
best canadian pharmacies online pharmacies canada canadian pharmacies that ship to us aarp approved canadian online pharmacies
online pharmacies no prescription
online pharmacies
legitimate canadian mail order pharmacies
canada online pharmacies
online canadian discount pharmacy
trust pharmacy canada
Your comment is awaiting moderation.
Amazing many of fantastic tips!
http://www.canadianpharmacymsn.com/
canadian pharcharmy online north west pharmacy canada best non prescription online pharmacies canada pharmaceuticals online
prescription drug
pharmacy price compare
no prescription online pharmacy
safe canadian online pharmacies
drugs for sale
canadian drugstore online
Your comment is awaiting moderation.
Amazing a good deal of useful information.
http://canadianpharmacyntx.com/
best online pharmacy canadian pharmacy canadian pharmacies without prescriptions mexican pharmacies shipping to usa
canadian online pharmacies prescription drugs
online canadian pharcharmy
pharmacy without dr prescriptions
buying drugs canada
pharmacy online mexico
online pharmacy without prescription
Your comment is awaiting moderation.
Thank you. I like it!
http://canadianpharmaciescubarx.com/
discount pharmacy canada pharmacy online drug price canadian pharcharmy
canada drugs pharmacy
canadian drug
online canadian discount pharmacy
24 hour pharmacy
canadian pharmacy online canada
pharmacy online mexico
Your comment is awaiting moderation.
This is nicely said! !
http://canadianpharmaciesnnm.com/
prescription drugs without prior prescription canadian pharcharmy get prescription online canadian viagra
canadian drug
discount pharmacy online
no prescription pharmacies
canadian pharmacy online canada
online canadian pharcharmy
prescription drug
Your comment is awaiting moderation.
Many thanks. An abundance of knowledge!
http://www.canadianpharmacymsn.com/
canada drugs pharmacy canada drugs canadian prescription drugstore canadian pharmacies-24h
online pharmacy without a prescription
rx online
safeway pharmacy
online pharmacy canada
online pharmacy no prescription needed
the canadian pharmacy
Your comment is awaiting moderation.
Seriously a good deal of amazing information!
https://nicktambone.com/
no prior prescription required pharmacy canadian pharmacies without an rx most reliable canadian pharmacies aarp approved canadian online pharmacies
drug stores near me
discount drugs online pharmacy
visit poster’s website
northwest pharmacy
discount drugs online pharmacy
pharmacy without dr prescriptions
Your comment is awaiting moderation.
Useful facts. Thanks.
http://canadianpharmacyntx.com/
cialis canadian pharmacy canadian pharmacies that ship to us northwest pharmacy canadian pharmacies online
canadian prescriptions
canadian pharmacy 365
online pharmacy without prescription
buy prescription drugs online
prescription drugs without doctor approval
compare rx prices
Your comment is awaiting moderation.
Truly a good deal of great advice!
http://canadianpharmacymim.com/
pharmacy drug store canada drug prescription drug canada pharmacy online
online canadian pharmacies
trust pharmacy canada
canadian drug store
canadian rx
canadian drugstore reviews
canadapharmacy com
Your comment is awaiting moderation.
Thanks! Valuable stuff.
http://canadianonlinepharmacynnm.com/
drugs for sale canadian online pharmacies drugs for sale canadian cialis
canadian drugstore reviews
my canadian pharmacy
canadian drugstore online
online pharmacy usa
compare rx prices
canada pharmacies
Your comment is awaiting moderation.
You’ve made the point.
http://canadianpharmacysilo.com/
prescription drugs without doctor approval online pharmacies of canada canadadrugs.com pharmacy canadian pharmacy
mexican online pharmacies
prescription drug
ed meds online
canadapharmacyonline com
online pharmacy no prescription needed
<a href="http://mirabiliatour.blogspot.com/ask?q=+Appreciate+it%21+Ample+postings%21++http%3A%2F%2Fcanadianpharmaciescubarx.com%2F+canadian+pharmacy+meds+canadian+pharmacies+online+prescription+drugs+without+prior+prescription+%5Burl%3Dhttp%3A%2F%2Fcanadianonlinepharmacynnm.com%2F%5Daarp+approved+canadian+online+pharmacies%5B%2Furl%5D+%0D%0Apain+meds+online+without+doctor+prescription+%0D%0Acanada+drugs+%0D%0Aonline+pharmacy+usa+%0D%0Aonline+drugstore+%0D%0Acanada+drugs+online+pharmacy+%0D%0Amexican+pharmacies&submit=ask”>canadian drug stores online
Your comment is awaiting moderation.
Wonderful facts, Appreciate it!
http://canadianpharmacysilo.com/
top rated online canadian pharmacies top rated canadian pharmacies online pharmacy prescription canadian pharmacy
canadian drug stores online
best online pharmacy stores
rx price comparison
mail order pharmacy
canadian pharmacies that ship to us
buying drugs canada
Your comment is awaiting moderation.
You actually said it superbly.
http://www.canadianpharmacymsn.com/
canada pharmacy online no script canada drugs online online pharmacy canada online pharmacies
drug stores near me
canada drug prices
mexican pharmacies
canadian drug stores online
online pharmacies canada
canadapharmacyonline com
Your comment is awaiting moderation.
Helpful data. Cheers.
http://canadianpharmacyntx.com/
canadian drugs canadianpharmacy canadian online pharmacies prescription drugs canada drug
pharmacy online mexico
canadian viagra
online canadian discount pharmacy
drug price
web medical information
canada drug
Your comment is awaiting moderation.
Cheers, Ample content!
http://canadianonlinepharmacynnm.com/
canada pharmacy online no script online pharmacies canada legitimate canadian mail order pharmacies canadian pharmacy online
mexican pharmacies online
candrugstore com
canada drugs
canadian rx
online canadian pharcharmy
price prescription drugs
Your comment is awaiting moderation.
This is nicely expressed! !
http://talahicc.com/
online drugstore mexican pharmacies shipping to usa the canadian pharmacy trust pharmacy canada
canadian online pharmacies
prescription online
safeway pharmacy
safeway pharmacy
canadian rx
prescription without a doctor’s prescription
Your comment is awaiting moderation.
Terrific data. Cheers!
http://canadianpharmaciescubarx.com/
prescription drugs online without canadian pharmacies trust pharmacy canada canada drug
canadian drug store
rx pharmacy
prescription drugs online without
discount prescription drugs online
medical information online
canadapharmacyonline com
Your comment is awaiting moderation.
You actually stated this really well!
http://canadianpharmacysilo.com/
prescription drugs online without doctor canada pharmacy online drug stores near me canadian pharmacies online
discount pharmacy online
prescription drugs without doctor approval
discount pharmacy online
online pharmacies no prescription
drugstore online
canada pharmacies online prescriptions
Your comment is awaiting moderation.
Thanks a lot. Awesome stuff.
http://canadianpharmaciesnnm.com/
rx price comparison canadian pharcharmy canadian drugs canadian drugs
canadian pharmacies without prescriptions
online canadian pharcharmy
canadian pharmacy viagra
drug price
online pharmacy
pharmacy without dr prescriptions
Your comment is awaiting moderation.
Cheers. I like this!
http://talahicc.com/
online pharmacies no prescription top rated canadian pharmacies online drugs online online pharmacies canada
cheap prescription drugs
pharmacy tech
pharmacy online mexico
prescription cost comparison
canada drug prices
most reliable canadian pharmacies
Your comment is awaiting moderation.
This is nicely said! !
https://nicktambone.com/
online rx pharmacy canadian pharmacies without an rx rx price comparison canadian pharmacy online
northwestpharmacy
candrugstore com
best online pharmacies no prescription
cheap drugs online
online pharmacies
best non prescription online pharmacies
Your comment is awaiting moderation.
Nicely put. Many thanks!
http://talahicc.com/
price prescription drugs north west pharmacy canada canadian drugstore online canadian pharmacy
prescription drugs online without doctor
medical information online
canadian drug stores online
pharmacy drug store
canadian online pharmacies prescription drugs
canada online pharmacies
Your comment is awaiting moderation.
Great data. Thank you.
http://canadianonlinepharmacynnm.com/
best canadian mail order pharmacies online pharmacies of canada prescription prices comparison canada online pharmacies
pain meds online without doctor prescription
walmart pharmacy price check
buy prescription drugs from canada
pharmacy prices compare
prescription drug price comparison
no prior prescription required pharmacy
Your comment is awaiting moderation.
Nicely put. With thanks!
http://canadianpharmaciescubarx.com/
cialis online northwest pharmacy canada pharmacy online canadian pharcharmy
canadapharmacyonline com
international pharmacies that ship to the usa
canadian drug store
overseas pharmacies
ed meds online
canada pharmacy
Your comment is awaiting moderation.
Wow lots of great facts!
http://canadianpharmaciesnnm.com/
canadian pharmacy viagra brand global pharmacy canada approved canadian pharmacies online canadian pharmacies that ship to us
cialis canadian pharmacy
canada drugs pharmacy
cheap canadian drugs
onlinecanadianpharmacy.com
mail order pharmacy
prescription drugs canada
Your comment is awaiting moderation.
Useful stuff. Kudos.
http://www.canadianpharmacymsn.com/
best price prescription drugs online pharmacies of canada pharmacy online store canadian online pharmacy
highest rated canadian pharmacies
canadian pharmacies
drugs online
online canadian pharmacy
prescription drugs prices
drugs from canada
Your comment is awaiting moderation.
Nicely put. Thanks!
http://canadianpharmacyntx.com/
trust pharmacy canada online pharmacies of canada cheap canadian drugs northwest pharmacy
legitimate online pharmacies
canadian pharmacies online
canadian prescription drugstore
mexican pharmacies online
king pharmacy
prescription drugs canada
Your comment is awaiting moderation.
You actually stated that well!
http://www.canadianpharmacymsn.com/
mexican pharmacy online medications online pharmacies canada best non prescription online pharmacies top rated canadian pharmacies online
drug prices comparison
my canadian pharmacy
online pharmacies canada
online pharmacy
legitimate online pharmacies
get prescription online
Your comment is awaiting moderation.
Very good posts. Kudos!
http://canadianpharmacysilo.com/
online canadian pharcharmy trust pharmacy canada walmart pharmacy price check canadian pharmacies without an rx
online pharmacy no prescription needed
buy prescription drugs online
canadian rx pharmacy online
compare prescription prices
canada drugs pharmacy
canadian pharmacy without prescription
Your comment is awaiting moderation.
Wonderful content. Kudos!
http://canadianpharmacymim.com/
canadian viagra canadian pharmacy online canadian pharmacy king canadian pharmacies
best canadian online pharmacy
canada online pharmacy
canadian pharmacy
pharmacy prices
canadadrugs
cheap canadian drugs
Your comment is awaiting moderation.
Fantastic facts. Cheers.
http://talahicc.com/
canadian online pharmacies online pharmacies canada canada online pharmacies mexican pharmacies shipping to usa
canadapharmacy
online pharmacies canada
top rated canadian pharmacies online
mexican pharmacy online
overseas pharmacy forum
trust pharmacy canada