Davester's Q&A profile

• SQL Server Same Member - multiple rollups (unbalanced hierarchy)

  This has been causing me a lot of trouble. Hopefully someone can help me out... A problem description follows the diagrams. [Diagram 1 - what users should see as navigation] Accounts | --Trial Balance | --Account#1 --Account#2 -- AccountGrouping#1 | --Account#3 --Account#4 --AcountGrouping#2 | --Account#5 --Account#6 --Account#7 --Account#8 | --BalanceSheet | --Account#9 --Account#10 --AccountGroup ...Show All

• Windows Forms IssueVision issue

  The setup wont 'see' my local sql installation and gives me the the only option 2 cacel the setup   :( Sql acceps mixed mode Remco Now that is a fast response btw do you know how 2 solve 'my' problem Remco ...Show All

• SQL Server Data Type Conversions

  I am trying to convert int to date. first I have converted the int value to string(dt_str), using 'Data Conversion' Transformation, then again I have used another 'Data Conversion' Transformation to convert it into date. but its giving the following error    [Data Conversion 1 [3643]] Error: Data conversion failed while converting column "THEDATE_INTO_STR" (2799) to column "CALENDAR_YEAR1" (3657).  The conversion returned st ...Show All

• Visual C# How to Set columns width in a Win. Form Datagrid at runtime?

  Thanks for the help. I figured out how to make certain columns to be readonly. But I had to do this to the DataTable before its even binded to the dataGrid. Is there a better way to do this Also is there a way to set the width of each column I looked at the code above. But I think were using differnt types of datasource. Im a newby with C# so excuse me if my questions seem kinda stupid...... Im not sure how to make the code you posted above ...Show All

• SQL Server SQL JOIN? BETWEEN? ON?

  i have two tables carModels and plates carModels = modelID(int,primary key), makeID(int), modelName(varchar), startYear(int), endYear(int) plates = plateID(int), plateName(varchar) When i insert a variable eg @modelID into the query. I want to return from the query the platedID and plateNames from the plates tables. Between the startYear and the endYear of the carModel table for the specific modelID record of the @modelID but i don't ...Show All

• Visual C# flash file

  how can you put a flash file in a c# application Cisco You can put it as an Embedded Resource, Understanding Embedded Resources in Visual Studio .NET . ...Show All

• Visual Basic VB 6 vs VB .NET vs VB 2005

  Hello friends. i am completely new in programming environment. i want to learn a good programming language, with the help of this language i want to develop good powerful software for my manufacturing company. my questions are 1. from where should i start VB 6 or directly from .net or VB 2005 2. learning a programming language is how much hard as i am not a good student of maths. and also new in programming world. ...Show All

• Visual C++ Error when building.

  Hi, I'm new to C++ and am having some troubles. I am trying to create my first successful program (just one that displays words to the screen). I have the source code and everything however the following error message comes up when I try to "build" the program: "Compiling managed resources... c:\- - -\ - -\ - - -\ - - -\ - - - - - -\ - - - \ GlobalConfig.resx(42,5): error RG0000: Type System.Drawing.Point, System.Drawing in the data at line 4 ...Show All

• Visual C++ Manifest issues with VC2005

  Hi I'm trying to build a production application in debug using Visual Studio 2005. The application builds, but when I go to run it in debug, I get an error that it can't find the Release versions of the run-time libraries. I've looked at a lot of documentation and discussion groups regarding manifests and have not found out what to do. It looks like the manifest (as near as I can tell) has the debug versions of the libraries included, but not th ...Show All

• Visual Basic Saving contentes of a graphic to a bitmap and load it

  Hello! I have a form with a picturebox and I turn the picturebox into a graphics object by using the creategraphics. I then draw a few things, and then I want to save what I have done in to a bitmap, but on disk, just on memory so I can reload it. I do like this    Public Shared Sub save(ByVal picb As PictureBox, ByRef bi As Bitmap)         Dim x As Bitmap     &nbs ...Show All

• SQL Server debuggin T-SQL

  How do I debug my T-SQL in SQL Server 2005 I think I saw an article from Niels Berglund notings that I need VS.NET to do this -- is this true If we're not a .NET shop (well, it's there in pockets), but using SQL Server, is there another way other than getting this IDE for my power DBAs that build the business logic Thanks... Hi Learningdba,   In SQL Server 2000, the debugger was ...Show All

• Visual Basic Loop without Do Error - End If

  Hey all. Can you help What am I missing in this section of code This exact bit of code runs just fine in one 6 of my spreadsheets, but it hangs up in a spreadsheet that is pretty much identical. When I break the loop and hit debug, it goes to the End If line near the end of the code. I have changed the structure of the if statements, and then I get a Loop without Do error. I am going insane. Thanks. Sub DeleteWorthlessRows() Dim i A ...Show All

• Visual Studio Team System TF80071 connecting MPP to Team project

  I have an MPP in my Team project. I have checked out the MPP file and opened it. When I click the Choose Team Project button and select my project, I get an error "TF8001: Team Foundation encountered an error while accessing the work item database.  Please contact the Team Foundation Server administrator." Any clues TIA, Doug Doug, please check the application tier for a corresponding event log entry.  ...Show All

• Windows Forms AxDSOFramer.AxFramerControl

  I am hosting an Excel spreadsheet in an instance of the AxDSOFramer.AxFramerControl object. There are properties to turn the menus, toolbar, and status bar on and off. However, there is no apparent way to control which menus are shown. If the Toolbars property is set to false, the Web Toolbar is shown. If it is set to true, the web, standard, and another toolbar are shown. Is there a way to control which toolbars are displayed Here is the code s ...Show All

• Windows Forms Editing, Sorting, Paging GridView based on custom DataTable

  Evening all. I have just been playing around with some code, I have a DataTable populated with some information I want to display to the screen.This is a ASP.net 2.0 app so I decided to use the GridView and attached the dt as the datasource. I now want to enable paging, sorting and editing all via the grid however it doesn't seem to work as I want (I can't just enable it). I have tried to find some code online but nothing seems to relate to ...Show All