Marcelo de Oliveira (BR/SP)'s Q&A profile

• Visual Studio Express Editions Viewing Images in a Access DB

  I am using Visual Web Developer 2005 Express for C#. I have an application that stores images (BMPs) directly into an Access DB (OLE field) and I need to view them in a ASP page. If I could change the application to store a link to the image, my problem would be fixed. Unfortunately, I cannot change it to a link so I need a work around. Is there a code expression that I can use that will allow me to display the image Or is there an easier solution Thanks! db structure table name : demotbl fields: id , photo private void button1_Click(object sender, EventArgs e) { string db ...Show All

• SQL Server Exporting SQL Maintenance Plans

  I have taken a look at the new maintenance plan designer and have come up with a maintenance plan I would like to be able to deploy on an enterprise level.  Anyone know of a way I can export the plan to another SQL 2005 server - without directly pulling from the msdb system tables   I like the fact that you can script the output of most of the wizards, but the maintenance plan wizard does not appear to be one of them. Thanks, Matt That may work if all you are dealing with is one organization. Creating a maintenance plan script can be reused at many different organizations which is what I have done and is far more beneficial. I ...Show All

• .NET Development Class SerialPort and DTR/DSR protocol

  I must realize DTR/DSR protocol with external device via serial port. I want to use class SerialPort from .Net 2.0. I don't know how to establishe properties of class in this case. I think that RtsEnable=false and DtrEnable=true, but Handshake= Sorry for bad English. Use None or XOnXOff. I'm not sure if the device driver will quickly respond to DSR turning off. If that's a problem, rewire the cable and connect DTR/DSR to CTS/RTS. ...Show All

• .NET Development A SIMPLE PROJECT ON ASP USING C#

  CAN U GUYS SEND ME A SIMPLE PROJECT ON ASP.NET USIG C# There are a number of quickstart samples available here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpqstart/html/cpsmpASPNETQuickStart.asp ...Show All

• Visual Studio Team System Install VS RC1 on Single Team System Server?

  Can I install VS RC1 on the same server as my (single-server) Team System Server   I know you can install Team Explorer on top, so I am asusming you can, but just wanted to verify. Thanks, Scott Thanks for the quick response... I just finished a successful install myself. ~slee ...Show All

• Windows Forms Terrarium 1.2: is the battle still fair?

  Is the upcoming Terrarium 1.2 game going to be fair if everyone can download the sources and build their own custom versions I hope the creators of Terrarium have anticipated this somehow... I can also imagine a webservice call when starting up your terrarium to get some parameters that are only known to the creators of the terrarium.  Axel ...Show All

• SQL Server How to edit a subquery in query designer

  Hello! Is it possible to edit a subquery in the diagram and grid pane,without using the texteditor in the SQL pane The way i do it now (hopefully not the best way): 1 Create a tmp dataset with sql statement for the subquery 2 Rightclick in the original dataset and "Add a new derived tables" 4 Paste the sql code from tmp query to the original dataset. After linking the original query with many subquerys, it is difficult to change any off the subquerys! Best Regards Hello, Currently, Query Designer does not support designing sub-queries via Diagram Pane or Criteria Pane. ...Show All

• SQL Server Fail to Connect Report Service via Management Studio

  Dear sir, I installed a copy of SQL Server 2005 Evaluation Edition in my XP Professional Computer. When I try to connect to Report Service using Management Studio, it fails to connect with the following error: ********************************************** TITLE: Connect to Server ------------------------------ Cannot connect to XXXXXXXXXXXX ------------------------------ ADDITIONAL INFORMATION: The server committed a protocol violation. Section=ResponseStatusLine (Microsoft.SqlServer.Management.UI.RSClient) ********************************************** I have no problem connect to other services. Also, I can connect to the Report Manage ...Show All

• Visual Studio 2008 (Pre-release) DLinq Experts: Writing a more difficult Dlinq query for Northwind Orders

  I'm working on code to write a DLinq query to get the number of products ordered on particular days with the product code. What I'm trying to do is retrieve a count of products grouped (and sorted by) an order date.   Northwind's order-order_detail-product relationship is what i'm talking about for the relationship between the two.   (An Order's OrderDetail: each record links with a Product) Wait for the sql if you're not sure what I'm after. This is could be a cool exercise for the community.  Of course I'll post when I get it figured out... Ensoft wrote: I'm wor ...Show All

• Visual C++ Converting time [hh:mm] into decimal format!

  Is there anybody out there that can help explain to me how on Earth to tell my computer (program, in C++) how to take an input of time, in the typical hh:mm format; and convert "that" into hours (decimal format). For example, if I were to prompt the question: "How long ago did something occur [hh:mm] _ And the user's response is 2:30 (which would represent 2 hours and thirty minutes ago). How do I explain to the computer to ONLY take the hours (i.e. 2) and add that to ONLY the minutes divided by 60 (i.e. 30/60, which equals 0.5). This should give me 2:30 = 2.5 Now, does anybody know a good way to handle that Please help! Th ...Show All

• SQL Server Authentication mode, connecting from webpage

  Hello, I need help setting up SQL Server Express edition. What I did so far: 1) Downloaded and installed it with windows authentication 2) Installed SQL Server Management Studio Express 3) Created a database 4) Realized I needed SQL Authentication for connecting via php page. 5) Followed these instructions to enable SQL Authentication Now that SQL Authentication is enabled, how do I create a user account that I can use in php pages to connect to the database Thanks, Kurt Hey Kurt. See the documentation in Books Online for the following commands: CREATE LOGIN CREATE USER The create login sta ...Show All

• Visual FoxPro cannot open up a form-- BIG TROUBLE

  I have been working on this form for about two months adding new objects and manipulating databases. The last save I did was about 4 days ago. I have a few grids in it on different pages of pageframe and everything worked fine. I never added any columns to any grid at design time. At runtime VFP determines the column layout after a grid is given an alias as a record source. Today, just a few minutes ago I decided to add three columns to a grid which has always been empty at design time. After I did a save, I got an error message at runtime: Error loading file - record number 34: o_Grid2 <or one of its members>. Header Class: ...Show All

• Visual C# setting media (mp3, wma) file metadata

  I am trying to read and write audio metadata (mp3/wma) using Shell extensions. Its very easy to Get metadata using "myFile.metadataitem = folder.GetDetailsOf(folderItem, n)" but i cant seem to find any methods to Set the values. can this be done in the shell if not, does anyone know an easy way of setting metdata tags ... i have parsed the verbs on an audio file but nothing lets me change the metadata... I think that manipulating properties may be a way forward but cant decipher the documentation to get and set them. Laurence Fass   Codeproject  has a good series of articles on working with audio in .net, including reading an ...Show All

• Windows Forms Network Printing Error...Pls help to solve..

  hi, i am doin the network printing project...i've encountered an error while i was trying to list out all the available network printers. This is the coding...  ------------------------------------------------------------------------------------------------------------  Public Function PopulateListControlWithPrinters(ListControl As Object) As Boolean  On Error GoTo errHandler:  Dim l As Long  Dim lCount As Long  Lis ...Show All

• Visual Basic Work with multiple projects

  I have a question regarding the "integration" of different projects: Firstly I would like to know if the beta2 version of visual basic express exports the forms in a way I can then use their design in other projects. I tried the wizard but doesn't seem to work. Basically what I need is import a form, previously designed in a project, in another project. I tried adding the project, that works although I don't know how to refer to the forms in the added project. If I use: My.Forms.Form1.Show()   It doesn't work as I cannot see the forms in the added project so I cannot refer to them. Thanks Leo ...Show All