Alexey Nayda's Q&A profile
Software Development for Windows Vista tableadapter update inside failed transactionscope doesn't rollback the datatable
I have a number of tableadapters which must update under one transaction. After a transaction failure I notice that the data in the (SQL Server 2005) database has rolled back but the data in the datatables on the middle tier has not. This creates problems as some of the tables contain data on which other data tables are dependent. In particular, identity fields on these datatables are left populated with the identity from the failed insert. Is there a way to accomplish a rollback of data in these datatables without resorting to datatable.clear() followed by datatable.Add[tablename]row Regards. While this may work now, it's still a dangerous and non-scalable way of doing rollback. Can y ...Show All
Smart Device Development Problems with more then 5 CE devices connecting to a webservice
we made a program in .net 2005 for a windows CE device. It uses a webservice to read and write information in a database. Everything works well, till the moment we start working with more then 4 devices. With 4 it works sometimes but with 5 or more after some minutes all devices stop working. They can't connect to the webservice anymore. Does anyone has an idea what could be the reason. Because we need to be able to work with 10 devices. thanks, Bart I would be looking into the server side, e.g. limits on connections, licenses and so on. ...Show All
Visual C# TableAdapter
I'm adding a new datagridview in a windows application and binding a stored procedure to it. However the SP accepts 2 parameters and VS has automatically added a this.rsp_GetStatsTableAdapter.Fill(this.AppDataSet.rsp_GetStats) line and I have no idea how to pass in the parameters. I've also tried editing the dataset designer to no avail. Any ideas Well programmatically, to pass parameters to the SP, this is how I would do it: SqlCommand theSQLCommand = new SqlCommand(" StoredProcName ") theSQLCommand.Connection = new SqlConnection(" ConnectionString "); theSQLCommand.CommandType = CommandType.StoredProcedure; SqlParameter param1 = new SqlParameter("@param1", SqlDbTyp ...Show All
SQL Server Creating Custom Sequence Container
I have a package that is going to have roughly 20 sequence containers in it. Each of these containers is going to have the same start task and the same end task. The data flow task(s) in each sequence container will differ. So I was thinking I would create a custom sequence container that would implement the common steps I need in each of my containers. I started to create a task that would inherit from Sequence, but I found that it is sealed. Bummer. What is involved in creating a sequence task by inheriting from Task I see that Sequence implements IDtsSequence. But looking at this interface, it seems like I would have to build the logic to execute the workflow contained in my sequence. Any pointers -Darrell ...Show All
Visual Studio Express Editions Function trouble
I have a Function that contains a calculation. The calculation pulls a number from a column to the left (let's call it "x"). For some reason it is not automatically calculating when "x" changes. I tried to input a Calculate at the end of the function but it still doesn't automatically change when the "x" changes. Any help is greatly appreciated! The excel worksheet has a selection changed event that you need to attach your code to...so that anytime that cell changes your code will fire: Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'if you need this to happen only when a certain cell changes you can put an if clause in to check the range RFC() End Sub ...Show All
.NET Development Is there a way to get list of all colors?
I need to get list of all system colors from drawing.color and be able loop through them is there a way to do it If you actually look at how this GetStandardValues works under the hood, it uses Reflection to fetch all public static properties of Color, and if it's a get property which returns color, adds it to the list. So, in other words, it looks like your way is probably the easiest. However, Xfolder, keep in mind that this list is not even close to all colors on the system. With 32 bits of color data, Windows supports about 4 billion distinct colors. This list is just the list of named non-system colors. ...Show All
SQL Server SSIS Data Mining Model Training Transform (Nested tables)
I guess this question belongs here rather than Data Mining section.. Maybe... I can't figure out how to put nested tables into the Data Mining Model Training Transform (SSIS). I can do a simple case table, but how do you get those nested tables with DM Training Transformation Any ideas Samples Thanks in advance, -Young K ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Graph shader?
I am trying to draw the FPS in a graph. For that I want to pass the shader effect a 1D texture, but it isnt very simple. I understand I need to use a sampler Does the steps of passing and using a 1D texture (or sampler) similar to those of passing and using a 2D texture Or do I need to do it differently For a 2D texture I have the SetTexture method for an effect, but I dont have the equivalent for a sampler or some sort of a 1D Texture which I dont know about. How do I achieve this Thank you. >> How do I create a 1D texture in DX >> Do I need to create a D3DTexture 2D texture and treat it as if it was a 1D texture Yes, create it like any other 2D texture but with a heigh ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Unable to apply a custom effect
Hello!, I'm asking your help because i'm having trouble when trying to use custom effect in my app. I've made a simpler one with just an untextured and red colored sphere from a fbx file and i still fail when applying even a simple color outputing shader (the one used in the xna custome effect section). I did set the WorldViewProjection parameter to the shader but nothing except my cleared screen appears. But when i use the BasicEffect class my sphere appears. here's the code (Sorry about the line spacing but i don't know why it's so high...please tell me how to correct this to if you know how :p): uniform extern float4x4 WorldViewProj : WORLDVIEWPROJECTION; struct VS_OUTPUT { float4 position : POSITION; float4 color : C ...Show All
Windows Forms how we can get the dataGrid row values....
1)i want to get the all the values which is enter in the rows 2)i want to display the value in the datagrid which i just enter in the textbox and press enter..... thanks Hi Ather, You would have to use: foreach( DataGridRow row in this.myDataGrid.Rows ) { TextBox first = (TextBox) row.FindControl( "_first" ); String input = first.Text; ... } Good Coding! Javier Luna http://guydotnetxmlwebservices.blogspot.com/ ...Show All
Visual C++ /Fx Wont work.
I set its option in project properties, but it doesn't generate any mrg.cpp or mrg.h. It is for a Windows CLR application project. What's wrong Jonathan Caves - MSFT wrote: Our you using any ATL Server attributes Unless you are then /Fx will have no effect. Why ...Show All
Visual C++ Reading XML File and storing into a 3 dimensional CString Array Variable
Hi, In MFC, I have to read a XML File which is having a size of 2 MB. The contents of the XML Files has to be stored into a 3 dimensional CString array variable. The process is very slow. How I can speed up this. In the place of CString array, if I am using a struct data type will it be faster If so how I can use that struct data type. ================Suresh Hi, Firstly why are you using a 3 dimensional array Surely your XML file is just a table of at the most 2 dimensions, or is it more than 1 2d table as per separate records An XML file is usually just text so why not just read it in line by line and split the lines where appropriate etc Do you want a code snippet Regards, S_DS. ...Show All
Visual Studio 2008 (Pre-release) NetMsmqBinding does not Queue
I am new to Indigo. So far, this technology looks like it should be very useful for many of our applications, but am not having much luck with the example code. We are most interested in the asynch possibilities of NetMsmqBinding. The MSDN samples (examples) for NetMsmqBinding are not working for me, though the non-queuing examples do work. Specifically, the "Transacted MSMQ Binding" and the "Transacted Batching" examples at MSDN Library > .NET Development > Samples > Windows Communication Foundation Samples > Windows Communication Foundation Technology Samples > Basic Windows Communication Foundation Technology Samples > Binding Samples > Net Binding Samples > NetMsmqBinding Samples (whew! ...Show All
Visual C++ Error: Stack corruption around the variable 'tm'
Hi, I have a win32 based application written in VC6. However, when I port it to VC2005 express edition, i get runtime check errors in the following way. Run-Time Check Failure #2 - Stack around the variable 'tm' was corrupted Run-Time Check Failure #2 - Stack around the variable 'lpText' was corrupted. The application works perfectly in VC6. As this has been tested using profiling tools such as Numega Bounds checker. Only on .NET versions 2003 and 2005, i get above such error. I use the following settings for my project: /D "WIN32" /D "_DEBUG" /D "_LIB" /D "_VC80_UPGRADE=0x0710" /D "_MBCS" /FD /EHsc /MTd /Zp1 /Fp".\Debug/mmi.pch" /Fo".\Debug/" /Fd".\Deb ...Show All
Visual Studio 2008 (Pre-release) Monitoring WCF Service
Hi, Is it possible to monitor data sent and received from each WCF Service I have a console application that create a new WCF Service for each customer ( i.e. same WCF Service but using new appDomain with new app.config ). I'm using QuickCounter for performance monitor for each WCF Service, but now I need to monitor data sent and received for each WCF Service. The current Performance Counter of WCF is global ( i.e. for all services hosted on machine ), but I need for a specific WCF Service. ( IIS does it for each site very well ) Does anyone know how to do it Regards, Alexnaldo Santos Hello, Have you tried enabling message logging via config, by putting the required config entries i ...Show All
