怎样用c#在sqlserver中查询一个字段

我想实现从数据库Teacher中查询名字等于我从ListView中选中的名字，然后让它查询数据库中等于选中名字的其他字段，比如工作量，是否外聘等，怎么做。已经网上找两天，不知道怎么解决，学生党，自学请见谅我的愚蠢。
private void ReadTeacher()//读取教师表
{

        this.TeacherList.Items.Clear();//更新教师列表
        SqlConnection sqlcon = new SqlConnection(con);//连接到指定的数据库
        sqlcon.Open();
        SqlCommand cmd = sqlcon.CreateCommand();
        cmd.CommandText = "select name from Teacher";
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            ListViewItem lvi = new ListViewItem();
            lvi.Content = dr["name"].ToString();                
            TeacherList.Items.Add(lvi);//将字符串显示到TeacherList这个控件上               
            lvi.Selected += new RoutedEventHandler(lvi_Selected);



        }            

        sqlcon.Close();//关闭数据库连接
    }


    private void lvi_Selected(object sender,RoutedEventHandler e)//每个老师被选中
    {
        ReadTeacherBaseInformation((sender as ListViewItem).Content.ToString().Trim());
    }

    private void ReadTeacherBaseInformation(string t)//从数据库读取教师基本信息
    {
        //连接到数据库
        SqlConnection mycon = new SqlConnection();
        mycon.ConnectionString =con;
        mycon.Open();
        string chaxun = " select name = t from Teacher";
        MessageBox.Show("data have erros");
        SqlCommand sqlc = new SqlCommand();
        SqlDataAdapter mydata = new SqlDataAdapter(chaxun, mycon);



    }

string chaxun = " select name = t from Teacher";
-> string chaxun = " select name from Teacher where name = '" + t + "'";
,,,

SqlDataAdapter mydata = new SqlDataAdapter(chaxun, mycon);
DataSet ds = new DataSet();
mydata.Fill(ds);
//下面可以绑定查询出来的表 ds.Tables[0] 就是结果

请问下面怎样将查询到的数据加到tea的各个属性比如名字，工作量等 private void ReadTeacher()//读取教师表 { this.TeacherList.Items.Clear();//更新教师列表 SqlConnection sqlcon = new SqlConnection(con);//连接到指定的数据库 sqlcon.Open(); SqlCommand cmd = sqlcon.CreateCommand(); cmd.CommandText = "select name from Teacher"; SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ListViewItem lvi = new ListViewItem(); vi= lvi.Content = dr["name"].ToString(); TeacherList.Items.Add(lvi);//将字符串显示到TeacherList这个控件上 lvi.Selected += new RoutedEventHandler(lvi_Selected); } sqlcon.Close();//关闭数据库连接 } private void lvi_Selected(object sender,RoutedEventArgs e)//每个老师被选中 { ReadTeacherBaseInformation((sender as ListViewItem).Content.ToString().Trim()); } private void ReadTeacherBaseInformation(string t)//从数据库读取教师基本信息 { //连接到数据库 SqlConnection mycon = new SqlConnection(); mycon.ConnectionString =con; mycon.Open(); //string chaxun = "select name = t from Teacher" ;//这一句和下一句都能实现从数据库中查询数据吗？ string chaxun2 = "select name from Teacher where name = '" + t+"'"; SqlDataAdapter mydata = new SqlDataAdapter(chaxun2,mycon); DataSet ds = new DataSet(); mydata.Fill(ds); if (chaxun2 ="") { this.TeacherTabTtem.Header = t; Teacher tea = new Teacher(); tea.name =; tea.title =; tea.titlepara = ; tea.baseWorkLoad = ; tea.baseWrokLoadType =; tea.supsidy = ; tea.supsidyType =; tea.waipin = ; UserControl uc = new UserControl(tea); } else { MessageBox.Show("error"); } }