consume wcf service with jquery

http://www.aspsnippets.com/Articles/Make-AJAX-JSON-call-to-ASP.Net-WCF-Service-using-jQuery-and-Javascript.aspx

List out all table procedures or specified table/column in sqlserver

List out all procedures which are used specific table

SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so on sc.id=so.id WHERE sc.text LIKE '%tablename%'


Get List of programs that used(mentioned) particular  column in side the query.

•  This script search stored procedures, views, functions as well other objects.

           SELECT OBJECT_NAME(OBJECT_ID), definition FROM sys.sql_modules WHERE              definition LIKE '%' + 'EMAIL' + '%'

• This script search only stored procedure for specified column.

            SELECT DISTINCT OBJECT_NAME(OBJECT_ID), object_definition(OBJECT_ID)

            FROM sys.Procedures WHERE object_definition(OBJECT_ID) LIKE '%' + 'EMAIL' + '%'

Getting json response as object

 [WebMethod]
    [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
    public static IEnumerable<SearchInfluencers.InfCategories> GetICategories()
    {
        return DAFindInflueners.GetInfluencersCountByCategory().OrderBy(i => i.ICATEGORYNAME).ToList();
    }


//---In js file
 success: function (Catlist) {
            $.each(Catlist.d, function (index, Cat) {
                alert(Cat.ICATEGORYID + Cat.ICATEGORYNAME + Cat.ICATINFCOUNT')
            });  

Create and consume wcf service..

http://www.webcodeexpert.com/2013/04/how-to-create-and-consume-wcf-services.html

Selecting multiple rows as single row in sql server

SELECT STUFF((SELECT DISTINCT ','+CONVERT(VARCHAR(10), MO_CC_ID) from NEWMAKE_OFFER WHERE MO_FU_ID=546 for XML path('')),1,1,'')

Dataview Row-filter Syntax in C#

http://www.csharp-examples.net/dataview-rowfilter/

Getting Query string value in aspx page

 <%# string.Format("{0}", Request.QueryString["value"])%>