Mike's: May 2009

code:

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
SqlConnection con;

protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection("Data Source=.;Initial Catalog=Proj_saha;Integrated Security=True ");
SqlCommand cmd = new SqlCommand("SELECT * FROM history", con);
con.Open();

//place table information into DataSet
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
rptList.DataSource = ds;
rptList.DataBind();
con.Close();
}
}

design:-

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
 
 <!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>
 <form id="form1" runat="server">
 <table>
 <tr><th style="width: 53px">username</th><th style="width: 29px">State</th></tr>
 <asp:Repeater ID="rptList" runat="server">
 <ItemTemplate>
 <tr><td><%#Eval("username") %></td><td><%#Eval("searched") %></td></tr>
 </ItemTemplate>
 </asp:Repeater>
 </table>
 <%-- <asp:Button ID="btnPrev" runat="server" Text="Previous" onclick="btnPrev_Click" />
 <asp:Button ID="btnNext" runat="server" Text="Next" onclick="btnNext_Click" />--%>
 </form>
 </body>
 </html>

Mike's

Saturday, May 30, 2009

Rahman great composes

Saturday, May 9, 2009

one year in 4 secondz

Wednesday, May 6, 2009

usage of repeater in c#