sqlserverfordeveloper.blogspot.com
Sql Server Blog: June 2012
http://sqlserverfordeveloper.blogspot.com/2012_06_01_archive.html
Deleting All Keys or constraints from database. C# DOT NET for Developers. Remove all XML tags from a string. Read client side IP Address. Project Lead, HCL Technologies Ltd. Noida. View my complete profile. Friday, June 22, 2012. Deleting All Keys or constraints from database. Sql NVARCHAR(500) DECLARE @Cursor CURSOR. Cursor = CURSOR FAST FORWARD FOR. SELECT DISTINCT sql = 'ALTER TABLE [' tc2.TABLE NAME '] DROP [' rc1.CONSTRAINT NAME ']'. FROM INFORMATION SCHEMA.REFERENTIAL CONSTRAINTS rc1.
maanusblogs.blogspot.com
Share Point Developer Blog: Change SharePoint 'Document library/List' Column width
http://maanusblogs.blogspot.com/2009/08/change-sharepoint-document-librarylist.html
Share Point Developer Blog. Tuesday, August 25, 2009. Change SharePoint 'Document library/List' Column width. Sometimes we need to change default column width of document library/list.To change sharepoint document library/list column we need to add a content editor webpart on that perticular page and need to write below code as javascript script. Use below code within javascript tag). For (var i = 0, l = document.getElementsByTagName("TH").length; i. If (thisTH.innerText = 'Comments') {. Solution : Go to...
dotnetfordeveloper.blogspot.com
C# DOT NET for Developers: 2/1/10 - 3/1/10
http://dotnetfordeveloper.blogspot.com/2010_02_01_archive.html
C# DOT NET for Developers. C#, ASP.Net, WCF, WPF, Web Services, etc. Sunday, February 7, 2010. Now let's see an example of DiffGrams. The code is to reads data from Employees tables and write in an XML document in DiffGram format. Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c: Northwind.mdb". Dim sql As String = "SELECT EmployeeID, FirstName, LastName, Title FROM Employees". Dim conn As OleDbConnection = Nothing. Dim ds As DataSet = Nothing. Create and open connection.
dotnetfordeveloper.blogspot.com
C# DOT NET for Developers: Difference between Interface and Abstract Class
http://dotnetfordeveloper.blogspot.com/2011/06/difference-between-interface-and.html
C# DOT NET for Developers. C#, ASP.Net, WCF, WPF, Web Services, etc. Friday, June 3, 2011. Difference between Interface and Abstract Class. What is an Abstract Class? An abstract class is a special kind of class that cannot be instantiated. So the question is why we need a class that cannot be instantiated? What is an Interface? A class may inherit several interfaces. A class may inherit only one abstract class. An interface cannot provide any code, just the signature. If various implementations only sha...
sqlserverfordeveloper.blogspot.com
Sql Server Blog: October 2009
http://sqlserverfordeveloper.blogspot.com/2009_10_01_archive.html
Search string in any column in a table. Counting rows in a table for improving performance. Searching in a column of any table by a substring. Select desired rows from table by IN Keyword. Select top two rows from SQL server database table. Insert rows/records from one table to another tabl. How to select Duplicate Rows from a table. Create Serial Number Column using SQL Server. C# DOT NET for Developers. Remove all XML tags from a string. Read client side IP Address. View my complete profile. EXEC sp Fi...
dotnetfordeveloper.blogspot.com
C# DOT NET for Developers: 5/1/09 - 6/1/09
http://dotnetfordeveloper.blogspot.com/2009_05_01_archive.html
C# DOT NET for Developers. C#, ASP.Net, WCF, WPF, Web Services, etc. Monday, May 11, 2009. Insert data through Stored Procedure in ASP.net. Here we will insert firstname in table tbl test. Stored Procedure. Below are the steps to implement it. Step1 : Add this in web.config file. Add key="cn" value="workstation id=SQL8;packet size=4096;user id=sa;password=amit;data source=USER1;initial catalog=amit; Connection Timeout=120;". Step2 : Add with other namespaces. Using System.Data.SqlClient;. The Connection ...
maanusblogs.blogspot.com
Share Point Developer Blog: Programmatically Upload a file from Local path to sharepoint document library [c#]
http://maanusblogs.blogspot.com/2009/06/programmatically-upload-file-from-local.html
Share Point Developer Blog. Wednesday, June 10, 2009. Programmatically Upload a file from Local path to sharepoint document library [c#]. Here code is using FileUpload control to get a file from local system path.After getting this local file path ,below is code which helps to add this file to sharepoint document library. String sourceFilePath = fileUpload.PostedFile.FileName.ToString();. SourceFilePath = sourceFilePath.Replace("%20", " ");. SourceFilePath = sourceFilePath.Replace(' ', '/');. FStream....
maanusblogs.blogspot.com
Share Point Developer Blog: December 2009
http://maanusblogs.blogspot.com/2009_12_01_archive.html
Share Point Developer Blog. Wednesday, December 30, 2009. View a detailed error in sharepoint. To View a detailed error in sharepoint, you need to follow below steps in your site’s web.config file . Change 'CallStack' value from false to true in SafeMode attribute as shown below. SafeMode MaxControls="200" CallStack="false" ./]. SafeMode MaxControls="200" CallStack="true" ./]. Change 'customErrors' tag mode from ‘On’ to ‘Off’. Change 'Debug' from 'false' to 'true' in 'Compilation' attribute. To deploy ou...
maanusblogs.blogspot.com
Share Point Developer Blog: August 2009
http://maanusblogs.blogspot.com/2009_08_01_archive.html
Share Point Developer Blog. Tuesday, August 25, 2009. Change SharePoint 'Document library/List' Column width. Sometimes we need to change default column width of document library/list.To change sharepoint document library/list column we need to add a content editor webpart on that perticular page and need to write below code as javascript script. Use below code within javascript tag). For (var i = 0, l = document.getElementsByTagName("TH").length; i. If (thisTH.innerText = 'Comments') {. Failed on Start 1.
maanusblogs.blogspot.com
Share Point Developer Blog: Remove / Hide the "Approval" and "Collect Feedback" workflow in the "Start a New Workflow" page.
http://maanusblogs.blogspot.com/2010/04/remove-hide-approval-and-collect.html
Share Point Developer Blog. Monday, April 19, 2010. Remove / Hide the "Approval" and "Collect Feedback" workflow in the "Start a New Workflow" page. Go to : Shared Service Administrator Site Setting Site Content Type Gallery Site Content Type,. Select 'Document' or that content type where you want to remove 'Approval' or 'Collect Feedback' OOB Workflows. Click 'WorkFlow Settings' remove the 'Approval' and 'Collect Feedback'. Labels: Remove / Hide the Approval and Collect Feedback. View my complete profile.