IT Programming

Changing the Setting From The Tools Menu In the Options dialog box of Tools Menu, expand Query Results, expand SQL Server and then select Results to Text as shown in the image below. In the right side panel change the value of Maximum number of characters displayed in each column

About IcoMoon is striving to build and provide the best iconography and icon management tool for perfectionists. IcoMoon's icon library features only the very best icon sets out there. All of our icons are designed on a precise pixel grid. The IcoMoon app lets you build and use

Private Sub ExportFile(ByVal strfilePath As String, ByVal strFilename As String) Try Response.Clear() Response.ContentType = "application/vnd.ms-excel" strfilePath = Server.MapPath(strfilePath) If Not System.IO.File.Exists(strfilePath) Then strfilePath = Server.MapPath("~//Data//ExportToExcel//NoRecord.xls") Response.AddHeader("content-disposition", ("attachment;filename=

Ever wanted to add an "Export to Excel" function to your ASP.Net, WinForms or WPF application ? This free C# and VB.Net library lets you export a DataTable or DataSet of data into a "real" Excel 2007 .xlsx file, using one line of code. DocumentFormat.

The problem is that the browser detection code in MicrosoftAjax.js does not detect WebKit (gasp!). Just include this javascript in your site and that should take care of it. Sys.Browser.WebKit = {}; if (navigator.userAgent.indexOf('WebKit/') > -1) { Sys.Browser.agent = Sys.Browser.WebKit; Sys.Browser.

Imports System.Web Imports System.Web.Services Imports System.Web.Services.Protocols Imports System.Data Imports System.Web.Script.Serialization Imports System.Runtime.Serialization.Json Imports System.IO _ _ _ Public Class WS Inherits System.Web.Services.WebService Private strConn As String _ _ Public Function GetSummaryDynamic(ByVal startrowindex As String, ByVal maximumrows As

DirectoryEntry entry = new DirectoryEntry("Domain", "UserName", "Password", AuthenticationTypes.None); DirectorySearcher dSearch = new DirectorySearcher(entry); dSearch.SearchScope = System.DirectoryServices.SearchScope.Subtree; dSearch.ReferralChasing = ReferralChasingOption.All; dSearch.PageSize = 5000; dSearch.Filter = "(&(objectClass=user))"; foreach (SearchResult sResultSet in dSearch.FindAll()) { if (sResultSet.Properties["

To kill all the connections to your database you can use the ALTER DATABASE command. Sometimes you want to restore the database from a backup but can't because people are connected. Here is one way which will kick off all the users immediately TSQLLINE NUMBER OFF | HIDE | SELECT

TSQL CREATE TABLE #TBL_ADM_USER ( user_id INT, user_name NVARCHAR(1000) ) INSERT INTO #TBL_ADM_USER VALUES (1,'NAME1') INSERT INTO #TBL_ADM_USER VALUES (2,'NAME2') INSERT INTO #TBL_ADM_USER VALUES (3,'NAME3') DECLARE @XML_STR AS NVARCHAR(MAX) SET

SELECT 'EXEC SP_RENAME ''' + name + ''' , ''' + 'X_20170223_' + name + '''' FROM sys.objects WHERE type = 'P' and modify_date > '2016-09-09 16:37:38.913' and name not like 'X_%'