private void searchDataButton_Click(object sender, EventArgs e)
{
String conStr = textBox1.Text;
String cmdStr = "select * from " + dataTableComboBox.SelectedItem.ToString();
if (!conStr.Equals(""))
{
cmdStr += " where " + conStr;
}
cmdStr += ";";
ArrayList colList = DBUtil.getTableColumns(dataTableComboBox.SelectedItem.ToString());
ArrayList list = DBUtil.executeQueryCmd(cmdStr, colList.Count);
searchResultListView.Columns.Clear();
for (int i = 0; i < colList.Count; i++)
{
ColumnHeader header = new ColumnHeader();
header.Text = (String)colList[i];
searchResultListView.Columns.Add(header);
}
searchResultListView.Items.Clear();
foreach (String[] ele in list)
{
ListViewItem item = new ListViewItem();
item.Text = ele[0];
for (int i = 1; i < ele.Length; i++)
{
item.SubItems.Add(ele[i]);
}
searchResultListView.Items.Add(item);
}
}
private void dataTableComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
String tableName = dataTableComboBox.SelectedItem.ToString();
ArrayList list = DBUtil.getTableColumns(tableName);
segmentComboBox.Items.Clear();
foreach (String s in list)
{
segmentComboBox.Items.Add(s);
}
if (list.Count > 0)
{
segmentComboBox.SelectedIndex = 0;
}
textBox1.Text = "";
}
private void dataTableComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
DBUtil mydb = new DBUtil();
String tableName = dataTableComboBox.SelectedItem.ToString();
ArrayList list = mydb.getTableColumns(mydb.chinesetoenglish[tableName]);
filtercombobox.Items.Clear();
foreach (String s in list)
{
filtercombobox.Items.Add(mydb.englishtochinese[s]);
}
if (list.Count > 0)
{
filtercombobox.SelectedIndex = 0;
}
textBox1.Text = "";
}
private void dataTableComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
DBUtil mydb=new DBUtil();
String tableName = dataTableComboBox.SelectedItem.ToString();
ArrayList list = mydb.getTableColumns(mydb.chinesetoenglish[tableName]);
filtercombobox.Items.Clear();
foreach (String s in list)
{
filtercombobox.Items.Add(mydb.englishtochinese[s]);
}
if(list.Count > 0) filtercombobox.SelectedIndex = 0;
textBox1.Text = "";
}