Articles (2414) - Page 77

Write Stored Procedure On Real Cloud.. 

Always we are not so fortunate to work with only SQL server through out our whole life. Sometimes we may have to come across different databases like DB2, MySQL, Sybase etc.. In this article we are going to create a dynamic sql query where we will pass few parameters into it through command line interface at the time of execution. You all must have been questioning yourself, why has not this guy adopted a simple stored procedure instead of breaking his head on scripting so much? That’s a nice question, I agree. Think, suppose you are not the DBA in your organization and have been restricted to create stored procedure in live database but on regular task you want to fetch few data for audit and delete some older history from the table with passing some different parameters for strong condition, each time.

How to Write a Simple login page in Asp.net 

Yesterday I stumbled across a post that was posted on our forum. I was very busy with other things, when Sheo started a conversation based on that post. I was looking at it until he updated the untagged code that was posted. By looking at the Stored Procedure I could see that the poster was lost and his Stored Procedure approach failed him. In this Article am going to explain how to write a simple login in Asp.net.

File Upload in Gridview with Ajax Modalpopup 

In this article,I will use fileupload control in ajax modal popup to upload file in gridview and the update it.

Creating a Custom Project Templates with IWizard interface using Extensibility Project of VS2010 SDK 

In this article we will learn creating a Custom Project Templates with IWizard interface using Extensibility Project of VS2010 SDK

Way to display query execution plan(Text) from c# 

We may sometime need to display the execution plan . I got one such requirement recently and thought of sharing the same here. I will take two examples into consideration for demonstrating the application . The first with a normal query and then the same with a stored procedure .

Creating a new category for Custom Templates with a new entry to Install Templates for Visual Studio using Extensibility Project of VS2010 SDK 

In this article we will see how to create a new category for Custom Templates with a new entry to Install Templates for Visual Studio using Extensibility Project of VS2010 SDK

A basic introduction to creation of CRUD operation using OData Web Service via WCF Data Services 

In this article we will have a basic introduction to creation of CRUD operation using OData Web Service via WCF Data Services

Some useful datatable extension methods we should know 

Some datatable extension methods we need often in projects

An introduction to Yoda Condition w.r.t. C# 

In this article we will look into what are Yoda conditions and it's advantages w.r.t C#

Setup Query Shortcuts in SQL Server 

SQL Server Management studio provides a very useful functionality called query shortcuts. This makes the task of querying the sql server easier. Just by pressing two keys on the keyboard a complex query can be executed.

How to get the value of Textbox, CheckBoxlist, RadioButtonList, ListBox, DropDownList in javascript 

In this Article you will learn how to get the values or text of textbox,CheckBoxlist,RadioButtonList,ListBox,dropdownlist in javascript.

Fixiing e24paymentpipe.dll error of HDFC payment gateway 

This small article explains how to fix e24paymentpipe.dll assembly manifest error.

Way to convert a varchar type column is to xml type with preservation of already existing data in SQL Server 

Here we will see a to convert a varchar type column is to xml type with preservation of already existing data.

Extract values from XML attributes and present in comma saperated values using XQuery in SQL Server 

In this article we will figure out as how to extract values from XML Attributes and present in comma separated values using XQuery

Extracting values from XML nodes and present in comma separated values using XQuery in SQL Server 

In this article we will look into some methods as how to extract values from XML nodes and present in comma separated values using XQuery