[ patak_daca @ 03.06.2015. 08:51 ] @
Pozdrav! U monodevelop-u na operativnom sistemu Linux Ubuntu izvršavam sledeći code: 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: Code: 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 |