Koristim VS 2005 i Vb.NET
Code:
Dim myConnection As SqlConnection = New SqlConnection("Data Source=(local);" + "Initial Catalog=XXXXX;" + "Integrated Security=SSPI;")
Dim MyCommand = New SqlCommand("GrupeArtikala", myConnection)
MyCommand.CommandType = CommandType.StoredProcedure
Dim StrSelect As String
StrSelect = "Izaberi"
Dim da As SqlDataAdapter = New SqlDataAdapter()
da.SelectCommand = MyCommand
Dim ds As New DataSet
da.Fill(ds, "Grupe")
Try
myConnection.Open()
Grupa.DataSource = ds
Grupa.DisplayMember = "NazivGrupe"
Grupa.ValueMember = "GrupeID"
Grupa.Items.Insert(0, New ListItem(StrSelect, 0))
Grupa.SelectedIndex = 0
Finally
myConnection.Close()
End Try
Dim myConnection As SqlConnection = New SqlConnection("Data Source=(local);" + "Initial Catalog=XXXXX;" + "Integrated Security=SSPI;")
Dim MyCommand = New SqlCommand("GrupeArtikala", myConnection)
MyCommand.CommandType = CommandType.StoredProcedure
Dim StrSelect As String
StrSelect = "Izaberi"
Dim da As SqlDataAdapter = New SqlDataAdapter()
da.SelectCommand = MyCommand
Dim ds As New DataSet
da.Fill(ds, "Grupe")
Try
myConnection.Open()
Grupa.DataSource = ds
Grupa.DisplayMember = "NazivGrupe"
Grupa.ValueMember = "GrupeID"
Grupa.Items.Insert(0, New ListItem(StrSelect, 0))
Grupa.SelectedIndex = 0
Finally
myConnection.Close()
End Try
Ali jednostavno ne radi. Ako neko zna pomoci ili ako ima neki koristan link...