Adam Lofts's Q&A profile

• SQL Server Schema Problem?

  background: local reports tied to a dataset, webforms, SQL 2005 Reporting Services. Event: Checked in report via source safe and network failed in the process. Once network was back online an extra field was added to the stored procedure and the dataset in VS 2005 refreshed just fine. Refreshed folders, looked at dataset schema and everything seems fine. Problem: My report refuses to notice that the dataset has now changed and doesnt like the new field. How/What do I refresh to get this connection working properly again (connection between my report and my new dataset). Is there actually a report schema oh and p.s. after compiling it gives me an error and even after running the app it runs. Oh and I deleted temporary as ...Show All

• SQL Server where do I find Sql Reproting services designer 2003 (had to rebuild my computer)

  I had to rebuild my computer with .net 2003, i cant remembrer how I installed reporting services designer Please HELP you have to install the sql reporting services client tools. i believe i just ran the setup as if i were going to install sql reporting services again, and there is an option to install client tools i believe. ...Show All

• .NET Development Problem with 'Oracle client' and 'ODPnetOnly'

  Hi all ! I have both Oracle Client and ODPnetonly on my system. They have their different homes. If the path of Oracle Client (D:\oracle\ora90\BIN) is before the path of ODPnetonly (D:\odpnetonly\bin), then I have a problem. In this case, my web applications (in C#.net) don’t work but my console applications (in C#.net) do. And if I change the path of ODPnetonly before the path of Oracle, then my web-applications work but my console applications don't. So please tell me what is wrong with my system. Is there any problem regarding installation of 'Oracle Client' or ODPnetonly (I installed 'Oracle Client' before the ODPnetonly) Thanks and Regards, Vikas Hi Paul! I have multiple Oracle Homes on my second c ...Show All

• .NET Development ADO.Net 2.0, SQL Server 2005 Express & VB 2005 Express: How to Use A DataAdapter to Create DataTables in VB Forms?

  Hi all, In my SQL Server 2005 Management Studio Express (SSMSE), I created a database "ChemDatabase" with 3 .dbo tables. In my VB 2005 Express, I created a VB 2005 Express Windows Application project (called it "AveRpd" ) and tried to use ADO.Net 2.0 to connect the database "ChemDatabase" that is in SSMSE and to create the 3 tables in the App_Data folder of the "AveRpd" project as a DataSet for my Windows Application. I studied the .NET Framwork Developer's Guide "Populating a DataSet from a DataAdapter" in http://msdn2.microsoft.com/en-us/library/bh8kx08z.aspx , but I could not understand this article and the "Console Application" source code used in this article confused me g ...Show All

• Windows Forms return type

  hi all, we all write the functions with return type as int,double but why we need return type as another class name e.g public class abc() { some code here } public abc functionname() { } why we want return type as name of the class also why we need the return type of function as an object any help......... Hi, If you compile this code, you will receive the following error: Use of unassigned local variable 'p1' . To be able to call the Add method without needing to instantiate the object, you need to make the method static . This can be done by changing public int add( int a, int b) to public static int add( int a, int b). But in this case, I think that ...Show All

• Windows Forms how to invoke a method from the parent window?

  hello, i need to know how to invoke a method from the parent window window1 call window2 in window2 i need to invoke method that is in window1 Thanks if this is mdi, you can get a reference to the mdi parent thru the mdiparent property of the mdi child and cast it to its type to invoke your method. if it is a dialog, you can assign the owner form as the dialogs owner (constructor overload) and similar to the first scenario, cast it to the specific type of the form class before invoking the method. ...Show All

• Visual Studio Team System Custom rule - Validating Pascal/Camel casing?

  Dear All, I've a requirement, where I need to validate local variables (of a method) for Pascal casing. Is there any way so that I can implement this Thanks Hello, Look at this: http://blogs.msdn.com/fxcop/archive/2006/04/07/570553.aspx It should help. regards, Anton. ...Show All

• Smart Device Development Traffic on GSM Modem

  Dear All, I am developing an application using GSM modem I have around 50 messages limitonto my SIM card of Modem. Time when I am receiving the SMS I have to delete it using AT commands through C#.NET, Similarily I did when I had very less traffic , But Now I am getting numerous messages and the time when I am deleting the messages I am getting more messages still to come and it goes on increasing and my process of reading data gets slow... I want to get the messages directly to my PC hard disk instead of getting it on SIM card .As soon as new message comes in to GSM modem I would be able to redorect message to my hard disk So that , I would be able to handle large amount of Messages on my Machine Regards ...Show All

• Visual C# How do I code to drag a graphic from 1 form to another?

  I'm very new to C# programming. How do I get started coding so I can click & drag with a mouse a graphic from one form to another For example, say I have a smiley face and I want the user to be able to drag it from form1 to form2 with a mouse. Thanks, Steven, C# beginner. This is not an easy problem to solve.  I suggest that you take it piece by piece.  The first step is to be able to draw the graphic itself on the form.  It would probably be best for you to add a Panel to the form and set its BackgroundImage property to the picture you want. Then figure out how to drag it around on its own form.  Click on the panel in the designer, and in the properties window click on th ...Show All

• SQL Server Will ALTER DATABASE ... SET NEW_BROKER retain structure?

  I am considering the use of ALTER DATABASE ... SET NEW_BROKER within an existing Service Broker instance. The reason is that I have about 23 million old endpoints in Service Broker that I am unable to clean up using the standard END CONVERSATION loops that have been discussed on these forums previously. It's a busy database, and it just cannot do the job within a reasonable timeframe. There are no critical conversations to be lost, becuse the majority of the old endpoints deal with ASP.NET SQL caching, so they are disposable. I have read that using the ALTER DATABASE command will delete all past endpoints, but I haven't seen much in the way of the retention of the existing message framework. If I execute ALTER DATABASE ... SET NEW ...Show All

• Visual Studio Team System Workitem Question

  Hi, I have couple of question with respect to workitems 1. Can I assign a single workitem to multiple people 2. Is it possible to get alerts if someone else has modified any workitem assigned only to me using any tools Thanks, Srikanth We have a custom type of work item that we use to track help topic development. It uses several fields to indicate various types of owners of the help topic - writer, editor, etc. When the topic status is writing, the work item is assigned to the writer. When the status is editing, it's assigned to the editor. Is that the kind of thing you want to do ...Show All

• Visual Basic ProgressBar colours.

  I want to change the little blocks on a progressbar to red at a specific event, then back again to their original colour at another event. I also want to have them as blue, on another bar.   Asday wrote: I want to change the little blocks on a progressbar to red at a specific event, then back again to their original colour at another event. I also want to have them as blue, on another bar. Hi, I doubt you'll get a stripey effect if that's what you are after But you can pick your color or colors from the list that intellisense pops up. See. >> ProgressBar1.ForeColor = System.Drawing.Color.Blue    ProgressBar1.BackColor = System.Drawing.Color.White    Regards, ...Show All

• .NET Development Generating tree hierarchy from adjacency list

   I have an XML representation of an adjacency list where each <row> element has 0 or 1 parent element where the ParentID element points to the ID element of the parent.  I am trying to use xsl:key to generate an XML output tree.  Could anybody help with this please Thanks, Tad input: < xml version="1.0" encoding="utf-8" > <root>   <row>     <ID>1</ID>     <Name>One</Name>   </row>   <row>     <ID>2</ID>     <ParentID>1</ParentID>     <Name>Two</Name>   </row>   <row>     <ID>3</ID> &nb ...Show All

• Visual Studio 2008 (Pre-release) Transperent Buttons

  hi all, is there any way that i can make my buttons transparent the one like transparent window also i want to make my buttons drag and drop. thanks in advance nani ...Show All

• SQL Server Data Migration Error - SQL TYPE Variant data

  I am trying to migrate our Portals database from SQL2000 to SQL2005, but I received "SQL Type Variant Data" error during the data migration with some database. Can anyone help me with this Thanks, Jay ...Show All