[QUOTE=mohsen22;1779669]
نوشته شده توسط
khokhan
ببخشید این دستورات در زبان وی بی چه شکلی هستند ؟
those code in vb .net shold be like this
Imports System.Data.SqlClient
Public Class Form1
Dim cmd As New SqlCommand()
Dim con As New SqlConnection
Dim rd As SqlDataReader
Dim ds As New DataSet()
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
If ComboBox1.SelectedIndex <> -1 Then
Dim con As New SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\logina.mdf;Integrated Security=True;User Instance=True")
Dim cmd As New SqlCommand("SELECT kala_code,price FROM kala WHERE kala_name = @pid", con)
cmd.Parameters.AddWithValue("@pid", ComboBox1.Text)
Dim da As New SqlDataAdapter(cmd)
Dim dt As New DataTable()
da.Fill(dt)
If dt.Rows.Count > 0 Then
TextBox1.Text = dt.Rows(0)("kala_code").ToString()
TextBox2.Text = dt.Rows(0)("price").ToString()
Else
ComboBox1.DataSource = Nothing
End If
End If
End Sub
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
End Sub
Private Sub TextBox2_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox2.TextChanged
End Sub
End Class