Programming With Sangani

Here we create the Paging in SQL Server  Query here Fetch Only that Record which is Required Query: Select  S.*,SM.Name as shape,CM.Name as Color,PM.Name as Purity,POM.Name As Polish,CUM.Name as Cut,SYM.Name As Symm,Fm.Name as FLS from stock as S Inner join SHAPE_MAS As SM  on SM.SEQ_NO=S.shape_seq inner join COLOR_MAS As CM on CM.SEQ_NO=S.color_seq inner join PURITY_MAS As PM on PM.SEQ_NO=S.PURITY_SEQ inner join POLISH_MAS AS POM on POM.SEQ_NO=S.polish_seq inner join CUT_MAS As CUM on CUM.SEQ_NO=S.cut_seq inner join FLS_MAS As FM on FM.SEQ_NO=S.FLS_Seq inner join SYMM_MAS as SYM on SYM.SEQ_NO=S.SYMM_SEQ    order by S.SEQ_NO Asc OFFSET 25 * (2 - 1) ROWS   FETCH NEXT 25 ROWS ONLY Note:  Here  25 is Page Size You have set Default you Want and 2 is page no it is change every page which record  Example: OFFSET 50 * (3 - 1) ROWS   FETCH NEXT 50 ROWS ONLY Here we set Page Size 50 and page no is 3 This Is useful when we use  the html table use as Grid view and we have easily

            To connect Ms SQL Server  In PhP Note: This is working in the Go-daddy  windows server No setting Required       if  use in the local they are some setting required in Php.ini and add  mssql.dll in  xamp or wamp server. Connect.Php <?php $server = Server Name/IP; $options = array( "UID" => "Username",  "PWD" => "Password",  "Database" => "DbName"); $conn = sqlsrv_connect($server, $options); ?> Note: Can't Close The Connection At Last.                   To Execute the Store Procedure In Php Web services Web_services.php <?php include("connect.php");     // Connection File Include Here     header('Content-Type:application/json;charset=utf8');   header('Access-Control-Allow-Origin: *');   header('Access-Control-Allow-Methods:GET,PUT,POST,DELETE,OPTIONS');   head

counter.ascx < table class ="gridview">         < tr >             < th colspan ="3">                 Internal Customer Count             </ th >             < th colspan ="3">                 External Customer Count             </ th >             < th colspan ="3">                 Total Customer Count             </ th >         </ tr >         < tr >             < td >                 This Year             </ td >             < td >                 This Month             </ td >             < td >                 This Day              </ td >             < td >                 This Year             </ td >             < td >                 This Month             </ td >             < td >                 This Day             </ td >    

Here is Html   < form id ="form1" runat ="server">     < asp : ToolkitScriptManager ID ="ToolkitScriptManager1" runat ="server">     </ asp : ToolkitScriptManager >     < div >         < table style =" width : 100%;">             < tr >                 < td colspan ="3" class ="style2">                     < h1 align ="center">                         Cascading Dropdown List Style                     </ h1 >                 </ td >             </ tr >             < tr >                 < td class ="style1">                     Selecte Country &nbsp; :-                 </ td >                 < td >                     < asp : DropDownList ID ="DropDownList1" runat ="server">                     </ asp : DropDownList >