Monday, September 1, 2008

Arraylist collection List

aspx Page

asp:GridView ID="Gv_User" runat="server" AutoGenerateColumns="false"
onrowdatabound="Gv_User_RowDataBound"
asp:BoundField DataField="UserID" HeaderText="User ID" />
asp:BoundField DataField="UserName" HeaderText="User Name" />
asp:TemplateField>
ItemTemplate>
asp:Label ID="lblUserID" runat="server" >
/ItemTemplate>
/asp:TemplateField>
/Columns>
/asp:GridView


CS File

public partial class CollectionClass : System.Web.UI.Page
{
ArrayList arr = new ArrayList();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ArrayList arrnew= getData();
Gv_User.DataSource = arrnew;
Gv_User.DataBind();
//foreach (User A1 in arrnew)
//{
// Response.Write(A1.UserName);
// Response.Write(A1.UserID);
//}

}
}

private ArrayList getData()
{
string sSQL = "select cast(ID as int),Name from tbl_test";
string sConnString = ConfigurationManager.ConnectionStrings["octanmen"].ToString();

using (SqlConnection oCn = new SqlConnection(sConnString))
{
SqlCommand oSelCmd = new SqlCommand(sSQL, oCn);
oSelCmd.CommandType = CommandType.Text;
oCn.Open();
SqlDataReader oDr = oSelCmd.ExecuteReader();
while (oDr.Read())
{
User objUser = new User();
objUser.UserID = oDr.GetInt32(0);
objUser.UserName = oDr.GetString(1);
arr.Add(objUser);

}
oDr.Close();
oCn.Close();
// return the finished ArrayList with customer objects
return arr;


}

}

//private void Printdata(IEnumerable myList)
//{
// IEnumerator myEnumerator = myList.GetEnumerator();
// while (myEnumerator.MoveNext())
// Response.Write(myEnumerator.Current);


//}

protected void Gv_User_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblUserID = (Label)e.Row.FindControl("lblUserID");
lblUserID.Text = DataBinder.Eval(e.Row.DataItem, "UserID").ToString();
}
}
}

public class User
{
private int m_intUserID = 0;
private string m_strName;
public int UserID { get { return m_intUserID; } set { m_intUserID = value; } }
public string UserName { get { return m_strName; } set { m_strName = value; } }



}