GPAustralia's Q&A profile

• SQL Server How to get a handle of my queries

  Does anyone knows of a tool that will help me manage my queries I have 100's of them and all scattered. On my PC at home, some in my laptop, some of them at work, some in memory sticks. Then, when I need them I can't find the one I'm looking for so I end up writing the query again. Any ideas YOu could use SourceSafe or a simple folder structure. If you want to keep them scattered, you can use MS Desktop Search to index all of your possible storage locations. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Problem connecting to SQL Server 2005 database instance

  I have an old ASP app that I have had to migrate to use SQL Server 2005. I have two pages that are virtually identical (one is edit only the other makes provision for adding new records - I didn't write these apps but I am responsible for making them work now). One page connect successfully to the SQL Server Instance and the other does not. They are using EXACTLY the same connect string. The only weird thing that has transpired is that we migrated to Active Directory recently. The ASP app that connects successfully was already on the web server prior to AD migration. The one that does not connect successfully was migrated after AD migrati ...Show All

• Visual Studio Debug breakpoints don't attach in managed code .h file

  When I set break points on C++/CLI code contained in a header file, for example a dialog created with the designer, the break points sometimes fail to attach at debug time.  By sometimes, I mean that most files don't work, but a few do.  This behavior is consistent within the project, the ones that don't work, never work, the ones that do, always do. I have tried a bunch of things with no solution: 1) New project with a dialog - Break point worked. 2) Simple Old project (vs2003) converted to new project (vs2005) - Break point worked. 3) Complex Old project (vs20003) converted to new project (vs2005) - Most breakpoints do not ...Show All

• SQL Server Related to "Users can not connect to sql server 2000 sp4 after applying hotfix (8.00.2148)

  To anyone who can help Does anyone know where I can get comprehensive instructions to achieve connectivity between a client and a server running Windows Server 2000 Ie the client able to connect to the server and the server able to connect to the client. For the background behind such a request read on ... I am new to Microsoft SQL server, it was suggested to me that I connect two pcs at home, and install some software: On one, I have: * SQL Server 2000 with Service Pack 4, ( hardware spec: a p4 machine with 1Gb RAM , 160 Gb hard drive) * This machine is called jco-pc1 * Operating system used with SQL Server 2000 is Microsoft Server 2003 ...Show All

• Windows Forms Range Parameters in my Report Doesn't work

  Hi, I just created a simple report using one range parameter with no default values because I have a WinForm with two comboboxes showing values from a table, Selecting the item from the combo boxes I set the range parameters for my report in the runtime, I added the following code:             Dim myReport As xReportEmpresa&nbs ...Show All

• Visual C# How to search a Record in DataTable

  let suppose i have a DataTable1, i want to find out a record, how can i do, please write code. thanks hi, there are difference between datatable in one hand, datagridview and binding source in other hand best regards ...Show All

• Windows Forms How to set Border for PANEL

  Can anyone please let me know how to set a border for a Panel control. I tried to set the BorderStyle property to FixedSingle and it produced a Black border around the Panel control. How do I change the border color to say Brown. Is it also possible to change the thickness of the borderline somehow Thanks in advance. Hi, as far as I know you have to override the painting of the panel to do that. Check this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=208258&SiteID=1 It may have the info you need. ...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 admin access. Hopefully someone can enlighten me. hi, i guess the 28 days left is for registeration, in your help  menu click register product vb express is ...Show All

• Visual C# Means of decoupling DAL and business layer?

  Hello, I have what I am assuming is a pretty newb question about C# class architecture. I have some basic data objects in the business layer of a project-tracking webapp, for example Task, which exposes various properties such as Name, ID, Text, UserID, ... I have got a static class set up to interact with the SQL Server Tasks table. I want to be able to call a method such as RetrieveTaskFromDB(int taskID), but I don't want to create and populate a Task object from within this DAL class, as it makes the coupling between the layers too tight (no ). My current solution is to use a Hashtable to mediate between the two (DAL returns a Hashtable, ...Show All

• Windows Forms Best practice when passing values between forms

  Hi, I want to pass values between forms using public properties. e.g. I want to pass "Supplier Name" from form 'A' and display it in a text box on form 'B' What's the best practise for setting the value on form 'B' Do i set the value directly from within the property or do i use the form load event to display the recieved property value Like so: Public Property SupplierReference() As String Get Return m_SupplierReference End Get Set ( ByVal value As String ) m_SupplierReference = value End Set End Property ====== Private Sub frmSupplierNewEdit_Load( ByVal ...Show All

• .NET Development Why do all examples assume you're binding data to a control?

  I'm starting to get frustrated now. Every example I come across shows you how to open a connection to a database, fill a dataset, but not how top programatically get at the data... Every example assumes you are going to bind the data to a control and update using a GUI. How do you get at the data within a DataSet once you've Fill()ed it Not from a form, but from with the application. This frustration is also heading towards disappoinment. The examples never seem to do anything. They get you to a point and then leave you dangling. This is an ideal way to ensure the after market for books etc. thrives... The "Build a Program Now!" e-book ...Show All

• Visual Studio Team System MSF Practitioner Consulting

   I work for a small IT services company in Washington, DC.  We're considering adopting MSF and looking for guidance from a practitioner.  We're ready the white papers, but we're not quite ready to take the plung and send someone to a $2,000 course.  We might be interested in consulting with a certified MSF practitioner who could help us determine whether or not MSF is a good fit for our environment.  Any suggestions on how I could locate area practitioners   Raymond In message , John@Jordan. .microsoft.com.invalid writes >Bindia, >I was under the impression the MSF Practi ...Show All

• Windows Forms Continuous Forms

  I am totally not sure if this is the right board or not. I am using Visual Studio Enterprise with VB 6. My question is that I am trying to set up a list form as I would in Access using the details section of the page to place a text box for each feild then setting the properties to Continuous Forms. This has the effect of showing each record in a list much like the hotmail inbox. I want to use this in my vb database but am having a hard time finding which control to use. Can someone please help me with this or direct me to the correct place where I can find some help Thank you, Robby VB6 questions ...Show All

• SQL Server New RDL Spec differences

  Is there somewhere that explains the major differences between the 2003 RDL spec and the new one released in November I will be going through the two specs in detail in January looking at the differences but I was just wondering if there's a quick synopsis out there somewhere. Are there any major differences Darren I guess I'll answer my own post in case anyone else out there is interested.   First the end of the new spec has a very brief and incomplete lists of the changes. The important changes I found were the following: 1) InteractiveWidth and InteractiveHeight subelements added t ...Show All

• Visual Studio Express Editions formview datetime error

  Hello, I am having the following problem.  I have created a formview to edit information in a SQL Server 2K table.  One of the fields is a date field.  The data type is set to datetime and Null values are allowed. Whenever I try to update the information, I get the following stack error. Any help would be appreciated... Exception Details: System.FormatException: String was not recognized as a valid DateTime. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack t ...Show All