ShadowRayz's Q&A profile

• SQL Server |DataDirectory| - minor issue SQLev

  It seems that the |DataDirectory| macro is giving VS 2005 fits. It's a minor issue though and I've stumbled on it recently. The issue actually doesn't come up until you try to "add a new data source" to your project (after you've made the modification in your app settings/Project Properties to use the macro). So if you started of with ".\something.sdf" and then changed it to use the macro, things do run fine....until you try to add a new datasource (new database datasource) The error is: "Illegal characters in path" which is the pipe symbol..... While on this subject, here's a tip to those who maybe going through some debugging mysteries: Even if your sdf file is in your app "root" folder ...Show All

• Visual Basic Visual Studio 2005 Auto code formating

  I've searching and searching and I'm very frustrated with VS 2005, every time I turn around it starts trying to auto format my code. Code that used to look like.. sub blah(by val test,....) dim somevar as int some more code and more end sub now gets formated, with no easily found way to fix it..half way across the screen with like 10 tabs on everything..it will not go away, and I'm close to removing the IDE from the system and going back to hand coding. I delete the formate and as soon as I move to the next line it puts it back, then if I make a change to the lines precedding or following it moves all that code as well... Help please. I have very little hair left and I'm tired of pulling it out. ...Show All

• .NET Development Help with MS Access SQL Query

  Hi, i'm using an MS Access Database file and i need to fetch a certain amount of rows but "TOP" statement isn't enough because i want to show 50 results per page in my application, can someone tell me how can i fetch records between 50-100 i tried to use "LIMIT" statement from mysql ("Select * From SampleTable LIMIT 50,50") but that doesn't work on ms access. "Select * From SampleTable" is how my sql statement looks without any restrictions. Can someone help me with this. Thanks in advance. Note : My table contains a dynamic number of records so i can't use any query logic based on record count. Hi, Yes, VMazur is right. THis functionality is not available in access. But I saw a similar function in MySql. I have m ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. .NET Compact Framework and XNA

  I heard that the xbox 360 will support a framework similar to the .NET compact framework. How do I filter the .NET Framework in XNA Game Studio Express so that only modules in the .NET Compact Framework show up with intellisense/etc show up Hmmm... thanks for the info. I know that you can look in the documentation of a class to see if it is supported in the Compact Framework. I was just wondering if there was an easier way to do this (for example, tell if a class is supported by the Compact Framework without having to go to msdn and search for the class). Anyway, it's not too important. ...Show All

• .NET Development GUI freezes while using TCPclient in VB.net

  Hello everyone, My programm supposed to send commands to an external device(by textbox1) and receive responses from the deivce through textbox2.If I send the command once by clicking button1,I receive the responce once,although the external device should send continuously responses so I added a loop now it responds and refreshes Textbox2 continuously but GUI freezes,I can't exit the programm by clicking button2(Quit)...I am not a programmer I am using VB.net since 70-75 days so I am too confused...I hope someone can show me the right way to follow... Kindest regards, Can my code: Imports System.NET Imports System.NET.Sockets Imports System.Text Public Class Form1 Dim tagid As String Dim tc ...Show All

• SQL Server Conversation Groups

  I am thinking of updating my SQL monitoring application to use Service Broker. Right now I loop through my list of servers performing various checks on each server. Things like 'check last database backup', 'check for new databases', 'check for server restart'. I loop through, one server at a time, doing one check at a time. The more servers I have the longer it is taking. So, I want to multi-thread the servers, but single-thread the checks on each individual server. This way I can check say, 5 servers at a time, but on each server I will only do one check at a time. This way I won't flood an individual server with multiple checks. Is this possible It looks like Conversation groups might be the way to go but I'm not sure. Th ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Platform options only at project creation?

  Hi, Like most I have talked with, I am doing most of my development / debugging on the PC and then deploying to the XBox360. One thing I have been unable to do is change the platform of a particular project. Instead, I have to have 2 projects and I literally just copy the files over or include from a common directory (where it seems to copy locally to that project directory for the c# using directives). In the project properties, the drop down box for platform only allows either x86 or xbox360 depending on what type of project you start, not both. Can I change the platform of a particular project from x86 to x360 The Windows Game Library can be added as a reference to an XBox 360 Game Project. From reading about the CLR, I assume this wi ...Show All

• Visual C# multithreading: locking a variable to return

  elementary question (I'm using VS2003 for this particular issue, but it pertains to VS2005 too) Is it possible for Foo() to be preempted between FetchFoo(), assignment of foo_, and pushing foo_ on the return stack public DataSet Foo() //thread1 { lock( fooSetLock_ ) { return ( foo_ == null ) foo_ = FetchFoo() : foo_ ; } } public void ResetFoo() //thread2 { foo_ = null; ...other code } If so, does this solve the issue public void ResetFoo() { lock( fooSetLock_ ) { foo_ = null; } ...other code } " Is it possible for Foo() to be preempted between FetchFoo(), assignment of foo_, and pushing foo_ ...Show All

• SQL Server Variable not getting updated and passed into data flow

  My package sets a variable in an ExecSQL task. This variable is then used as a parameter in a DataFlow task that follows. Normally everything works just fine. However, sometimes if the package fails inbetween the step that sets the variable and the DataFlow, the default value of the variable is stored in the checkpoint file. (It is not failing in the step that sets the variable) When the package is restarted I can see that the variable is not set to the data value in the database, but rather it has its default (design time) value. Anyone else see this bug Chopaka wrote: My package sets a variable in an ExecSQL task. This variable is then used as a parameter in a DataFlow task that follows. No ...Show All

• Visual Studio 2008 (Pre-release) What is "best practise" for databinding custom controls with xmlFile from xaml ?

  Hello.. I’m having a hard time figuring out how to databind a custom control from xaml with an XmlDocument. My problem is how to generate the ItemCollection. Example, myListBox control containing a List of <myListBoxItem>. In codebehind it is very easy to create a ... List<myListBoxItem> myItems = new List<myListBoxItem>(); ...and then use... myItems.add(..); What I’m looking for is a very simple example where this is done so after the databinding has been made in xaml (with xml) I have an customized ItemCollection (in this case myListBoxItem) that I can control, add events, animate or whatever I wanna do from my parentContainer (myListBox) Hope I made myself clear, otherwise I’ll try to clar ...Show All

• SQL Server .dtsx package from Informix using ODBC

  Help! I'm trying to create a simple .dtsx package that imports data to SQL server 2005 from an informix 7.3 db using an ADO.net ODBC connection. I am first creating the groundwork for the dtsx package in SQL server using the wizard, and then editing the file later in visual studio. My data source SQL in the dataflow task is simple and it works great until I hit a locked record on the Informix database. select <coulmns> from <table> Where <condition> The work around syntax for the locked row on the informix DB should be: set isolation to dirty read go select <coulmns> from <table> where <condition> This syntax will return the data correctly using a non-microsoft ...Show All

• SQL Server Internal SQL Statement

  Need 1 SQL Statement to find out which databases have what tables with what Columns with what datatypes Thank you Jens. What I had in mind was something like: SELECT dbo.sysobjects.name as Tabellenname, dbo.syscolumns.name as Spaltenname, dbo.systypes.name as Datentyp, dbo.systypes.length as 'Laenge in Byte' FROM <dbname>.dbo.syscolumns,<dbname>.dbo.sysobjects,<dbname>.dbo.systypes where dbo.sysobjects.xtype='U' and dbo.sysobjects.id = dbo.syscolumns.id and dbo.systypes.xtype=dbo.syscolumns.xtype Can you help me with a loop in order to run through all databases automatically regards matthias P.S. Whats wrong with sqlserv2005.de. Is the server down ...Show All

• Smart Device Development Can't develop PPC/SPH2003 using VS2005

  I would like to develop applications for smartphone 2003,PocketPC 2003 and Windows Mobile 5.0 using VS2005 and C#. There are no problem with Windows Mobile 5.0. But when I compile PPC/SPH2003 applications, error was reported that ".Net Compact Framwork 1.0 is required, .Net Framework 1.1 is required but not found in this PC". What's wrong with my VS2005 My develop environment: VS2005 TS Simplified Chinese. Windows Mobile 5.0 sdk I also installed PPC/SPH 2003's sdk. It is reported that eVC should be installed first, while I don't install eVC. Hi Yin, I believe that your problems happens when you try to create or deploy a CF 1.0 application, right did you install Fraework 1.1 ...Show All

• Visual Studio Express Editions Simple client and server applications

  how do i make server and client (but very basic, just to transmit a string would do). I've been programming in VB.NET for a year so im good, but not great. Transmit the string from where to where From server to client or from client to server From or to a database or a text file Where does the string reside We need more information.... ...Show All

• Visual Studio Tools for Office PLEASE READ FIRST: Non-VSTO Question/Issue Resources

  Mike, I know this is not your doing but I want to complain LOUDLY to MS. Why ALL the Office products don't have VSTO is beyond me, I guess MS figures to hell with anyone not using Word and Outlook. Be that as it may, after all the searching on the Microsoft site I finally get here and what Oh yeah, I am directed to go to news groups where everyone else is scratching their backsides because there is no information. News for ya guys, I found the news groups days ago and NO ONE understands the damn PIAs, why they FAIL constantly, and why thier add ins won't work on anything other than a VS dev machine. Come on MS, get on the ball!!! Noneatall wrote: Why ALL the Office products don't ...Show All