Archive for April, 2008

Client side validation on button click using Customvalidator

Posted on April 29, 2008. Filed under: Asp.net |

<asp:Panel ID=pn runat=server  DefaultButton=imagebutton1>
               <table width=”620″ height=”60″ cellpadding=”0″ class=tablesearchborder cellspacing=”0″>
                      <tr>
                        <td align=”center” valign=”middle”  background=”images/searchnew.gif”>
                                     <table width=”620″ height=55px cellpadding=”0″ cellspacing=”0″>
         <tr>
                              <td height=”15″></td>
                              <td></td>
                              <td></td>
                              <td></td>
                              <td></td>
                              <td></td>
                            </tr>
       
                            <tr>
                              <td width=”1″></td>
                              <td width=”7″ class=”head1″> </td>
                              <td width=”36″ class=”head1″> </td>
                              <td width=”67″ class=”head1″>Search</td>
                              <td width=”382″><span class=”searchboxdata”>
                              <asp:TextBox runat=server    ID=ksearch  ValidationGroup=ks  CssClass=”txt”></asp:TextBox>
                             
                              </span></td>
                              <td width=”83″ align=left><asp:ImageButton ID=”ImageButton1″  ValidationGroup=ks Width=38 [...]

Autosuggestion, autocomplete textbox data from server(using ajax.dll)

Posted on April 23, 2008. Filed under: Asp.net |

lt;style type=”text/css”> 
.Table
{
background-color:yellow;
font-family:Verdana;
font-size:10px;
width:200px;
}
.DefaultRowColor
{background-color:gray;
}
.HighlightRow
 
{background-color:#eeeeee;
}
</style>
</
 
head><

body>
<form id=”form1″ runat=”server”>
<div><

script language=”javascript” type=”text/javascript”>var

word =”;
var
 
UP = 38; var
 
DOWN = 40; var
 
ENTER = 13;var
 
index = -1; var
 
TAB = 9; var
 
BACKSPACE = 8; var
 
table = null; var 
rows = null;var 
selectedRow = null;function 
GetProducts(e)
{var 
keynumvar
 
keycharvar
 
numcheckif
 
(window.event)// IE
{keynum = e.keyCode
}
else
 
if(e.which)// Netscape/Firefox/Opera
{keynum = e.which
}
keychar = String.fromCharCode(keynum)
numcheck = /\d/
// If the down key is pressed
if
 
(keynum == DOWN)
{MoveCursorDown();
return;
}
else
 
if(keynum == UP)
{MoveCursorUp();return;
}
else
 
if(keynum == ENTER)
{if(IsFireFox())
{document.getElementById(“txtSearch”).value = selectedRow.childNodes[1].innerHTML;
}
else
{document.getElementById(“txtSearch”).value [...]

export dataset in multiple excelsheet in asp.net

Posted on April 12, 2008. Filed under: Asp.net |

<asp:TextBox ID=”txtname” runat=”server”></asp:TextBox> 
<asp:Button ID=”Export” runat=”server” Text=”Export” OnClick=”Export_Click” />

public void DataSetToExcelSheet(DataSet source, string fileName)
 {
string strPath = Server.MapPath(“ExcelFile”); //folder get pathSystem.IO.StreamWriter excelDoc = new System.IO.StreamWriter(strPath+“/” + fileName);
const string startExcelXML = “<xml version>\r\n<Workbook “
+“xmlns=\”urn:schemas-microsoft-com:office:spreadsheet\”\r\n”
+ ” xmlns:o=\”urn:schemas-microsoft-com:office:office\”\r\n “
+ “xmlns:x=\”urn:schemas- microsoft-com:office:”
+ “excel\”\r\n xmlns:ss=\”urn:schemas-microsoft-com:”
+ “office:spreadsheet\”>\r\n <Styles>\r\n “
+ “<Style ss:ID=\”Default\” ss:Name=\”Normal\”>\r\n “
+ “<Alignment ss:Vertical=\”Bottom\”/>\r\n <Borders/>”
+ “\r\n <Font/>\r\n <Interior/>\r\n <NumberFormat/>”
+ “\r\n <Protection/>\r\n </Style>\r\n “
+ [...]

display custum text using case in sqlserver

Posted on April 11, 2008. Filed under: Sql Server |

SELECT FirstName, LastName,
       CASE WHEN sex =’M’ THEN ‘MALE’
            WHEN sex = ’F’ THEN ‘FEMALE’
            ELSE ‘Undefined’
       END As Sex
FROM Employees

find Nth highest salary of employee by procedure

Posted on April 11, 2008. Filed under: Sql Server |

Create proc GetNthmaxsalary
(
@high int
)
as
set nocount on
SELECT TOP 1 emp1.salary FROM

(

SELECT DISTINCT TOP @high salary FROM

emp

ORDER BY salary DESC) as

emp1

ORDER BY emp1.salary

go

Creating Updated google New Using Google Rss in show in datagrid

Posted on April 11, 2008. Filed under: Asp.net |

in aspx page u write
 <asp:DataList id=”myDataGrid” Width=200px runat=server>
<ItemTemplate><%#Eval(“description” %></ItemTemplate>
 </asp:DataList>
in codebehind
protected void Page_Load(object sender, EventArgs e)
{myDataGrid.DataSource = RssFeed.getrssdata().Tables[3];
myDataGrid.DataBind();
}
 
using class file———–
 public class RssFeed{
public RssFeed(){}
public static DataSet getrssdata()
{XmlTextReader reader = new XmlTextReader(“http://news.google.com/news?ned=in&output=rss”);
DataSet ds = new DataSet();
ds.ReadXml(reader);
return ds;
}
}

using Ajax.dll show data from Database at time interval

Posted on April 11, 2008. Filed under: Asp.net |

<%@ Page Language=”C#” AutoEventWireup=”true” CodeFile=”showdata.aspx.cs” Inherits=”showdata” %>
 <!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>Untitled Page</title></head>

<

body onload=”getDataSet();”>

<form id=”form1″ runat=”server”>
<div>
<script language=javascript>
function getDataSet()
{showdata.getdata(GetDataSet_callback);}
 function GetDataSet_callback(response)
{var ds = response.value;
if(ds != null && typeof(ds) == “object” && ds.Tables != null)
{var s = new Array();
s[s.length] = “<table border=1>”;
for(var i=0; i<ds.Tables[0].Rows.length; i++){
s[s.length] = “<tr>”;
s[s.length] = “<td>” + ds.Tables[0].Rows[i].companyname + “</td>”;
s[s.length] [...]

Recursively find control from previous page

Posted on April 9, 2008. Filed under: C# |

hi
i study more time asp.net starter kit and i found best code for finding previous page server control.
But from prevoius page you must use  postbackurl on button  or use  server.transfer(”go.aspx”);
The code is follow……..
public sealed class Util{ 

 
private Util(){
}
 

 
public static Control FindControlRecursively(string controlID, ControlCollection controls){
if (controlID == null || controls == null) 

 
return null; 
 
foreach (Control c in controls){
 
 
if [...]

Caching data -fast performance

Posted on April 9, 2008. Filed under: Asp.net |

public class CacheSearch
{
    protected DataSet _ds;
    protected string ksearch;
  
 public CacheSearch()
 {  
 }
   
    public static DataSet GetAlldataCIdKeyid(int cid, int kid)
    {
        return GetAlldataCityIdKeyid(HttpContext.Current, cid, kid);
    }
protected static DataSet GetAlldataCityIdKeyid(HttpContext context, int cid, int kid)
    {
        string ksearchkey = “cachkey_” + cid.ToString() + “_” + kid.ToString();
        DateTime expiration = DateTime.Now.AddMinutes(10);
        DataSet allcidkey = context.Cache[ksearchkey] as DataSet;
        if (allcidkey == [...]

Rediff Tab Code —Most Usefull

Posted on April 9, 2008. Filed under: JavaScript |

<!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>
    <title>Untitled Page</title>
   
    <style type=”text/css”>
.chatclk{cursor:pointer;cursor:hand;}
.f10 {FONT-FAMILY: arial; FONT-SIZE: 10px;}
.f11 {FONT-FAMILY: arial; FONT-SIZE: 11px;}
.f12 {FONT-FAMILY: arial; FONT-SIZE: 12px;}
.f12r {FONT-FAMILY: arial; FONT-SIZE: 12px; line-height:13px}
.f12n {FONT-FAMILY: arial; FONT-SIZE: 12px; line-height: 1.3em}
.ft11a{font-family:Tahoma;font-size:11px;line-height: 13px}
.fv9 {FONT-FAMILY: verdana; FONT-SIZE: 9px;}
.fv8 {FONT-FAMILY: verdana; FONT-SIZE: 8px;}
.fv10 {FONT-FAMILY: verdana; FONT-SIZE: 10px;}
.ft11{font-family:Tahoma;font-size:11px;line-height:14px;}
.fmicro9 {FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 9px;}
a.srchlink:link [...]