اين کد برنامه است همونه که بالا توضيح دادم:
Public Class Question
Dim CN As New SqlConnection("Data Source=.;Initial Catalog=Clinic;Integrated Security=True")
Dim SQLDA As New SqlDataAdapter
Dim DS As New DataSet
Private Sub Question_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim t2 As New DataTable("anstype")
DS.Tables.Add(t2)
Dim cmd2 As New SqlCommand
cmd2.Connection = CN
cmd2.CommandType = CommandType.Text
cmd2.CommandText = "select * from anstype"
SQLDA.SelectCommand = cmd2
SQLDA.Fill(DS.Tables("anstype"))
Dim t1 As New DataTable("question")
DS.Tables.Add(t1)
Dim cmd1 As New SqlCommand
cmd1.Connection = CN
cmd1.CommandType = CommandType.Text
cmd1.CommandText = "select qid,fid,question.anstypeid,question,qpriority,qvis ible,anstype from question inner join anstype on question.anstypeid=anstype.anstypeid"
SQLDA.SelectCommand = cmd1
SQLDA.Fill(DS.Tables("question"))
DataGridView1.DataSource = t1
DataGridView1.AllowUserToAddRows = False
DataGridView1.Columns("qpriority").HeaderText = "اولويت"
DataGridView1.Columns("qpriority").Width = 40
DataGridView1.Columns("qpriority").Resizable = DataGridViewTriState.False
DataGridView1.Columns("fid").HeaderText = "کد بخش"
DataGridView1.Columns("fid").Width = 52
DataGridView1.Columns("fid").Resizable = DataGridViewTriState.False
DataGridView1.Columns("qid").HeaderText = "کد سوال"
DataGridView1.Columns("qid").Width = 53
DataGridView1.Columns("qid").Resizable = DataGridViewTriState.False
DataGridView1.Columns("question").HeaderText = "شرح سوال"
DataGridView1.Columns("question").Width = 224
DataGridView1.Columns("question").Resizable = DataGridViewTriState.False
DataGridView1.Columns("anstype").HeaderText = "نوع جواب"
DataGridView1.Columns("anstype").Width = 70
DataGridView1.Columns("anstype").Resizable = DataGridViewTriState.False
DataGridView1.Columns("qvisible").HeaderText = "نمايش"
DataGridView1.Columns("qvisible").Width = 40
DataGridView1.Columns("qvisible").Resizable = DataGridViewTriState.False
DataGridView1.Columns("anstypeid").Visible = False
comboAnsType.DataSource = DS.Tables("anstype")
Dim CM AS CurrencyManager
CM = Me.BindingContext(DS.Tables("question"))
txtQID.DataBindings.Add("Text", DS.Tables("question"), "qid")
txtFID.DataBindings.Add("Text", DS.Tables("question"), "fid")
txtQuestion.DataBindings.Add("Text", DS.Tables("question"), "question")
txtQPriority.DataBindings.Add("Text", DS.Tables("question"), "qpriority")
comboAnsType.DataBindings.Add("Text", DS.Tables("question"), "anstype")
chkQVisible.DataBindings.Add("Checked", DS.Tables("question"), "qvisible")
butFSave.Enabled = False
End Sub
Private Sub butNew_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles butNew.Click
CM.AddNew()
End Sub
اول یه combobox که پر میشه و بعد هم DataGridView