public void FillDeviceTypeCombo()
{
DataTable dt = new DataTable();
dt = VSWebBL.ReportsBL.ReportsBL.Ins.FillDeviceTypeComboforhistoricalresponseBL();
// SqlQuery = "select Distinct DeviceType from DeviceDailyStats";
// SqlDataAdapter da = new SqlDataAdapter(SqlQuery, con);
// DataSet ds = new DataSet();
// da.Fill(ds, "DeviceDailyStats");
// dt = ds.Tables[0];
// dt.Rows.Add(dt.NewRow()[0]["All"]);
DataRow dr1 = dt.NewRow();
dr1[0] = "BlackBerry";
dt.Rows.Add(dr1);
DataRow dr2 = dt.NewRow();
dr2[0] = "NotesMail";
dt.Rows.Add(dr2);
DataRow dr3 = dt.NewRow();
dr3[0] = "All";
//dt.Rows.Add(dr3);
//DataRow r=new DataRow();
dt.Rows.InsertAt(dr3, 0);
DeviceTypeComboBox.DataSource = dt;
DeviceTypeComboBox.TextField = "DeviceType";
DeviceTypeComboBox.ValueField = "DeviceType";
DeviceTypeComboBox.DataBind();
}
private void fillServerTypesComboBox()
{
//6/30/2014 NS added for VSPLUS-789
try
{
DataTable ServerDataTable = VSWebBL.SecurityBL.ServerTypesBL.Ins.GetAllData();
if (ServerDataTable.Rows.Count > 0)
{
DeviceTypeComboBox.DataSource = ServerDataTable;
DeviceTypeComboBox.TextField = "ServerType";
DeviceTypeComboBox.ValueField = "ID";
DeviceTypeComboBox.DataBind();
}
}
catch (Exception ex)
{
//6/27/2014 NS added for VSPLUS-634
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
}
}
