/// <summary>
/// Populates all tables for the source connection string
/// </summary>
private void PopulateDatasets()
{
if (txtSeverName.Text != "" && txtDbName.Text != "" && txtSQLUserID.Text != "")
{
listView1.Items.Clear();
string sConnectionString = Helper.ConnectionString(txtSeverName.Text, txtDbName.Text, txtSQLUserID.Text, txtSQLPwd.Text);
ConnectionString = sConnectionString;
string Exception = "";
if (TestSourceConnection(out Exception))
{
PollPush objPollPush = new PollPush(null, null);
objPollPush.ConnectionString = sConnectionString;
DataSet dsTables = objPollPush.ListAllDatasets();
if (dsTables != null)
{
if (dsTables.Tables.Count > 0)
{
ListViewItem lviDataSetName = null;
foreach (DataRow drData in dsTables.Tables[0].Rows)
{
lviDataSetName = new ListViewItem(drData["name"].ToString());
DataSet dsColumns = objPollPush.PopulateColumns(drData["name"].ToString());
lviDataSetName.Tag = PopulateColumns(dsColumns);
lviDataSetName.ToolTipText = drData["name"].ToString();
listView1.Items.Add(lviDataSetName);
}
}
JobSettingsStatus.Text = "Source Connection Datasets populated!";
}
else
{
JobSettingsStatus.Text = "No dataset exists for given Source Connection!";
}
}
else
{
if (Exception == "")
{
JobSettingsStatus.Text = "Source Connection is not valid, datasets cannot be loaded!";
}
else
{
JobSettingsStatus.Text = "Error - " + Exception;
JobSettingsStatus.ToolTipText = "Error - " + Exception;
}
}
}
}
/// <summary>
/// Populates all tables for the source connection string
/// </summary>
private void PopulateDatasets()
{
if (txtSeverName.Text != "" && txtDbName.Text != "" && txtSQLUserID.Text != "")
{
listView1.Items.Clear();
string sConnectionString = Helper.ConnectionString(txtSeverName.Text, txtDbName.Text, txtSQLUserID.Text, txtSQLPwd.Text);
ConnectionString = sConnectionString;
string Exception = "";
if (TestSourceConnection(out Exception))
{
PollPush objPollPush = new PollPush(null, null);
objPollPush.ConnectionString = sConnectionString;
DataSet dsTables = objPollPush.ListAllDatasets();
if (dsTables != null)
{
if (dsTables.Tables.Count > 0)
{
ListViewItem lviDataSetName = null;
foreach (DataRow drData in dsTables.Tables[0].Rows)
{
lviDataSetName = new ListViewItem(drData["name"].ToString());
DataSet dsColumns = objPollPush.PopulateColumns(drData["name"].ToString());
lviDataSetName.Tag = PopulateColumns(dsColumns);
lviDataSetName.ToolTipText = drData["name"].ToString();
listView1.Items.Add(lviDataSetName);
}
}
JobSettingsStatus.Text = "Source Connection Datasets populated!";
}
else
JobSettingsStatus.Text = "No dataset exists for given Source Connection!";
}
else
{
if (Exception == "")
JobSettingsStatus.Text = "Source Connection is not valid, datasets cannot be loaded!";
else
{
JobSettingsStatus.Text = "Error - " + Exception;
JobSettingsStatus.ToolTipText = "Error - " + Exception;
}
}
}
}
