The DataAdapter.SelectCommand property

[ 212.194.193.212 @ 14.01.2006. 19:11 ] @

problem, naime sa gornjeg sloja prosledjujem dole navedenoj funkciji u brokeru DataSet-ds, koji hocu da spustim u bazu (SQL), eeeee sad sam nashao ovu foru sa Adapter.Update ali mi puca stalno i javlja:

[bold] The DataAdapter.SelectCommand property needs to be initialized [/bold]

eee il ako neko zna neki drugi nachin da dataSet prosledjen od gore samo prosledim dalje SQL bazi

Code:

        public void viaDS2(DataSet ds)
        {
            try
            {
                conn.Open();
                SqlDataAdapter dataAdapter2 = new SqlDataAdapter();
                SqlCommandBuilder commBuilder2 = new SqlCommandBuilder (dataAdapter2);
                dataAdapter2.Update(ds,"Kupci");

            }
            catch(Exception)
            {
                if (tran!=null)
                    tran.Rollback ();throw;
            }
            finally
            {
                conn.Close();
            }

        }

heeeeeeeeeeeeeeeeeelp hitno :}}

'zdrav

[ marko v @ 14.01.2006. 19:44 ] @

a kako ti glasi select komanda tog adaptera.i update ili insert into komande?

[ 212.194.193.212 @ 14.01.2006. 20:48 ] @

select * from kupac

[ marko v @ 15.01.2006. 08:37 ] @

nevidim gdje si novom adapteru postavio tu naredbu.
pokušaj ovako
string SelectKomanda = "Select * from ImeTabele";
SqlDataAdapter dataAdapter2 = new SqlDataAdapter(SelectKomanda,TvojaKonekcija);

[ 212.194.193.212 @ 15.01.2006. 23:57 ] @

daadaddaad koji sam ludak nisam u adapteru stavio "select * ...

axxa hvala puno

_{[Ovu poruku je menjao 212.194.193.212 dana 16.01.2006. u 01:02 GMT+1]}