Ross B.'s Q&A profile

• SQL Server Installing SQL SERVER 2005 Enterprise Edition On Windows XP??????

  Hi, I brought the MCTS Sql Server 2005 Implementation and Maintenance,Self paced training kit recently but i cant get my hands on the required OS for SQL Server 2005 Enterprise Edition which comes with the book. (Too Expensive!!!!!!) Is it OK to intall it on Windows XP Will I encounter any problems Many thanks Uma Tyagi What was the error you are getting Take help of this KBA http://support.microsoft.com/kb/328306 to resolve the issue. ...Show All

• Windows Forms Extracting cell data from dataGridView

  Any help would be greatly appreciated, as I cannot seem to find an answer. How does one extract the value of a particular cell from a dataGridView object in c# I looked for dataGridView1.Cell(3,4) but 'Cell is not appearing as one of the methods available for this class. TIA. Hi Knji, as i roughly think about this question, we can just use code like MessageBox .Show(dataGridView1.CurrentCell.Value.ToString()); MessageBox .Show(dataGridView1.Rows[0].Cells[1].Value.ToString()); I am not sure if I catch your requirement, ...Show All

• Visual Studio Express Editions Removing characters from a string

  I am importing a string into a database. I have noticed that from the text file I can see a Square Character. How do I remove these characters from the string Here is some Very early code that I am working on, Dim linenumber Dim theReader As IO.StreamReader = IO.File.OpenText( "test.txt" ) ListBox1.Items.Clear() Do While theReader.Peek <> -1 linenumber = theReader.ReadLine If linenumber.Contains( "MeridianMail" ) Or linenumber.Contains( "No Activity" ) Or linenumber.Contains( "Services Detail" ) Or linenumber.Contains( "Interval Start-End" ) Or linenumber.Contains( "Service" ) Or linenumber.Contains( "Accesses" ) Or String ...Show All

• Software Development for Windows Vista Heavy action and thread blocking

  Hi there, I have a question re: heavy action( I use "heavy" to indicate the time to run the a activity is very long). -- I need to build a flow to generate a series of reports. As you can imagine, each reports probably take minutes/hours to run. I create a data exchange service to generate the report ,and create a workflow and use "CallExternalMethod" to run the reports. However, as I understand, "CallExternalMethod" will post the data back to the host thread.So in my case the host thread will be blocked while report is running and it will make this application stop responding for any new request until the report is generated. I can off-load the task using queue based design. But I want to know 1. if my und ...Show All

• SQL Server Should I use indexes?

  I have a very large table (about 200,000 records), but there are only 2 fields in the table only one populated with data. I need to update the 2nd field with the first field's data. UPDATE Table1 SET field2 = field1 This is taking a really long time to run about 3.5 minutes. Is this normal Can I create an index What can I do to shorten the run time Thanks, Ninel I just can't help but asking what the point is to duplicate column1 into column2 ..unless this is just a simplified description of another 'real' requirement.. just curious =;o) /Kenneth ...Show All

• SQL Server Why Notification services

  Hi folks, I have not worked on Notificatioin services.Currently I am using COM+ to send messages to the customers.Is there any additional advantage by using by Notification services.Help me(Give me atleast related links) Thanks alot JOE WEBB.It is great.I will start working on this and I will be in touch with you through this forum ...Show All

• SQL Server MgmtStudio: Use current connection/window when opening file

  Is there a setting that I am missing, or is it just not possible to do. When I have a "QueryAnalyzer" Connection/Window open in SQL Server Management Studio, and I open a script file... it wan't to make another connection. Is there a way that I can set it to NOT do this, and use the existing Window/Connection. As we have to SQL Logins and thus need to type our passwords each time a new connection is made... Also, is CTRL-N not in use anymore to open a new connection/window This behavior has been changed in our next service pack (Service Pack 2). There were many Microsoft Connect items filed around this. You can check them out here: http://connect.microsoft.com/SQLServer/. Paul A. Mestemaker II Program ...Show All

• Visual Studio 2008 (Pre-release) Resizing Columns and Rows in a Grid

  Hi, I would like to know if the following is possible with a grid (meaning that it is already built in, no extra coding required! :) ) I have a grid which I use to fill in info, say 2 columns and about 10 rows. The first column contains labels containing the details, say Name, Surname, etc. and the second TextBoxes. Now in order for the form to be global, is to create a resource file, enter there text values, and set the corrosponding label's to the corrosponding resource text values. The problem here is that say in one language (for arguments sake), Name equals about 20 letters, if that is the case, I would like the grid's columndefinition to automatically adjust itself if a control's width becomes bigger then the grid's columnde ...Show All

• Software Development for Windows Vista UOPs and DVD navigation

  Hi all, My question: is it possible to discover the UOP restrictions that apply to a DVD title before commencing playback of that title It's easy enough to call IDvdInfo2::GetCurrentUOPS once you've started playing the title, but my application is only interested in playing a title if it's possible to navigate to a different title during playback! I've already looked at IDvdInfo2::GetTitleAttributes but that's no help. A bit of background info - the UOPs are the User Operation controls, basically a set of flags allowing the DVD disc to determine, at any given point on the disc, which navigation commands (if any) the user may use. My application iterates through the "titles" on the DVD in search of the feature title that ...Show All

• Windows Forms DataGridView and Update/Insert/Delete data in MS Access

  Hello, I have an application (Windows Forms) that populates a table from an *.mdb file to a DataGridView . Is there any tutorial available which shows how to implement Update/Delete of current data, or Adding(Insert) new data using the DataGridView   Thank you in advaned. Ok i found the problem. As you suggested the problem was caused by the "Copy Option" of the database file. It should have been set to "Never". The OledbException though was caused because the database didn't exist in the "..\bin\debug" directory of the project. I fixed this by copying the database to this directory. ahmedilyas thank you for you help. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Adding models at runtime

  Hello! My application reads information from an OPC server. Each model is a cylinder (Standard Primitives) I have made 1 basemodel of the cylinder that i change the height and radius in runtime by scaling it. My problem is that when the application first time gets information from the OPC server it contains only one cylinder, 2min later it could be 30cylinders. The number of cylinders will change under runtime. In the startup i load one model of the cylinder: protected override void LoadGraphicsContent( bool loadAllContent) { if (loadAllContent) { Model modelRulle = content.Load< Model >( "Content\\Models\\Rulle" ); } Can i resuse this model to clone or copy it in runtime ...Show All

• Smart Device Development no exe in task manager

  Hello, I have the strange phenomen that my cf2.0 application is not show in the windows task manager. (PocketPC 2003/SE and Windows Mobile 5) Can someone tell my why Thanks Karin In most cases developers are trying to _not_ show application in task manager, so I would guess blank application shows it. You can create new blank application and replicate whatever it does on to your application. ...Show All

• SQL Server How to translate oracle decode

  Hi, How to translate oracle Decode without changed code I mean: I have one application and instead to change all decode to case when I would like just replace decode for dbo.decode, so I Wrote this function select dbo.fnDecode( 1 , 2 , 3 ) first parameter always int, and the others parameters could be char, int or float. I would like to test first value and return second or third value -> sql_variant for all parameters, ok but I can use + or - I can't do this select dbo.fnDecode( 1 , 2 , 3 ) + dbo.fnDecode( 1 , 2 , 3 ) If I put cast ok, but I is there another way, overload this call With clr doesn't work, because Sql Server doesn't accept function overload calls from C# Any ideia ...Show All

• Windows Forms DataTable as My.Settings

  Has anyone used a DataTable as the type for one of the settings in My.Settings I can't get it to save the table data, and if there are other settings they do not make to the My.Settings XML file either... Thanks, Tony ...Show All

• Visual Studio 2008 (Pre-release) How to cancel a context menu from opening in Windows app

  I'm working in a window app: 1) When user right clicks on a control to open the context menu, and before it opens I want to run logic to determin which menu items to enable and disable. What's the best event to do this in The only event I found that I could do this is the context menu loaded event. 2) After the right mouse click and before the context menu displays, if certain conditions exists I want to cancel the menu from opening as if it didnt exist. How can I do this Thanks. Thanks. I tried this and the event now fires when I expect it to, however, the event handler is added to a thumb control but the event's e.Source property returns System.Windows.Controls.Border. Hmmm. I need to g ...Show All