sqlmgmt.com

dotnetbeyond.blogspot.com

.NET and Beyond: September 2011

http://dotnetbeyond.blogspot.com/2011_09_01_archive.html

A developer's notes - C# / .NET. Monday, September 26, 2011. Read/Write Data in Excel using OleDb (C#). There are many ways of read/write data in Excel file. This post shows a simple example of using System.Data.OleDb in C#. One of advantages of using this method is no need to have Office in client machine. The code snippet below shows how to connect to Excel using OleDB, how to select, update and insert data. There is DELETE operation here since it is not supported by OLEDB provider. Select/Update/Delet...

dotnetbeyond.blogspot.com

.NET and Beyond: December 2014

http://dotnetbeyond.blogspot.com/2014_12_01_archive.html

A developer's notes - C# / .NET. Tuesday, December 16, 2014. How to debug SQLCLR in VS 2012. Here is how to debug your SQLCLR code in Visual Studio. I assume that you already have your SQLCLR DLL and its related stored procedure set up in your SQL Server. Open "SQL Server Object Explorer" (can be opened from View - SQL Server Object Explorer menu). Rightclick on the connection and choose [Allow SQL/CLR debugging]. Rightclick on the SP and choose "Debug Procedure". Subscribe to: Posts (Atom).

dotnetbeyond.blogspot.com

.NET and Beyond: February 2013

http://dotnetbeyond.blogspot.com/2013_02_01_archive.html

A developer's notes - C# / .NET. Tuesday, February 26, 2013. Send email from cmd script using Powershell. In C#, sending mail is a simple task. We create an instance of System.Net.Mail.SmtpClient class and then call Send method with MailMessage object. Sometimes smalle task is done by using windows shell script. If we have to use shell script in .cmd file, how do we send email? ECHO OFF REM Run App MyApp.exe data.ini MyApp.out 2 &1 echo EXIT CODE : %errorlevel% REM Check exit code if %errorle...The next ...

dotnetbeyond.blogspot.com

.NET and Beyond: July 2011

http://dotnetbeyond.blogspot.com/2011_07_01_archive.html

A developer's notes - C# / .NET. Wednesday, July 6, 2011. How to right justify text in textbox. WinForm TextBox control does not have any property or method that right justify text in the control. But this goal can be archieved by using SelectionStart and SelectionLength property. If you set SelectionStart to last position of the textbox and give a SelectionLength to zero, it mimics moving TextBox position to the end. Here is how to right-justify text in the TextBox control. Subscribe to: Posts (Atom).

dotnetbeyond.blogspot.com

.NET and Beyond: August 2012

http://dotnetbeyond.blogspot.com/2012_08_01_archive.html

A developer's notes - C# / .NET. Friday, August 17, 2012. WPF PropertyGrid - display partial enum values in ComboBox. In the previous post. I explained a way of getting a subset of enum values. This post shows an example of displaying a subset of enum onto WPF PropertyGrid. In WPF 4.0, there is no standard built-in PropertyGrid control but one can find a good PropertyGrid from Extended WPF ToolKit. BindingMode.TwoWay : BindingMode.OneWay; binding.Converter = CreateValueConverter(); BindingOpe...ResolveVa...

dotnetbeyond.blogspot.com

.NET and Beyond: October 2011

http://dotnetbeyond.blogspot.com/2011_10_01_archive.html

A developer's notes - C# / .NET. Tuesday, October 25, 2011. How to set cursor position in RichTextBox in WinForms. How can we set cursor position in WinForms RichTextBox control? One way of doing it is to use RichTextBox.Select() method. This method takes two parameters. First parameter is a starting character index and second one is the length of the selection. The following code snippet shows how to set cursor on the current position when mouse rightclick button is clicked. Tuesday, October 11, 2011.

dotnetbeyond.blogspot.com

.NET and Beyond: April 2013

http://dotnetbeyond.blogspot.com/2013_04_01_archive.html

A developer's notes - C# / .NET. Saturday, April 6, 2013. Add new line in .resx resource string. A simple topic. When adding newline such as n or r n in .RESX resource string, Visual Studio actually escapes the backslash character, so the actual data that is saved is double backslash instead od single backslash. For example, for input " n" in .RESX resource editor, the actual data will be n in .resx. Msg = string.Format(Resource1.ErrorMsg, errInfo); MessageBox.Show(this, msg, "Error");.

dotnetbeyond.blogspot.com

.NET and Beyond: June 2011

http://dotnetbeyond.blogspot.com/2011_06_01_archive.html

A developer's notes - C# / .NET. Saturday, June 4, 2011. UIA - how to automate WPF Ribbon control. Microsoft Ribbon for WPF 4.0 is not well working with Coded UI Test. UI recording against WPF ribbon control might work but replaying automation is likely not working. One way of getting around this problem is to use UIA (aka UIAutomation). Here is an example of WPF Ribbon control in XAML. If the application is run, it displays ribbon menus as follows. Subscribe to: Posts (Atom). Subscribe Now: Feed Icon.

dotnetbeyond.blogspot.com

.NET and Beyond: August 2011

http://dotnetbeyond.blogspot.com/2011_08_01_archive.html

A developer's notes - C# / .NET. Wednesday, August 31, 2011. VS : Changing .config file using conditional post-build event. Let's say one wants to use remote SQL connection by default and use local SQL connection only when special parameter (called UseLocalSQL. Is defined. To implement this sceanrio, first one needs to add the condition to Post build event in VS Project Properties dialog. If '$(UseLocalSQL)'= 'True' Copy "$(ProjectDir)LocalApp.config" "$(TargetPath).config" /y. Friday, August 26, 2011.