scdlewis's Q&A profile

• .NET Development Exception: DataTable internal index is corrupted: '5'. on ...

  Hi, I have a problem with bindingsource component in framework 2.0. I have a combobox bound to a bindingsource which is also bound to a dataset with 2 related tables and a datagridview bound to the same bindingsource. What I want to do is : When the selectedindex property of my combobox changes, the corresponding cell value must be changed in the datagridview. But although the value in bindingsource changes, datagridview does not display the new value. That value is displayed after I move the mouse over that cell and make it invalidate its region manually. Another error I caught is the one that you can see as the subject of my post. I do not know why i have that message when I try to change the property of ((DataRowView)mybindi ...Show All

• Visual C# How to change the formatting of System.DateTime.Now without convert to string type

  Does anyone know how to change the formatting of System.DateTime.Now, but not have it outputted to a String type. I have a SOAP webservice element that only accepts a dateTime type and format similar to this: 2006-12-04T17:21:42.788Z I'm using the following code below, but need to change its formatting to conform to the sample above: meterRequest.serviceRequestTimeStamp = System.DateTime.Now; Thanks, Henry If the function requires a DateTime object, where does the ToString come into play Data access functionality internally is not done by ToString() but by specific properties which return integers. If you need to format a string to a specific output, then you will need to use ToString with format specifie ...Show All

• SQL Server BCM with accounting 2007

  I have bcm with outlook 2007 and accounting express. when i create an opportunity in bcm, everything is fine. when i click the convert to quote button, it dumps all of the item information (quantity, name, description, price, tax....) into the description field in accounting. Then I have to copy each piece out of the description field into it's appropriate field in accounting 2007 express. Where is the mapping for these fields, so that I can map each one correctly Is there something else i should be doing ...Show All

• SQL Server Converting a date in the form of a string to a datetime format

  Hi, I'm writing some SQL and want to convert the following expression into a date format in the SELECT list: '01/'&Month(OrderDate)&'/'&Year(OrderDate) Basically, I want to look at each order date, convert that date to the first of that month and GROUP BY this expression. There is a CONVERT function, but I'm new to all this and can't seem to get it to work. Any help would be gratefully received! Cheers! Keith you can group by without having to transform the date and that is done like the example below use northwind select year(orderdate) as year, month(orderdate) as month , count(*)as ordercount from orders group by year(orderdate),month(orderdate) order by 1,2 ...Show All

• Visual Basic Trying to Do an inplace Update of Rectangle Objects stored in generic List

  This is a strange one for me. What I have is a List(Of Rectangle) that are each 200 by 200. I want to be able to go through the list iteratively, change each ones location to being 10 pixels to the right and 10 pixels down and then shrink their size by 20 on each dimension. Initially, I planned on something like this: Private Sub prepareMenuSquares( ByRef squares As List( Of Rectangle)) For Each thing As Rectangle In squares thing.X += 10 thing.Y += 10 thing.Width -= 20 thing.Height -= 20 Next End Sub I assumed I would be passing the List by reference and then would have access directly to the Rectangle objects themselves and could do an inplace modifcation, no problem. Well that didn't work a ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Does LPD3DXMESH have built in values I can adjust manually?

  I have my CUBE.x loaded into LPD3DXMESH object. Are there specific flags I can set for the entire object Like I want to translate/rotate/scale just this object in the view of my camera. I don't want these changes to affect any of my other loaded models. Are there local axises that I can alter Well, actually things are the same for multiple models scene, D3DXMatrixTranslation here is really useful Try this code (it looks very familiar, doesn't it ) static float DistanceZ=1.0; D3DXMATRIXA16 mWorld; D3DXMATRIXA16 mTrans; D3DXMatrixTranslation(&mTrans, 0, 0, DistanceZ); DistanceZ+=0.05 ;//try to change this value mWorld=mWorld*mTrans; pDevice->SetTransform( D3DTS_WO ...Show All

• Visual C# Problems with a DLL

  hello all, I've been receiving an AccessViolationException whenever trying to pass a couple of parametres inside a function placed in an external DLL: public partial class soldsk { [DllImport("C:\\...myProject\\\\bin\\Debug\\myDLL32.dll", EntryPoint="sendtram")] public static extern int SC_sendtram(int hwnd, int port, int pasdereponse, int vto, string Commande, ref string Reponse); } ... //some code Ret = (short)soldsk.SC_sendtram(hwnd, port, 0, 0, command, ref rep) (when command and rep are strings of a fixed length) Obviously, when I leave out the 'ref' keyword, it all goes smoothly, but the parameter rep is not affected by the DLL method (who normally gives it a new value). Hope this was clear enough- if not just let me ...Show All

• SQL Server Reporting Service interoperability

  Hi, I'm evaluating Sql Server 2005 for my company. Here we also use AS400 DB2 for our ERP. Could I use Reporting Service to create report on DB2 in the same way as someone could use MS access TIA Marco Paci Yes. You need to go to the IBM web site and download the db2 drivers. I think the package is IBM DB2 Client Access Enabler (CAE). You then need to write your DB2 SQL in the report which can get kind of hairy. If I can get away with it, I write SSIS packages and write the reports using SQL Server. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. .fbx vs. .x

  1) I've had virtually no luck getting the output of the AutoDesk convert-to-fbx tools to load into XNA successfully. Judging from the AutoDesk conversion tools, there are a number of .fbx variants in play. Maybe I'm converting to the wrong flavor of .fbx. Which variant does XNA like the best 2) In general XNA seems to like .x models better than .fbx models. What editors beside Blender produce .x directly Thanks for any insight. Cheers, Scott Me too. From maya to fbx and XNA. I've experienced problems with transforms into the fbx file, but I think that it's my lack of modeling talent. I don't know if there any differences between fbx and x. I'm not sure but I think that these two formats con ...Show All

• .NET Development Overhead of Serialization

  Hi, What level of performance effect does Serialization/Deserialization gives opposite to direct consumption of Objects/Interface I am talking about scenario on WEB when we have Presentation Layer, Business Layer , Data Access Layer in picture and we want to make the architecture SOA Extendible. Thanks There is a cost to pay but .NET framework is optimized for it. To use or not use webservices is a performance vs extensibility/interoperability discussion. Webservices alone dont enable SOA. SOA is a collection of patterns around service modelling. Webservices is just one of the technologies involved. You will find tons of articles on the web/msdn/pnp websites. Check out http://www.microsoft.com/patterns or http://msdn.microso ...Show All

• SQL Server Processing a dimension using AMO does not work if the connection to the “DataSource” used is “SQL Server Authentication”

  Processing a dimension using AMO does not work if the connection to the “DataSource” used is “SQL Server Authentication” amoDimension.Process(ProcessType.ProcessFull)   The following exception is returned: -                        ex          {"OLE DB error: OLE DB or ODBC error: Login failed for user ' MyUserId '.; 42000. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'MyDataBase', Name of ' MyDataBase'. Errors in the OLAP storage engine: An error occurred while the dimension, wit ...Show All

• SQL Server FTP task - StopOnFailure not working as I expect?

  Hi I'm using an FTP task in a loop to download files from a WAN based FTP server. I've got a script to generate the name of the file I require and place into a variable. Problem is sometimes some of the remote files haven't been published so the FTP component errors and the package fails. I tried setting StopOnFailure to False - all I get is the following errors [FTP Task] Error: File represented by "User::RemotePath" does not exist. [FTP Task] Error: Attempt to read message string for 0x80020918 failed with error 0xc02090f3. Make sure all message related files are registered. What I want to do is ignore the error and perform the next loop iteration Is this a bug, or am I missing something Dave ...Show All

• Visual C++ how to invoke a progress bar after firing a command button from a dialog box?

  dear all, i have made a progress bar which works as desired if placed on a dialog box. so no issue. but i wanted for a better user interface that the progress bar should only appear , once i press a command button for an action that takes some time to complete. (e.g say i press button A to do a task B which takes some time. so till task B is happening or giving a feedback that it takes time to coplete i fire a progress bar..) 2. solution i found out. i created another dialog box called as progress bar dialog box and created a progress bar for that .and wrote code on OnInitDialog of the dialog box m_progressbar.SetRange(0,100); m_progressbar.SetStep(2); m_progressbar.SetBkColor(RGB(255, 0, 0)); for(int i=0;i<50;i++) ...Show All

• .NET Development Where is the SqlContext.GetConnection method ?

  I want to use SqlContext.GetConnection method from System.Data.SqlServer namespace, but there is no SqlServer namespace anymore. I've read that all code was moved to System.Data.SqlClient namespace but GetConnection method vanished. I want to return rows from C# dll library (sql server assembly) to application written in Delphi. I use SQL Server Authentication. Is there any similar method Regards KonRi. I know but first I need to create SqlConnection , to execute SqlCommand , so I need GetConnection or similar method. Is there any similar method ...Show All

• Connected Services Framework Events and Sessions

  Hi, I have one question regarding events and session. I have a session and inside it there are two services, namely A and B. Service A subscribes to an event of service B. A then requests B to execute an operation. After B finishes that operation it fires an event using the Push delivery (PushDeliveryMode class). This event doesn't get into the session but gets called directly on A (avoiding all the routing rules). My issue here is I would like to route the event from service B to service A using a Intercept service in between to perform some changes on the event and then route it forward. What I'd like to know is: Is it possible for session to catch events (WS-Eventing based) and route them accordingly to the session routin ...Show All