大家帮忙看下啊
string text = comboBox4.SelectedItem.ToString();
.
.
.
.
string sql = "select 'text' from [县市界_polygonR] ";
OleDbDataAdapter aa = new OleDbDataAdapter(sql, objConnection);
DataTable df = new DataTable();
aa.Fill(df); this.listBox2.DataSource = df;
this.listBox2.DisplayMember = "text";
this.listBox2.ValueMember = "id
string text = comboBox4.SelectedItem.ToString();
.
.
.
.
string sql = "select 'text' from [县市界_polygonR] ";
OleDbDataAdapter aa = new OleDbDataAdapter(sql, objConnection);
DataTable df = new DataTable();
aa.Fill(df); this.listBox2.DataSource = df;
this.listBox2.DisplayMember = "text";
this.listBox2.ValueMember = "id
string sql = "select 'text' from [县市界_polygonR] ";
是不是这个意思:
"select 列名 from [县市界_polygonR] where 查询列名 like ‘%" + text + "%'"
using (SqlConnection conn = new SqlConnection("连接串"))
{
conn.Open();
SqlDataAdapter aa = new SqlDataAdapter(string.Format("select 列名 from [县市界_polygonR] where 查询列名 like %" + text + "%"), conn);
DataTable df = new DataTable();
aa.Fill(df);
this.listBox2.DataSource = df;
this.listBox2.DisplayMember = "列名";
}
string text = comboBox4.SelectedItem.ToString();
.
.
.
.
string sql = "select * from [县市界_polygonR] ";
OleDbDataAdapter aa = new OleDbDataAdapter(sql, objConnection);
DataSet ds= new DataSet ();
aa.Fill(ds); this.listBox2.DataSource = ds;
this.listBox2.DisplayMember = "text";
this.listBox2.ValueMember = "id
string text = comboBox4.SelectedItem.ToString();
.
.
.
.
string sql = "select * from [县市界_polygonR] where text like '%"+text +"%'";
OleDbDataAdapter aa = new OleDbDataAdapter(sql, objConnection);
DataSet ds= new DataSet ();
aa.Fill(ds); this.listBox2.DataSource = ds;
this.listBox2.DisplayMember = "text";
this.listBox2.ValueMember = "id
OleDbDataAdapter aa = new OleDbDataAdapter(sql, objConnection);
DataTable df = new DataTable();
aa.Fill(df);
this.listBox2.DataSource = df;
this.listBox2.DisplayMember = "text";
this.listBox2.ValueMember = "id";
但是在aa.Fill(df); 这里显示错误说:至少一个参数没有被指定值。
string text = comboBox4.SelectedItem.ToString();
.
.
.
.
string sql = "select * from [县市界_polygonR] where text like '%"+text +"%'";
OleDbDataAdapter aa = new OleDbDataAdapter(sql, objConnection);
DataSet ds= new DataSet ();
aa.Fill(ds); this.listBox2.DataSource = ds;
this.listBox2.DisplayMember = "text";
this.listBox2.ValueMember = "id