请高手帮我看一下这段代码,谢谢
Dim mystr As String
Dim mysql As String
Dim myconn As New sqlconnection
Dim myds As New DataSet
mystr = "data source=WWW-7EDE22A8BFA;initial catalog=school;persist security info=true;user id=sa;password=11"
myconn.connectionstring = mystr
myconn.open()
mysql = "select distinct 民族 from student"
Dim myda As New SqlDataAdapter(mysql, myconn)
myda.Fill(myds, "student")
Combobox1.DataSource = myds
Combobox1.DisplayMember = "Student.民族"
myconn.Close()
myda.Fill(myds, "student") 中student 的内容和 mysql = "select distinct 民族 from student" 的student表中的内容一样吗!
是不是 dataset 中的 student 表中只含有民族这一列内容啊