private void init()
{
lblCountry.Text = "United States";
dbUtil = new ClsDBUtil();
string cmdText = "SELECT Abbreviation, State FROM C_US";
List<ClsLinkItem> states = dbUtil.getLinkItemList(cmdText);
dlStates.Items.Clear();
for (int i = 0; i < states.Count; ++i) {
dlStates.Items.Add(new ListItem(states[i].Name, states[i].ID.Trim()));
}
clStates.Items.Clear();
for (int i = 0; i < states.Count; ++i)
{
clStates.Items.Add(new ListItem(states[i].Name, states[i].ID.Trim()));
}
txtStates.Items.Clear();
for (int i = 0; i < states.Count; ++i)
{
txtStates.Items.Add(new ListItem(states[i].Name, states[i].ID.Trim()));
}
}
private void init()
{
connStr = ClsConfig.connStr();
dbUtil = new ClsDBUtil();
using (SqlConnection conn = new SqlConnection(connStr))
{
try
{
conn.Open();
lblContent.Text = getCountriesAsList(conn);
}
catch (Exception ex)
{
Response.Write("error: " + ex.Message);
}
}
}
/// <summary>
/// Return form fields in order of SeqNo.
/// </summary>
/// <param name="FormName"></param>
/// <returns></returns>
public ClsProfileEntry[] getFormSetting(string FormName)
{
string cmdText = "SELECT * FROM T_FormSetting WHERE FormName = " + ClsDB.sqlEncode(FormName) + " ORDER BY SeqNo ASC";
DataTable dt = new ClsDBUtil().getQueryAsDataTable(cmdText);
List<ClsProfileEntry> setting = new List<ClsProfileEntry>();
for (int i = 0; i < dt.Rows.Count; ++i) {
DataRow dr = dt.Rows[i];
setting.Add(
new ClsProfileEntry(
ClsUtil.ObjToStr(dr["FieldName"]),
ClsUtil.ObjToStr(dr["FieldLabel"]),
ClsUtil.ObjToBool(dr["ShowInUI"]),
ClsUtil.ObjToBool(dr["IsRequired"]),
ClsUtil.ObjToBool(dr["IsDisabled"]),
ClsUtil.ObjToStr(dr["FieldValue"]))
);
}
return setting.ToArray();
}
