How to call Webservice from c#

//Written in html.aspx in

 <script type="text/javascript">
        function CreateTest(Path) {
            var pageUrl = '<%=ResolveUrl("~/SitemapService.asmx")%>'
            var parameters = "{path:'" + Path + "'}";
            $.ajax({
                type: "POST",
                url: pageUrl + "/CreateXMLBreadCrum",
                data: parameters,
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                success: OnSuccessCall,
                error: OnErrorCall
            });
        }
        function OnSuccessCall(response) {
            //alert('Hi');
        }
        function OnErrorCall(response) {
            //alert(response);
        }
    </script>

// CreateXMLBreadCrum is ametohd in a SitemapService.asmx

//Calling By C#
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), System.Guid.NewGuid().ToString(), "CreateTest('sitemap/Web.sitemap');", true);

How to set dynamic DEfault button in dot net whith master page and usercontrol in datalist

string st="BtnSubmit" ;//button control id, txtBox= Textbox id this is for gridviw or repeater or datalist

((TextBox)e.Item.FindControl("txtBox")).Attributes.Add("onkeydown", "if(event.which || event.keyCode){if ((event.which == 13) || (event.keyCode == 13)) {document.getElementById('" + st + "').click();return false;}} else {return true}; ");

hOW TO SET MAIL SETTING IN ASP.NET?

//IN WEB.CONFIG

<system.net>

<mailSettings>

<smtp>

<network host="smtp.servername" port="25" userName=noreply@servername password="*******"/>

</smtp>

</mailSettings>

</system.net>

how to set namespace in asp.net C#?

//IN Web.config 
<pages enableViewStateMac="true" enableEventValidation="false" controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID" enableViewState="true">

<namespaces>

<add namespace="System.Collections.Generic"/>

<add namespace="System.IO"/>

<add namespace="System.Data"/>

<add namespace="System.Data.SqlClient"/>

</namespaces>

</pages>

How to set browser in .net C#

<system.webServer>

<httpProtocol>

<customHeaders>

<clear />

<add name="X-UA-Compatible" value="IE=9" />

</customHeaders>

</httpProtocol>
</system.webserver>

How to set Viewstate in .net

<add key="aspnet:MaxHttpCollectionKeys" value="100001" />
//in Web.config

partition and paging in sql server

CREATE proc [dbo].[pagingandprtion]--

(

@FilterValue VARCHAR(MAX),

@SearchText VARCHAR(MAX),

@startindex INT ,

@pagesize INT,

@Flag VARCHAR(10),

@OrderBy VARCHAR(200)

)

AS

BEGIN

DECLARE @SQL varchar(MAX)

IF(@Flag='CODE')

BEGIN

SET @SQL = '



WITH PagingCTE AS (

SELECT ROW_NUMBER()OVER(ORDER BY ItemCode)AS Row_ID1,* from

(SELECT * ,ROW_NUMBER()OVER(partition by itemcode ORDER BY itemcode)AS Filt_Id FROM vw_allProductNew1 WHERE IsActive=1 AND

(ProductCode LIKE ''%'+ @SearchText + '%'' OR ProductName LIKE ''%'+ @SearchText + '%'') '+@FilterValue+') AS A )



select * from( SELECT ROW_NUMBER()OVER(ORDER BY ItemCode)AS Row_ID,* FROM PagingCTE WHERE Filt_id=1) as a WHERE

Row_ID >= ('+cast(@pagesize as varchar(10))+' * '+cast(@startindex as varchar(10))+') - ('+cast(@pagesize as varchar(10))+' -1) AND

Row_ID <= ('+cast(@pagesize as varchar(10))+' *'+ cast(@startindex as varchar(10))+') ' +'' +@OrderBy+''

--print @sql

END

ELSE

BEGIN

SET @SQL = '



WITH PagingCTE AS (

select ROW_NUMBER()OVER(ORDER BY ItemCode)AS Row_ID1,* FROM (select ROW_NUMBER()OVER(PARTITION BY ItemCode ORDER BY ItemCode)AS ID,* FROM

(SELECT *,ROW_NUMBER()OVER(partition by itemcode ORDER BY itemcode)AS Filt_Id FROM vw_allProductNew1 WHERE

IsActive=1 AND (ProductCode LIKE ''%'+ @SearchText + '%'' OR ProductName LIKE ''%'+ @SearchText + '%'')'+@FilterValue+')AS A) B WHERE B.ID=1 )



select * from( SELECT ROW_NUMBER()OVER(ORDER BY ItemCode)AS Row_ID,* FROM PagingCTE WHERE Filt_id=1) as a WHERE

Row_ID >= ('+cast(@pagesize as varchar(10))+' * '+cast(@startindex as varchar(10))+') - ('+cast(@pagesize as varchar(10))+' -1) AND

Row_ID <= ('+cast(@pagesize as varchar(10))+' *'+ cast(@startindex as varchar(10))+') ' +@OrderBy+''

END



--print @SQL

EXEC (@SQL)

END