U monodevelop-u na operativnom sistemu Linux Ubuntu
izvršavam sledeći code:
konekcija_cela.Open()
Dim cmd As New SqlClient.SqlCommand("Vrati", konekcija_cela)
cmd.CommandType = CommandType.StoredProcedure
Dim id_korisnika_p As New SqlClient.SqlParameter("@id_korisnika", SqlDbType.NVarChar, 1300)
id_korisnika_p.Value = "nekavrednost"
cmd.Parameters.Add(id_korisnika_p)
Try
Dim adapter As New SqlClient.SqlDataAdapter(cmd)
Dim ds As New DataSet
adapter.Fill(ds, "sluzbe") [b]------------------------------------- u ovom delu dobijam error...[/b]
konekcija_cela.Close()
Catch ex As Exception
msgbox(ex)
End Try
dobijam grešku:
Unhandled Exception: System.IndexOutOfRangeException: Array index is out of
range.
at System.Data.Common.DataAdapter.FillTable (System.Data.DataTable dataTable,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords, System.Int32&
counter) [0x00000] in <filename unknown>:0
at System.Data.Common.DataAdapter.FillInternal (System.Data.DataTable
dataTable, IDataReader dataReader) [0x00000] in <filename unknown>:0
at System.Data.Common.DataAdapter.Fill (System.Data.DataTable dataTable,
IDataReader dataReader) [0x00000] in <filename unknown>:0
at System.Data.Common.DbDataAdapter.Fill (System.Data.DataTable dataTable,
IDbCommand command, CommandBehavior behavior) [0x00000] in <filename unknown>:0
at System.Data.Common.DbDataAdapter.Fill (System.Data.DataTable dataTable)
[0x00000] in <filename unknown>:0
a kada umesto pozivanja procedure izvršim sledeći code, sve radi dobro:
konekcija_cela.Open()
Dim cmd1 As New SqlClient.SqlCommand("SELECT * FROM nekatabela", konekcija_cela)
Dim adapter1 As New SqlClient.SqlDataAdapter(cmd1)
Dim ds1 As New DataSet
adapter1.Fill(ds1, "tabela")
konekcija_cela.Close()
Da li je to bug ili nešto drugo?
Naravno oba dela code su testirana na Windows OS i rade odlično.
Ako neko ima savet ili predlog....
Hvala!!
Patak