ITDevSpace - Development Tips & Tricks

When you have DataGridView with checkbox column and you click on the checkbox the underlying DataTable is not updated correctly. DataTable is only updated if you move to other row. Not sure why it's like that, but this is a workaround. public void Save(){ DataTable dataTable1 = ((DataTable)dataGridView.DataSource).GetChanges(); //dataTable1 is NULL //revalidate form (fixes the problem) this .ValidateChildren(); DataTable dataTable2 = ((DataTable)dataGridView.DataSource).GetChanges(); //dataTable2 has correct values now }

private void button_Click( object sender, EventArgs e) { try { string target = "http://itdevspace.blogspot.com/" ; System.Diagnostics.Process.Start(target); } catch (Exception ex) { MessageBox.Show( "Failed to open webpage" ); } }

To get rid of extra BR lines when posting to blogger with Windows Live Writer and Code Snippet plugin make sure you set the Markup Type to HTML (rather then XHTML) in Advanced Setting for your blog in Windows Live Writer.

This is an example of how to use try/catch functionality in SQL Server 2005 to manage transactions. USE [MyDatabase] PRINT 'Moving Data' GO BEGIN TRY BEGIN TRAN PRINT 'Inserting..' INSERT INTO table2(Id,ParentId,Name) SELECT t1.Id, t1.ParentId, t1.Name FROM Table1 t1 WHERE t1.ParentId = 1 PRINT 'Deleting..' DELETE FROM [Table1] i WHERE t1.ParentId = 1 COMMIT TRAN END TRY BEGIN CATCH ROLLBACK TRAN END CATCH GO

CREATE TABLE [dbo].[ Table 1]( [Id] [ int ] NOT NULL , [ParentId] [ int ] NOT NULL , [Name] [ datetime ] NULL , [ Date ] [ datetime ] NULL CONSTRAINT [DF_Table1_Date] DEFAULT getdate(), --default CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED -- primary key ( [Id] ASC ), CONSTRAINT [UQ_Table1_Name] UNIQUE NONCLUSTERED --unique key ( [Name] ASC ), CONSTRAINT [FK_Table1_Table2_ParentId] FOREIGN KEY --foreign key ( [ParentId] ) REFERENCES [ Table 2]( [Id] ) )

App.config section configuration < configuration > < configSections > < sectionGroup name = "section1" > < section name = "nvpconfig" type = "MyCompany.NameValueConfiguration,MyCompany" /> < section name = "customconfig" type = "MyCompany.CustomConfiguration,MyCompany" /> </ sectionGroup > </ configSections > < section1 > < nvpconfig > < properties > < add name = "id" value = "1" /> < add name = "name" value = "One" /> < add name = "age" value = "18" /> </ properties > </ nvpconfig > < customconfig > < list > < add id = "1" name = "One" age = "18" /> < add id = "2" name = "Two" age = ...

This is example how to access defined application settings in runtime public static string MyStringSetting { get { return Properties.Settings.Default.MyStringSetting; } set { Properties.Settings.Default.MyStringSetting = value ; Properties.Settings.Default.Save(); } } public static List< string > MyStringCollectionSetting { get { return toStringList(Properties.Settings.Default.MyStringCollectionSetting); } set { Properties.Settings.Default.MyStringCollectionSetting = fromStringList( value ); Properties.Settings.Default.Save(); } } private static List< string > toStringList(StringCollection sc) { List< string > list = new List< string >(); if (sc != null ) { foreach ( string s in sc) { list.Add(s); } } return list; } private static StringCollection fromStringList(List< string > list) { StringCollection sc = new StringCollection(); if (list != null ) { foreach ( s...

//read file using (TextReader tr = new StreamReader(" sample.txt ")) { string line = tr.ReadLine(); } //write file using (TextWriter tw = new StreamWriter(" sample.txt ")) { tw.WriteLine(" text "); }

Define the ComboBox with DataTable //define DataTable DataTable dt = new DataTable(" dataTable "); dt.Columns.Add(" Id ", typeof ( int )); dt.Columns.Add(" Name ", typeof ( string )); //add DataRow DataRow row = dt.NewRow(); row[" Id "] = 1; row[" Name "] = " One "; dt.Rows.Add(row); //assign to ComboBox comboBox.DataSource = dt; comboBox.DisplayMember = " Name "; comboBox.ValueMember = " Id "; Get Selected data from ComboBox DataRow row = ((DataTable)comboBox.DataSource).Rows[comboBox.SelectedIndex]; int Id = ( int )row[" Id "]; string Name = ( string )row[" Name "];

Define the GridView with DataTable //define DataTable DataTable dt = new DataTable(" dataTable "); dt.Columns.Add(" Id ", typeof ( int )); dt.Columns.Add(" Name ", typeof ( string )); //add DataRow DataRow row = dt.NewRow(); row[" Id "] = 1; row[" Name "] = " One "; dt.Rows.Add(row); //assign to gridView gridView.DataSource = dt; Get data from selected Row in GridView //get data from selected row private void gridView_SelectionChanged( object sender, EventArgs e) { if (gridView.SelectedCells.Count > 0) { int seletedRow = gridView.SelectedCells[0].RowIndex; DataRow row = ((DataTable) gridView.DataSource).Rows[seletedRow]; int id = ( int )row[" Id "]; string name = ( string )row[" Name "]; } } Change Column colours private void gridView_CellFormatting( object sender, DataGridViewCellFormattingEventArgs e) { DataGridViewRow row = gridView.Rows[e.R...

using System.ServiceProcess; public void Test() { ServiceController controller = new ServiceController(); controller.MachineName = " . "; controller.ServiceName = " MyService "; controller.Stop(); //wait until stopped controller.Start(); //wait until started controller.Refresh(); Console.WriteLine(controller.Status.ToString()); }

DotNetZip is an OpenSource Zip library for C# public void ZipDir( string directoryPath, string zipFilePath) { using (ZipFile zip = new ZipFile()) { zip.AddDirectory(directoryPath); zip.Save(zipFilePath); } } public void UnzipDir( string zipFilePath, string directoryPath) { using (ZipFile zip = ZipFile.Read(zipFilePath)) { zip.ExtractAll(directoryPath, true ); } } public void UnzipFile( string zipFilePath, string directoryPath, string fileName) { using (ZipFile zip = ZipFile.Read(zipFilePath)) { zip.Extract(fileName, directoryPath, true ); } }

This is the fastest way to compare 2 tables in SQL Server. Generate hash for both tables and see if it's the same. SELECT checksum_agg(checksum (*)) FROM table 1

This system tables allow you to see the list of views, tables, stored procedures in the database as well as information like creation, modify date. SELECT * FROM MyDb.sys.views SELECT * FROM MyDb.sys.tables SELECT * FROM MyDb.sys.procedures

Grant/Revoke privileges on Tables Privilages: Select, Insert, Update, Delete , References, Alter, Index References - Ability to create contraint that refers to table Alter - Ability to alter table definition Index - Ability to create index Grant/Revoke privileges on Functions/Procedures Privilages: Execute Examples: GRANT Select, Update ON Table1 TO MyDbUser REVOKE Select, Update ON Table1 FROM MyDbUser GRANT Execute ON MyStoredProcedure TO MyDbUser REVOKE Execute ON MyStoredProcedure FROM MyDbUser

public static string ToString<T>(List<T> list) { StringBuilder builder = new StringBuilder(); if (list != null ) { foreach (T t in list) { builder.Append(t.ToString()); } } return builder.ToString(); } public static string ToString<T,K>(Dictionary<T,K> dictionary) { StringBuilder builder = new StringBuilder(); if (dictionary != null ) { foreach (KeyValuePair<T, K> pair in list) { builder.Append(pair.ToString()); } } return builder.ToString(); }

To autogenerate ToString() method with Resharper (Alt+Ins) download JetBrains PowerToys The installer will create directory structure in C:\Program Files\JetBrains\ReSharper\v3.0\ If you're using different version v3.x make sure to copy the contents of \v3.0\vs8.0\PowerToys and \v3.0\vs8.0\Bin\Plugins to \v3.x folder.

This example shows how to load a specialized version of Component implementation from from another dll during runtime. Define an interface in a Common project namespace MyCompany.Common { public interface Component { void Execute(); } } Create specialized library that will be loaded at runtime and add reference to Common project. using MyCompany.Common; namespace MyCompany.Custom { public class SampleComponent : Component { public void Execute() { Console.WriteLine(" Sample Component "); } } } Create your Console/Windows project and add a reference to Common project. Do not add reference to Custom one as this assembly will be loaded at runtime. using MyCompany.Common; namespace MyCompany.MyProgram { static class Program { public static void Main() { string path = @" {your.dll.directory}\MyCompany.Custom.dll "; Assembly a = Assembly.LoadFile(path); Component c = (Component)a.C...

Create spring configuration file spring.xml with a sample bean definition <? xml version="1.0" encoding="utf-8" ?> < objects xmlns = "http://www.springframework.net" > < object id = "MyClass" type = "MyCompany.MyClass,MyCompany" > < property name = "name" value = "John" /> </ object > </ objects > Use XmlApplicationContext to access bean namespace MyCompany { [TestFixture] public class Test { public void Test1() { IApplicationContext context = new XmlApplicationContext(" spring.xml "); IObjectFactory factory = context; MyClass obj = (MyClass)factory[" MyClass "]; obj.Test(); } } public class MyClass { private string name; public string Name { get { return name; } ...