Matt354245's Q&A profile

• Smart Device Development Pocket PC. Database. sdf to mdf ?

  Iam developing a order system for a mobile device. The thogut is that a user should go home to his desktop computer an plugin his pocket pc device(.sdf) and update the databasefile(.mdf) that is on the desktop compputer. The desktop computer will be a Windows Xp computer and the program wil be done by VS 2005 windows forms. Is there any soultion on this problem out there Iam using VS 2005, Sqlserver 2005 and .Net compact framework 2.0. Have a nice day ! Latso wrote: My problem is not to write to a xml file, but to read and write to a database from one :) I'm still failing to see what more you need here ... assuming you're on the network, you establish a SqlConnection to your SQL Server. Yo ...Show All

• SQL Server ay Mon- Fri Bit fields Query

  I am having trouble figuring out how to complete this any help is appreiciated. I have Mon , Tues , Weds , Thurs , Fri as bit fields I need to write a query for a report to see if the value is true, and display M , T , W , Th , F in a column Days if they are scheduled that day example: Mon and Wed I got on the bus the checkboxes are set to True, I want one column in the report Days : to display M, W I was playing around with the code, and I don't believe this is what I am trying to do let me explain a lil more. I have a table that does a transportation schedule. It has Mon, Tues, Wed, Thurs, and Fri as bit data types so that I may have checkboxes on the front-end. I need to build a r ...Show All

• SQL Server How to dynamically assign database name in query or store procedure?

  Hello, I am not sure if this possible, but I have store procedures that access to multiple databases, therefore I currently have to hardcode my database name in the queries. The problem start when I move my store procedures into the production, and the database name in production is different. I have to go through all my store procedures and rename the DBname. I am just wonder if there is way that I could define my database name as a global variable and then use that variable as my DB name instead of hardcode them something like Declare @MyDatabaseName varchar(30) set @MyDatabaseName = "MyDB" SELECT * from MyDatabaseName.dbo.MyTable Any suggestion Please. Thanks in advance For one, you need to grant ...Show All

• Visual FoxPro Future of Visual Foxpro

  Hello friends, I have a general question. What will be the future of VFP The reason for asking this question is because, our company is planning a major commercial software development. So far we were very much satisfied with VFP. But now doubts are being raised whether we should base our investment on this platform or consider something new like VB.NET. Especially when we hear that the products will not be served beyond 2009!!! Any sincere opinion will be a big help. Thank you. This has been almost a touchy subject for me. I started using foxpro about 3 years ago and as soon as I really got into it I was hooked. When I heard that VFP was being "phased out", I was, to say the least, somewhat devistated. I keep hopi ...Show All

• SQL Server sp1 effects...

  Is anyone here aware of anything else that has been changed in regard to SQLCLR via sp1 (excluding this http://support.microsoft.com/kb/910414/ ) ...Show All

• Visual Studio Express Editions Creating Folders

  Here is the deal... We create project folders for every project that we do. Each folder has around 15 sub folders. Project Name Folder -Project Name - Folder Type -Project Name - Folder Type -Project Name - Folder Type -Project Name - Folder Type -Project Name - Folder Type -etc We also have a few excel files and powerpoint templates inside of some of the folders and one folder has some sub folder. In other words it gets a pain in the but to rename all this one at a time so I'd like to make a visual basic program that would all someone to enter the project name and path to save the project folder too (will be on our server that can be accessed by either a drive letter (V: is this case) or like a typical server(//servername/blah/bl ...Show All

• .NET Development How to make sure the code is executed sequently?

  I have the following piece of codes: public void Func1() { DateTime start = DateTime .UtcNow; SomeFunction(); DateTime end = DateTime .UtcNow; } public void SomeFunction() { //some tasks ... DateTime timeBetween = DateTime .UtcNow; //some other tasks ... } If everything is executed sequently, timeBetween should be between start and end. But I think because of .net runtime optimization, I run into the problem that timeBetween is earlier than start. How can I force sequent execution of codes during run time Not through compiler switch, that doesn't work for me. Thx for the advice. Well you could do it this way: public void Func1() { Dat ...Show All

• SQL Server Stored Procedures

    I heard about "Stored procedures" ...But I'm not sure when I should use it...It is only when I will display information from the database or could it be used even when saving to the database I have the following code (which save a value from a textbox in database)...How do I convert this code so it use stored procedures instead...(if its possible to use stored procedures when saving ) Can someone please help me with that This is the code-behind file, called addCity.aspx.vb: Protected Sub btnSave_Click( ByVal sender As Object , ByVal e As System.EventArgs) Handles btnSave.Click Dim ConnString As String = ConfigurationManager.ConnectionStrings( "Connectionstring" ...Show All

• SQL Server Restore a set of databases from a SQL2000 server to a SQL2005 server

  I can restore databases one by one, setting .mdf and .ldf destination paths. How can I restore all my Databases at the same time Thanks G. Zanghi In SQL2000 i have a script that permits me to restore, at the same time, a group of databases backed up with a maintenance plan. In SQL2005 this script doesn't run. Do you know a similar one Restoring one by one it's an hard work.... ...Show All

• Visual Studio Express Editions Visual C++ Error...Please Help

  G'day, Ive recently come upon an error, which prohibits me installing programs and so on. It occured when attempting to update and install Net Framework 1.1 Service Pack 1 of microsoft update and when installing Age of Empires 3. The error is as follows: Microsoft Visual C ++ Runtime Library error Runtime Error! Program: C:\DOCUME~1\Anthony\LOCALS~1\Temp\SL83.tmp This Application has request the Runtime to terminate in an unusual way. Please contact the application's support team for more information. Help would be much appreciated. Cheers. Tony The wording of messages in this case is unfortunate. The message is not about an error in the Microsoft Visual C++ Runtime Library. The ...Show All

• SQL Server Sample database not found?

  I install the SQL 2005 Evaluation. I selected to install samples and documentation during the installation wizard. It finished successfully but I could not find the sample databases on the SQL Management Studio. Why Thanks. Joe. Hi, you can download them at: http://www.microsoft.com/downloads/details.aspx familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Managed vs. Unmanaged code - please assplain

  i'm reading a lot of talk about managed vs. unmanaged code. i've tried to understand the difference on my own, but Wikipedia writers aren't known for stating things simply :) i come from a Flash background. What is Flash Actionscript Managed or unmanaged Or neither Or both Can anyone explain the managed vs. unmanaged debate What are the points for and against each And why might i care Thanks, -MrSock Flash is closer to managed code, it does not run directly on the hardware it runs in a software layer. The whole debate about Managed vs. Unmanaged is about speed, in the past and still now unmanaged code runs faster, however unmanaged code is closing the gap on performance speed. ...Show All

• .NET Development accessing the call stack via reflection: find the EventInfo object

  delegate void ActionInvokeDelegate(CallReturnDelegate CallbackFunction, params object[] Parameters); I have an event of the type above. When it fires, I have an anonymous method that handles it, calling a method (of a different delegate type) for each item in a List<MethodInfo> collection (because I want them to run in a specific order, and for other reasons). I need the name of the action (a string) within the anonymous method, but because this isn't being passed in, I don't have access to it. My first question: is there a way to query the call stack using reflection or any other method, so that I can get the EventInfo object for the triggering event If not the call stack, is there a way to get information about the execution contex ...Show All

• SQL Server install reporting service 2005

  Hi I tried to install reporting service after i had installed sql server 2005, I find reporting service checkbox is disabled, so i can not install it. Why it is disabled, and how i install reporting service. thanks I resolved the exception error thanks to the post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=573569&SiteID=1&mode=1 after reading the post , I downloaded the refactor software . I tried to install it , but it could not be installed due to error: "Error 1001: The SavedState Dictionary contains inconsistent data and might have corrupted." I traced the propblem until i found that DXCore (software provided by same company of refactor) was the reason. I r ...Show All

• Visual Studio Team System TFS31002 error

  When I try to connect to our newly installed team foundation server I receive the general error TFS31002 stating that I cannot connect. I'm using the account which i used to install TFS but it just doesn't work. We are using the official version of TFS (so no beta of RC). When I navigate to the url http://<server>:8080/services/v1.0/ServerStatus.asmx i receive a login box. after entering the same credentials as above i see the content of the asmx page. Is there anyway I can troubleshoot this problem. Kind Regards Patrick Severijns I am deeply ashamed to tell you the problem is solved. It turned out that the team system client was not the release version but the beta 3. Someone forgot to pl ...Show All