007farzad
جمعه 09 تیر 1391, 12:37 عصر
سلام
میخواستم بدونم تفاوت این کدها در چیه:
Dim cmd As New SqlCommand()
Dim sda As New SqlDataAdapter()
Dim ds As New DataSet()
Connect()
cmd.CommandText = "SELECT * FROM goods_centers"
cmd.Connection = cnn
sda.SelectCommand = cmd
sda.SelectCommand.Connection = cnn
cnn.Open()
sda.Fill(ds, "data")
cnn.Close()
-------------------------------------------------
Connect()
Dim strSQL As String = "SELECT * FROM goods_centers"
Dim da As New SqlDataAdapter(strSQL, cnn)
Dim ds As New DataSet
da.Fill(ds, "Disk")
----------------------------------------------------
دسته اول کد زیر رو اجرا نمیکنه ولی دسته دوم اجرا میکنه:
With combobox
.DataSource = ds.Tables("Disk")
.DisplayMember = "center_name"
.ValueMember = "center_name"
.SelectedIndex = 0
End With
میخواستم بدونم تفاوت این کدها در چیه:
Dim cmd As New SqlCommand()
Dim sda As New SqlDataAdapter()
Dim ds As New DataSet()
Connect()
cmd.CommandText = "SELECT * FROM goods_centers"
cmd.Connection = cnn
sda.SelectCommand = cmd
sda.SelectCommand.Connection = cnn
cnn.Open()
sda.Fill(ds, "data")
cnn.Close()
-------------------------------------------------
Connect()
Dim strSQL As String = "SELECT * FROM goods_centers"
Dim da As New SqlDataAdapter(strSQL, cnn)
Dim ds As New DataSet
da.Fill(ds, "Disk")
----------------------------------------------------
دسته اول کد زیر رو اجرا نمیکنه ولی دسته دوم اجرا میکنه:
With combobox
.DataSource = ds.Tables("Disk")
.DisplayMember = "center_name"
.ValueMember = "center_name"
.SelectedIndex = 0
End With