Add a Drop Down List into Excel File using C# .NET

Here I will demonstrate to you how to add a drop down list into an Excel File using C# .NET. Before you adding this codes, make sure you have add the Microsoft Excel Object Library as reference into your project.Here are the codes:Excel.Application xlsApp = new Excel.ApplicationClass();Excel.Workbook xlsWorkbook;Excel.Worksheet xlsWorksheet;object oMissing = System.Reflection.Missing.Value;//Create new workbookxlsWorkbook = xlsApp.Workbooks.Add(true);//Get the first worksheetxlsWorksheet = (Excel.Worksheet)(xlsWorkbook.Worksheets[1]);string[]...

Add a Project or Solution to Source Control

You can add projects and solutions to source control through Solution Explorer in Visual Studio. Follow the steps as below:1. On the Tools menu, click Options. In the Options dialog box, select Source Control. Select Visual Studio Team Foundation Server from the Current source control plug-in list. 2. In Solution Explorer, right-click the solution, choose Add Solution to Source Control.3. In the Add Solution to Source...

15 Date Formats in SQL Server 2000

--'YYYYMMDD'SELECT CONVERT(CHAR(8), GETDATE(), 112)--'YYYY-MM-DD'SELECT CONVERT(CHAR(10), GETDATE(), 23)--'YYYY-MMM-DD'SELECT STUFF(CONVERT(CHAR(10), GETDATE(), 23), 6, 2, LEFT(DATENAME(m, GETDATE()), 3))--'YYMMDD'SELECT CONVERT(VARCHAR(8), GETDATE(), 12)--'YY-MM-DD'SELECT STUFF(STUFF(CONVERT(VARCHAR(8), GETDATE(), 12), 5, 0, '-'), 3, 0, '-')--'YY-MMM-DD'SELECT STUFF(STUFF(STUFF(CONVERT(VARCHAR(8), GETDATE(), 12), 3, 2, LEFT(DATENAME(m, GETDATE()), 3)), 6, 0, '-'), 3, 0, '-')--'MM-DD-YY'SELECT CONVERT(CHAR(8), GETDATE(), 10)--'MMDDYY'SELECT...

Differences between VARCHAR and NVARCHAR

VARCHAR is an abbreviation for variable-length character string with a maximum limit of 8000 bytes.NVARCHAR are the Unicode equivalents of VARCHAR. Unicode uses two bytes per character, which allows the storage of multilingual characters with a maximum length of 4000 bytes. The most common use of NVARCHAR is to store character data that is a mixture of English and non-English symbols, such as English and Chinese. Other languages have an extended set of character codes that need to be saved and this datatype allows for this extension....

How to get IP Address of a computer in C#

To get the IP address of the local machine in C#, system.net namespace is needed. From the IPHostEntry class, we can get the address list in a string array.using System.Net;private string GetIP() {     string strHostName = "";      strHostName = System.Net.Dns.GetHostName();      IPHostEntry ipEntry = System.Net.Dns.GetHostEntry(strHostName);      IPAddress[] addr = ipEntry.AddressList;      return addr[addr.Leng...

ASP .NET File Upload Problem

When I upload a large file (> 4MB), I started getting error - "The page cannot be displayed". It took me 15 minutes before I realized that maxRequestLength is causing this problem.By default, the maxRequestLength will be 4MB. If you are uploading a file which is larger than 4MB, please be sure to edit your web.config file by using httpRuntime attribute.httpRuntime attribute has several properties, but the attributes that you need to take note are executionTimeout and maxRequestLength. The executionTimeout is the maximum time...

Filtering and Sorting in ADO .NET

There are many ways to filter data. One way is to filter data by using a WHERE clause on your database query. In ADO .NET, there is some additional functionality that you can use to filter data in a dataset. Two fundamental approaches of it:(i) DataTable Select Method(ii) DataView ObjectFiltering with Select MethodImagine that a dataset contains data about Students and Grades tables. To filter on those data with the Grade of A, you can use Select method, which will return an array of rows.VBDim ds_Student As New DataSetDim...