GeoffUnique's Q&A profile

• Windows Forms DataTable Troubles Galore

  Hello, I am trying to do the following in my code: I query the database and obtain the information in a DATATABLE. At one point in time, I need to delete all the rows from the datatable and add say 3 new rows. Here;s how I go about doing it: For i = 0 to loGenTable.Row.Count-1 loGenTable.Rows(i).Delete Next loGenTable.AcceptChanges() I then go on to add a new ro ...Show All

• SQL Server SQL Server Express Security?

  We are releasing an application built on SQL Server Express in the next few months.  Our clients are mostly small companies with little technical knowledge, and they will be using our application on desktop computers where everyone likely logs in as the same user.  As such, my thinking is that we setup SQL Server Express as in SQL Server Authentication mode.  This way they could select an Administrator password upon first installation, and manage user names and passwords from within the application itself.  Any thoughts   Also, how would we install this scenario   We haven't been able to figure out how to custo ...Show All

• SQL Server How to 'group by' properly?

  Hi, I'm working on a report where a customerid is passed from the application. The result are data for that specific customer. The result is something like this: Customer: <name customer> Number of hours: <hours:minutes> Average time to deliver: <days> This works perfectly. But now I have also make it possible to pass value 0 as customerid , which means all customers has to in that report. The problem now is that the calculation of the 'number of hours' and 'avg time to deliver' are calculated over ALL customers, not for each customer . E.g. for each customer id this is the correct output: Customer: Acme I ...Show All

• Visual Basic Replacing microsoft.common.targets

  How do I replace it   (Lost my CD) ...Show All

• Smart Device Development Using Vista and PPC 2003 Devices

  Hi, I'm trying to use Vista (beta 2) and VS 2005 to develop a Windows Mobile 2003 SE application. However, whenever I try to deploy my very very simple application to the Pocket PC 2003 Device (not the emulator) I get an error saying: Connection failed. ActiveSync is not installed. From what I have read ActiveSync is not needed on Vista as it has some of AS built in. However, it looks like VS 2005 doesn't quite understand this! When I plug my device in to the cradle, Windows 'pings' at me but I don't see anything in the Sync Center. Should I I did try to install AS 4.1 before I found out about Sync Center but the installation ...Show All

• SQL Server Can't put an array into an object variable

  Hi, I have the following code in a script task:   Dim items(0) As String   ReDim items(response.HierarchyItems.Length - 1)     For Each item In response.HierarchyItems    items(count) = item.AreaId    count += 1 Next   Dts.Variables( "User::AssetIdMaster" ).Value = items   Which works fine. Then I have this Private Structure AreaInfo     Dim AreaID As String     Dim AreaType As String End Structure Dim items(0) As AreaInfo ReDim items(response.HierarchyItems.Length ...Show All

• Visual Basic [OTP] Microsoft visual c ++ runtime libary

  I am running windows ME I am trying to open power point 2000 it worked a while back but now it wont open I get this runtime error message (Program: c:\program files\microsoft office\office\powerpnt.exe) This application has requested the runtime to terminate it in an unusual way. I have reloaded office 2000 have updated office and internet explorer to no avail can anyone give me some idea of what to do Thanks Higgins I'm afraid that you've found a form full of programmers. All the forums here are f or programming questions, you need to find a consumer level forum to ask this question. ...Show All

• Software Development for Windows Vista Keybord Shortcuts

  What is the possibilty of having shortcuts that will Create a new folder Create a new file These shortcuts can put work just like the CTRL+C or CTRL+V shortcuts and place files or folders on the desktop or in a file browser dialog or windows explorer. It would save quite a signicant amount of time if there was a native shortcut to add new folders rather than having to use either the context menu or the File menu to create new files or folders.     On the desktop, you use Shift+F10 to get a menu. You can file bugs and make suggestions via the "how to file a bug" shortcut on the desk ...Show All

• Software Development for Windows Vista Specifying a custom level for requireExecutionLevel in a UAC manifest

  Can we specify a custom level for the requestedExecutionLevel in a UAC manifest (meaning apart from asInvoker , highestAvailable , requireAdministrator ) -Tanveer Rashid ...Show All

• SQL Server Unhelpful error message

  I've just got the following error message from a script component: "The value is too large to fit in the column data area of the buffer". How difficult would it be to get the name of the column in question. Seeing as its metadata of the component surely it can't be that difficult I'm making an assumption here I admit! -Jamie Jamie, Yep, not a very good error. This one sounds like it could be easily improved, but that may be deceiving. When you find errors like this, we simply ask that folks report them. We'll try to improve them as we go. I don't know anything about the error that you've encountered. It may be simply an oversight. I ...Show All

• Visual Studio 2008 (Pre-release) Working with a Canvas in Cider Designer

  When working with canvasses in the Cider Designer, I can't select it to move it around, and I can't seem to drop anything on it, I have to add with XAML, and if add the items in that way, the items themselves are not moveable or sizeable. Is there a bug fix for this Thank you, Jaco There is currently no support for interacting with container controls other than the Grid. Much of the work we have done in previous iterations focused on improving the overall quality of the features (such as working with the Grid) in the CTPs. We have decided to remove some functionality that was present in previous CT ...Show All

• .NET Development Connection Pooling doubt

  Hi, Have a doubt about connection pooling. There are two parameters Min Pool Size and Max Pool Size, which default values are 0 and 100 respectively. So, the first time application connects to database the pool is created, and if several connections are open simultaneously then connection pool grows until Max Pool Size. But what happen if afterward application is idle or less demanding in sumultaneous connection The connection pool reduce automaticaly until Min Pool Size or it keeps all connections How much time an idle connection is keep in the connection pool until is eliminated Because if this interval is too short the po ...Show All

• Windows Forms OverDrawing Custom Inherited Controls

  Hi, Using VB.NET. I'm a beginner so please be gentle..  I am trying to overdraw most of the windows controls, including Listbox among others, so that they have a solid 3 pixel border. Currently I am doing this by creating a customcontrol inheriting from the specific windows control i.e. CustomListBox, inherits ListBox. CustomTextBox inherits TextBox.. etc.. then han ...Show All

• SQL Server Is there a way around using MAX Statement on Report

  I have a report that due to being unable to find a successful solution across the web relies on me using a value in a box as shown below; =MAX(Fields!budgeted_net_rent.Value) The problem I now have is that I have another field on the report and want to a =SUM on it and it tells me that you can't do that unless it is a header or footer and something about being part of an aggregate function. How can I fool SSRS into placing the value for this field into a sperate box so that I can complete the calculation I need to do. This report uses various drill throughs etc. If it is relevent, the value that I want to perform the calculat ...Show All

• Visual C++ Need Help

  Dear all I am bit confused .. regarding studying VC++6 or VC++.net... so please tell me what to learn.. i think that VC++.net will be a better choice. so what you all say technically. also please give me the links to study VC++.NET ............. regards Thank you Visual C++ 6.0 is an old product that is no longer supported. The most recent version of Visual C++ is the 2003 edition, and Beta 2 is available of the 2005 version. For learning C++ I would actually recommend starting with the Beta 2 version of 2005. Sicne Stan Lippman works on my team, I am partial to his recently released C++ P ...Show All