Wednesday, 11 July 2012

how to open a page using ifram and jqury popup

Code:

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

<!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 runat="server">
    <title></title>
    <script language="javascript" type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
     <script language="javascript" type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.js"></script>
    <style type="text/css">
    #popupBoxClose
 {
    font-size:10px;
    line-height:15px;
    right:5px;
    top:5px;
    position:absolute;
    color:#6fa5e2;
    font-weight:500;    
}
#popup_box {
    display:none;
    position:fixed;
    _position:absolute;
    height:auto;
    width:auto;
    background:#FFFFFF;
    left: 300px;
    top: 150px;
    z-index:100;
    margin-left: 15px;
    border:2px solid #999999;    
    padding:15px;
    font-size:15px;
    -moz-box-shadow: 0 0 5px #ff0000;
    -webkit-box-shadow: 0 0 5px #ff0000;
 
}

    </style>
     <script type="text/javascript">
         function x(s) {
             $('#<%=im.ClientID %>').attr('src', s);
             $('#popup_box').slideDown("slow");
          }
         $(document).ready(function () {
           
             $('#popup_box').click
             (
             function () {
                 $('#popup_box').slideUp("slow");
             }
             )
             Sys.WebForms.PageRequestManager.getInstance().add_endRequest(JqueryAction);
             JqueryAction();
         });
         function ShowPopUp() {
         
             $('#popup_box').slideDown("slow");
         }
         function JqueryAction() {
           
             $('#popupBoxClose').click(function () {
                 $('#popup_box').slideUp("slow");
             });
         }
      
</script>
</head>
<body>
    <form id="form1" runat="server">
  
<a href="#"  onclick="x('Default.aspx')" id="ab" >Press Me</a>
<div id="popup_box">
<a id="popupBoxClose" href="#">Close</a><br />
     <iframe runat="server" id="im" style="height:300px; width:600px"></iframe>
</div>


   
    </form>
</body>
</html>

Tuesday, 10 July 2012

dynamic store procedure call

ALTER PROCEDURE ams.Uselection
    (
    @TableName varchar(50),
    @Value varchar(50),
    @Text varchar(50)
    )
   
AS
declare @sql varchar(max)
BEGIN
 SET NOCOUNT ON
 set @sql=('select '+ @Value +','+ @Text +' from '+ 'ams.'+@TableName)
exec(@sql)
 set  NOCOUNT ON
END

Friday, 6 July 2012

Numaric validation in javascript

function validate(s)
         {
             var x = s.keyCode;
             var phn = document.getElementById('<%=TxtOFFZipCode.ClientID %>');
             var j = "0123456789"
             for (var i = 0; i < phn.value.length; i++) {
                
                 if (j.search(phn.value.charAt(i)) == -1) {
                     alert('Zip code  should be Numeric ');
                     phn.value = "";
                     return false;
                 }
             }

how to open a new window in javascript for ever browser

 mywindow = window.open("Default.aspx", "mywindow", "location=1,status=1,scrollbars=1, width=580,height=600,screenX=300,screenY=300");
                        mywindow.moveTo(100, 20);

how to say of text in asp.net

First add a DLL in this way


Code:
 using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using SpeechLib;

public partial class Default3 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
      
    }
    protected void btn_Click(object sender, EventArgs e)
    {
        SpVoiceClass sp = new SpVoiceClass();
        sp.Speak("jay jagannath", SpeechVoiceSpeakFlags.SVSFDefault);
    }
}

Wednesday, 27 June 2012

how to open user control in asp.net

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    UserControl uc = new UserControl();
    UserControl uc1 = new UserControl();
    protected void Page_Load(object sender, EventArgs e)
    {
       
        uc=(UserControl)LoadControl("WebUserControl.ascx");
        uc1 = (UserControl)LoadControl("WebUserControl2.ascx");
    }
    protected void lb_Click(object sender, EventArgs e)
    {
        pn.Controls.Add(uc);
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        pn.Controls.Add(uc1);
    }
}

insert,update and delete in webmatrix

 Page looks like:
 
@{
    var cn=Database.Open("l");
    var m="";
    var nn="";
    var o="";
    if(Request["id"]!=null)
    {
       nn =Request["id"];
       o=Request["name"];
    }
    if(Request["id1"]!=null)
    {
        var qq="delete from emp where eid=@0";
        var q=cn.Execute(qq,Request["id1"]);
    }
   
    if(IsPost)
    {
        if(!Request["c"].IsEmpty())
        {
             var p="insert into emp values(@0,@1)";
        var q=cn.Execute(p,Request["a"],Request["b"]);
        m="One record saved.";
        }
       else if(!Request["cc"].IsEmpty())
       {
           var qq="update emp set name=@0 where eid=@1";
        var q=cn.Execute(qq,Request["b"],Request["a"]);
        m="One record updated.";
       }
 
        
    }
    var d=cn.Query("select * from emp");
}
 
<!DOCTYPE html>
 
<html lang="en">
    <head>
        <meta charset="utf-8" />
        <title>My Site's Title</title>
    </head>
    <body>
        <form method="post">
        <table align="center">
            <tr><td>&nbsp;</td><th>@m</th></tr>
            <tr><td>EID</td><td><input type="text" name="a" value="@nn" ></td></tr>
            <tr><td>NAME</td><td><input type="text" name="b" value="@o" ></td></tr>
            <tr><td>&nbsp;</td><td><input type="submit" name="c" value="Save">&nbsp;<input type="submit" value="update" name="cc"></td></tr>
            <tr><td>&nbsp;</td><td>
            <table border="1">
                <tr><th>UPDATE</th><th>DELETE</th><th>EID</th><th>NAME</th></tr>
                @{
                    foreach(var n in d)
                    { 
<tr><td><a href="Default.cshtml?id=@n.EID&name=@n.NAME">Edit</a></td><td><a href="Default.cshtml?id1=@n.EID">Delete</a></td><td>@n.EID</td><td>@n.NAME</td></tr> 
                    }
                    
                 }
            </table>
            </td></tr>
        </table>
        </form>
    </body>
</html>