Skip to main content

.Net - Here and There

Search This Blog

Add a identity column in the table in a database

on February 14, 2010

Get link
Facebook
X
Pinterest
Email
Other Apps

alter table CustomersTest add ID int identity

CustomerTest is the table name and ID is the column name

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Popular Posts

Upgrade Umbraco version from 4.7.1 to 6.0.1

To upgrade from a old version to new version is pretty straight forward. I have upgraded one my projects where I followed the steps below - Download the Umbraco 6.0.1 Take a backup of your current site and the database Copy the following folder and files from the downloaded new version 6.0.1 and paste into the old version /App-Plugins /bin /install /Umbraco /Umbraco-Client /Config /Views /Global.asax /web.config 4. Before copying web.config make sure all of your settings are transferred to the new web.config file e.g. appsettings 5. If you add anything in the ValidElements section in the tinyMceConfig.config file, make sure you transfer your settings to the new file after copying. (the file is located under config folder) 6. Also update the 404 settings in the /Con...

How to update properties (summary and custom properties) of a word document without using the word API?

With the help of Dsofile.dll provided by Microsoft, you can easily modify properties of a document when Microsoft Office is not installed in the machine. The link is below - http://support.microsoft.com/kb/224351 For your convenience, I am putting some code below. I worte the code for a sharepoint project to remove document properties. Hope it helps. Imports System.IO Public Class RemoveAllProperty Private m_oDocument As DSOFile.OleDocumentPropertiesClass Public Function RemoveProperties(ByVal oStream As Stream) As MemoryStream ‘get the temporay file name along with the path Dim sFileName As String = Path.GetTempFileName() Dim oFileStream As System.IO.FileStream oFileStream = New System.IO.FileStream(sFileName, System.IO.FileMode.Create, FileAccess.ReadWrite) ‘copy the stream CopyStream(oStream, oFileStream) oStream.Close() oFileStream.Close() oFileStream.Dispose() Dim oSummProps As DSOFile.SummaryProperties Dim oCustProp As DSOFile.CustomProperty Dim sFile As Stri...

Few features of ASP.Net

If you are a web developer who uses ASP.NET, you might be interested in some of the latest features that Microsoft has introduced in this framework. Here are some of the highlights: - Blazor WebAssembly: This feature allows you to run C# code directly in the browser, without relying on JavaScript. You can use the same code and libraries for both server-side and client-side development, and enjoy fast performance and low latency. - SignalR: This feature enables real-time communication between the server and the client, using WebSockets or other protocols. You can use SignalR to build interactive web applications that support chat, gaming, live updates, and more. - gRPC: This feature is a modern, high-performance RPC framework that supports multiple languages and platforms. You can use gRPC to create microservices that communicate efficiently and reliably over HTTP/2. - Health Checks: This feature allows you to monitor the health and availability of your web applications and service...

Powered by Blogger