Hi all, Please tel me how to bind a listview using dataset in vb.net application? Thnaks in advance

Hi All, I have developed a windows application,have a listview in one form... Given below is the code to bind the listview :- Dim sqlCmd As SqlCommand = New SqlCommand("Select Query") Dim myData As SqlDataReader Dim lvhHelper As ListViewData = New ListViewData() Try If _con.State = ConnectionState.Open Then _con.Close() End If _con.Open() sqlCmd.Connection = _con myData = sqlCmd.ExecuteReader lvhHelper.FillListView(LstItems, myData) _con.Close() And below is the FillListView Class file Dim lvwColumn As ColumnHeader Dim itmListItem As ListViewItem Dim strTest As String Dim shtCntr As Short MyListView.Clear() For shtCntr = 0 To myData.FieldCount() - 1 lvwColumn = New ColumnHeader() lvwColumn.Text = myData.GetName(shtCntr) lvwColumn.Width = "100" MyListView.Columns.Add(lvwColumn) Next 'lvwColumn = Nothing Do While myData.Read itmListItem = New ListViewItem() strTest = IIf(myData.IsDBNull(0), "", myData.GetValue(0).ToString) itmListItem.Text = strTest For shtCntr = 1 To myData.FieldCount() - 1 If myData.IsDBNull(shtCntr) Then itmListItem.SubItems.Add("") Else itmListItem.SubItems.Add(myData.GetValue(shtCntr).ToString) End If Next shtCntr MyListView.Items.Add(itmListItem) Loop by using this codes listview is getting binded very slowly and will be blank hile loading... is there anything wrong i did in this code?.. any otherway to bind the listview using datareader?.. Thanks in Advance..

can u please explain me What is the difference between Managed and Unmanaged Code in .NET with example...?

Hi all, Am creating a report(matrix) using microsoft report viewer... am getting the output like this:- Code Name 24 25 26 27 28 1 Sam 9.81 9.81 9.81 18.81 18.81 Now i want to put the total of(9.81 +9.81 +9.81 + 18.81 + 18.81) as total as next column as given below Code Name 24 25 26 27 28 Total 1 Sam 9.81 9.81 9.81 18.81 18.81 64.05 how can i do this? Thanks in Advance...

Hi all, I have a table like :- Start Time End Time ---------- --------- 12/12/2008 1:46:26 PM 12/12/2008 11:48:06 PM how can i get the diffrence between these two dates? (it should be in HH:MM:SS format.....) Thanks in Advance...

Hi all, I have created a windows application,in that 1 MDI parent and 2 child forms are there....i have opend 2 child forms,now if i add anything in the first window textbox that should get updates in the second window's dropdown,bcz the value which i entered in the first window is get stored in the database,and the second window dropdown is populating form that table... This is not happening...how to do?... (2 windows are of child of the same parent window..) Thanks in advance...

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?...

Hi all, How to insert values to a temptable by executing a storedprocedure... Ex :- INSERT INTO TempYearEndBal exec BLYearEndLeaveTcktBalRep; Getting error while trying to insert the values to "TempYearEndBal" by executing the SP "BLYearEndLeaveTcktBalRep"... can anybody help me to come out from this issue... Thanks in Advance...

Hi all, I have a problem with executing function in Oracle 10g. Below mentioned is the function :- FUNCTION UnpackArray ( Source IN VARCHAR2 DEFAULT NULL, Delimiter IN CHAR DEFAULT ',' ) RETURN reSourceArray0 PIPELINED IS SourceArray00 SourceArray0:=SourceArray0(NULL); TYPE REFCURSOR IS REF CURSOR; CURSOR0 REFCURSOR; DelLen int; Pos int; Cnt int; str int; LEN int; Holder VARCHAR2(255); BEGIN IF Source is null or Delimiter is null THEN Return; END IF; IF RTRIM(LTRIM(Source)) = ' ' THEN Return; END IF; SELECT LENGTH(RTRIM(Delimiter)) INTO DelLen FROM DUAL; SELECT INSTR(UPPER(Source), UPPER(Delimiter)) INTO Pos FROM DUAL; IF Pos = 0 THEN BEGIN INSERT INTO UnpackArray_TBL ( Data ) VALUES ( Source ); return; OPEN CURSOR0 FOR SELECT * FROM UnpackArray_TBL; END; END IF; SELECT 1 INTO str FROM DUAL; << LABEL4 >> WHILE Pos > 0 LOOP BEGIN SELECT Pos - str INTO len FROM DUAL; SELECT SUBSTR(Source, str, len) INTO Holder FROM DUAL; INSERT INTO UnpackArray_TBL VALUES ( Holder ); SELECT Pos + DelLen INTO str FROM DUAL; SELECT INSTR(UPPER(Source), UPPER(Delimiter), str) INTO Pos FROM DUAL; OPEN CURSOR0 FOR SELECT * FROM UnpackArray_TBL; END; END LOOP; SELECT SUBSTR(Source, str, length(RTRIM(Source))) INTO Holder FROM DUAL; IF length(RTRIM(Holder)) > 0 THEN INSERT INTO UnpackArray_TBL VALUES ( Holder ); OPEN CURSOR0 FOR SELECT * FROM UnpackArray_TBL; END IF; Return; LOOP FETCH CURSOR0 INTO SourceArray00.Data; EXIT WHEN CURSOR0%NOTFOUND; PIPE ROW(SourceArray00); END LOOP; CLOSE CURSOR0; RETURN; END; While executing this am getting the error like: Running "EDOCS"."UNPACKARRAY" ( SOURCE = admin, DELIMITER = ). Parameter 'RETURN_VALUE': No size set for variable length data type: String. can anybody help me to solve this...? Thanks in advance.

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

I have a storedprocedure in oracle,in that am using begin OPEN RCT1 FOR SELECT REPLACE(SelectStatus.SelectCommand, '@Location', SelectStatus.Location) INTO SelectStatus.SelectCommand FROM DUAL; end; My output is :- Select * from area_master where location = '001' order by area_name what is want is instead of getting this query as output,i want the result of this query as output.. how can i execute this query inside the SP?... Any help will be appreciated thanks in advance...

I have a storedprocedure in oracle,in that am using begin OPEN RCT1 FOR SELECT REPLACE(SelectStatus.SelectCommand, '@Location', SelectStatus.Location) INTO SelectStatus.SelectCommand FROM DUAL; end; My output is :- Select * from area_master where location = '001' order by area_name what is want is instead of getting this query as output,i want the result of this query as output.. how can i execute this query inside the SP?... Any help will be appreciated thanks in advance...

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?

thanku.... let me try and get back to u...

Am using wep 800 dx printer...how to set?

Dear all Its been some time, i have been trying to print bills in CrystalReport using vb.net. I am using VS 2008 & SQL 2005(windows application using vb.net). I am using continueous paper with 13.2 cm width on wep 800 dx printer. i would like to know how to eject paper after printing each bill so that it wont print Blank spaces after the contents. OR How to stop the paper after printing the first bill without ant blank space BILL FORMAT :- COMPANY NAME COMPANY ADDRESS -------------------------------------------- BILL NO : 123 BILL DATE:DD/MM/YYYY -------------------------------------------- ITEM NO1 1000.00 ITEM NO2 530.00 ITEM NO3 450.00 ITEM NO4 1.50 ITEM NO6 2500.00 -------------------------------------------- TOTAL : 4481.50 -------------------------------------------- THANK YOU VISIT AGAIN -------------------------------------------- Thanks in Advance...

how to do Auto positioning to cut bills after the contents in WEP DX 800 printer?

Hi all How to give setup to print till the content end..the printer should stop after the contents prints.... am using wipro lx 800 printer... apllication developed in windows using crystal report.. should i need to add some code in application or directly can i set in the printer propery?

what is Oracle equalent for Systypes,Syscolumns...? if Systype - All_Types,Syscolumns -All_Tab_Columns then what is the eualent for name,xtype,xusertype in All_types and xtype,ID,name in All_Tab_columns... please anybody give me a solution for this? Thanks in advance...

how to implement Filter for listbox using textbox in windows application using vb.net i have a textbox and a listbox in my application listbox id binded from database.. now when the user enters anything in textbox the items which starts with the text enterd in the listbox should filter and come in the first (i mean list box is already filled in ascending order,so only the thing is the scroll should move to the starting of the word which is enterd in the textbox ) how can i achieve this? any idea?.. (same like the index search in microsoft sites)