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 searchDataButton_Click(object sender, EventArgs e)
{
List <string> colList;
DBUtil mydb = new DBUtil();
List <List <string> > list = mydb.executeQueryCmd(textBox1.Text);
colList = mydb.getcloumnname();
searchResultListView.Columns.Clear();
for (int i = 0; i < colList.Count; i++)
{
ColumnHeader header = new ColumnHeader();
header.Text = mydb.englishtochinese[(String)colList[i]];
searchResultListView.Columns.Add(header);
}
searchResultListView.Items.Clear();
foreach (List <string> ele in list)
{
ListViewItem item = new ListViewItem();
item.Text = ele[0];
for (int i = 1; i < ele.Count; i++)
{
item.SubItems.Add(ele[i]);
}
searchResultListView.Items.Add(item);
}
}
private void searchDataButton_Click(object sender, EventArgs e)
{
List<string> colList;
DBUtil mydb=new DBUtil();
List<List<string>> list = mydb.executeQueryCmd(textBox1.Text);
colList = mydb.getcloumnname();
searchResultListView.Columns.Clear();
for (int i = 0; i < colList.Count; i++)
{
ColumnHeader header = new ColumnHeader();
header.Text = mydb.englishtochinese[(String)colList[i]];
searchResultListView.Columns.Add(header);
}
searchResultListView.Items.Clear();
foreach (List<string> ele in list)
{
ListViewItem item = new ListViewItem();
item.Text = ele[0];
for (int i = 1; i < ele.Count; i++)
{
item.SubItems.Add(ele[i]);
}
searchResultListView.Items.Add(item);
}
}