private void FillCompanyEntity()
{
string strSql = "";
strSql = "SELECT COMPANY_ID as ID,replace(convert(char(23),ltrim(COMPANY_NAME ))+ COMPANY_ID,' ',' ' ) as NAME FROM ENT_COMPANY where COMPANY_ISDELETED='0'";
SqlConnection con = new SqlConnection(m_connections);
con.Open();
SqlCommand cmd = new SqlCommand(strSql, con);
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
DataSet thisDataSet = new DataSet();
adpt.Fill(thisDataSet);
LstCompany.DataValueField = "ID";
LstCompany.DataTextField = "NAME";
LstCompany.DataSource = thisDataSet.Tables[0];
LstCompany.DataBind();
}
private void FillCompanyEntity()
{
try
{
string strSql = "";
//strSql = "SELECT COMPANY_ID as ID,replace(convert(char(23),ltrim(COMPANY_NAME ))+ COMPANY_ID,' ',' ' ) as NAME FROM ENT_COMPANY where COMPANY_ISDELETED='0'";
strSql = "select zone_id,ZONE_DESCRIPTION from zone where ZONE_ISDELETED=0";
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(strSql, conn);
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
DataSet thisDataSet = new DataSet();
adpt.Fill(thisDataSet);
LstCompany.DataValueField = "zone_id";
LstCompany.DataTextField = "ZONE_DESCRIPTION";
LstCompany.DataSource = thisDataSet.Tables[0];
LstCompany.DataBind();
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
catch (Exception ex)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "EmployeeManagerHierarchyAdd");
}
}
