Archive for June, 2008
creating Xml data in asp.net
protected void Page_Load(object sender, EventArgs e)
{
Response.ContentType = “text/Xml”;
int vid = Convert.ToInt32(Request.QueryString["vid"]);
SqlConnection con = new SqlConnection( ConfigurationManager.
ConnectionStrings["connect"].ConnectionString);
SqlDataAdapter cmd = new SqlDataAdapter(“select vedioname,vediourl,vediodesc from vedio where vedioid=@vid”, con);
cmd.SelectCommand.Parameters.Add(“@vid”, SqlDbType.Int).Value =vid;
cmd.SelectCommand.CommandType = CommandType.Text;
DataSet ds = new DataSet();
cmd.Fill(ds, “root”);
String s = ds.GetXml();
Response.Write(s);
Response.End();
}
Get web control value through javascript
<asp:TextBox id=”txtname” runat=server ></asp:TextBox>
<script>
function getvalue()
{
var val=document.getElementById(‘<%=txtname.ClientID%>’).value;
alert(val);
}
gridview with SqlDatasource
<asp:GridView ID=”gv” Runat=”Server”
AutoGenerateColumns=”true”
BorderColor=”#000080″
BorderWidth=”2px”
HorizontalAlign=”Center”
Width=”90%” >
</asp:GridView>
codebehind file/////////
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
SqlDataSource Source= new SqlDataSource();
Source.ConnectionString = ConfigurationManager.
ConnectionStrings["ConnectionString"].ConnectionString;
Source.DataSourceMode = SqlDataSourceMode.DataReader;
Source.ProviderName = “System.Data.SqlClient”;
Source.SelectCommand = “SELECT companyname, companyaddress, companycity FROM companydetail ORDER BY companyname”;
gv.DataSource = Source;
gv.DataBind();
}
}
using gridview calculate total in footer template
<asp:GridView ID=”gv” Runat=”Server”
AllowPaging=”false”
AllowSorting=”false”
AutoGenerateColumns=”false”
BorderColor=”#000080″
BorderStyle=”Solid”
BorderWidth=”2px”
Caption=””
HorizontalAlign=”Center”
ShowFooter=”true”
Width=”90%”
OnRowDataBound=”gv_RowDataBound” >
<HeaderStyle HorizontalAlign=”Center” />
<RowStyle />
<AlternatingRowStyle />
<FooterStyle HorizontalAlign=”Right”/>
<Columns>
<asp:TemplateField HeaderText=”Name” FooterText=”Total:”>
<ItemTemplate>
<%# Eval(“name”) %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=”Salary”
ItemStyle-HorizontalAlign=”Right”>
<ItemTemplate>
<asp:Literal id=”lblsalary” runat=”server”
text=’<%# Eval(“Salry”) %>’ />
</ItemTemplate>
<FooterTemplate>
<asp:Literal id=”lbltotSalary” runat=”server” />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=”Tax”
ItemStyle-HorizontalAlign=”Right”>
<ItemTemplate>
<asp:Literal id=”lblTax” runat=”server”
text=’<%# Eval(“Tax”) %>’ />
</ItemTemplate>
<FooterTemplate>
<asp:Literal id=”lblTotTax”
runat=”server” />
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
codebehind pages
private Decimal msalaryTotal;
private Decimal mTaxTotal;
protected void Page_Load(object sender, EventArgs e)
{
SqlDataSource dSource = null;
if (!Page.IsPostBack)
{
dSource = new SqlDataSource();
dSource.ConnectionString = ConfigurationManager.
ConnectionStrings["dbConnectionString"].ConnectionString;
dSource.DataSourceMode = SqlDataSourceMode.DataReader;
dSource.ProviderName = “System.Data.SqlDb”;
dSource.SelectCommand = “SELECT [...]
Inserting in Gridview
<asp:GridView ID=”gv” runat=”server”
AutoGenerateColumns=”False”
HorizontalAlign=”Center”
Width=”90%”
ShowFooter=”True”
OnRowCommand=”gv_RowCommand” CellPadding=”4″ ForeColor=”#333333″
GridLines=”None”>
<PagerStyle BackColor=”#2461BF” ForeColor=”White” HorizontalAlign=”Center” />
<SelectedRowStyle BackColor=”#D1DDF1″ Font-Bold=”True” ForeColor=”#333333″ />
<HeaderStyle HorizontalAlign=”Center” />
<RowStyle BackColor=”#EFF3FB” />
<EditRowStyle BackColor=”#2461BF” />
<AlternatingRowStyle />
<FooterStyle BackColor=”#507CD1″ Font-Bold=”True” ForeColor=”White” />
<Columns>
<asp:TemplateField HeaderText=”companyname”
ItemStyle-HorizontalAlign=”Center”
FooterStyle-HorizontalAlign=”Center”>
<ItemTemplate>
<%#Eval(“companyname”)%>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox id=”txtcompanyname” runat=”server”
Columns=”3″ />
</FooterTemplate>
<FooterStyle HorizontalAlign=”Center”></FooterStyle>
<ItemStyle HorizontalAlign=”Center”></ItemStyle>
</asp:TemplateField>
<asp:TemplateField HeaderText=”Address”
ItemStyle-HorizontalAlign=”Left”
FooterStyle-HorizontalAlign=”Left”>
<ItemTemplate>
<%#Eval(“Companyaddress”)%>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox id=”txtCompanyaddress” runat=”server”
Columns=”40″ />
</FooterTemplate>
<FooterStyle HorizontalAlign=”Left”></FooterStyle>
<ItemStyle HorizontalAlign=”Left”></ItemStyle>
</asp:TemplateField>
<asp:TemplateField HeaderText=”CompanyCity”
ItemStyle-HorizontalAlign=”Center”
FooterStyle-HorizontalAlign=”Center”>
<ItemTemplate>
<%#Eval(“CompanyCity”)%>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox id=”txtCompanyCity” runat=”server”
Columns=”40″ />
</FooterTemplate>
<FooterStyle HorizontalAlign=”Center”></FooterStyle>
<ItemStyle HorizontalAlign=”Center”></ItemStyle>
</asp:TemplateField>
<asp:TemplateField FooterStyle-HorizontalAlign=”Center”>
<FooterTemplate>
<asp:Button ID=”btnInsert” runat=”server”
Text=”Insert”
CommandName=”Insert” />
</FooterTemplate>
<FooterStyle HorizontalAlign=”Center”></FooterStyle>
</asp:TemplateField>
</Columns>
</asp:GridView>
coding pages
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
bindData();
}
}
protected [...]
datagrid first prev next last paging
<asp:DataGrid ID=”dg” Runat=”server” BorderColor=”#CC9966″ BorderWidth=”1px” AutoGenerateColumns=”False”
Width=”90%”
HorizontalAlign=”Center”
AllowPaging=”True”
PageSize=”5″
PagerStyle-Visible=”False” BackColor=”White” BorderStyle=”None”
CellPadding=”4″>
<HeaderStyle HorizontalAlign=”Center” BackColor=”#990000″ Font-Bold=”True” ForeColor=”#FFFFCC”
/>
<FooterStyle BackColor=”#FFFFCC” ForeColor=”#330099″ />
<SelectedItemStyle BackColor=”#FFCC66″ Font-Bold=”True” ForeColor=”#663399″ />
<PagerStyle Visible=”False” BackColor=”#FFFFCC” ForeColor=”#330099″
HorizontalAlign=”Center”></PagerStyle>
<ItemStyle />
<AlternatingItemStyle/>
<Columns>
<asp:BoundColumn HeaderText=”regid”
DataField=”regid” />
<asp:BoundColumn HeaderText=”companyname”
DataField=”companyname”
ItemStyle-HorizontalAlign=”Center” >
<ItemStyle HorizontalAlign=”Center”></ItemStyle>
</asp:BoundColumn>
<asp:BoundColumn HeaderText=”address”
DataField=”address”
ItemStyle-HorizontalAlign=”Center” >
<ItemStyle HorizontalAlign=”Center”></ItemStyle>
</asp:BoundColumn>
</Columns>
</asp:DataGrid>
<br />
<table width=”20%” border=”0″ align=”center”>
<tr>
<td align=”center”>
<input id=”btnFirst” runat=”server” type=”button”
value=”First”
onserverclick=”btnFirst_ServerClick”>
</td>
<td align=”center”>
<input id=”btnPrev” runat=”server” type=”button”
value=”Prev”
onserverclick=”btnPrev_ServerClick”>
</td>
<td align=”center”>
<input id=”btnNext” runat=”server” type=”button”
value=”Next”
onserverclick=”btnNext_ServerClick”>
</td>
<td align=”center”>
<input id=”Last” runat=”server” type=”button”
value=”Last”
onserverclick=”btnLast_ServerClick”>
</td>
</tr>
</table>
codebehind pages
protected void Page_Load(object [...]
Edit,Update in datagrid
<div>
<asp:DataGrid id=”dg” runat=”server” BorderColor=”#3366CC” BorderWidth=”1px”
AutoGenerateColumns=”False” HorizontalAlign=”Center” dth=”63%”
OnCancelCommand=”dg_CancelCommand” OnEditCommand=”dg_EditCommand”
OnUpdateCommand=”dg_UpdateCommand” DataKeyField=”companyid”
BackColor=”White” BorderStyle=”None” CellPadding=”4″ Height=”170px”>
<HeaderStyle HorizontalAlign=”Center” BackColor=”#003399″ Font-Bold=”True”
ForeColor=”#CCCCFF” /> <FooterStyle BackColor=”#99CCCC” ForeColor=”#003399″ />
<SelectedItemStyle BackColor=”#009999″ Font-Bold=”True” ForeColor=”#CCFF99″ />
<PagerStyle BackColor=”#99CCCC” ForeColor=”#003399″ HorizontalAlign=”Left”
Mode=”NumericPages” /><ItemStyle BackColor=”White” ForeColor=”#003399″ />
<AlternatingItemStyle /><Columns><asp:BoundColumn DataField=”companyid”
ItemStyle-HorizontalAlign=”Center” HeaderText=”Company Id” ReadOnly=”True” >
<ItemStyle HorizontalAlign=”Center”></ItemStyle>
</asp:BoundColumn><asp:TemplateColumn HeaderText=”ComapnyName”>
<ItemTemplate><%#Eval(“CompanyName”)%></ItemTemplate><EditItemTemplate>
<asp:TextBox id=”txtcompanyname” runat=”server” Columns=”55″
text=’<%# Eval(“CompanyName”) %>’ /></EditItemTemplate>
</asp:TemplateColumn>
<asp:templatecolumn headertext=”Company Address”
itemstyle-horizontalalign=”Center”><itemtemplate>
<%# Eval(“companyAddress”) %></itemtemplate>
<edititemtemplate>
<asp:TextBox id=”txtcompanyAddress” runat=”server” Columns=”55″
text=’<%# [...]
paging and sorting in Datagrid
div><asp:DataGrid id=”dg” runat=”server” AutoGenerateColumns=”False” width=”90%”
HorizontalAlign=”Center” AllowSorting=”True”AllowPaging=”True”PageSize=”5″
PagerStyle-Mode=”NumericPages” PagerStyle-PageButtonCount=”5″
PagerStyle-Position=”Bottom” pagerStyle-HorizontalAlign=”Center”
PagerStyle-NextPageText=”Next” PagerStyle-PrevPageText=”Prev”
PagerStyle-CssClass=”pagerText” OnPageIndexChanged=”data_PageIndexChanged”
OnSortCommand=”data_SortCommand” CellPadding=”4″ ForeColor=”#333333″
GridLines=”None” >
<HeaderStyle HorizontalAlign=”Center” BackColor=”#507CD1″
Font-Bold=”True” ForeColor=”White” />
<ItemStyle BackColor=”#EFF3FB” />
<FooterStyle BackColor=”#507CD1″ Font-Bold=”True” ForeColor=”White” />
<EditItemStyle BackColor=”#2461BF” />
<SelectedItemStyle BackColor=”#D1DDF1″ Font-Bold=”True” ForeColor=”#333333″ />
<PagerStyle NextPageText=”Next” PageButtonCount=”5″ PrevPageText=”Prev”
HorizontalAlign=”Center” BackColor=”#2461BF” ForeColor=”White”></PagerStyle>
<AlternatingItemStyle /><Columns>
<asp:BoundColumn DataField=”companyname” HeaderText=”companyname”
SortExpression=”companyname” />
<asp:BoundColumn DataField=”companyaddress”
ItemStyle-HorizontalAlign=”center” SortExpression=”companyaddress”>
<ItemStyle HorizontalAlign=”Center”></ItemStyle></asp:BoundColumn>
<asp:BoundColumn DataField=”companycity”ItemStyle-HorizontalAlign=”Center”
SortExpression=”companycity” >
<ItemStyle HorizontalAlign=”Center”></ItemStyle></asp:BoundColumn>
</Columns></asp:DataGrid></div>
codebehind pages
private enum SortOrder
{soAscending = 0,
soDescending = 1
}
static readonly String SORTEXPRESSION = [...]
Read Full Post | Make a Comment ( None so far )page bookmark in javascript
var urlAddress =window.location.href;
var pageName = document.title;
function addToFavorites()
{
if (window.external)
{
window.external.AddFavorite(urlAddress,pageName)
}
else
{
alert(“Sorry! Your browser doesn’t support this function.”);
}
}
show hide layer on tab clicking
function showDiv(dvnm)
{
document.getElementById(dvnm).style.display = ‘block’;
document.getElementById(dvnm).style.visibility = ‘visible’;
}
function hideDiv(dvnm)
{
document.getElementById(dvnm).style.display = ‘none’;
document.getElementById(dvnm).style.visibility = ‘hidden’;
}
function showlayer(n)
{
for(i=1;i<=2;i++)//number of layer u want to show
{
if(i==n)
{
showDiv(‘div’+ i);//dynamically call div id
document.getElementById(‘tab’+i).style.backgroundColor=”#666666″;//dynamically show contant id
}
else
{
hideDiv(‘div’+ i);
document.getElementById(‘tab’+i).style.backgroundColor=”gray”;
}
}
}
« Previous Entries
