Snickel65's Q&A profile

• Visual C# Visual Studio 2005

  Hi, I am running Visual Studio 2005 (Professional Edition). When I change IDE colors from Options, like "Memory Changed" and open the memory window in a debug session the new color is not applied (ie the default color is applied). What's wrong The memory window does not honor the font/color options you select in the options dialog. Whether this was an oversight or a bug that was of low enough priority to get bumped I don't know. It hasn't been fixed as of SP1. However the colors for the text editor should work just fine. I'm not aware that this has been reported to MS at all. Then again maybe the memory window requires something extra. I've tried modifying values from a program and within the debugger it ...Show All

• SQL Server How do I update a SQL Table from a spreadsheet in EXCEL using VBA

  I am a new programmer trying to write some VBA codes in excel to get data out from the Sql server database, edit/update the data in EXCEL, and then update the SQL server database with the updated information. Any help would be greatly appreciated. Thanks. There is no connection between SQL Server and Excel. Excel stored information positional, SQL Server relational. You will have to do all the code to update the database on your own, for information about getting data written to SQL Server using VBA, simply search the web for "ADO EXCEL VBA SQL Server". You will get tons of links for that. HTH, Jens SUessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Tools for Office Performance question

  If I understand the process correctly, accessing any Office object or property from managed code will suffer an interop penalty. I have ancountered this issue in my .NET add-in (IDTExtensibility2, Word 2003, .NET 1.1 SP1): It adds several items to context menus (and there are a lot of them!). A function that ran over all the context menus, found our items (by tag) and enabled/disabled them took over 10 seconds to execute. I had to replace it with a macro call, which ran much faster. Question #1: Is such a penalty unavoidable with manage code or did VSTO (any version) manage to improve it. Question #2: If C++/CLI native interop is significantly faster, is it possible to use it with VSTO and isolate areas that do a lot of COM ...Show All

• SQL Server Inserting global variables storing values in a table

  Hi, I need a resolution of the following issue: Following SQL is to be inserted in an audit table : INSERT INTO GLOBAL_VARIABLE_LOAD ( [LOAD_ID] , [LOAD_STATUS] , [START_TIME] , [END_TIME] ) VALUES ( @P_LOAD_ID , @P_LOAD_STATUS , @P_START_TIME , @P_END_TIME ) @P_LOAD_ID , @P_LOAD_STATUS , @P_START_TIME , @P_END_TIME are the 4 parameters mapped to global variables (At package Level) which store values mapped in a previous SQL Task in my control flow. Following Error Message is thrown on executing the SQL Task: Invalid object name 'GLOBAL_VARIABLE_LOAD'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameter ...Show All

• Visual C# help with DataTable.AcceptChanges()

  hi all. in my code i wrote: dataview MyDv=new Dataview(MyDataTable); MyDv["SomeColumn"]="xxx"; and here i enter a new row directly to MyDataTable: Datarow DrNew=MyDatatable.NewRow(); DrNew["Column"]=xxx; MyDataTable.Rows.Add(DrNew); do i have to use MyDataTable.AcceptChanges() to get the changes i enterd in the MyDv Before i add a new row do i have to use Mydv.BeginUpdate() and EndUpdate() before i change it's data No your code for adding a new looks good. When you add a new row it's RowState property will be Added, etc.... The AcceptChanges() method changes the RowState of all rows to Unchanged. You don't need to call this before you add any row. It's use is for validation, rollback, pushing c ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DBP Submission Platform

  I have a question about the dbp challenge. My xbox360 has just fallen prey to the dreaded " three flashing red lights on the ring of light " issue and, I suspect, will have to be sent in for service. I'm working with support and awaiting their response, but that's not really the issue. I really really wanted my game to be cross platform such that the same code-base built for both windows and xbox360. Would I be penalized if I my submitted solution had projects for both xbox360 and windows, and the xbox360 version was borked I mean, I think I've gotten a pretty good appreciation for what issues must be taken into account when developing for the 360, but since it's out of commission for the time being I obviously wouldn't be able ...Show All

• Visual C# propagation of user-type objects through a webservice

  Hello, here is my problem: I have written a webservice with several methods that shall be called by a client application and return data in the shape of a user-defined type. This type contains two string arrays and some numerical information and is defined in a dll. The problem shows up when i want to compile the client; i get the error message: Argument '1': cannot convert from 'Conformity_FTP_Client.localhost.ActualDirInfo' to 'Conformity_FTP_Tools.ActualDirInfo' Here is the critical part of the client sourcecode: I'm no remoting guru but I believe you have to have the business object (dll) on both sides of the web service equation. That's the reason for Data Transfer Object (DTO's). So you'll have to deploy the bus ...Show All

• SQL Server Query Parameter Value Type

  What is the attribute/element (such as ValuesTypes, ParameterValuesType..) I should refer to Query Parameter - Value according to the RDL XML Schema Definition as the following example <QueryParameters> <QueryParameter Name="@CompanyName"> <Value>=Parameters!CompanyName.Value</Value> </QueryParameter> </QueryParameters> Thanks a lot. Thanks for reply to my post. What I am looking for, is the type of Attribute/Element I should refer to, for QueryParamater -Value. In your post, for example, your ValueField (attribute or element i'm not sure about it well) is refer to ItemChoiceType31.ValueField, and DatasetName is refer to ItemChoiceType31.Datas ...Show All

• Visual Studio Express Editions Different Coloured Brushes

  How do I change the brush colour so that each square is different I was thinking of using an array, Dim arrCol() As String = {"Red", "Yellow", "Green"} but string can't be converted to system.brush. I tried Dim arrCol as System.Brushes, but that doesn't work either. So any ideas please. Here's the code, Dim B1 As New Bitmap(146, 92) Dim G1 As Graphics = Graphics.FromImage(B1) Dim PB As New PictureBox Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim X, Y, W, i As Integer X = 0 Y = 0 W = 128 For i = 1 To 40 G1.FillRectangle(Brushes.Blue, X, Y, 16, 16) X += 18 If X > W Then X = 0 ...Show All

• Software Development for Windows Vista Workflow event does not get fired

  Workflow event does not get fired Do you have UnloadOnIdle set to true If so, this is expected behavior assuming that the event has not been fired yet. When the workflow becomes idle it is unloaded. If an event comes in for the workflow the runtime will load the workflow and deliver the event. ...Show All

• Visual Studio Express Editions VB Ignoring changes in designer

  I made a change to my program (moved a button) and accidently pressed F6 instead of F5. my vb did something, because now if i make a change like move something it always runs the old version from when i pressed F6. also, when i change the code it doesnt save it like if i added msgbox ("boo") to form1 load, where before it was blank, and i run it, id get no messagebox just what was there before. Also this happens in other projects Please help!! Thanks! What F6 does depends on your Visual Studio settings, but in most cases it simply moves to the next document or panel. So it should not have done anything to your application. The only thing I can think of that may have happened is that somehow you are running a version that was co ...Show All

• Windows Forms VB.NET 2005 *ERROR* DESIGNER LOADER DID NOT PROVIDE ROOT COMPONENT

  I am getting an error with the VB.NET 2005 in the Design stage of my application. The Exact error message occurs after I double click on a control to enter some VERY simple Code. One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. The designer loader did not provide a root component but has not indicated why. I am using LEADTOOLS Rasterimage PRO v14.5 for .NET also in the application, but I have gotten this message when working with JUST VB Controls. Also I when working with controls the screen will not refresh properly. I am ONLY starting this application now and I a ...Show All

• Visual Basic I need ur help in my project ... tree view

  Hi Every one !! i'm new VB.net(2003) Programmer and i need ur help.. i'm having a tree view in my form and i want to print this tree . how can i do this Notice that : if the tree is very lond i hav 2 continue printing in another paper. of course the line which connect the tree nodes should be dashed; this is very easy can be done by the following peice of code : Dim pn As New Pen(Color.Black) pn.DashStyle = DashStyle.Dash plz add ur code which can do this or add a link which maybe can help ... thanks every one !! again thnx Richard, ok man how we can convert the tree view( and not the whole form) to an image and then print it and the captured image will be printed in one paper or more let us use : drawtobitmap. i dont kn ...Show All

• Visual Basic Launching a .exe prgram from within a VB program

  Howdy, I am wanting to write a simple program to launch my application from a button, basically like the old Office launch bar. what i would like is that i press button X, and it loads microsoft word, I press button Y and it loads Half Life. I have been playing with system.io but i dont seem to get it...lol Thanks in advance. Dwayne Schaffarz Imports System.Diagnostics; ... in button_Click event add something like this: Dim HalfLife as New Process HalfLife.StartInfo.Filename = "Filename to Halflife" HalfLife.Start() This lines have to run HalfLife. ...Show All

• Visual Basic Date and Time Format Problem

  Question one May i know is there any time picker in VB.NET 2005 which allows user to enter a time The DateTimePicker can only retrieve current time and i think of using few combo boxes to form the format like hour,sec and AM or PM. Apart from that, is there any other way of doing it If i use the combo boxes method, how to parse the concatenation string as time and store in database   Question two I allowed user to select a date from DateTimePicker and format the date as the below and store it in database.   FormatDateTime(join_date.Text, DateFormat.ShortDate)   The datatype of that column i set it to string in order to prevent any format error. One problem is that the time format (DD/MM/YY) appea ...Show All