SPA's Q&A profile

• Game Technologies: DirectX, XNA, XACT, etc. Reflection - Assembly.Load generates error

  I seem to be experiencing some trouble with Reflection, specifically I am trying to load an assembly and call foo.EntryPoint.Invoke on it, but when I call Assembly.Load, I get: System.BadImageFormatException was unhandled Message="Could not load file or assembly '90112 bytes loaded from TestReflection, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An attempt was made to load a program with an incorrect format." Source="mscorlib" FileName="90112 bytes loaded from TestReflection, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" FusionLog="" StackTrace: at System.Reflection.Assembly.nLoadImage(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence evidence, StackCrawlM ...Show All

• Smart Device Development Going wireless advice...

  Hi, I am making a business case for our company to update our inventory barcode scanners and I need some advice. If we're going to use the wireless functionality of the scanners to do merge replication with the SQL server, then will we still need a desktop in the inventory area I figure not, as long as the wireless is working and they can just dock the scanners for charging, but I'm just not 100% sure. It seems quite obvious, but I just want to cover my bases. Thanks. Thank you, I'll re-phrase it. Is there a way to transfer the data from the scanner to the SQL Server through IIS wirelessly without having to store it on the scanner Kind of like a live inventory system I'm trying to eliminate the need to ha ...Show All

• Visual Studio Displaying info with line breaks in Quick Info

  Hi, I'd like to display a method description in the Quick Info menu, that has line breaks. I have formatted the xml documentation of the method, and tried <list>, <br>, and all that I could remember but it never displays line breaks! Does anybody know if this is possible Thanks, Pedro ...Show All

• SQL Server File Groups

  Hi everyone, While creating our database in only one disc(C or D), suppose that we create more than one file group in order to group our data files. However, in this situation; I wonder that whether it brings any benefit or advantage to us. Also, I wonder that why we always have to put our data file into separate file group if we use separate discs for data files. Is not it allowed to use only one file group even if we use separate dics Would you explain these to me Thanks Hi, There something make me still confused about this topic. For example, when we call some columns from a table with Select query statement, do the SQL server do this by first finding the file group that this table located in and then finding the corresopnding t ...Show All

• SQL Server How tot select the most recent date

  I have 2 tables: 1) Item table (No_, Description) 2) Sales Price HAG table (Item No_, Sales Price HAG, Starting Date) I want to have a report within from every item the most recent sales price. But, it is possible that a unique item has more than 1 sales price in the 'Sales Price table' (if it has more than one Starting Date). I want to report the sales price with the most recent date. I've made this statement: SELECT [DatabaseName$Item].No_, [DatabaseName$Item].Description, [DatabaseName$Sales Price HAG].[Unit Price] FROM [DatabaseName$Item] INNER JOIN [DatabaseName$Sales Price HAG] ON [DatabaseName$Item].No_ = [DatabaseName$Sales Price HAG].[Item No_] ...Show All

• Visual Studio Express Editions Is it possible ?

  Is it possible to view the memory location of where a Variable is stored in C# and whats the difference between protected and internal protected "Is it possible to view the memory location of where a Variable is stored in C# " Where do you want to view it Why do you need such a thing "whats the difference between protected and internal protected " protected means that the member is accesible to the derived classes protected internal means that the member is accesible to the derived classes and the classes that in the same assembly as the declaring type ...Show All

• .NET Development use of name: "Object Library" vs. "Class Library"

  This is a question that I have pondered, but never bothered to really look into it till now. What is the difference between calling library of classes a "Class Library" and an "Object Library" I've heard these two terms used synonymously, but now I'm at a point where I have to find out if there really is a difference. Yeah that would be an object model. A "class library" is generally a term used for an assembly which contains the classes (and enums, structs etc). An "object model" is the term used to describe how the classes relate to each other, and may involve classes from multiple class libraries. ...Show All

• Visual C# Constructor not being called in Array of refrence class

  I guess that's a little repetitve because in C# classes are always refrence objects....but any ways... I have a class (we will call this class MainObject) that contains another refrence class. I want to declare MyMainObject (the instance(s) of MainObject as an array) but when I try to access the sub classes of MyMainObject[0] ect. it gives me a null refrence error. I have deduced that this is due to the contructor not being called. When I just make three individual instances MyMainObject every thing works fine. This works fine for now, but what if I want want to make 12, or 500 instances in later versions If this helps this was the code I was using: MainObject [] MyMainObject = new Ma ...Show All

• Visual Studio Express Editions Question.

  How can I make a combo box represent a keycode Because I am making a program where you can choose what key you press to fire up an event I Figured it out. I did this. If (e.KeyCode = Keys.A) Then If ( Me .ComboBox1.Text = "A" ) Then charector1up.Start() Else End If End If and so on with every thing else ...Show All

• .NET Development Access query to transpose table data

  Hello, I have the following table structure in my database and would like to create a query or table that displays a single record for each country with the three different RatingsType1 across the top as column headings with the respective rating filled in. Something like this: Country Rating1 Rating2 Rating3 US AAA CCC Baa1 where Rating1, Rating2, Rating3 are one of the three types of ratings from the tblRatingsType1 table. Here's the table structure: tblCountry CountryID (PK autonum) CountryName tblCountryRating CountryRatingID (PK autonum) RatingType1ID (FK to tblRatingType1) Rating RatingDate tblRatingType1 RatingType1ID (PK au ...Show All

• .NET Development class Thread Safety

  Hi all, I saw has the class in MSDN to be thread safety---" Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe. ".For instance said the FileStream class is this. If I operate a file in the Server end with the FileStream class, whether only needs it to put in static method may guarantee under the multiuser scene does not make a mistake thanks. Hi, It is not what it means. The statement means that if you call any static method of the class the designers had guaranteed that the call will be thread safe. If you check the static methods of "FileStream" you will get (ex: Synchron ...Show All

• Visual Studio Express Editions how to connect remote access database from VB.net??

  how to connect remote access database from VB.net hallo, i am looking for a code that connect to a remote database(ms access)on the web from a desktop vb.net/vb application. help me I need to connect to a mdb file located in internet from a VB desktop application. For Example: My database is located here: http://www.mysite.com/dbfolder/mydb.mdb What should I do in VB 6.0 Thanks ...Show All

• .NET Development IEnumerable.GetEnumerator()

  Greetings, I have some questions on IEnumerable.GetEnumerator(): 1. Should each invocation return a distinct enumerator object 2. If so, should the enumerators keep their state in sync or independent of each other 3. If independent, can distinct enumerators (returned by the same method) enumerate the underlying collection in different orders MSDN Lib seems to have left these unspecified, so maybe it's all up to the method implementer, but since the interface is tied to foreach sematic, perhaps there are specific answers/rule for the interface If MSDN Lib specifies the answers to these, I'd be grateful if you can point me to the URL. Thanks for any info, Dasa The current version of th ...Show All

• SQL Server Give me a list of the "Last updated" time of each cube in a certain database ?

  Anyone know a way to query the ssas database, retrieve the last updated time and put it in table I found you that i can query the ssas database with: <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> <RequestType>MDSCHEMA_CUBES</RequestType> <Restrictions> <RestrictionList> <CATALOG_NAME>test</CATALOG_NAME> </RestrictionList> </Restrictions> <Properties> <PropertyList> <Catalog>test</Catalog> <Format>multidimensional</Format> </PropertyList> </Properties> </Discover> This gives me a xml list, but how do i get that into some meaningfu ...Show All

• SQL Server Transact sql 2005 Code changes

  Have there been any updates to sql 2005 transact codes, because I tried to use some transact code that I used in sql 8.0 and in sql 2005 on the same database and it did not work. Here is the code I used Select p.pub_name, e.fname + ' ' + e.lname "Employee name", e.job_lvl from publishers P inner join employee e on p.pub_id = e.pub_id where e.job_lvl > 200 ...Show All