private void button1_Click(object sender, System.EventArgs e)
{
try
{
string StrSQL="SELECT * FROM wj WHERE ChineseName LIKE '";
StrSQL+=this.textBox1.Text+"'";
//if(this.comboBox1.Text=="All")
//StrSQL="SELECT * FROM wj";
this.sqlDataAdapter1.SelectCommand.CommandText=StrSQL;
this.sqlDataAdapter1.SelectCommand.Connection=this.sqlConnection1;
//打开数据库连接
this.sqlConnection1.Open();
//执行SQL命令
this.sqlDataAdapter1.SelectCommand.ExecuteNonQuery();

System.Data.SqlClient.SqlDataReader MyReader=this.sqlDataAdapter1.SelectCommand.ExecuteReader();
this.listView1.Clear();
this.listView1.View=View.Details;
for(int i=0;i<MyReader.FieldCount-1;i++)
{
this.listView1.Columns.Add(MyReader.GetName(i),100,HorizontalAlignment.Left);
}

while(MyReader.Read())
{
ListViewItem MyItem=new ListViewItem();
MyItem.Text=MyReader.GetString(3);
for(int j=0;j<MyReader.FieldCount-2;j++)
MyItem.SubItems.Add(MyReader.GetString(j+1));
this.listView1.Items.Add(MyItem);
}
//关闭连接
this.sqlConnection1.Close();
}
catch(Exception Err)
{
MessageBox.Show("查询数据库记录操作失败："+Err.Message,"信息提示",
MessageBoxButtons.OK,MessageBoxIcon.Information);
//如果打开了连接，则关闭它
if(this.sqlConnection1.State==ConnectionState.Open)
{
this.sqlConnection1.Close();
}
}
}


请问我如何可以控制显示的字段,要在哪里改动呢?

希望如果有会的人请大家帮帮我了，谢谢了！

private void Form1_Load(object sender, System.EventArgs e)
{
SqlConnection con = new SqlConnection("server =.;database=LOGIN;uid=sa;pwd=;");
con.Open();
SqlCommand cmd = new SqlCommand("select ID from LOGIN",con);
SqlDataReader read = cmd.ExecuteReader();
while(read.Read())
{
string item = read.GetString(0);
this.listView1.Items.Add(item);
}
}

SqlCommand cmd = new SqlCommand("select ID from LOGIN",con);
这句的字段修改下就OK了。

[CODE] private void button1_Click(object sender, System.EventArgs e)
{
listView1.Items.Clear();
listView1.View = View.Details;
listView1.FullRowSelect = true;
ListViewItem ListItem ;
ColumnHeader ColHeader;
string ConString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source = D:\\mdb\\NorthWind.mdb;Jet OleDb:DataBase Password=123456";
OleDbConnection Conn = new OleDbConnection(ConString);
Conn.Open();
OleDbCommand Cmd = new OleDbCommand("Select * from Orders",Conn);
OleDbDataReader dr = Cmd.ExecuteReader();
for(int i = 0;i<dr.FieldCount;i++)
{
ColHeader = new ColumnHeader();
ColHeader.Text = dr.GetName(i).ToString();
ColHeader.TextAlign = HorizontalAlignment.Left;
listView1.Columns.Add(ColHeader);
}
while(dr.Read())
{
ListItem = new ListViewItem();
ListItem.Text = dr.GetValue(0).ToString();
for(int i = 1;i<dr.FieldCount;i++)
{
ListItem.SubItems.Add(dr[i].ToString());
}
listView1.Items.Add(ListItem);
}
dr.Close();
Conn.Close();
}[/CODE]