Bind list from datatable
List<dc_chamber> chamberusedlist = new List<dc_chamber>();
bc_chamber chusedpro = new bc_chamber();
chamberusedlist = chusedpro.getChamberList();
cmb_ChamUsed_semana.DataSource = chamberusedlist;
cmb_ChamUsed_semana.DisplayMember = "chname";
cmb_ChamUsed_semana.ValueMember = "chamberid";
cmb_ChamUsed_semana.SelectedIndex = -1;
cmb_ChamUsed_semana.Text = "--Select--";
---------------------------------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace casadal
{
public class dc_chamber
{
int chamberid = 0;// `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
public int Chamberid
{
get { return chamberid; }
set { chamberid = value; }
}
string chname = string.Empty;//`chname` varchar(100) DEFAULT NULL,
public string Chname
{
get { return chname; }
set { chname = value; }
}
int archive = 0;//`archive` int(11) DEFAULT '0',
public int Archive
{
get { return archive; }
set { archive = value; }
}
int isdeleted = 0;//`isdeleted` int(11) DEFAULT '0',
public int Isdeleted
{
get { return isdeleted; }
set { isdeleted = value; }
}
}
}
--------------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using casadal;
namespace casabal
{
public class bc_chamber
{
string query = string.Empty;
dbprocess dpro = new dbprocess();
public List<dc_chamber> getChamberList()
{
query = "select * from ss_tblchamber where isdeleted=0 and archive=0";
return getListof(dpro.dtexe(query));
}
public void delete_champ(int id)
{
query = "delete from ss_tblchamber where id=" + id;
dpro.vdexe(query);
}
public int insert_champ(string chamname)
{
dc_chamber c = new dc_chamber();
c.Chname = chamname;
string query = "insert into ss_tblchamber(chname) values('" + chamname + "') ; select @@identity;";
return dpro.intscalar(query);
}
internal List<dc_chamber> getListof(DataTable result)
{
List<dc_chamber> listof = new List<dc_chamber>();
for (int i = 0; i < result.Rows.Count; i++)
{
DataRow dr = result.Rows[i];
listof.Add(getoneof(result.Rows[i]));
}
return listof;
}
internal dc_chamber getoneof(DataRow dr)
{
dc_chamber oneof = new dc_chamber();
oneof.Archive = utility.toint(dr["archive"]);
oneof.Chamberid = utility.toint(dr["id"]);
oneof.Chname = utility.tostring(dr["chname"]);
oneof.Isdeleted = utility.toint(dr["isdeleted"]);
return oneof;
}
}
}