Monday, 13 February 2017

Design

           No comments   

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>

<STYLE>
.main-menu
{
    background:#000;
    margin:0;
    padding:0;
    list-style:none;
    width:100%;
    position:relative;
}

.main-menu li
{
    display:inline-block;
    padding:5px;
}

.main-menu li a
{
    color:#fff;
    text-decoration:none;
}

.sub-menu-box
{
    position:absolute;
    top:100%;
    left:0;
    width:800px;
    min-height:400px;
    background:#fff;
    border:1px solid #999;
    display: none;
    padding:20px;
   
}

.left-image-container
{
    float:left;
    max-width:30%;
    width:100%;
    border:1px solid #333;
}


.right-menu-container
{
    float:left;
    max-width:35%;
    margin-left:5%;
}

.heading-featured
{
    text-transform:uppercase;
    font-size:18px;
    border-bottom:1px dotted;
}
   

</style>

<script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>

<script>

$(document).ready(function()
{
   
       
        $('.main-menu  li').mouseenter(function() {
    $(this).children('.sub-menu-box').stop().slideDown('slow')
}).mouseleave(function() {
    $(this).children('.sub-menu-box').stop().hide()
});
       
   
   
    });


</script>

</head>

<body>

<ul class="main-menu">

<li><a href="#">HOME</a>
<div class="sub-menu-box">

<h1>1</h1>

<div class="left-image-container">
<p class="heading-featured">This is demo</p>
<img src="2-Pack-and-Everyday.jpg" />
</div>

<div class="right-menu-container"></div>


<div style="clear:both;"></div>

</div>


</li>
<li><a href="#">ABOUT US</a>
<div class="sub-menu-box">
<h1>2</h1>


</div>
</li>
<li><a href="#">PRODUCT1</a>

<div class="sub-menu-box">
<h1>3</h1>


</div>
</li>
<li><a href="#">PRODUCT2</a>

<div class="sub-menu-box">
<h1>4</h1>


</div></li>
<li><a href="#">PRODUCT3</a>

<div class="sub-menu-box">
<h1>5</h1>


</div></li>
<li><a href="#">PRODUCT4</a>

<div class="sub-menu-box">
<h1>6</h1>


</div></li>
<li><a href="#">PRODUCT5</a>

<div class="sub-menu-box">
<h1>7</h1>


</div></li>
</ul>


</body>
</html>

Thursday, 15 September 2016

           No comments   

    SqlCommand cmd;
    static string connString =     System.Web.Configuration.WebConfigurationManager.ConnectionStrings["conn"].ConnectionString;
    DbCommand dbcommand;
    SqlDatabase db = new SqlDatabase(connString);
    public static SqlConnection scon = new SqlConnection(connString);





 #region Connection function
    public void CreateConnection()
    {
        if (scon.State != ConnectionState.Open)
        {
            scon.Open();
        }
    }
    public void CloseConnection()
    {
        scon.Close();
    }
    #endregion





 #region Common Function
    public DataSet GetDataSet(string SQL)
    {
        DataSet dsInv = new DataSet();
        dbcommand = db.GetSqlStringCommand(SQL);
        dsInv = db.ExecuteDataSet(dbcommand);

        return dsInv;
    }
    public DataTable GetDataTable(string SQL)
    {
        DataTable dtInv = new DataTable();
        dbcommand = db.GetSqlStringCommand(SQL);
        ds = db.ExecuteDataSet(dbcommand);
        if (ds.Tables.Count > 0)
        {
            dtInv = ds.Tables[0];
        }
        return dtInv;
    }




 public int ExecuteQuery(string qur)
    {
        int Retval = 0;
        dbcommand = db.GetSqlStringCommand(qur);
        Retval = db.ExecuteNonQuery(dbcommand);
        return Retval;
    }
    public int ExecuteScalar(string qur)
    {
        int Retval = 0;
        dbcommand = db.GetSqlStringCommand(qur);
        Retval = Convert.ToInt32(db.ExecuteScalar(dbcommand));
        return Retval;
    }
    public int ExecuteIntScalar(string qur)
    {
        int Retval = 0;
        dbcommand = db.GetSqlStringCommand(qur);
        Retval = Convert.ToInt32(db.ExecuteScalar(dbcommand));
        return Retval;
    }
    public string ExecuteStringScalar(string qur)
    {
        string Retval = string.Empty;
        dbcommand = db.GetSqlStringCommand(qur);
        Retval = Convert.ToString(db.ExecuteScalar(dbcommand));
        return Retval;
    }



 <add name="conn" connectionString="Data Source=; Initial Catalog=;User ID=;Password=;MultipleActiveResultSets=True;Connect TimeOut=100000;Pooling=true;Max Pool Size=250;Min Pool Size=100;"/>

Wednesday, 14 September 2016

Data table Class Table Shorting

           No comments   

 protected void GridView1_PreRender(object sender, EventArgs e)
    {
        dtInv = objDataAccess.GetDataTable("select * from tbl_fin_Customerregistration");
        GridView1.DataSource = dtInv;  //GetData is your method that you will use to obtain the data you're populating the GridView with

        GridView1.DataBind();

        if (GridView1.Rows.Count > 0)
        {
            //Replace the <td> with <th> and adds the scope attribute
            GridView1.UseAccessibleHeader = true;

            //Adds the <thead> and <tbody> elements required for DataTables to work
            GridView1.HeaderRow.TableSection = TableRowSection.TableHeader;

            //Adds the <tfoot> element required for DataTables to work
            GridView1.FooterRow.TableSection = TableRowSection.TableFooter;
        }

    }


                        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="true" width="100%" CssClass="table table-striped table-bordered table-hover gvv" OnPreRender="GridView1_PreRender" >
                        </asp:GridView>





 <script language="javascript" type="text/jscript">
        $(document).ready(function () {
            $('#dataTables-example').DataTable({
                responsive: true,
                "lengthMenu": [[10, 25, 50, 100, 500, 1000, 1000000], [10, 25, 50, 100, 500, 1000, "All"]]
            });
        });
        $(document).ready(function () {
            $('.gvv').DataTable({
                responsive: true,
            "lengthMenu": [[10, 25, 50, 100, 500, 1000, 1000000], [10, 25, 50, 100, 500, 1000, "All"]]
            });
        });
    </script>

Monday, 5 September 2016

List Spand

           No comments   

<script>    
 $(function () {
          var pgurl = window.location.href.substr(window.location.href.lastIndexOf("/") + 1);

          $("ul li a").each(function () {

              if ($(this).attr("href") == pgurl) {
                  //alert(pgurl);

                  $(this).parent().addClass("active");
                  //$(this).parent().find('li').addClass("active");
                  // $(this).addClass("active");
                  $(this).parent().parent().parent().addClass("active");
                  $(this).parent().parent().parent().parent().parent().addClass("active");
                  //alert($(this).parent().parent().parent().find('li').addClass("active");
              }
          })
      });

  
   </script>

Wednesday, 17 August 2016

Friday, 17 June 2016

How we get table structure from database

                No comments   

CREATE procedure dbo.Gettable   
@tablename nvarchar(100) 
as   
    DECLARE  
           @object_name SYSNAME  ,    
          @object_id INT     
        , @SQL NVARCHAR(MAX)     
         
    SELECT     
          @object_name = '[' + OBJECT_SCHEMA_NAME(o.[object_id]) + '].[' + OBJECT_NAME([object_id]) + ']'     
        , @object_id = [object_id]     
    FROM (SELECT [object_id] = OBJECT_ID(@tablename, 'U')) o     
         
    SELECT @SQL = 'CREATE TABLE ' + @object_name + CHAR(13) + '(' + CHAR(13) + STUFF((     
        SELECT CHAR(13) + '    , [' + c.name + '] ' +      
            CASE WHEN c.is_computed = 1     
                THEN 'AS ' + OBJECT_DEFINITION(c.[object_id], c.column_id)     
                ELSE      
                    CASE WHEN c.system_type_id != c.user_type_id      
                        THEN '[' + SCHEMA_NAME(tp.[schema_id]) + '].[' + tp.name + ']'      
                        ELSE '[' + UPPER(tp.name) + ']'      
                    END  +      
                    CASE      
                        WHEN tp.name IN ('varchar', 'char', 'varbinary', 'binary')     
                            THEN '(' + CASE WHEN c.max_length = -1      
                                            THEN 'MAX'      
                                            ELSE CAST(c.max_length AS VARCHAR(5))      
                                        END + ')'     
                        WHEN tp.name IN ('nvarchar', 'nchar')     
                            THEN '(' + CASE WHEN c.max_length = -1      
                                            THEN 'MAX'      
                                            ELSE CAST(c.max_length / 2 AS VARCHAR(5))      
                                        END + ')'     
                        WHEN tp.name IN ('datetime2', 'time2', 'datetimeoffset')      
                            THEN '(' + CAST(c.scale AS VARCHAR(5)) + ')'     
                        WHEN tp.name = 'decimal'     
                            THEN '(' + CAST(c.[precision] AS VARCHAR(5)) + ',' + CAST(c.scale AS VARCHAR(5)) + ')'     
                        ELSE ''     
                    END +     
                    CASE WHEN c.collation_name IS NOT NULL AND c.system_type_id = c.user_type_id      
                        THEN ' COLLATE ' + c.collation_name     
                        ELSE ''     
                    END +     
                    CASE WHEN c.is_nullable = 1      
                        THEN ' NULL'     
                        ELSE ' NOT NULL'     
                    END +     
                    CASE WHEN c.default_object_id != 0      
                        THEN ' CONSTRAINT [' + OBJECT_NAME(c.default_object_id) + ']' +      
                             ' DEFAULT ' + OBJECT_DEFINITION(c.default_object_id)     
                        ELSE ''     
                    END +      
                    CASE WHEN cc.[object_id] IS NOT NULL      
                        THEN ' CONSTRAINT [' + cc.name + '] CHECK ' + cc.[definition]     
                        ELSE ''     
                    END +     
                    CASE WHEN c.is_identity = 1      
                        THEN ' IDENTITY(' + CAST(IDENTITYPROPERTY(c.[object_id], 'SeedValue') AS VARCHAR(5)) + ',' +      
                                        CAST(IDENTITYPROPERTY(c.[object_id], 'IncrementValue') AS VARCHAR(5)) + ')'      
                        ELSE ''      
                    END      
            END     
        FROM sys.columns c WITH(NOLOCK)     
        JOIN sys.types tp WITH(NOLOCK) ON c.user_type_id = tp.user_type_id     
        LEFT JOIN sys.check_constraints cc WITH(NOLOCK)      
             ON c.[object_id] = cc.parent_object_id      
            AND cc.parent_column_id = c.column_id     
        WHERE c.[object_id] = @object_id     
        ORDER BY c.column_id     
        FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 7, '      ') +      
        ISNULL((SELECT '     
        , CONSTRAINT [' + i.name + '] PRIMARY KEY ' +      
        CASE WHEN i.index_id = 1      
            THEN 'CLUSTERED'      
            ELSE 'NONCLUSTERED'      
        END +' (' + (     
        SELECT STUFF(CAST((     
            SELECT ', [' + COL_NAME(ic.[object_id], ic.column_id) + ']' +     
                    CASE WHEN ic.is_descending_key = 1     
                        THEN ' DESC'     
                        ELSE ''     
                    END     
            FROM sys.index_columns ic WITH(NOLOCK)     
            WHERE i.[object_id] = ic.[object_id]     
                AND i.index_id = ic.index_id     
            FOR XML PATH(N''), TYPE) AS NVARCHAR(MAX)), 1, 2, '')) + ')'     
        FROM sys.indexes i WITH(NOLOCK)     
        WHERE i.[object_id] = @object_id     
            AND i.is_primary_key = 1), '') + CHAR(13) + ');'     
         
    PRINT @SQL

Popular Posts

  • (no title)
        SqlCommand cmd;     static string connString =     System.Web.Configuration.WebConfigurationManager.ConnectionStrings["conn"]...
  • List Spand
    <script>      $(function () {           var pgurl = window.location.href.substr(window.location.href.lastIndexOf("/") + 1);...
  • Data table Class Table Shorting
     protected void GridView1_PreRender(object sender, EventArgs e)     {         dtInv = objDataAccess.GetDataTable("select * from tbl_fi...
  • Design
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd...
  • How we get table structure from database
    CREATE procedure dbo.Gettable    @tablename nvarchar(100)  as        DECLARE              @object_name SYSNAME  ,               @object_id ...
  • Dashboard
    https://startbootstrap.com/template-overviews/sb-admin-2/
  • hii
    hiii

Recent Posts

Categories

Pages

Powered by Blogger.

Sample Text