Asp.net
Posted on July 8, 2008. Filed under: Asp.net |
<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” [...]
Read Full Post |
Make a Comment ( None so far )
Posted on July 7, 2008. Filed under: Asp.net |
<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 [...]
Read Full Post |
Make a Comment ( 1 so far )
Posted on July 7, 2008. Filed under: Asp.net |
<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["rubruConnectionString"].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();
}
Read Full Post |
Make a Comment ( None so far )
Posted on July 4, 2008. Filed under: Asp.net |
ClientScript.RegisterHiddenField(
“hd”,pageState.ToString());
where hd is hidden field name and pagestate in numeric variable which contian value
Read Full Post |
Make a Comment ( None so far )
Posted on June 28, 2008. Filed under: 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();
}
Read Full Post |
Make a Comment ( None so far )
Posted on June 28, 2008. Filed under: Asp.net |
<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["rubruConnectionString"].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();
}
}
Read Full Post |
Make a Comment ( None so far )
Posted on June 27, 2008. Filed under: Asp.net |
<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 [...]
Read Full Post |
Make a Comment ( None so far )
Posted on June 27, 2008. Filed under: Asp.net |
<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 [...]
Read Full Post |
Make a Comment ( None so far )
Posted on June 27, 2008. Filed under: Asp.net |
<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 [...]
Read Full Post |
Make a Comment ( None so far )
« Previous Entries
