Archive for July, 2008
Insert, Update, delete, paging in formview
<asp:FormView ID=”fv” runat=”server” Height=”206px” Width=”347px” AllowPaging=true OnModeChanging=”ChangMode” OnPageIndexChanging=”pagechanged” OnItemDeleting=”Delete” OnItemInserting=”Insert” OnItemUpdating=”Update”
CellPadding=”4″ ForeColor=”#333333″ >
<FooterStyle BackColor=”#507CD1″ Font-Bold=”True” ForeColor=”White” />
<RowStyle BackColor=”#EFF3FB” />
<EditItemTemplate>
<table style=”width: 100%; height: 100%”>
<tr>
<td align=”right” style=”width: 100px”>ID:</td>
<td align=”left” style=”width: 100px”>
<asp:Label ID=”theIDLabel1″ runat=”server” Text=’<%# Eval(“companyID”) %>’></asp:Label></td>
</tr>
<tr>
<td align=”right” style=”width: 100px”>Name:</td>
<td align=”left” style=”width: 100px”>
<asp:TextBox ID=”theNameTextBox” runat=”server” Text=’<%# Bind(“companyName”) %>’>
</asp:TextBox></td>
</tr>
<tr>
<td align=”right” style=”width: 100px”>City:</td>
<td align=”left” style=”width: 100px”>
<asp:TextBox ID=”theCityTextBox” [...]
Paging in Gridview using PagerTemplate
<asp:GridView ID=”gv” Runat=”Server” DataSourceID=”SqlDataSource1″ AutoGenerateColumns=”false”
BorderColor=”#000080″
BorderWidth=”2px”
HorizontalAlign=”Center”
Width=”90%” AllowPaging=true BackColor=Gray PagerSettings-Position=TopAndBottom >
<Columns>
<asp:BoundField HeaderText=”localityID” DataField=”localityid” />
<asp:BoundField HeaderText=”localityName” DataField=”localityname” />
</Columns>
<PagerTemplate>
<asp:LinkButton CommandName=”Page” CommandArgument=”First”
ID=”LinkButton1″ runat=”server” Style=”color: white”>
« First</asp:LinkButton>
<asp:LinkButton CommandName=”Page” CommandArgument=”Prev”
ID=”LinkButton2″ runat=”server” Style=”color: white”>
< Prev</asp:LinkButton>
[Records <%= gv.PageIndex * gv.PageSize%>-<%= gv.PageIndex * gv.PageSize + gv.PageSize - 1%>]
<asp:LinkButton CommandName=”Page” CommandArgument=”Next”
ID=”LinkButton3″ runat=”server” Style=”color: white”>
Next ></asp:LinkButton>
<asp:LinkButton CommandName=”Page” CommandArgument=”Last”
ID=”LinkButton4″ runat=”server” Style=”color: white”>
Last »</asp:LinkButton>
</PagerTemplate>
</asp:GridView>
<asp:SqlDataSource ID=”SqlDataSource1″ runat=”server” SelectCommand=”SELECT * FROM [...]
fix header in repeater and datalist
<asp:DataList ID=”dl” runat=server>
<HeaderTemplate><table bgcolor=gray><tr style=”font-family:Arial;font-size:14px;font-weight:bold;background-color:Gray”><td>Localityid</td><td>Localityname</td></tr><tr><td colspan=2><div style=”overflow-y:scroll;height:250px;width:200px;”><table bgcolor=white></HeaderTemplate>
<ItemTemplate>
<tr><td width=100><%#Eval(“localityid”) %></td><td width=100><%#Eval(“localityname”) %></td></tr>
</ItemTemplate>
<FooterTemplate></table></div></td></tr></table></FooterTemplate>
</asp:DataList>
code behind code/////////
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlDataAdapter cmd = new SqlDataAdapter(“select top 100 * from locality”, con);
cmd.SelectCommand.CommandType = CommandType.Text;
DataSet ds = new DataSet();
cmd.Fill(ds);
dl.DataSource = ds;
dl.DataBind();
}
register hidden field and its value in code file
ClientScript.RegisterHiddenField(
“hd”,pageState.ToString());
where hd is hidden field name and pagestate in numeric variable which contian value
Edit,Update,delete in gridview using Xml file
<asp:GridView ID=”gv” runat=”server” OnRowEditing=”Editdata”
OnPageIndexChanging=”pageddata” OnRowDeleting=”Deletedata”
OnRowUpdating=”Updatedata” OnRowCancelingEdit=”Canceldata” AllowPaging=”True”
AutoGenerateColumns=False PageSize=”3″ CellPadding=”4″ ForeColor=”#333333″
GridLines=”None”>
<FooterStyle BackColor=”#507CD1″ Font-Bold=”True” ForeColor=”White” />
<RowStyle BackColor=”#EFF3FB” />
<Columns>
<asp:TemplateField HeaderText=”empId” >
<ItemTemplate>
<asp:Label ID=”lblid” runat=server Text=’<%#Eval(“empid”) %>’></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID=”txtid” runat =server Text=’<%#Eval(“empid”) %>’></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=”empname” >
<ItemTemplate>
<asp:Label ID=”lblname” runat=server Text=’<%#Eval(“empname”) %>’></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID=”txtname” runat =server Text=’<%#Eval(“empname”) %>’></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=”empcity” >
<ItemTemplate>
<asp:Label ID=”lblcity” runat=server Text=’<%#Eval(“empcity”) %>’></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID=”txtcity” runat =server Text=’<%#Eval(“empcity”) %>’></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=”empsalary” >
<ItemTemplate>
<asp:Label ID=”lblsalary” [...]
Set dropdownlist value from querystring in javascript
<script language=javascript>
function SetSetectedVelue()
{
var id=’<%=Request.QueryString["cityid"] %>’;
if(id.length==0)
id=1;
var city=document.getElementById(‘<%=ddlcity.ClientID%>’);
for(var i=0;i<city.length;i++)
{
if(city.options[i].value==id)
city.selectedIndex=i;
}
}
</script>
<body onload=”SetSetectedVelue()”>
<form id=”form1″ runat=”server”>
<div>
<asp:DropDownList id=”ddlcity” runat=server >
<asp:ListItem value=”1″ >delhi</asp:ListItem>
<asp:ListItem value=”2″>mumbai</asp:ListItem>
<asp:ListItem value=”3″>channai</asp:ListItem>
<asp:ListItem value=”4″>kolkota</asp:ListItem>
</asp:DropDownList>
</div>
</form>
</body>
Display Rss data througth Javascript
function GetXmlHttpObject()
{
/*extern ActiveXObject, XMLHttpRequest */
var xmlHttp=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}
catch (e)
{
// Internet Explorer
try
{
xmlHttp=new ActiveXObject(“Msxml2.XMLHTTP”);
}
catch (e)
{
xmlHttp=new ActiveXObject(“Microsoft.XMLHTTP”);
}
}
return xmlHttp;
}
function displayRSS(url)
{var xmlhttp=GetXmlHttpObject();
if(xmlHttp==null)
{return;}
xmlHttp.open(“GET”,url,true);
xmlHttp.onreadystatechange=getRssFormat;
xmlHttp.send(null);
}
function getRssFormat()
{if(xmlHttp.readyState==4)
{if(xmlHttp.status != 200)
{
document.getElementById(“rss”).innerHTML= “<br><br><br>Sorry….<br><br><br><br>The Server did not return any results (Result code: 200)<br><br><br><br>Please try again<br><br>Sorry for the Inconvenience”;
}
else{
var items_count=3;
link=new Array(), title=new Array(), pubDate=new Array()
for(var i=0; i<items_count; i++) {
if(items.getElementsByTagName(‘item’)[i].getElementsByTagName(‘link’).length==1)
link[i]=items.getElementsByTagName(‘item’)[i].getElementsByTagName(‘link’)[0];
if(items.getElementsByTagName(‘item’)[i].getElementsByTagName(‘title’).length==1)
title[i]=items.getElementsByTagName(‘item’)[i].getElementsByTagName(‘title’)[0];
if(items.getElementsByTagName(‘item’)[i].getElementsByTagName(‘pubDate’).length==1)
pubDate[i]=getDateFormat(items.getElementsByTagName(‘item’)[i].getElementsByTagName(‘pubDate’)
[0].firstChild.nodeValue);
}
if(title.length==0)
return false;
var ws=/\S/;
ul = document.createElement(“ul”);
var mydiv = document.getElementById(“rss”);
mydiv.appendChild(ul);
for(var [...]
