I write about some tools or usefull programs on this category.
February 1st, 2010 — 6:13am
Hata denetim uygulamalarını inceledim geçen haftalarda. Ücretsiz ve ücretli alternatifleri karşılaştırdım. Basitce bir kullanım için BugNet’de karar kıldım sonunda.
Kurup kullanmaya da başladım. Gittikçe daha çok seviyorum. Arayüzü güzel açık kaynaklı bir .net projesi olduğu için seçmiştim. Söyle maddeler halinde de bana göre artılarını yazayım.
Neden BugNet
- Ücretsiz ve Açık Kaynaklı (Asp.Net,CSharp,Sql Server)
- Forumlarda adı pek geçmemiş :) ama çok güzel
- BugNet Task Pane in Visual Studio 2008, Bir VS eklentisine sahip.
- Özel alanlar ekleyerek özelleştirebiliyorsunuz
- Kategori, Milestone, Versiyon, Kişiye atama gibi özellikler var (pek çoğunda da zaten olan özellikler)
Hata denetim uygulamalarını (Bug Tracking Tools) kıyaslayan bir powerpoint sunumu hazırlamıştım onu da paylaşayım sizlerle…
http://hotfile.com/dl/26662385/14e88be/BugTrackingTools.rar.html
Comment » | Tools - Programs
January 15th, 2010 — 4:42pm
i was looking for image watermark programs. And found “FastStone Photo Resizer”. It is a freeware.
FastStone allows you to,
- Set watermark from text or image. (you can set opacity)
- Batch Resize
- Change DPI
- Batch Rename

This program can batch rename images very well. You can rename by folder names, give number sequences as well.

And i like the interface, it is easy to use for me.
I recommend everybody to use this freeware program to Rename, Resize and Watermark their images.
You can Download it from these addresses…
http://download.cnet.com/FastStone-Photo-Resizer/3000-2192_4-10319476.html
http://www.faststone.org/FSResizerDownload.htm
Comment » | Tools - Programs
January 6th, 2010 — 6:35am
I have a project that have too many stored procedures. I need to search in procedures too many times. So i made a simple application to browse them easyly source kod and the exe links are below you can download it.
http://hotfile.com/dl/23158895/837faab/SpBrowser-exe.rar.html
http://hotfile.com/dl/23158896/83e7dba/SpBrowser-project.rar.html
code of the appliation
string cnnStr = "Server=.;Database=master;Trusted_Connection=Yes;";
private void Form1_Load(object sender, EventArgs e)
{
SqlDataAdapter da = new SqlDataAdapter("SELECT [name] FROM [master].[sys].[databases]", cnnStr);
DataTable dt = new DataTable();
da.Fill(dt);
cbDatabases.DataSource = dt;
cbDatabases.DisplayMember = "name";
cbDatabases.ValueMember = "name";
}
private void cbDatabases_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox mycb = (ComboBox)sender;
if (!string.IsNullOrEmpty(mycb.Text) && mycb.Text != "System.Data.DataRowView")
{
SqlDataAdapter da = new SqlDataAdapter(string.Format(@"USE {0}; SELECT DISTINCT OBJECT_NAME(id) as ad,id FROM syscomments WHERE OBJECTPROPERTY(id, 'IsProcedure') = 1 AND OBJECT_NAME(id) LIKE '%{1}%';", mycb.Text.Trim(), txtCriteria.Text.Trim()), cnnStr);
DataTable dt2 = new DataTable();
da.Fill(dt2);
lbSp.DataSource = dt2;
lbSp.DisplayMember = "ad";
lbSp.ValueMember = "id";
}
}
private void lbSp_SelectedIndexChanged(object sender, EventArgs e)
{
ListBox myLb = (ListBox)lbSp;
if (myLb.Text != "System.Data.DataRowView")
{
SqlDataAdapter da = new SqlDataAdapter(string.Format(@"USE {0}; SELECT [text] FROM syscomments WHERE OBJECTPROPERTY(id, 'IsProcedure') = 1 AND OBJECT_NAME(id) = '{1}';", cbDatabases.Text.Trim(), myLb.Text), cnnStr);
DataTable dt2 = new DataTable();
da.Fill(dt2);
txtSpText.Text = string.Empty;
for (int i = 0; i < dt2.Rows.Count; i++)
{
txtSpText.Text += dt2.Rows[i][0].ToString();
}
}
}
private void txtCriteria_TextChanged(object sender, EventArgs e)
{
SqlDataAdapter da = new SqlDataAdapter(string.Format(@"USE {0}; SELECT DISTINCT OBJECT_NAME(id) as ad,id FROM syscomments WHERE OBJECTPROPERTY(id, 'IsProcedure') = 1 AND (OBJECT_NAME(id) LIKE '%{1}%' OR [text] LIKE '%{1}%');", cbDatabases.Text.Trim(), txtCriteria.Text.Trim()), cnnStr);
DataTable dt2 = new DataTable();
da.Fill(dt2);
lbSp.DataSource = dt2;
lbSp.DisplayMember = "ad";
lbSp.ValueMember = "id";
}
Comment » | Csharp - C#, Sql, Tools - Programs