Generic Examples
Generic >> List
Connection
string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
con.Open();
return con;
DataLayer
namespace DLayer
{
public class userins
{
private string uname;
private string pwd;
public string Pwd
{
get { return pwd; }
set { pwd = value; }
}
public string Uname
{
get { return uname; }
set { uname = value; }
}
}
public class listins
{
public List<userins> get()
{
SqlConnection con = Connection.con();
SqlDataAdapter da = new SqlDataAdapter("select * from test",con);
DataTable dt = new DataTable();
da.Fill(dt);
List<userins> ui = new List<userins>();
for(int i=0;i< dt.Rows.Count;i++)
{
userins ins = new userins();
ins.Uname=dt.Rows[i]["username"].ToString();
ins.Pwd = dt.Rows[i]["password"].ToString();
ui.Add(ins);
}
return ui;
}
}
}
CodeBehind(.cs)
listins l = new listins();
List<userins> li = new List<userins>();
li = l.get();
for (int j = 0; j < li.Count; j++)
{
DropDownList1.Items.Add(li[j].Uname.ToString());
}
Generic >> Dictionary
DataLayer
namespace DLayer
{
public class userins
{
private string uname;
private string pwd;
public string Pwd
{
get { return pwd; }
set { pwd = value; }
}
public string Uname
{
get { return uname; }
set { uname = value; }
}
}
public class dictins
{
public Dictionary<string, userins> getall()
{
SqlConnection con = Connection.con();
SqlDataAdapter da = new SqlDataAdapter("select * from test", con);
DataTable dt = new DataTable();
da.Fill(dt);
Dictionary<string, userins> di = new Dictionary<string, userins>();
for (int i = 0; i < dt.Rows.Count; i++)
{
userins ui = new userins();
ui.Uname = dt.Rows[i]["username"].ToString();
ui.Pwd = dt.Rows[i]["password"].ToString();
di.Add(Convert.ToString(i), ui);
}
return di;
}
}
}
CodeBehind(.cs)
dictins di = new dictins();
Dictionary<string, userins> dis = new Dictionary<string, userins>();
dis = di.getall();
for (int j = 0; j < dis.Count; j++)
{
DropDownList1.Items.Add(dis[Convert.ToString(j)].Uname.ToString());
DropDownList2.Items.Add(dis[Convert.ToString(j)].Pwd.ToString());
}