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

Question

我想实现从数据库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);



    }

Answer 1

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] 就是结果