Wednesday, 15 June 2016

Show Table Data

                    No comments    

This IS Code For Show  Table Data..
If We Want to Get Data Inserted in Any  Table And Copy then use  this Code in SQL Server

Syntax-
DECLARE @Fields VARCHAR(max); SET @Fields = '[ColumnName1], [ColumnName2], [ColumnName3]' -- your fields, keep []
DECLARE @Table  VARCHAR(max); SET @Table  = 'Table Name'   -- your Table Name
DECLARE @SQL    VARCHAR(max)
SET @SQL = 'DECLARE @S VARCHAR(MAX)
SELECT @S = ISNULL(@S + '' UNION '', ''INSERT INTO ' + @Table + '(' + @Fields + ')'') + CHAR(13) + CHAR(10) +
 ''SELECT '' + ' + REPLACE(REPLACE(REPLACE(@Fields, ',', ' + '', '' + '), '[', ''''''''' + CAST('),']',' AS VARCHAR(max))
+ ''''''''') +' FROM ' + @Table + '
PRINT @S'
EXEC (@SQL)

 Ex.-
DECLARE @Fields VARCHAR(max); SET @Fields = '[id], [Waiver], [isactive]' -- your fields, keep []
DECLARE @Table  VARCHAR(max); SET @Table  = 'plot_Waiver'               -- your table
DECLARE @SQL    VARCHAR(max)
SET @SQL = 'DECLARE @S VARCHAR(MAX)
SELECT @S = ISNULL(@S + '' UNION '', ''INSERT INTO ' + @Table + '(' + @Fields + ')'') + CHAR(13) + CHAR(10) +
 ''SELECT '' + ' + REPLACE(REPLACE(REPLACE(@Fields, ',', ' + '', '' + '), '[', ''''''''' + CAST('),']',' AS VARCHAR(max))
+ ''''''''') +' FROM ' + @Table + '
PRINT @S'
EXEC (@SQL)
OutPut-

INSERT INTO plot_Waiver([id], [Waiver], [isactive])
SELECT '1', '40.00', '1' UNION
SELECT '2', '25.00', '1' UNION
SELECT '4', '20.00', '1' UNION
SELECT '5', '45.00', '1'

Monday, 13 June 2016

Use SQL Server Functions

                    No comments    

SQL Aggregate Functions
This functions return a single value, calculated from values in a column.
Like Ex.-

AVG() - Returns the average value.
      Syntax - SELECT AVG(column_name) FROM table_name
COUNT() - Returns the number of rows.
     Syntax -  SELECT COUNT(column_name) FROM table_name
FIRST() - Returns the first value.
    Syntax - SELECT FIRST(column_name) FROM table_name
LAST() - Returns the last value.
    Syntax - SELECT LAST(column_name) FROM table_name
MAX() - Returns the largest value.
    Syntax - SELECT MAX(column_name) FROM table_name
MIN() - Returns the smallest value.
   Syntax - SELECT MIN(column_name) FROM table_name
SUM() - Returns the sum.
    Syntax - SELECT SUM(column_name) FROM table_name

SQL Scalar functions
This Functions return a single value, based on the input value.
Ex.

  UCASE() - Converts a field to upper case
        Syntax - SELECT UCASE(column_name) FROM table_name;
   LCASE() - Converts a field to lower case
        Syntax - SELECT UCASE(column_name) FROM table_name;
   MID() - Extract characters from a text field.
        Syntax - SELECT MID(column_name,start,length) AS some_name FROM table_name;
   LEN() - Returns the length of a text field
       Syntax - SELECT LEN(column_name) FROM table_name;
   ROUND() - Rounds a numeric field to the number of decimals specified
         Syntax - SELECT ROUND(column_name,decimals) FROM table_name;
   NOW() - Returns the current system date and time
        Syntax - SELECT NOW() FROM table_name;
    FORMAT() - Formats how a field is to be displayed
        Syntax - SELECT FORMAT(column_name,format) FROM table_name;

Friday, 10 June 2016

CSS 3D Transforms

                    No comments    


<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title></title>
    <style type="text/css">

     .container{

/* How pronounced should the 3D effects be */
perspective:800px;
-webkit-perspective:800px;

background: radial-gradient(#e0e0e0, #aaa);
width:350px;
height:380px;
margin:0 auto;
border-radius:6px;
position:relative;
}

.iphone-front,
.iphone-back{

/* Enable 3D transforms */
transform-style: preserve-3d;
-webkit-transform-style: preserve-3d;

/* We are using two separate divs for the front and back of the
  phone. This will hide the divs when they are flipped, so that the
  opposite side can be seen:  */

backface-visibility: hidden;
-webkit-backface-visibility: hidden;

width:200px;
height:333px;

position:absolute;
top:50%;
left:50%;
margin:-166px 0 0 -100px;

background:url(http://demo.tutorialzine.com/2013/10/css3-features-you-can-finally-use/assets/img/iphone.png) no-repeat left center;

/* Animate the transitions */
/*transition:0.8s;*/
    transition:1.5s;
}

.iphone-back{

/* The back side is flipped 180 deg by default */
transform:rotateY(180deg);
-webkit-transform:rotateY(180deg);

background-position:right center;
}

.container:hover .iphone-front{
/* When the container is hovered, flip the front side and hide it .. */
transform:rotateY(180deg);
-webkit-transform:rotateY(180deg);
}

.container:hover .iphone-back{
/* .. at the same time flip the back side into visibility */
transform:rotateY(360deg);
-webkit-transform:rotateY(360deg);
}
    </style>
</head>
<body>
   <div class="container">
<div class="iphone-front"></div>
<div class="iphone-back"></div>
     <img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDx4ENlGMpgGklms8BkkVYgSBh7vJj0JbauaFHtG9o3t_c0nK6aqy9G7X0Tl1tLMhYdf0G7_Oa8p5snYdEPOT0tFRFkAUMEcvmBl9AnX0Xwk2low6B5nkuyvOCwNphrjD-SaphfYZsezby/s1600-r/finalc%2523logoPNGupdated.png" style="height:50px; width:100px;" /> 
</div>

</body>
</html>

Wednesday, 8 June 2016

Current Date

                    No comments    

Show Current Date-

 I Want To Show Current Date Then Use-
  SELECT GETDATE()  AS CurrentDate
OutPut-
           2016-06-08 12:11:00.083
 More Format In Date Then Use-
Ex. 1:
 SELECT CONVERT(varchar(20),GETDATE(),100)  AS CurrentDate
OutPut-
           Jun  8 2016 12:13PM
 Ex.2:
 SELECT CONVERT(varchar(20),GETDATE(),101)  AS CurrentDate
OutPut
       06/08/2016
Ex.3:
 SELECT CONVERT(varchar(20),GETDATE(),102)  AS CurrentDate
OutPut
      2016.06.08
Ex.4:
 SELECT CONVERT(varchar(20),GETDATE(),103)  AS CurrentDate 
OutPut
     08/06/2016
Ex.5
 CONVERT(varchar(20),GETDATE(),104)  =  08.06.2016.
 CONVERT(varchar(20),GETDATE(),105 )=  08-06-2016
CONVERT(varchar(20),GETDATE(),106) =  08 Jun 2016
CONVERT(varchar(20),GETDATE(),107) =  Jun 08, 2016
CONVERT(varchar(20),GETDATE(),108) =  12:24:08
CONVERT(varchar(20),GETDATE(),109) =  Jun 08, 2016
CONVERT(varchar(20),GETDATE(),110) =  06-08-2016
CONVERT(varchar(20),GETDATE(),111) = 2016/06/08
CONVERT(varchar(20),GETDATE(),112) = 20160608
CONVERT(varchar(20),GETDATE(),113) = 08 Jun 2016 12:26:08

ONLY FATCH TIME IN DATE THEN USE
EX.1
 SELECT (LTRIM( RIGHT(CONVERT(varchar(20),GETDATE(),100),7))) as  CURRENTTime
 OutPut
     12:28PM

Tuesday, 7 June 2016

Ajax FilteredTextBox Extender

                    No comments    

How To Use FilterTextBoxIn Asp.net.
SOURCE OF PAGE
Firstly Add  Directory on page
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit"  TagPrefix="asp" %> 
Only Restrict For Upper case
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager> 
<asp:TextBox ID="txtUpperCase" runat="server"/>
 <asp:FilteredTextBoxExtender ID="UpperCase" runat="server" TargetControlID="txtUpperCase"        FilterType="UppercaseLetters"> </asp:FilteredTextBoxExtender>
  OutPut-
Show UpperCase Letetr In Text box.
Only Restrict For Lower case
<asp:TextBox ID="txtLowerCase" runat="server"/>
<asp:FilteredTextBoxExtender ID="LowerCase" runat="server" TargetControlID="txtLowerCase"
  FilterType="LowercaseLetters"> </asp:FilteredTextBoxExtender>
OutPut-
    Show LowerCase Letetr In Text box .

Only Restrict For Numeric Value
<asp:TextBox ID="txtNumbers" runat="server"/
<asp:FilteredTextBoxExtender ID="Numbers"  runat="server"  TargetControlID="txtNumbers"     FilterType="Numbers" </asp:FilteredTextBoxExtender>
OutPut-
 Show Numbers In Text box
 To Restrict certain or special characters
<asp:TextBox ID="TextBox1" runat="server"/>
<asp:FilteredTextBoxExtender ID="Custome" runat="server" TargetControlID="TextBox1"
   FilterMode="InvalidChars"  InvalidChars="!@#$%^&amp;*()~?><|\';:">
</asp:FilteredTextBoxExtender>
OutPut-
InvalidChar Not Enter In Text box.We Can Give Valid Character Same like As Ex.

Friday, 29 April 2016

Calender Control In Ajax

                    No comments    


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register Assembly="CalendarExtenderPlus" Namespace="AjaxControlToolkitPlus" TagPrefix="ajaxToolkit" %>

<form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server" />
 
<asp:TextBox ID="txtTimeIn" runat="server"  AutoPostBack="true"></asp:TextBox> <ajaxToolkit:CalendarExtender ID="Calendar1" ClientIDMode="AutoID" runat="server" Format="dd/MM/yyyy" TargetControlID="txtTimeIn">
                                </ajaxToolkit:CalendarExtender>                               
</form>
 
 Restrict the calendar to only allow selection of the current date only not  previous date and next Date.
 C# Code
Calendar1.StartDate = DateTime.Today;
Calendar1.EndDate = DateTime.Today;
 
If Calander in Girdview then use on Row Data Bound
 protected void Girdview1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
     if (e.Row.RowType == DataControlRowType.DataRow)
        {
            (e.Row.FindControl("Calendar1") as AjaxControlToolkit.CalendarExtender).StartDate = DateTime.Today;
            (e.Row.FindControl("Calendar1") as AjaxControlToolkit.CalendarExtender).EndDate = DateTime.Today; 
 }
}
 

Popular Posts

Powered by Blogger.

Text Widget

Sample Text

Pages