Barzot's Q&A profile

• SQL Server How To Import Access to SQLServer with Parameter from SQLServer, Help Pls!

  Hello Expert! I have 2 Database – Access & SQLServer(ver 7) I need to Import Data TblShift from Access to SQLServer – using DTS I’ve done this successfully! Now I want to use parameter so I only importing record within range (e.g. ShiftDate BETWEEN 05-24-2006 AND 06-23-2006) In SQLServer, I have created table to store the date range as following: TblParameter DateFrom: 04/24/2006 DateTo: 05/23/2006 How do I use the date range from TblParameter(SQLServer) to import record from TblShift(Access) using DTS Is this possible or any better solution for this TIA Regards, have you tried using the ole db source component If you use a parameterized query, you can map variables to param ...Show All

• .NET Development Problem reading 2 XML documents via Stream

  I have a winform which has a method that calls an XML doc and read the data inside using XMLReader class. On the same form, I also another function that calls another XML doc, using XMLReader class as well. The structure for both XML docs are similar. I can successfully read the data on one method but failed to do so with another. Is it because I have 2 docs connected to the form Below is my XML docs lookalike: Doc#1 to store list of user and Doc#2 to store calendar events, todo. Doc#1: <doc> <response>1</response> <userlist> <user> <username>Mikey</username> <name>Michael Philasano</name> </user> <user> <username>Jon Arc< ...Show All

• Visual Studio 2008 (Pre-release) Another ArgumentNullException - can we check expressions at compile time?

  I saw this reported previously, but wanted to report another occurence. When I run the query against an in-memory array, it runs fine. When I run against SQL, it fails: FAIL:System.ArgumentNullException: Value cannot be null. at System.Data.DLinq.ProviderBase.SqlUnary.set_Operand(SqlExpression value) at System.Data.DLinq.ProviderBase.SqlUnary..ctor(SqlNodeType nt, Type clrType, ProviderType sqlType, SqlExpr ession expr, Expression sourceExpression) at System.Data.DLinq.ProviderBase.QueryConverter.VisitAggregate(Expression sequence, LambdaExpression lambda , SqlNodeType aggType, Type returnType) at System.Data.DLinq.ProviderBase.QueryConverter.VisitSequenceOperatorCall(MethodCallExpression mc) at System.Data.DLinq.ProviderBase.Query ...Show All

• .NET Development Remove Empty tag from XML file

  Hi All, I have a xml document which has one empty element. I want to remove/delete it using aspx page. e.g. Xml file is in this format <abc> <xyz> <efg/> </xyz> </abc> In the above exampele I want to remove <efg> tag It depents. You could do a simple string replace ( xml.Replace("<efg/>", "") ) or you could load it into an XmlDocument instance, get the node and remove it from the parent node and save the whole XmlDocument again. ...Show All

• Visual Studio Express Editions Save

  How do I Save a file with out calling the dialog box, at the moment I can SaveAs the file(with dialog box) but what I'm after is when you click just save it just saves the file that is opened in its original format with any alterations that have been made. The program is a cut down version of a text editor. When you use the dialogbox you presumably have something like: If SaveFileDialog1.ShowDialog = Windows.Forms.DialogResult.OK Then ' some code to save the file End If To save it without the dialogue then just put the code you run there into your Save button click event, replacing the dialog.filename property with the name of the file you opened originally. Or am I missing the poin ...Show All

• .NET Development WebService - Passing page as a byref parameter

  As far as I could tell this is the best forum...apologies if it isn't. It is our task to dynamically change label and link texts on web pages based on login info. We must do this for several hundred pages every time they load. It seems a web service would be the most centralized method of accomplishing this, unless there's a tweak for global.aspx. The method I would like to use is to pass the page into the service by reference, change the texts inside the service, then return the page. My question is, how can I pass an aspx page by reference into a web service (or accomplish anything similar) If I need to elaborate more please let me know. Basically, depending on which client is logged in, we n ...Show All

• Software Development for Windows Vista Signed dll won't load

  I'm having a problem with a com dll after it is signed. Once we sign the dll, it will no longer load. Without the signing it works fine. I've never seen a problem with signing before, so I'm not convinced that is the problem, but I can't see a problem anywhere else. I've tried regsvr32, called CoCreateInstance, and they all hang when trying to load the dll when it is signed. Any ideas on what could be the problem would be greatly appreciated. Thanks, Anthony This turned out to be a bug in .Net 1.1. We have reported it to Microsoft support and have acknowledged that there is a problem. Anthony ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Architectu "push" vs. "pull" model

  Xna.Input.Keyboard has no events OnKeyUp and OnKeyDown, so I can't subscribe any object on this events using delegates. Is any reasons - why I know that I can do this by myself (examine the keyboard state every Update and call those events), but it's an ideological/archetectural question: I don't want to "pull" keyboard every time, I need my objects to be "pushed" on a keyboard event. In general, "push" model improves scalability and maintainance of a system since It's syncronous - each object reacts the event immediatly when event call occur. My guess on this would be this - 1: Not everyne wants/needs the push model you describe. Whilst it might not be the most inneficient thing in the wor ...Show All

• Visual Studio Tools for Office connecting excel file to C++ program

  Hi every body I am a new programmer and I have been studying C++ for one semester. I know how to link and use files with these extinsions (.dat , . txt). However, I need to know how to connect excel spreadsheet with my C++ program "win 32 console application" and then I need to read my input from this spreadsheet and produce my output on it. I searched a lot but I did not find any thing. Actually, I do not know what is the solution for my problem, is it a code or a tool or something else If there is any one who can help me, I will be thankful. Moreover, If there is a refrence or a book that helps me ,please tell me and I will be glad to study it. I use MS Office 2003, Visual Studio 2005. Sorry if my question seems sill ...Show All

• Visual C++ New Thread can't update edit box

  I have a simple MFC dialog app with one dialog. I have 3 buttons and 3 edit boxes. When I click each button I start a new thread which increments one of 3 global variables - 1 counter for each edit box. I want to see the counters being incremented in the edit boxed but I have a problem. In the 'thread' function I cannot seem to get SetDlgItemInt to work: like so: UINT Thread1Proc( LPVOID Param ) { while (1) { count ++; SetDlgItemInt(IDC_EDIT1,count); } } The 'SetDlgItemInt(IDC_EDIT1,count);' works elsewhere but not in the code for the new Thread. I keep getting compile errors like error C2660: 'SetDlgItemInt' : function does not take 2 arguments etc... Why is this and how can this be resol ...Show All

• Software Development for Windows Vista Embedded designer and custom activities (dll and .xoml)

  Hi! I'm currently testing the embedding of the workflow designer. Like the Hands-on Lab 10, I have my workflow designer embedded in a windows Form and An activity designer too. I have a dll with all my custom activities. There are loaded in a toolbox with the ToolboxItems.txt Sample: Hi Antonie, If your "activity" is Xoml only, then it is not a custom activity. It is just a workflow definition. In order to add activities to toolbox, you will need to compile the xoml (have a x:class attribute in the xoml) and then add it to the toolbox. Thanks, VIhang ...Show All

• SQL Server Permissions in SQL Server 2005 to allow users to view the Management Activity monitor?

  For SQL Server 2000 we have a user login mapped to msdb with database role membership of db_datareader and public checked. This seems to allow the developers to view the Management Activity monitor. For SQL Server 2005 the same mapping is in place but the developers cannot view the Management Activity monitor. Developers are NOT granted the sysadmin role, and should not have that role. What permissions need to be set for SQL Server 2005 to allow users to view the Management Activity monitor They should not be allowed to take actions on the activities. The easiest way is to just open a connection (i.e. using sqlcmd or Management Studio) using your sysadmin credentials and issue the following statemen ...Show All

• Visual Studio 2008 (Pre-release) Determine service endpoint types

  Hi, I currently have a a service behavior that in the ApplyDispatchBehavior method iterates over the endpoints of the service adds an EndpointBehavior to them. The issue is that i dont want to apply the EndpointBehavior to the MEX endpoint as it is not needed there. Is there a way to determine when interating over the endpoints if the endpoint is the mex binding and therby not applying the behavior to it Thanks Dave Thomas, I ended up doing the following: public void ApplyDispatchBehavior( ServiceDescription serviceDescription, System.ServiceModel. ServiceHostBase serviceHostBase) { foreach ( ServiceEndpoint serviceEndpoint in serviceDescription.Endpoints) { ...Show All

• .NET Development Deserialize - unable to find an Assembly .....

  Hi, I've got a really strange error. I'm using a fairly standard method to implement the IClonable interface, basically I serialize my object to a memory stream and then stream it back again. This all works fine in the .Net runtime environment and if I use a test application. However, I need to run as a COM control inside of an HTML page (long story, but I am embedding it in the home page pane of Outlook). Anyway everything works fine except this routine. It fails when trying to deserialize with "Assembly not found". I added some debug code to load the assembly dynamically and that all works fine. It can't be a version issue as I am serializing and deserializing the same object in the same method. I've traced where the framewor ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Framerate decoupling

  I'm trying to decouple the framerate from Update() so i can have more than 60 FPS. I saw this post with private void graphics_ModifyDevice(object sender, ModifyDeviceEventArgs e) { e.GraphicsDeviceInformation.PresentationParameters[0].PresentationInterval = PresentInterval.Immediate; } but couldnt get that to work... any help/ideas I know I'll have to use the ElapsedRealTime in my FPS code but not sure where to put it at. A good way to slow it down is to tie it to your refresh rate ...Show All