public Steal_a_Feel(ref GeniePlugin.Interfaces.IHost host, string sDBLocation)
{
InitializeComponent();
try
{
oDS = new DataSet();
sSQLConn = new SQLiteConnection();
oDS.Tables.Add("AllData");
_host = host;
_host.EchoText(sDBLocation);
this.tbContainer.Text = this._host.get_Variable("StealingContainer");
this.cbMark.Checked = this._host.get_Variable("StealingMark") == String.Empty ? false : true;
this.cbPerceiveHealth.Checked = this._host.get_Variable("StealingPerceiveHealth") == String.Empty ? false : true;
this.cbPerceive.Checked = this._host.get_Variable("StealingPerceive") == String.Empty ? false : true;
this.sSQLConn.ConnectionString = "DataSource= " + sDBLocation;
SQLiteCommand cmd = new SQLiteCommand(sSQLConn);
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from ItemList";
SQLiteDataAdapter sDA = new SQLiteDataAdapter(cmd);
sSQLConn.Open();
DataSet ds = new DataSet();
sDA.Fill(ds.Tables["AllData"]);
sSQLConn.Close();
sSQLConn.Dispose();
cmd.Dispose();
this.comboBox1.DataSource = oDS.Tables[0].Rows[1];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
