tasleemarif's Q&A profile

• Microsoft ISV Community Center Forums Excel user form to select a favourite file

  I am trying to use a custom form for the first time and would like to select an excel file from the normal "File _ Save As..." window and once selected, save the path and filename into cell A1 of a spreadsheet called "My Toobar.xls". This will then allow the user to open this "favourite" file very quickly. Can anyone help me get this Windows "File _ Save As..." browser window embedded into a UserForm. Many thanks, Paul Hi, You can use the build in SaveAs dialog in Excel. The example below show you how to show the dialog filtered, it only shows files of type *.fil and the file the user selected is stored in variable vSelectedFile.     ...Show All

• SQL Server The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)

  I know that another thread dealt with this error message before but after trying all the suggestions of that thread without success, I thought my problem may be different. I have SSRS 2005 installed on my local machine (TAH112) and it worked flawlessly for months. Suddenly it stopped working today. The Reporting Services Configuration tool shows everything is normal (green buttons all the way except for encryption keys button that is blue and Execution Account button that is yellow). When I try to connect to the server with SSMS, I got the following error: TITLE: Connect to Server ------------------------------ Cannot connect to http://tah112/reportserver . ------------------------------ ADDITIONAL INFORMATION: The requ ...Show All

• .NET Development Retreive incoming IP Addresses?

  Is it possible to get the incoming IP Addresses and display them in a listview Thanks, If you're using HttpListener, then yes. Retrive the HttpListenerContext using GetContext(). Get the HttpListenerRequest from the context using its property. Then grab the RemoteEndPoint from this HttpListenerRequest http://msdn2.microsoft.com/en-gb/library/system.net.httplistenerrequest.remoteendpoint(VS.80).aspx ...Show All

• Visual Studio Express Editions How do I use OpenFileDialog to change a form graphic?

  -Visual Basic Express 2005- I have a question that I think is simple but I can't figure it out on my own: I'm designing a basic company program that enables the company to insert a logo image into one of the forms for printing. I use: Private Sub PictureBox1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles p_logo.Click Dim myStream As IO.Stream = Nothing Dim openFileDialog1 As New OpenFileDialog() openFileDialog1.InitialDirectory = "c:\" openFileDialog1.Filter = ".GIF files (*.gif)|*.gif" openFileDialog1.FilterIndex = 2 openFileDialog1.RestoreDirectory = True If openFileDialog1.ShowDialog() = System.Windows.Forms.DialogResult.OK ...Show All

• .NET Development Read data from an Opened excel file with attribute= archive using an asp.net application

  My asp.net application reads data from excel sheet and displays data on the grid.My application and excel sheet are on the same server.If the excel sheet is opened , for example , if excel is opened manually by any users, and if the application trys to read data , the application will show an error message. The error message is as follows, "The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data." If i set the prorperty of the excel file readonly and even if it is opened by some other users , my application works fine . If i reset the property of excel file then my application will show the error again. Connection string i am using is ...Show All

• Windows Forms Big data updates

  Hi All, I'm designing this student testing system. Some pages contain say 40 items: Each of which correspond to a combobox where a score of 1-5 may be entered. Each Q also has "question text". My initial plan was to just get all these params (the scores) and concatenate them into a string (the numbers only) and call a stored procedure, which would hold all of the other details in order. This way relies on the order of scores, which is fine by me. Example call (As an SQL command from C# Front, C# omitted): p_insertScoresForATest 1, 4, 3, 5, 2, 4, 3, 5, 4, 3, 2, 4, 5, 3, 2, 3 ...... In p_insertScoresForATest it knows to associate the first param with 'writing skills', the second with 'pencil co-ordination', etc. It ...Show All

• SQL Server Replication problem in SQL Server 2000

  Hi all SQL Server experts! I have created replication on my two servers (production and backup servers). I used wizards to create it and then generated SQL script for deleting and creating replication. For another task I came across the command sp_removedbreplication 'dbname' and I tried to use that for removing replication more easily on the servers. It seemed to not remove everything on the production server and whenever I install replication now, either by using wizards or my generated SQL scripts I get an error icon (red circle with a black X in it) on my Replication Monitor all the way down to Publisher and the publication named with the computer name. Also this icon is on Agents and Log Reader Agents but not on the actual agent. ...Show All

• Windows Forms Drag & Drop Rich Text Boxes

  Hi, In this application I use a number of RTBs on a windows form, in which three of them are enabled to allow drag and drop operations. This is done by setting the EnableAutoDragDrop property, when everything works fine with the exception of the very first drop after the start of the application. Here it goes. The selection of the text and the drag seems to work fine as the cursor changes shape appropriately while the drag goes on, but when the cursor is positioned on the RTB target, the cursor does not change to the drop shape, or the default arrow. You have to abort the operation, and start it again when from then on everything works fine. The first drag does not matter to start from which RTB, and its failure provides success to the ...Show All

• Visual Studio Express Editions Anti-Cracking Packers?

  Not to beat a dead horse, but after reading some of the threads about decompiling and the abundance of tools such as Reflector, I am just looking for some opinions. I am a newbie coder and just learning and through various googles on various topics, I've seen companies that claim to produce .exe packers that either prevent or make decompiling/cracking a vb or any .net application harder to do. Anyone ever try any of these Would anyone try one of these things   xwinterx wrote: Anyone ever try any of these Would anyone try one of these things Take a look at Dotfuscator...it is the premier tool in code protection: http://preemptive.com/products/dotfuscator/   dotfuscator ...Show All

• SQL Server How to raise error in script

  I can't believe I can't find this in books online... I have a transformation script component and I have a case where I want the object to completely fail if it is encountered. How do I code that All my searching BOL could find is how to redirect rows to an error output which is not what I need in this case.... I'd think it would be something simple like Me.RaiseError("Something really bad happened") but I haven't found it ... From BOL, please use the following example. Using Error Outputs in a Data Flow Component   ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/a2a3e7c8-1de2-45b3-97fb-60415d3b0934.htm First off, to establish the relevance of the above BOL link ...Show All

• Visual C# Are there really no methods that converts "æ" to "%E6" (URL)

  I need a string to be converted to "URL encoding" so that the webserver correctly handles the request. When sending "aoa" - the server expects: "%E6%F8%E5". I don't know what the encoding is called, but this is what i want. In PHP, urlencode() will produce this encoding. In C# the nearest i get is: %C3%A6%C3%B8%C3%A5 using the HttpUtility.UrlEncode(). This will not work for me. Does anyone know how i can get C# convert a string to me to the format mentioned above Spaces should also be converted to "+" - not %20. Of course, i could create such method myself, but it's a lot of work since this applies to all special characters. And i find it weird that such method does not exist already W ...Show All

• Visual Studio Express Editions MSHTML

  Using VS 2005 I can reference mshtml, but in c# express I can't find the appropriate reference entry to allow me to access properties like innerhtml. I feel I'm missing some simple here. Any help greatly appreciated! JB If you're using Visual C# Express, I suggest using Framework Class Library classes like HtmlDocument . ...Show All

• Smart Device Development WEB Browser problem with WINDOWS CE

  Hi, I am targetting my Pocket PC 2003 application to Treo 700WX device. Almost it is working in the same way. but in some areas I observed the differences. 1) My application is running very very slower in Treo 700WX emulator than it was running in Pocket Pc 2003 emulator. I want speed up my application as it was running in Pocket PC 2003 emulator. 2) When I add some text to WebBrowser It shows one progress bar( shows "connecting" ) and then adds text. after adding the text webbrowser looks like it is getting refreshed continuosly even though i dint use any to refresh. The same worked properly in Pocket PC 2003 Emulator with out this problems. I want to remove that progress bar and I dont want refreshi ...Show All

• Visual Studio Express Editions I got this message

  Server Error in '/WebSite2' Application. Sorry! Im quite new to this, i would like to this explained to me som that even an novice like me understand Is this doen in the regedit It worked, but than suddenly it didnt. I have checked the folder you described and both are there. The V1.1.4322 and the V2.0.50727 Should i delete one of them Thanks for your help ...Show All

• .NET Development Updates Using the Entreprise Library DAAB

  I am using the Jan 2006 Enterprise Library DAAB. One of the big benefits for me is abstracting myself from the database. I work for an ISV and our product must run on multiple databases. With that said I have been instructed to stay away from stored procedures. The dataadapter can create Update, Insert and Delete commands dynamically based on the Insert Command. I am trying to figure out how to dynamically create delete, insert and update statements using the DAAB. It appears that you to update using DAAB you must create your own commands. Therefore I decided to try and create a generic routine that would create these commands based on the columns in the dataset. I can cycle through the columns in the table to get the column names and ...Show All