.NET programming tips and solution

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

2010-06-10T07:08:00.000-07:00

SQL Errors and Solutions,The conversion of a varchar data type to a datetime data type resulted in an out-of-range value,SQL,SQL tips SQL Server Error Message: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value This error occurs when the varchar value does not form a valid date. Error Message: Server: Msg 242, Level 16, State 3, Line 1 The

Unable to find the requested .Net Framework Data Provider. It may not be installed.

2010-06-09T15:20:00.000-07:00

SQL Errors and Solutions,.NET Errors and Solutions,Unable to find the requested .Net Framework Data Provider. It may not be installed.,.NET I got this error "Unable to find the requested .Net Framework Data Provider. It may not be installed." when I try to retrieve the data from SQL Server. Reason: Whoo!! I had wrongly mentioned the Data provider name in my dll. I had mentioned as

Convert CYYMMDD format to datetime - SQL

2010-05-27T15:55:00.000-07:00

Convert CYYMMDD to DateTime,Convert CYYMMDD to DateTime Format,SQL,SQL Query,AS400 datetime In the date format CYYMMDD(AS400 date format), C is Century. If C is 0 the year is 19XX, and it is 20XX if C is 1(Where XX can be any two digit year). YYMMDD is Year Month and Day(All two digit). In CYYMMDD format, today's date (May 27, 2010) would be 1100527. It is '0' for 19 and '1' for 20 to make

Invalid object name 'INFORMATION_SCHEMA.tables' - SQL Error

2010-05-27T15:27:00.000-07:00

Invalid object name 'INFORMATION_SCHEMA.tables',SQL Errors and Solutions,SQL The error Invalid object name 'INFORMATION_SCHEMA.tables' was thrown when I executed the following query, Select * from INFORMATION_SCHEMA.tables for a particular database. Reason: The particular database was case sensitive. Solution: I re-ran the same query with upper-case letters and it worked fine. Select *

Google Chrome browser keyboard shortcuts

2010-05-27T15:04:00.000-07:00

Ctrl-Alt-Del in Remote Desktop Connection Window,Remote Machine, Keyboard Shortcuts Google Chrome offers some tips on keyboard shortcut for easy navigation and operation. The below keyboard hotkeys or accelerators are the lists of common and useful built-in shortcuts . CTRL + SHIFT + N : automatically opens up a Chrome ‘incognito’ window which allows you to surf on a PC without leaving behind

Ctrl-Alt-Del in Remote Desktop Connection Window

2010-05-27T14:54:00.000-07:00

Ctrl-Alt-Del in Remote Desktop Connection Window,Remote Machine, Keyboard Shortcuts Ctrl-Alt-Del keyboard shortcut has been commonly used since IBM PC with DOS era to perform soft reboot, and used in modern Windows system to activate Winlogon process (log on to Windows NT), open Task Manager or Windows Security dialog box that allows user to log off, lock computer, shutdown PC, run Task Manager,

Not enough storage is available to process this command

2010-05-06T17:19:00.000-07:00

Not enough storage is available to process this command I recently faced an issue in the development server, the error message "Not enough storage is available to process this command" popped up when try to ran the longer query in the sql server. Not enough storage is available to process this command The reason for the error was due to the IPRStackSize registry entry was missing or

Convert YYYYMMDD to DateTime SQL

2010-05-05T11:40:00.000-07:00

Convert YYYYMMDD to DateTime,Convert YYYYMMDD to DateTime Format,SQL,SQL Query The following SQL query converts the date stored as decimal or numeric in the form of YYYYMMDD to datetime. 1) SELECT CAST(CAST(YourDateField AS VARCHAR(8)) AS DATETIME) For example: SELECT CAST(CAST(20060204 AS VARCHAR(8)) AS DATETIME) AS [DateTime] will be displayed as 2006-02-04 00:00:00.000 2) CONVERT(

WPF application executable path

2010-05-03T14:12:00.000-07:00

In windows forms, Application.ExecutablePath gives the executable path of the application. What is the alternative in WPF? System.Reflection.Assembly.GetExecutingAssembly().Location will give the executable path of the WPF application.

Convert Julian Date YYYYDDD to Datetime Format

2010-05-03T13:45:00.000-07:00

Convert YYYYDDD to datetime,Convert Julian Date YYYYDDD to Datetime Format,Convert Julian Date YYYYDDD to Gregarian Format,SQL,SQL Query I got a requirement to display the date which is the format 7-digit YYYYDDD (Julian Date) to display in Gregarian format. This is the query I wrote to convert YYYYDDD format to YYYY-MM-DD format. YYYY - 4 - digit Year DDD - number of the day in the year SQL

Remove grid lines in remote desktop

2010-04-28T14:02:00.000-07:00

Computer Tips,Remove grid lines in remote desktop, Remote desktop issue I am having been of late developing a Soft ware package in .NET Framework 3.5 for the LegaSync Project, to migrate the data from various legacy ERP systems (SAP,SYTELINE,MACPAC,MANMAN,JDE etc) to SQL server. when it came to production deployment, the client had hosted a server with the latest configuration ( Windows Server

Display line numbers in .NET Code Editor

2010-04-27T16:01:00.000-07:00

.NET Tips,Display line numbers in code editor, display line numbers in VS .NET IDE We can display the line numbers in the Visual studio .NET code editor. In the VS.NET IDE , Click TOOLS > OPTIONS Expand TEXT EDITOR (in left window) Select Basic > Editor You will find the Line Numbers Option Under Interaction Group box. Check Line Numbers option Click OK code Editor with Line

Import Microsoft Access 2007 Database Tables into SQL Server 2008

2010-04-26T17:11:00.000-07:00

Import Microsoft access 2007 database to SQL Server,Import Microsoft access 2007 database to SQL Server 2008,Import Microsoft access database to SQL Server,Import access 2007 database to SQL Server,Import access 2007 database to SQL Server 2008,Import Ms access 2007 database to SQL Server,Import Ms access database to SQL Server,Import Ms access 2007 database to SQL Server 2008, Import MS access

Display varbinary columns in Datagridview

2010-04-26T15:38:00.000-07:00

Display varbinary columns in DataGridview,VB.NET,.NET Tips,Display varbinary,Display varbinary in Datagridview Varbinary to string,Handling of varbinary data,SQL Varbinary datatype, Byte[], Datagridview I recently faced an issue while displaying SQL query results in a DataGridView, it was crashing on varbinary columns. The reason was that the default format for a varbinary column is to display it

System.Management.Automation dll missing

2010-04-22T13:32:00.000-07:00

System.Management.Automation,.NET,.NET Tips,Microsoft If the Powershell SDK is already installed, System.Management.Automation dll will be found in the following location. C:\Program Files\Reference Assemblies\Microsoft\WindowsPowerShell\v1.0 The Windows PowerShell 2.0 Software Development Kit can be downloaded from the following link: http://www.microsoft.com/downloads/details.aspx?FamilyID=

Populate DataGridView using CSV File

2010-04-20T10:34:00.000-07:00

The following VB.NET Code is used to populate the DataGridView using CSV File. I have used a 2 dimensional array to store the content of csv row and column wise Also 2 One dimensional arrays are used to populate the row and column data respectively. The logic is to parse the file content into string and store in a two dimensional array. Then read row wise and column wise and populate the

Panel Double buffering VB.NET and C# - Flicker Free

2010-04-19T15:37:00.000-07:00

I faced a problem when loading background image in the panel. It used to flicker a lot. I thought of double buffering concept. But there is no in-built double buffering property for panel. All what I did is to write a class which inherits from Panel Class, and in the constructor set the DoubleBuffered to true and set the appropriate control styles. VB.NET Code Public Class DoubleBufferPanel

Rename Excel Sheet VB.NET and C#.

2010-04-19T15:22:00.000-07:00

The following sections will show you how to rename an Excel worksheet through VB.NET and C#. To rename an excel sheet we need to open the excel file, rename the sheets, sava and close it. For open an Excel 2007 workbook ,we have to add the Microsoft Excel 12.0 Object Library (For Excel 2007, but it may vary depends on the Excel version you are using) in you project. From the following

Log off Remote Desktop Users

2010-04-16T09:00:00.000-07:00

There are serveral DOS commands to forcibly log off the remote user. But we need to be an administrator of the target machine. How to query for users on a machine? First we can query to find out what users have a session on a remote machine? Windows provides the "quser" command which we can use to query for the sessions running on that machine. The format is as follows: quser /server:

Value Close() cannot be called while doing CreateHandle()

2010-04-14T12:54:00.000-07:00

The error Value Close() cannot be called while doing CreateHandle() usually happens when we try to close the form in the constructor or Load event. For example, the following code gives the error: Private Sub RootForm_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load 'Some Validation 'If Failed then close the form Me.Close 'The exception throws -->Value Close()

Display row count for all SQL tables

2010-04-14T12:29:00.000-07:00

The following T-SQL script returns the number of rows in each table for a database. SELECT '[' + SCHEMA_NAME(t.schema_id) + '].[' + t.name + ']' AS [Full Table Name], SCHEMA_NAME(t.schema_id) AS [Schema Name], t.name AS [Table Name], i.rows AS [Row Count] FROM sys.tables AS t INNER JOIN sys.sysindexes AS i ON t.object_id = i.id AND i.indid < 2 WHERE (t.type = 'U') Sample Output:

Items collection cannot be modified when the DataSource property is set

2010-03-31T11:28:00.000-07:00

I received the following error "Items collection cannot be modified when the DataSource property is set" when populating the combo box with data table. Reason: The Items.Clear method was called while the combo box's data source was assigned. Solution: Need to set the combo box's data source to nothing before calling Items.Clear method The following sample code explains this scenario

The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

2010-03-29T07:43:00.000-07:00

I received the following error The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine' in my 64-bit machine, Windows 2008 R2 when I ran by windows application. But the same code was working fine in 32-bit machine. Reason: There is no 64-bit Microsoft.Jet.OLEDB Provider. Solution: We need to forcibly build the application to 32-bit. Steps Goto Build ->Project

Create Setup and Deployment Project Visual Studio 2008

2010-03-01T08:05:00.001-08:00

Creating a Setup and Deployment Project In this article I will cover the basics of creating a Windows Installer. This article will explain the step by step process of creating a Setup Project. Step 1: Create a Sample .Net Project. I have named this project as "TestBlogProject". Figure 1 Sample Project Create a Setup Project Open the TestBlogProject in the VS IDE. Figure 2:

Display Logical drives information of Machine VB.NET

2010-02-25T14:55:00.000-08:00

The following code snippets explains how to retrieve the logical drives in the system, information about the logical drives (Drive Name, Drive Type, Available Free Size, Volume Label etc.,) present in the system. All we have to do is to reference the namespace System.IO The System.IODirectory.GetLogicalDrives method is used to get an array of the drive names. I have displayed them in a