Ricardo Mendes's Q&A profile

• SQL Server replace first few characters

  how do i replace "Building" with bld i will getting the data like this: Buildling 100 Buildling 200 Buildling 300 Buildling 400 Buildling 500 i want like this: Bld 100 Bld 200 Bld 300 Bld 400 Bld 500 in other words, where ever building replace with BLD i'm using SRS 2000 thanks a lot Hi, You can do this either in the query or in the report. In the query you can u ...Show All

• SQL Server URGENT : Failed to run snapshot agent ?

  Everytime I generate the snapshot always show this error on replication monitor: Error messages: Executed as user: toshiba\snapshot_agent. The replication agent encountered a failure. See the previous job step history message or Replication Monitor for more information. The step failed. Then I go to SQL Server Agent tree and view Job Activity monitor, an got some steps, like this: 1. Snapshot agent startup message => Success Messag ...Show All

• SQL Server Datasource Reader - Name for output column is blank.

  Hi, I have a problem using the odbc datasource reader to execute a sql command on a progress database. My query is something like:- select max(id), sum(amount) from my_table OR select a, b, c, recid(my_table) from my_table which produces external columns and output columns with no name. The progress sql doesn't support using aliases on column names and setting validateexternalmetadata to false and manually naming the input and out ...Show All

• Windows Forms Positioning the child controls

  <.NET Framework 1.1> I am trying to develop a table control for Windows these days. It should look like an HTML Table control with rows and cells. For this purpose, I inherited from ContainerControl and added a ParentControlDesigner to it. I overrided the OnPaint method to draw the table border and all the rows and cells in the table. Now I want that if the user drag and drops any other control on to it. I should be notified that a control ...Show All

• Visual Studio Express Editions Windows Server 2003 Security Settings

  How do I change security settings for the .Net Framework 2.0 on a Windows 2003 server There is no snapin for it in Microsoft Management Console, only for .NET 1.1 and changes that I make to that don't apply to my 2.0 programs. Any help Thanks much, Lydon This thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=343181&SiteID=1 discuss (among other things) how to get a managed application to ...Show All

• Visual Studio Localization tool

  Hi, I am looking for a tool which helps to do a localization of an application. My idea is that it is an interactive tool which is looking for strings in source code and makes them localized. When such tool is started it offers each string found in source and asks if the string is translatable. If yes, some identifier is supplied by user to name this string in resources and new record is created in resources. The string in source code is repla ...Show All

• .NET Development serialization stopped working? help! invalidoperation

  Hi. All of a sudden just now the serialization I have been using on my test environments seems to work but when implemented into another project, they have stopped working, this is without me modifying any code. I have a server, and it serializes all objects and sends them down the wire to the client (smartphone running WM5 and .NET CF 2.0) This worked fine until just now. I get an invalidOperationException on the client when it tries to d ...Show All

• Windows Forms Is it possible to use the PhotoListView outside of this application?

  I'd like to be able to use the PhotoListView in another application, but so far I haven't had much luck in trying to decouple it from FotoVision. I don't know if it's an artifact of VB.Net or just the way the application was architected,&n ...Show All

• Visual Studio "The class diagram service failed to load."

  imediately followed by another message: "The operation could not be completed". I got the two messages when I create a new C# project and then choose "View Class diagram" on Form1.cs. After this happens I can't open either code or designer window for Form1! I'm using Visual Studio Team Suite RC (8.0.050727.86) Frode, Does this happen only for Forms or for others as well   Did you instal ...Show All

• Visual Studio DateTime picker and the ReportViewer

  Hi, I am running SQL Server 05 (SP 1 CTP) and Visual Studio 05. Is the reportViewer used for the Asp.net webforms supposed to have a working date time picker control I know that this was an issue on the beta 2 but I am still expericiencing the same problem.  The date report parameters work fine on the preview but when displayed on the ReportViewer in a webform  they don't work. I am running version 8.0.0.0 of the &nb ...Show All

• Visual Studio Express Editions Using VB Express with a limited account

  I've installed this (it required admin privileges) and then tried to register on my limited account and it refuses to accept the key although it quite happily did on the admin account. When I run it on the limited account it tells me that I have 28 days left before it expires. Does this mean I can to only use VB Express as a superuser Seems a bit daft considering that Microsoft are currently trying to discourage lazy developers from requiring ad ...Show All

• Visual Basic .NET 2005 Express Not Functioning Properly

  I downloaded vb.net 2005 express beta 2 on two computers. On one computer, the intellisense correctly finds the Size structure/class when I try to dim a variable as new size. However, the other one, which has .net 2002 installed already, cannot find size structure/class. The intellisense forces me to select either sizeconvert or sizef classes. Hi- Thanks for letting us know.  We tested this on our Beta2 edit ...Show All

• SQL Server "...conversion between types DT_I1 and DT_I2 is not supported"

  I created a simple ragged file with 3 lines: 1 2 3 and coupled it to a Flat File Source. The Flat File Source suggested that the type was DT-I1. Next I created a “SQL Server Destination task and connected the output of the Flat File to the Sql Destination. In the Destination editor I created a table, whose one column was declared to be a sql smallint. Here’s the problem: the Sql Server Destination now disp ...Show All

• Windows Forms DoubleBuffer - how to control behaviour

  Hallo! I have enabled DoubleBuffer with SetStyles for my control (and the other two flags needed). The problem is that the buffer gets flipped after every single drawing operation, of which I am doing a lot, because there's LOTS of graphical content on&n ...Show All

• .NET Development as to show tables of the data base through one winapp

  as to show tables of the data base through one winapp Hi, It's an access security issue. You have to Allow admin user reading system table. Go to "Tools\Security\Acces rights" in access HTH. Hayder Marzouk ...Show All