SQLServer2050's Q&A profile

• Visual C# how to use switch to judge range values

  How to use switch to judge range values like if(a>10&&a=15) ... if(a>15&&a<20) .... how to change if statement above to switch statement Hi You can also use Ternary operator to minimze your code like ((a>10) && (a > 5)) "True" : " False"; "True" means the stamente here will be executed when the condition is true other wise the staments in False will be executed. ...Show All

• Windows Forms [SOLVED] ListBox how to question

  Hi all, [C#] I have a method which adds files into a ListBox as follows: foreach ( String file in Directory .GetFiles( @"C:\Files" ))     {         listBox1.Items.Add( new FileInfo (file).Name);     } This statment is run shortly after InitializeComponent(); then I have an event handle the change: private void listBox1_SelectedIndexChanged( object sender, EventArgs e)     {         : // not sure what needs to be done here         myTxtFile.Text = listBox1.SelectedIndex.FileName; // cannot resolve FileName!!!         this.CallsMyMethod(); // no p ...Show All

• SQL Server Poor Performance READING data using VB.NET Temporarily Cured by Re-booting SQL Server

  Poor Performance READING data using VB.NET Temporarily Cured by Re-booting SQL Server Please can you help SQL Server 2000. Accessed by VB.Net 2003. Server set up by SQL consultant (who is no longer available). We have a regular problem, which is most noticeable when analysing data (rather than data inserts/deletions) for producing xml or csv files or reports, even though the amount of data is relatively small. However structure of database means that there are still quite a lot of records and a lot of links between tables (database is currently being redesigned but in the mean time the problem still exists). The problem is that access slows down dramatically and in some cases all but stops (one exam ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. VMX library on XBox 360

  As my thread on 360 performance has somehow drifted way from my original theme, I'd like like to follow up on a comment made in that thread here:   EmoSaru wrote: Well, I think the BEST solution all around is to extend the API to provide optional use of intrinsics.  Just like with the standard devkit, let ME decide when I want to use intrinsics and vectorized code and when I don't. :) I would not be opposed to offering separate types for intrisic versions of vectors/matrices/etc., so long as the appropriate conversion operators/functions are provided.  It seems like this gives you the best of all words, insofar as within tight loops the native instrinsic code should not be hard to produce, but you don't have to worry ...Show All

• Smart Device Development How to set column visible and invisible in Datagrid for Pocket PC application?

  Hi, I want to hide a column in a datagrid for pocket pc application after binding the dataset to the datagrid Please suggest me how to achive this. Thank you you need to use the DataGridTableStyle here u can set the display name for a column and the width, -1 for it to be invisible the datagridtablestyle needs to be added to the datagrid after the datasource has been assigned to it If Not datagrid1.TableStyles.Count > 0 Then 'Sets the layout of the datagrid by assigning it 'a tablestyle. This lets you set the width of 'columns and which are shown Dim l_dgts As New DataGridTableStyle l_dgts.MappingName = "stocktakeitem" Dim l_aCol1 As Ne ...Show All

• Visual Studio custom paper size cannot be used on other machine?

  I created a customized paper report on my dev machine. The report's size looks fine when run, the way I want the format to be. Then I compiled my vb.net application and copied the application to client machine. The preview of the report showed in "Letter" format instead of that I created. What did I do wrong I've referred to http://support.businessobjects.com/...es/c2011657.asp but it can't help. the paper size I set is 5.5 inch x 5.5 inch I'm using win XP, crystal report for VS.NET 2003 (VB.NET) mmh.. I Found a solution! When you want to use a papersize with an id greater then 118 (Windows coded papersize) you must supply the id of your papersize to PrintOptions.PaperSou ...Show All

• Visual C# Making an advanced settings form

  I am working on a user interface that needs to have a form added for advanced settings for the program. I have added a button and set the event handler for the button to call up the new form, but I am unable to get the program to take any of the settings from the advanced form. Everything is under the same namespace, but it will not find them, so when I try to build my program I get an error for each time that one of the settings from the advanced tab is called out. Is there a call out that I am forgetting, or do I need to change each callout to reflect that the setting is on a different form Thanks SVandal My program consists of a main form named Carriage_Motion_Controller public partial class Carriage_Mo ...Show All

• Internet Explorer Development Organizing IE7 Toolbars - Toolbar tip for all versions of IE.

  What a Horrible experience has been using IE7. First I can't put more bars in the same row as the address bar So I get a incredibly big address bar and loose a lot of screen. Other problem is that toolbars dont stay in the place you put them. They keep moving even if you lock the toolbars. Is this a Primary BUG at IE7 Is there anyway to make IE 7 as useful as IE6 and customize bars the way I want and not the way the developers wanted Thank you in advance for solutions.... Thanks Rob, for the tip... and Viktor, for your suggestion... But both are irrelevant to the OP's message. I obviously also experience the same problem... and (as some of you probably did...) found this tread doing a Google sea ...Show All

• Windows Forms Accessing null value from datatable

  What is the most efficient method for accessing a value in a datatable when the value might be null The following works but there is a definite pause waiting for the exception to return. . try strUserName = .UserName catch ex as Exception strUserName = "" end try Is there some other way to do this that will avoid the exception altogether I tried using IsDBNull(.UserName) before using .UserName in an assignment but the dataset still throws an exception. Hi There are a couple of methods you could utilise. The first is to compare the field value against the System.DbNull.Value type: If Not DataTable.Rows(0).Item("YourFieldName") Is System.DbNull.Value Then 'Field is NOT null El ...Show All

• Visual Studio Express Editions Continuously Update Form

  I am creating a form that is going to act as a notification system for users. It has 8 buttons on the form, each button represents a location. Based on the current status of the location, the buttons color will change. I have the program reading from a database at startup and updating the buttons color. What I am needing is how do I have the form check the database after it has been loaded to see if it needs to update the color of a button. What I am planning on doing is, using Thread.Sleep to make the program sleep for about 5 minutes, then check the database again. This would be in an infinite loop, so that the program will always run and update the color of the buttons. I tried to use the Load event, but that does not load the for ...Show All

• .NET Development CLR data alignment

  Is there any way in the CLR to specify how data is aligned I am attempting to process float arrays in unmanaged code that have been allocated by the CLR, and there appears to be no way I can ensure that the arrays have been allocated on a 16 byte boundary, as required by the code. Is there any way, from the managed side, of ensuring that the arrays are correctly aligned Thanks, Andrew. You could artificially pad the array element until it is just large enough. This will do it: [StructLayout(LayoutKind.Sequential)] private struct InteropFloat { float value; Int64 pad; } Test it like this: int size = Marshal.SizeOf(typeof(InteropFloat)); ...Show All

• Internet Explorer Development IE7 Beta Antiphishing

  I moved my master hard drive to a slave and installed a new master. I was trying to delete fiels off the old hard drive but there is one folder associated with the previous IE7 Beta installation that I can not delete. C:\Documents and Settings\User\Local Settings\Temporary Internet Files\Antiphishing The folder is inaccessible and undeletable. How do I delete it Ending explorer.exe and using command prompt does not work. dude, thank you! i've been trying to delete that folder for HOURS now. I had a feeling it had something to do with securities or permissions but i had no idea how to use them. a hundred thousand thanx. good thing i stumbled across this before i committed suicide. ...Show All

• Visual Basic Unable to modify VS2005 Binding Navigator in the inherited Form

  Hi! I put a BindingNavigator on a Form1 and set Modifier=Public. Then I created an inherited Form2. I put a BindingSource on Form2. But I cannot to set any value of inherited BindingNavigator because they are disabled. I need to set "BindingSource" property to the created BindingSource. Is it possible in other way than at run-time Stone I understand your frustration around this issue, but we disabled this scenario intentionally (for ToolStrips and ToolStrip derived controls such as BindingNavigator). We chose to not make the engineering effort it would have required to enable this scenario for VS 2005. This decision was not make lightly and we understand customers would like this functionality, but the existing visual inheritance arc ...Show All

• Visual Studio Express Editions Combining numbers

  Hi everyone, I am struggling to implement a combining numbers game with recursion. The game is about : you enter some numbers, and then a value, then the program tries to determine that wherher with these numbers, this value can be obtained or not. But when I compile the program, I got peculiar errors as the following: Would you please help me in correcting the errors ------ Build started: Project: hw2, Configuration: Debug Win32 ------ Compiling... SymmetricMatrix.cpp c:\documents and settings\mert\belgelerim\visual studio 2005\projects\hw2\hw2\symmetricmatrix.cpp(440) : error C2228: left of '.length' must have class/struct/union type is 'int []' c:\documents and settings\mert\belgelerim\visual studio 2005\projects\hw2\hw2\symmetr ...Show All

• SQL Server Sql Management Studio Express

  I recently installed Sql Server Management Studio Express on my computer. I am unable to connect to a remote instance of Sql 2005 using this program on my computer. I have shut off windows firewall as well as my third-party firewall but have come up with the same error message. TITLE: Connect to Server ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) I installed Management Studio on another computer and was able to ...Show All