Bachmo's Q&A profile

• .NET Development Serializing array SOAP

  I try to send array from SOAP server to client. Function GetAccounts(..) returns array of 2 dimensions, but client receive array with only 1 dimension... How i can to fix this bug [code] private Account[] GetAccounts(string UserID) { using (DbManager db = new DbManager(".Ora")) { List<Account> result = new List<Account>(); using (IDataReader dr = db.SetCommand(@"SELECT acc.ID, acc.Amount,acc.AccountLimit, oacc.Name AS AccName FROM Account_ acc JOIN Object oacc ON oacc.ID = acc.ID WHERE acc.PartyID = ( SELECT oa.ObjectID FROM ObjectAttr oa JOIN ObjectTypeAttr ota ON oa.ObjectTypeAttrID = ota.ID AND oa.Value = UserI ...Show All

• Visual Basic Help with dll

  How would i do these calls in vb.net ////////////////////////////////////////////////////////////////////// // -- MXSock.dll -- // WinMX WPNP Support Dynamic Link Library Header File // Copyright 2004 [Nushi]@[2SN] ////////////////////////////////////////////////////////////////////// #pragma once ////////////////////////////////////////////////////////////////////// // includes ////////////////////////////////////////////////////////////////////// #include <Windows.h> ////////////////////////////////////////////////////////////////////// // Export or Import Switching ////////////////////////////////////////////////////////////////////// #ifdef _MXSOCK_DEV_ #define MXSOCKAPI extern "C" __declspec(dllexport) #else #de ...Show All

• Windows Forms IPersistComponentSettings example for component

  Hi I've been looking into the Net 2.0 features for saving settings, in particular, how you use it for Custom Controls. I've got a couple of questions that I haven't been able to find an answer to yet. 1. When we say "Custom Controls" we're not simply talking about classes that inherit from Control are we It also includes components doesn't it I'd like to take advantage for the settings architecture in some non visual components as well. 2. The "Application settings for custom controls" http://msdn2.microsoft.com/en-us/library/6a0381s6.aspx doc is really quite confusing. The way I read it is that a. Your main control should implement IPersisteComponentSettings if you want it to fit in with the features of the Wi ...Show All

• SQL Server Trigger isn't showing in folder!

  Hi, I selected create trigger from the tables pop up menu. I created a trigger for the dbo.sysjobhistory table in the msdb database. When I click the parse icon it comes back with success. When I check the trigger folder under the sysjobhistory table the the trigger is not there. What am I doing wrong FYI, here is the trigger code: CREATE TRIGGER dbo . email_on_job_fail_INSERT ON dbo . sysjobhistory FOR INSERT AS IF EXISTS ( SELECT run_status FROM inserted WHERE run_status = 0 ) BEGIN DECLARE @cmd VARCHAR ( 1200 ) SET @cmd = ( SELECT step_id , step_name , sql_message_id , run_date , run_time , server , message FROM inserted WHERE run_status = 0 ) EXEC master . dbo . xp_ ...Show All

• Visual Studio Team System Anyone using TestToolsTask-1.1 ?

  TestToolsTask-1.1 is the new task that Buck Hodges posted to allow test running without owning the VS test version. I am having some problems with it. I have replaced the Original TeamFoundation targets and also added the PowerToys assembly to the PrivateAssemblies folder. I have the following set with the .proj file: < RunTest > true </ RunTest > And then I have the following: <MetaDataFile Include=" "> <TestList> </TestList> </MetaDataFile> --> < TestContainerInOutput Include = " %2a%2a\%2aTest.dll " /> Since I have everything configured correctly I am not sure why my tests aren't being run. I assume TestContainerInOutput is suppose to fin ...Show All

• Visual Studio Express Editions How do we connect and use remote SQL Server 2000 Datbases

  I have an existing SQL 2000 database I have access to and want to use the tables within it. Express shows only ./SQLEXPRESS as the only database method to use. Can we not add other source to this Just use the rigth SQL-Connectionstring. You will get it at http://www.connectionstrings.com. Then just define a new SQL Connection like this: Dim cnSQL as new SQLClient.SQLConnection([Here goes your Connectionstring]) . . . cnsql.open . . . ...Show All

• SQL Server Merge Replication-Apply BCP files

  How can i apply a BCP files generate by Distributor in the Suscribers. I don’t know wich parameters BCP.EXE need. Thanks I need to manually apply because there is few information, and i've configured suscription with the option to no send the schema tables. I've configured the replication via internet (is slow for a very large tables) But now i need to send data to the suscribers. Thanks ...Show All

• Software Development for Windows Vista How to retrieve value of ActivityInstanceId (or Activity's ContextGuid) from an HandleExternalEvent1_Invoked method?

  I have a StateMachineWorkflowActivity where each state contains a EventDrivenActivity, HandleExternalEvent, and SetStateActivity. In the HandleExternalEvent1_Invoked handler, I want to be able to access the ActivityInstanceId (or Activity's ContextGuid) value   How can I do this (ActivityInstanceId is the name of a field in the ActivityExecutionStatusEvent SQL tracking database table.  An Activity's ContextGuid appears to server a similar purpose.) Michael. private void HandleExternalEvent1_Invoked( object sender, ExternalDataEventArgs e {     TaskActionSentEventArgs e2 = ( TaskActionSentEventArgs )e;     Console .WriteLine( "HandleExternalEvent1_Invo ...Show All

• SQL Server Reading Records from Excel File

  Hi all, Whilst reading in records from an excel source via the SQL command method I've stumbled across a problem. my SQL query takes in all records where the date column is not NULL, this ensures that only populated rows are obtained. If the date is in a format that is incorrect i'd really like the whole data flow to fail. However... What seems to happen is that any rows with a fault in the date column are just missed out and not pulled through the pipeline. I have tried changing the error output from fail component to ignore error and redirect row but nothing seems to catch it. Does anyone have any suggestions as to why this may be the case Many thanks, Grant The field is converted to a NULL by the driv ...Show All

• SQL Server SQL Server 2005 Management Studio Annoyances

  I have two annoyances about the Table grid editor on SQL Server Management Studio. (1) Whenever I am editing the value of a cell and press SHIFT + SPACE at the same time, the cursor jumps out of the cell. So when I want to type two words with capital letters following each other e.g. "ABC DEF"; thus, for every space, typing has to slow down. This behavior was different in 2000. Any way to disable this "feature" (2) It appears impossible to select and resize multiple columns in the table in the same way as in Enterprise Manager 2000. Is there still some way to resize multiple columns I have overlooked I know these things may seem like a small deal for some, so thanks for any advice anyway in advance. ...Show All

• Visual Studio 2008 (Pre-release) Authentication issue when WCF service is hosted in a windows service

  Hi, I created a WCF service and hosted it in a console application. I tried accessing the same from a remote machine on the same network. It worked fine without any issue. But when I tried hosting the same in a windows service, I get an error "407, Proxy Authentication Required". Not quite sure why it didnt show up when hosted in console app.. How do I resolve this Thanks Sai Yes. Thats exactly what I am trying to do. I have hosted in an NT service on one machine and I am trying to access it from another machine. By the error it does appear to be credential issue, I am not sure how address the same in the code. ...Show All

• Windows Live Developer Forums Contacts not adding suddenly...

  Basily what the title says. i've been using live for a long time now with no issues thus far. however now all of a sudden, its giving me all kinds of issues adding people to my contact list. i add them, yet the "request" isn't going through to them on their side... any idea why this is happening no more then 2 weeks ago i've added multiple contacts with no issues, however anyone i've tried to add within the last week or so hasn't worked. i went back to msn 7.5 untill i fully understand this situation thanks a lot. rob Same problem here. The problem has just manifested itself in the past coupe of weeks. Maybe some weird server problem with not refreshing or something. Im goin to get back to 7.5 be ...Show All

• Windows Forms Concurrency problem when setting control value in code

  When I set the value of one bound control on a form from the AfterUpdate event of another, I get a concurrency exception when I try to update the table adapter: System.Data.DBConcurrencyException was unhandled   Message="Concurrency violation: the UpdateCommand affected 0 of the expected 1 records."   RowCount=1  In this example, there is a combo box listing status codes.  When a code is selected, a status code date field gets updated to the current date/time.  This causes the exception when updating.  There is no conflicting user entry of this field to cause the exception. What is causing this problem and how can I avoid it ...Show All

• Visual Basic Sum on a listview

  I've the following code to populate a listview with records from my database: Private Sub preencherListView() Dim lstItem As ListViewItem Call conexao() sSQL = "SELECT * FROM [TempoTotalFamiliaQuery] WHERE (Data LIKE'" & dtpDataRelatorio.Text & "')" da = New OleDb.OleDbDataAdapter(sSQL, con) da.Fill(ds, "TempoTotalFamiliaQuery") For i As Integer = 0 To ds.Tables("TempoTotalFamiliaQuery").Rows.Count - 1 lstItem = New ListViewItem() lstItem.Text = (ds.Tables("TempoTotalFamiliaQuery").Rows(i).Item(0)) lstItem.SubItems.Add(ds.Tables("TempoTotalFamiliaQuery").Rows(i).Item(1)) lstFamilias.Items.Add(lstItem) Next l ...Show All

• Visual Studio Tools for Office How do I create a "global" solution for Excel or Word 2007 using VBA?

  It looks like VSTO is great for producing global "Add-In" solutions for Office applications. What's the best way to to use this "Add-In" style model using VBA instead of .NET How do I create a "global" solution for Excel or Word 2007 using VBA Thanks in advance. --Nick Hi Nick I'm not sure what you mean by "global" exactly. Word supports template addins and Excel xla addins. you can look up discussions about these in the relevant VBA newsgroups as listed in the " Please Read First " posting at the top of this forum. ...Show All