clstephenson's Q&A profile

• Game Technologies: DirectX, XNA, XACT, etc. Issue with XNA Tutorial and scrolling backgrounds

  Greetings, I followed the second XNA tutorial, and got to creating a scrolling background for the space ship program. My problem is that as soon as I added the code from the tutorial for the scrolling background, the space ship became somewhat transparent, meaning that I am not seeing it like a solid rather a sum total of spheres and other geometries. For example, I can now see the 4 spheres on the surface of the ship in their entirety, and also the scrolling background behind it. Can someone help me out here Thanks! Yep, the Batch.draw statements in that tutorial use the layerDepth parameter, and even after playing around with the values, my ship is still translucent. I am new at this, and have a feelin ...Show All

• SQL Server Strange Issue in T-Sql

  Hi, I have bumped into a strange problem. The below select query does not return back any results : select skuid, itemnum, rmsskuid from sku where rmsskuid is not null However, the same query with a top clause returns results: select top 500 skuid, itemnum, rmsskuid from sku where rmsskuid is not null I started to investigate(with queries below) in more than one ways..however the problem remains un resolved. The below query returned the count correctly select count(*) from ( select skuid, itemnum, rmsskuid from sku where rmsskuid is not null) a The below select query does not return back any results : select a.* from ( select skuid, itemnum, rmsskuid from sku where rmsskuid is not null ) a The Table Create Scr ...Show All

• Visual Studio Express Editions Problem With DataBinding and Listbox

  Hello All, I am having a bit of trouble with a Listbox and the display member databinding. Whenever I databind to the listbox, the only text that comes up is System.Data.DataRowView. Any ideas what I'm doing wrong Me .ListBox1.DataSource = myTable Me .ListBox1.DataBindings.Add( New Binding( "DisplayMember" , myTable, "Name" )) take a look at this and see if this helps   http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=539251&SiteID=1   in particular to my response, converted to VB.NET for you: Me .listBox1.DataSource = theDataSet.Tables(0).DefaultView; Me .listBox1.DisplayMember = "theColumnName" ;   ...Show All

• Visual C# How do you convert int[,] into object[,]?

  I've got 3 questions. Need help please, 1. I have a multidimension integer[5,3]  that needed to be converted into object[5,3]. Is there any best way of doing it 2. What is the best/common practice of searching a record (to see if it existed) a)  using executescalar() and what is the object that it returns b) any other suggestion 3. What is a safearray for Can anybody give me a simple example to demonstrate how to use safearray and its benefit Thanks in advance! Thanks for the reply, I thought there was a simple way such as object[]=int[]; I'm new to this C#. language. I find a lot of ways to search a record in a database. The one that I just knew is by using ...Show All

• SQL Server Visual Studio VS ReportBuilder problem

  Hi ! We have made a lot of reports using Visual Studio. Now some of our client would like to customize those reports. We have install ReportBuilder on their server to allow them to create their own reports. Everything is working fine when they are trying to create new reports. The problem is when they are trying to customize reports that we have made using Visual Studio. When they are trying to open those reports in ReportBuilder they get this Error: One or more unexpected Report Definition Language (RDL) elements of the following type have been removed: DataSet Microsoft.ReportingServices.ReportBuilder.ReportModel.Report: System.Web.Services.Protocols.SoapException: The operation you are attempting on item "/Data Sources/DataSou ...Show All

• SQL Server Access denied error message using xp_cmdshell to access network share

  When running the following statement in SQL 2005, I get the error message "Access is denied": exec master . dbo . xp_cmdshell 'TYPE \\SERVER-B\SHARE\FILE.TXT' The following are true about the network: The SQL Server is installed on SERVER-A. SERVER-A and SERVER-B are Windows 2003 servers on the same Windows 2003 domain. The SQL Server and SQL Server Agent services are running under the domain account SQLSERVICE. SQLSERVICE is a member of the Domain Admins group. The Domain Admins group is part of the local Administrators group on SERVER-B. The SQLSERVICE account has also explicitly been given Full Control to the folder referenced by \\SERVER-B\SHARE xp_cmdshell use has been ena ...Show All

• Visual C# Storing the row content in local variable.

  How I can store the data from the DataGridView to a variable in another form Form1 form=sender as Form1 ; System.Windows.Forms. DataGridViewRow row; row = form.dataGridView1..........; I was thinking something like this. Can anyone help me //here's my sample class called Class1 to bind to the DataGridView. It simply contains two string variables with their respective properties. public class Class1 { private string string1; public string String1 { get { return string1; } set { string1 = value; } } private string string2; public string String2 { get { return string2; } s ...Show All

• SQL Server Report Services Instance not found

  after re-installing sql server 2005 server reporting services when i start the Reporting Services Configuration Manager a message pops up saying "Not Found", at the instance selection screen. when i type in the name of the server and click find i get the same message.. what am i doing wrong When i go to sql server 2005 surface area to check if the report service is running i see the service listed under Surface area configuration for Services and Connection and it is started by local system. when i go to Surface Area configuration for features and i click on reporting services a message pops up that says Not Found (System.Management) why is this ...Show All

• SQL Server Aggregate error on calculated measure with time range

  Hi, I'm using Excel together with AS 2000 (Std Edition) cubes and m y problem is that Sub Totals or Grand Totals generates an error for one of my measures when I apply filters on my time dimension. I have figured out that the error has to do with the Aggregate function. The aggregate function is used by Excel to display filtered totals in the pivottable. This is the mxd generated by Excel when I filter my time dimension on year 2005 and 2007: WITH MEMBER [Period].[Quarter].[XL_QZX] AS 'Aggregate({[Period].[Quarter].[All Period].[2005],[Period].[Quarter].[All Period].[2007]})' SELECT FROM [Ledger] WHERE ([Measures].[Amount],[Account].[Balance sheet].[1200 - Equipment],[Period].[Quarter].[XL_QZX]) CELL PROPERTIES VALUE, FORMAT_STRI ...Show All

• Visual Studio How to get the platform name for a SolutionConfiguration in VS 7.x?

  I need to be able to match a SolutionConfiguration to it's name|platform. In VS 8.0 I can get both values by doing a get_Name on the SolutionConfiguration and a get_PlatformName on the SolutionConfiguration2 object. How do I get the patform name for VS 7.x Or how can I make sure that for a given name/platform combination I get the correct SolutionConfiguration If I do end up having to parse the solution directly (which at this point looks like the only possible way), and looking at GlobalSection(SolutionConfigurationPlatforms) to get the list of name/platform pairs, does the position in that list correspond to the array index when accessing the SolutionConfigurations via the API Thanks, Sven Hm ...Show All

• SQL Server SQL's america date format conflict with australian date format

  Hi I am trying get my VB6 application to insert a record into a table (SQL Express) which has a datetime column but it would not process if the data format is differ to *American Date format*. The date() function in VB returns 15/11/2006 which is in Australian Date format (DD/MM/YYYY) according to my setting in "Reginal and Lanuage Option-> Locale 0> English (Australia)" setting. I get the following error: Msg 242, Level 16, State 3, Server KIT\SQLEXPRESS, Line 1 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated. My computer's locale is set to English (Australia) and I expect the datetime format would follow what is set ...Show All

• Visual Studio Express Editions dataset and datagrid problems

  i have a db (access file) i draged a datagrid and connected the thing to the dataset in wizard it automathicly gave me this line in my load function this .workersTableAdapter.Fill( this .db1DataSet.Workers); now i see the rows inside the grid, but i cant seem to change them (when i reopen the program, the rows are the same they were) if someone here knows the subject and can give me some pointers that could be great (if that someone has an email address, icq, or msn, even better, maybe i could even send it to them if they would rather see it with their own eyes) well the links provided give you most of the guidence, you just need to implement it into your solution :-) if you like my email, send ...Show All

• Visual C# Tab Controls

  Can someone let me know how i can add a TAB CONTROL to an existing windows form application You can drag and drop it to create a new form, but that means starting again with designing form and everything. I am try to avoid that and just add it into the existing form. ...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 Basic need help here! please

  I suck at programming and i have a few problems here. Hope some kind soul can save me Firrst, i have a textbox to allow users to input related hyperlinks. Therefore, users are to enter the links lik this in the textbox. http://www.yahoo.com,http://www.asp.net However, when some1 clicks on the link, it appears http://www.yahoo.com,http://www.asp.net in the address bar. Can some1 teach me how to seperate this 2 sites so that it appears http://www.yahoo.com or just http://www.asp.net in the address bar How to seperate them The text box is a single line text box. Secondly, the websites have to input with this format http://www.yahoo.com . can anyone tell me how to detect whether the user has input the website with the http:// in f ...Show All