Kevison's Q&A profile

• SQL Server SQL Server CTP won't install as Express is there, but Bld Uninstall Wiz won't remove it...

  What to do After 2 days trying (with only increasing frustration) to get SQL Server working on Net Server 2003 SP1, I'll try it on my dev box: XP Pro SP2. I've installed Visual Studio June CTP on my dev box, so guess that SQL Express is on it. Express Manager isn't installed apparently, so I can't just use that. So now when I try to install SQL 2005 CTP, it displays a dialog that old bits need to be uninstalled first. Add-Remove Programs dialog show Visual Studio Beta 2 but not SQL Express or any other SQL. So I run Bld Uninstall Wizard that displays the following dialog I continue, but then it says it is done: But SQL ...Show All

• Windows Forms User Preferences

  I'm still very new to writing windows apps so go easy on me.  I'm writing a program that is basically a food journal for people doing low-carb diets. There are several things that have been asked for that should really be options and I'm wondering what is the best way of storing and retrieveing these options  An example would be wether weight  ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. MDX2 and Action Mapping?

  Can anyone direct me to documentation on using Action Mapping via MDX in the latest release of the DX9 SDK (Feb) Searching has proved mostly fruitless and DX8 samples of AM (using DIACTION, etc) are useless as it appears the entire structure has changed. I've looked through the SDK docs but they are simply a shell outline and only list classes and their members - there is little to nothing in the way of description and zero examples. Also, are VB docs and coding examples for any of DX planned As a VB.NET coder I feel like the "forgotten stepchild" when it comes to DX as the majority of the material is in C++ or C# (actually 10 ...Show All

• Visual Studio Express Editions query the BackColor property of a Form?

  I am writting a simple bit of code to place a random black point on a white form each time I click Button1. I want to code it to look at the randomized location an see if there is already a black point there. If there is then make the point white. Any help would be appreciated! Here is what I have so far: Public Class Form1 Dim x As Integer = -1 Dim y As Integer = -1 Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Rnd(-1) Randomize() End Sub Private Sub Form1_Paint( ByVal sender As Object , ByVal e As System.Win ...Show All

• Visual Basic Streaming text from a view to a file.

  The following code is supposed to place data rows from a SQL Server 2000 view (vwExport) into a text file: G:\doc\Output.txt. The compile error I get is: 'Application.ApplicationDataSetTableAdapters.vwExportTableAdapter' cannot be converted to 'System.Data.DataTable'. Code: Dim strExport As String = "" Dim strExportFile As String = "" Dim x As DataView = New DataView(VwExportTableAdapter) Dim z As Integer Dim y As Integer For z = 0 To x.Table.Rows.Count - 1 For y = 0 To x.Table.Columns.Count - 1 strExport = strExport & x(z).Item(y).ToString & vbCrLf Next strExport = strExport & vbC ...Show All

• .NET Development changing command text of command created by command builder

  Hi! I 'm creating a dataadapters commands using a sql command builder. After setting the commands I want to slightly add insert command text so I write the following: myCommand.insertCommand = myCommandBuilder.GetInsertCommand(); myCommand.insertCommand.commandText += myAdditionalSQL; however, performing an update uppon a data table, I see that the additional sql is not used. Why found it! myCommandBuilder.RefreshSchema(); should be called If only I checked the documentation! This would save me an hour of searching! ...Show All

• SQL Server User defined functions in MSAS

  Is it still possible to use COM based user defined functions in MSAS similar to AS 2000 "use library" statement Or all UDFs must be in a .NET assembly Regards, Alex Sorry for the distraction! Just found the COM DLL type in the combo on the Register Server Assembly dialog. Regards, Alex   ...Show All

• Visual C++ add class - cannot add mfc and atl items

  Hello, the add-class wizard does not allow me to create atl or mfc entries, such as "ATL Simple Object" etc., i.e. the edit fields Name and Location are grayed out and Add does not work. This is even true in a new project, what could be wrong, any ideas thx Alex Hi David, Could you send me a small sample project that exhibits this behavior You can email it to borisj at microsoft dot com. Thanks, ...Show All

• Windows Forms child controls of custom control disappear at run-time

  Hi! I'm developing custom control with two panels. I'll make just only one panel have controls. so, I used 'EnableDesignMode'. below is my code [Designer(typeof(WPCTest.WPCTestDesigner))] public partial class WPCTest : UserControl { public Panel Area { get { return this.panel2; } } internal class WPCTestDesigner : ParentControlDesigner { public override void Initialize(IComponent component) { base.Initialize(component); EnableDesignMode(((WPCTest)component).Area, "Area"); } } } In Designer, user can design Form using custom control (for example, I added a B ...Show All

• Visual Basic How to update timestamp - Please help

  Hello All, I am new to VB.NET (was a VB 6 programmer for the last 8 years). In my database, I have a CreatedBy, CreatedTime field in my "Transaction" table. CreatedBy should be updated with the currently logged on UserID. CreatedTime field should be updated just before the user clicks on "Save". I simply dragged and dropped the "data table" on the form and VB.NET created the grid and also generated all the code for me [Great feature]. However, I do not want the user to type in the value for "UserID" or "Created Time". Instead I would like to do that behind the scenes just before the data is ...Show All

• .NET Development I couldn't find advantage of StringBuilder in .NET 2.0

  I have written a small application to test differet way of appending strings Method 1: Use + operator. Like s = s + " " + str1 + " " + str2 + " " + str3 + " " + str4 + " " + str5 Method 2: Using String.Join. Like s = String.Join(" ", new string [] {s, str1, str2, str3, str4, str5}); Method 3: Using String.Format. Like s = String.Format("{0} {1} {2} {3} {4} {5}", s, str1,str2,str3,str4,str5); Method 4: Using StringBuilder. Here is the tick time I got for 5000 iteration: Method 1: 19438310752 Method 2: 19796152256 Method 3: 48454067568 Method 4: 24874657960 ...Show All

• Windows Forms DataGrid printing tiny data

  I have a datagrid I want to print and I got it to print using the code below from MSDN. Except that the data in the datagrid prints really really tiny you cant make it out at all and the hole section of data starts at the top of the page and is over the darkend top border of the grid and goes down 2 cells and over one.  Its reallly strange I dont know how to go about fixing this.  Hope someone can help,  Thanks    private void btnPrintGrid_Click( object sender, EventArgs e) { printDocument1.Print(); } private void printDocument1_PrintPage(System. Object sender, System ...Show All

• Visual Basic AnalogTVTuningSpace and MSVidCtl

  I´m trying to develop a decent tv tuner/capture application (since there are no such apps, nowhere, I say) in Visual Basic 6.0. I´m using the MSVidCtl component together with the AnalogTVTuningSpace and IChannelTuneRequest object to achieve this, as described here:  http://msdn.microsoft.com/library/default.asp url=/library/en-us/directx9_c/directX/htm/hostingthevideocontrolinavisualbasicform.asp  and here:  http://msdn.micro ...Show All

• SQL Server Report Manager name?

  Hi all, I am not sure is this the correct forum to post this question, but here is the question. Is it possible to have the Report Manager name changed according to different user entry What I meant in Report Manager name is the Name which by default is "SQL Server Reporting Services". I know I can change the name to something else from Microsoft SQL Server Management Studio, but I want it to show for example "XXX's Reporting Manager" when XXX logged in. Please let me know is it possible and how do I go about doing it. Thanks in advance. Daren Unfortunately Report Mana ...Show All

• Visual C# Exception Usage

  I want to know which scenarios to inherit following exception class Exception SystemException ApplicationException Vikram Go to GotDotNet.com and search for "ApplicationException FxCop", you will find a number of posts regarding this, including some responses from Microsoft. I will post a suggestion for this to be updated. ...Show All