那位大神可以帮忙啊？很急的。我想把作家那张表里的作家姓名添加到combobox中，调试的时候我把combobox控件点开里面是空的，我应该怎么写代码？越详细越好。 谢谢！

           

假设combobox绑定的列表为DataSet2的ListTable表(含有ListID,   ListName字段)，需要绑定的记录字段为DataSet1的Table1表的ListID字段   
combobox.DataSource   =   dataset2.Tables["ListTable"];   
combobox.DisplayMember   =   "ListName";   
combobox.ValueMember       =   "ListID";   
   
combobox.DataBindings.Add("SelectedValue",   dataset1,   "Table1.ListID");

2.*****************************************************************
//dt为数据表,ID,Name为dt的两个字段：   
comboBox1.DataSource   =   dt   ;   
comboBox1.ValueMember   ="ID";   
comboBox1.DisplayMember   ="Name";
3.******************************************************************

SqlConnection   con   =   new   SqlConnection("server=192.168.2.198;uid=sa;pwd=sa;database=northwind");   
SqlCommand   cmd   =   con.CreateCommand();   
   =   "Select   *   from   Customers   where   country='USA'";   
SqlDataAdapter   adp   =   new   SqlDataAdapter();   
adp.SelectCommand   =   cmd;   
DataSet   ds     =   new   DataSet();   
adp.Fill(ds,   "Customers");   
   
   
comboBox1.DataSource   =   ds.Tables["Customers"];   
comboBox1.DisplayMember   =   "CompanyName";   
comboBox1.ValueMember   =   "CompanyName";   

谢谢！还有一个问题。怎么能将数据库里的数据在gridview中显示，我们调试的时候没有错，可是显示不出结果，gridview里是空的，连表格都不出，下面是我们的代码。
using System;
using System.Collections.Generic;
using
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace all
{
    public partial class shop : Form
    {
        public shop()
        {
            InitializeComponent();
            this.IsMdiContainer = true;
        }
        SqlDataAdapter sqlDataAdapter;
        DataSet abc;

        private void shop_Load(object sender, EventArgs e)
        {
            SqlConnection myConnection = new SqlConnection();
            myConnection.ConnectionString = "server=PC-20111126CNWU;uid=sa;pwd=123;database=store";
            SqlCommand sqlCommand = new SqlCommand();
            sqlCommand.Connection = myConnection;
             = CommandType.Text;
             = "SELECT sno as 编号,name as 店名,time as 经营时间,star as 星级指数 from shop1";
            

            sqlDataAdapter = new SqlDataAdapter();
            sqlDataAdapter.SelectCommand = sqlCommand;
            SqlCommandBuilder builder = new SqlCommandBuilder(sqlDataAdapter);

            abc = new DataSet();
            sqlDataAdapter.Fill(abc, "shop1");



            dataGridView1.DataSource = abc;
            dataGridView1.DataMember = "shop1";
            
        }

            }
}

            ds.Clear();
            string con =Class1.s;
            conn = new SqlConnection(con);
            conn.Open();
            string sql = "select * from 学生表";
            SqlDataAdapter da = new SqlDataAdapter(sql, conn);

            da.Fill(ds, "学生表");
            DataView dv = new DataView();
            dv.Table = ds.Tables["学生表"];

            dataGridView1.DataSource = dv;

这是一个完整的显示用dataGridView显示数据的代码块 Class1.s 是该表所映射的实体类(就是学生表的字段)
你好对着看一下
 

神人们！  别人说的是Combobox！

能不能具体讲解一下，看不懂，麻烦了，谢谢！！     ds.Clear是什么啊     


           ds.Clear();
            string con =Class1.s;
            conn = new SqlConnection(con);
            conn.Open();
            string sql = "select * from 学生表";
            SqlDataAdapter da = new SqlDataAdapter(sql, conn);

            da.Fill(ds, "学生表");
            DataView dv = new DataView();
            dv.Table = ds.Tables["学生表"];

            dataGridView1.DataSource = dv;

ds 是 DataSet ds = new DataSet();
ds.Clear();是清除DataSet 之前所有数据
这个动作是必须的

Vitual属性项是不是选的detail

能不能帮我看一下下面的代码什么意思？我看不懂
DataRow myDR = abc.Tables["writer"].NewRow();
   if (dataGridView1.RowCount > 1)
       myDR[0] = int.Parse(abc.Tables["writer"].Rows[(dataGridView1.RowCount - 2)][0].ToString()) + 1;
    else
        myDR[0] = 1;
        myDR[1] = textBox1.Text.Trim();