Did you try google at all? That should be your first step. Try this: listview binding vb .net[^]

Also justhave a look Cheers!! Brij

Add a textbox in design view right click got to value select the value =Sum(Fields!YourID.Value, "datasetname") in Dropdownlist LatestArticle :Log4Net Why Do Some People Forget To Mark as Answer .If It Helps.

Yae.. I didnot notice that I made that mistake. Very sorry. But thanks. :) Niladri Biswas

The simplest way is to create a method in form2 that refreshes the dropdown and call this method from form1 when text is entered in the text box. But and ideal solution would involve using delegates to achieve loose coupling. Hope this helps, Shameel

U can do this in SQL server.... Inside the SP itself create the temp table and try to insert like : INSERT INTO #TempYearEndBal exec BLYearEndLeaveTcktBalRep this will work.... But in Oracle,what is the equlent way to do this?...

step 1 : create a Table types named "DIVISION_ARRAY" CREATE TYPE "DIVISION_ARRAY" AS TABLE OF VARCHAR2(12) step 2 : execute the below procedures CREATE OR REPLACE FUNCTION "UNPACKDIVISIONARRAY" (Source IN VARCHAR2 DEFAULT NULL, Delimiter IN CHAR DEFAULT ',') RETURN division_array PIPELINED IS l_list varchar2(32767) := Source; l_idx pls_integer; l_value varchar2(32767); BEGIN loop l_idx := instr(l_list,Delimiter); if l_idx > 0 then pipe row(substr(l_list,1,l_idx-1)); l_list := substr(l_list,l_idx+length(Delimiter)); else pipe row(l_list); exit; end if; end loop; return; end UNPACKDIVISIONARRAY; step 3 : execute the below sql to see the result Select column_value from TABLE(UNPACKDIVISIONARRAY('111,113')) hope that this will help you. regards, Sumith Koshy Thankan, OASYS Information Technology. Dubai

I have done it using cursor.... now its working...:-)

Please ask this in the General Database[^] forum instead. "WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes. My blog | My articles | MoXAML PowerToys | Onyx

But in this case i have to specify the height also.... but i dont want to specify the length..it should take automatically the contents height..(same like the bill) thats what i want..is there any way? should i need to give through code or some settings?

Hi, I see basically three ways to achieve this: 1. adapt the database query as you type, using a "LIKE '+myInitialText+"%'" clause. That would be easiest. 2. adapt the items shown in some other way, maybe by copying them to a list, working on the list, and setting the new list as the new datasource 3. leaving the items as is, however simply not showing some; that takes DrawMode.OwnerDrawVariable, and returning height zero in MeasureItem for the items you want to hide. (I haven't done this yet, but I think it should work). :) Luc Pattyn [Forum Guidelines] [My Articles] The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

If i add the presision also the same result..:-(

I don't use Oracle but try removing the RETURN, this should then get the result set back instead of trying to RETURN any output parameters (of which there are NONE). Never underestimate the power of human stupidity RAH

thanks for ur reply.. its exactly bcz of the space...i gave like <>' ' it worked...

Welcome Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

can u just tel me which forum i should post this message?... and if i remove collate database_default am getting this error: PL/SQL: ORA-00933: SQL command not properly ended