public static string GetConnectionTypes()
{
FunctionTemplates.HTMLTemplates ft = new FunctionTemplates.HTMLTemplates();
string sErr = "";
DataTable dt = new DataTable();
dt = ft.getConnectionTypes(ref sErr);
if (!string.IsNullOrEmpty(sErr))
{
throw new Exception("Connection Type lookup error: " + sErr);
}
else
{
string sHTML = "<select name=\"ddlConnectionType\" style=\"width: 200px;\" id=\"ddlConnectionType\">";
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
sHTML += "<option value=\"" + dr["connection_type"].ToString() + "\">" + dr["connection_type"].ToString() + "</option>";
}
}
sHTML += "</select>";
return(sHTML);
}
}
public static string GetConnectionTypes()
{
FunctionTemplates.HTMLTemplates ft = new FunctionTemplates.HTMLTemplates();
string sErr = "";
DataTable dt = new DataTable();
dt = ft.getConnectionTypes(ref sErr);
if (!string.IsNullOrEmpty(sErr))
{
throw new Exception("Connection Type lookup error: " + sErr);
}
else
{
string sHTML = "<select name=\"ddlConnectionType\" style=\"width: 200px;\" id=\"ddlConnectionType\">";
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
sHTML += "<option value=\"" + dr["connection_type"].ToString() + "\">" + dr["connection_type"].ToString() + "</option>";
}
}
sHTML += "</select>";
return sHTML;
}
}