GL SOFT INDIA

When dealing with string data, one of the most useful Transact-SQL functions you can have in your toolbox is  PATINDEX . Aside from it’s man...

CREATE   FUNCTION  Split (      @StringToSplit  varchar (2048),      @Separator  varchar (128) ) RETURNS   TABLE   AS   RETURN WITH  CTE  AS...

How to export GridView to PDF (ASP.NET) Recently I have been trying to generate some reports to PDF file format from ASP. NET2.0 application...

Import Data from Excel File to sql datatable To Export Data Form an Excel file, there is one drawback lying behind them. The Sheet1 from the...

Import Data from Excel File to sql datatable As I has stated in my previous post regarding to Export Data Form an Excel file, there is one d...

Export Datatable to Excel (Not HTML Tables) Recently I working with export data to an excel file, but had faced a lot of problems. The main ...

Difference between NVARCHAR and VARCHAR in SQL Server The broad range of data types in SQL Server can sometimes throw people through a loop,...

Complete List of Web 2.0 APIs http://programmableweb.com/apilist/bycat Very useful.  Hope helps!

Suppose, we have identical records like :- name age *********** RAM 30 RAM 30 we have to keep one entry each for ram:30  and ram:40 and d...

        Dim strSample As String = "Left Center Right"         'left         strSample = strSample.Substring(0, 4)         ...

        Dim strSample As String = "Left Center Right"         'left         strSample = strSample.Substring(0, 4)         ...

Private Sub dgv_EditingControlShowing(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewEditingControlShowingEventArgs) Ha...

Dim excel As New Excel.Application         Dim wBook As Excel.Workbook         Dim wSheet As Excel.Worksheet         wBook = excel.Workbooks...