Hi,
I am using a frame in main window to load different pages. My application has a user control with one text box and a button. I am using this user control 3 times in one of the pages. Suppose I have entered “Name_1” in first user control text box, “Name_2” in second user control text box and “Name_3” in third user control text box. After that I went to another page and come back to this page using the navigation back...
ammoos
Last Activity: Jun 15 '12, 12:08 PM
Joined: Apr 3 '07
Location:
-
Issue with WPF user control
-
Thanks for your reply.. the issue solved.. I used the following sql
Code:select * from table order by case when @num=2 then col1 end, case when @num=1 then col2 end
-
Dynamic order by
Hi,
I am using the following code for order by
But when I set @IsOrderByAccno =0 it works fine. but when I set @IsOrderByAccno =1 then it generating an error message "Conversion failed when converting datetime from character string.". I think this is due to...Code:SELECT * FROM TBLTEST ORDER BY CASE WHEN @IsOrderByAccno=0 THEN testDate ELSE testname END
-
WPF Popup issue
Hi All,
In WPF application which uses a pop up window, if we set a property ‘StaysOpen=true ’ for a popup, then on navigating away from the application and taking another application, the popup will appear on top of the currently active application. If we set ‘StaysOpen=fals e’, then the popup window wont exist when we come back after visiting an another application. My application needs to stays the popup open... -
WPF NavigationUIVisibility properties
Dear All
I am using frame in the main window of my application and in that window the NavigationUIVis ibility is visible. I think this service is available only pagewise, not like the back button in web pages. my requirement is, I have a textbox and a listview in my application. When user type somthing in this textbox then the matching data will load to this listview. suppose user typed "WPF" and then each keypress the matching... -
WPF NavigationUIVisibility properties
Dear All
I am using frame in the main window of my application and in that window the NavigationUIVis ibility is visible. I think this service is available only pagewise, not like the back button in web pages. my requirement is, I have a textbox and a listview in my application. When user type somthing in this textbox then the matching data will load to this listview. suppose user typed "WPF" and then each keypress the matching... -
How to open .odt files in browser?
Hi,
I am using the following code to open files in browser
...Code:function OpenDoc(path) { window.open (path,"mywindow"); } <a href="#" onclick="return OpenDoc('<%#DataBinder.Eval(Container, "DataItem.docName")%>'); "> Document </a> -
Thanks very much ADezii...Leave a comment:
-
How to set the margins for header and footer of access reports
Hi Friends,
I need to set the marigin of header and footer in my access reports, like Margins 10mm on all four sides of header and footer. Please help me
Thanks Ammoos -
Thanks for your reply FrinnyLeave a comment:
-
Issue with reading data from remote excel sheet
Hi Friends,
I need to read data from an excel sheet. I am keeping this excel sheet in a remote machine. I am using OLEDB connection to read the data from this excel sheet. But when I am trying to read the data, then I am getting the error message “It is already opened exclusively by another user, or you need permission to view its data.” I am sure the file is not opened by another user. Then may I know what I have to do for getting... -
CK
I just tried to copy the same excel file from remote machine to the server machine using the following code.. but that time I got the message "Access is denied"
declare @msg varchar(3000)
declare @file varchar(1000)
declare @file1 varchar(1000)
set @file = '\\remote macine IP\folder\Data_ Sheet.xls'
set @file1 = '\\server machine IP\folder\Data_ Sheet1.xls'...Leave a comment:
-
CK
I am not sure how to access the remote machine from SQL Server via IP.. Can you pls help me?
AmmoossLeave a comment:
-
Sorry..I couldnt understand your question.. I access the remote machine using the IP via the RunLeave a comment:
-
Yes.. I can access that machine from sql server machineLeave a comment:
-
Issue when reading data from excel sheet
Hi Friends
I am getting the following error when I am trying to read data from an excel sheet using sql script
OLE DB provider 'Microsoft.Jet. OLEDB.4.0' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet. OLEDB.4.0' IDBInitialize:: Initialize returned 0x80004005: The provider did not give any information about the error.].
... -
Read data from excel sheet
Hi Friends
I need to read data from excel sheet. The issue is that the first few rows of the excel sheet are images and buttons...and the data I need to read is start from the 6th row. And also the column names are dates...
I tried oledb object to read data but it’s not worked since the data in the excel sheet are not in the table format... shall I read the data from excel row by row? Is there... -
Cannot move controls in a userform using keyboard
Hi friends
I couldnt move controls in a user form(ms excel) using keyboard but I can move it by mouse.. I couldnt understand whats the issue.. now I reinstalled ms office 2003 on my machine, before that there were no such issues.. pls help me..
Thanks
Ammooss -
Many thanks Denburt .......Leave a comment:
-
MS Excel: Zip a file
Hi Friends
I am developing an excel application for e mail the copy of active worksheet. I successfully developed that functionality but my issue is sometimes this mail goes to spam folder since that work book have some macros.. so I decided to zip the copy of workbook before sending.. To zip the file I need to know the path where WinZip is installed.. How can I get the path where this winzip is installed... Can anyone help me? ...
No activity results to display
Leave a comment: