robzappa's Q&A profile

• SQL Server management studio

  is there a way to deploy only the workstation tools Can I create an msi or sms package to install only the tools I need for users to have Can I lock down the interface so all options are greyed out other than workstation tools thanks You can perform a "Tools only" install of SQL Server by selecting "Client Components" during SQL Server 2005 setup. Are you looking for something more granular than that As far as deploying it from SMS, I'm not sure. I think this thread is better suited for the SQL Server Setup & Upgrade forum. Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ ...Show All

• Visual Basic Problem with DataGridView Control

  Hai all I have a Windows Form with Show button , Update button and DataGridView controls. To Display Data From CUSTOMER(MS ACCESS2000) TABLE . Public conn As New OleDbConnection("provider= Microsoft.Jet.OleDb.4.0; data source=ss.mdb") Private Sub cmdshow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim myada As New OleDbDataAdapter("select * from customer", conn) Dim myds As New DataSet myada.Fill(myds, "Customer") DataGridView1.DataSource = myds.Tables("Customer") End Sub IT IS WORKING FINE TO DISPLAY DATA. BUT THE PROBLEM IS WHEN I WANT UPDATE DATA IN DATAGRID CONTROL. UPDATIONS ARE NOT EFFECTING TO TABLE I have tried through thi ...Show All

• Windows Forms Hide Columns Using DataSet

  Once the dataSet is binded to the datagrid...how would i go about showing only certain columns like this.dataset.Table.Coulmns.ColumnName = "SomeColmn".Hide....or how would i do that this ._dsItemRates.Tables[0].Columns[0].ColumnMapping = MappingType.Hidden; this is what got my column hidden thanks!! ...Show All

• Smart Device Development Ad Hoc Wifi note exchange

  Hi - i'm playing around with an app that allows myself and a friendto exchange notes between our wifi-enabled devices, connected ad-hoc. The devices both use Windows Mobile 5. I have done various things with Bluetooth, but this is my first real attempt at Wifi. Does anyone have samples (in C#) that demonstrate how to connect an ad-hoc network dynamically (well, with least user intervention as possible). I'd also like to see something that shows how to send a file between the devices - although i'd imagine that you don't have to do anything wifi protocol specific - this is done at a higher level right many thanks, steven. ...Show All

• Visual Studio ss.exe get with no prompt

  Hi, In the VSS i want to write a script that perform a get for a directory but it stuck and wait for user answer ,I get the following prompt ( the string in <> is changed by me it's directory name that i am checking out ) : <directory> as the default folder for project < vss-directory> (Y/N) How can i set that the answer is NO. Thanks. Zvia I was looking for that for ages. The command line help for this is quite confusing I think. I had a read over the -I (i) switch thinking it was nothing to do with such auto answer / silent run options. Until you go right into the full switch details and read the info on that particular switch I had no idea where it was hidden. Tha ...Show All

• Audio and Video Development Video Transitions and Effects missing

  Hello! I got problem when I tried to make my slideshow. I could not find any transition and effect in Windows movie maker. This program displyed "Video Transitions and Effects missing" Please help me how to get them back. Thanks you so much. Regards, FFFC You have reached the wrong forum for your question. I suggest you post your question in the Movie Maker Newsgroup at http://www.microsoft.com/windows/windowsmedia/community/newsgroups/WindowsMedia/default.mspx Sumedh ...Show All

• Smart Device Development How can i launch my service after installation [native Service .dll]

  How can i launch my service after installation that is when installation is successful it will be launched ...Show All

• Internet Explorer Development Is it possible to let multiple BHOs add their own context menu items?

  Hello, Thanks for providing this forum to ask questions for MS technicians who know the inside of IE. I have a BHO that shows some context menu items with the default IE items together. The approach was from an article on MSDN http://msdn.microsoft.com/library/default.asp url=/workshop/browser/hosting/wbcustomization.asp The approach is good for only one BHO to add context menu items. But if more than two BHOs are existing, this approach seems not working. Is there any good solution for this problem The short answer: do not use IDocHostUIHandler from a BHO to replace the standard context menu. You will invariably override other BHOs and possibly expose options that are supposed to be locke ...Show All

• SQL Server Data Conversion Numeric to date

  I have some data which I am trying to put into a DM where I can use it as part of a cube (my first!!) I have hit a small problem with dates, I get it from the ERP system as a numeric field, and I need to convert it to a date format. The intension is to use this converted data with Named Calculations to derive Year, month Day ect. However I cannot seem to be able to convert and store (in SQL) this column can anyone advise Thanks The source column is called AHDATE and a value is 60703 which I am told is YY/MM/DD and using a data conversion componant transforming to data type date[DT_DATE] I get 12/03/2066 00:00:00 Which is way out Thanks for any help Robbie ...Show All

• SQL Server Outer join problem

  Hi guys I have got two tables which I need to join table 1 DHBName DHBService PU Budget Admission ABC C1 M00 $200 Acute ADC C2 M10 $300 Severe Table 2 DHBService PU Admission Actuals ABC M10 Severe 412.88 ADD M12 Acute 333 The 'DHB Service ' , 'PU' and 'Admission' are common in two tables but 'budget' and 'actuals' are different I need to combine these two tables in such a way that I have all the fields from both the table The sample result should be like this DHBService PU Admission Budget Actuals ABC M10 Severe Null 412 ADC M00 Ac ...Show All

• SQL Server Primary Key Question

  I have been developing a .NET Web app with an SQL Server 2005 Express database. Since I've been testing insert and delete code with a large data source, the Primary Key column which is also an autoincrement integer column is now at very large numbers (starting at over 40,000 now). I've tried doing a shrink on the database, but other then reducing the database size, it has done nothing to reduce the Primary Key numbers. Is there a command way to reduce the starting number back to 1 or do I need to completely reconstruct the database from scratch TIA hi Carl, Speedo wrote: .... I'll take your advice on the autogenerated key into account and redesign accordingly. One of the two curren ...Show All

• Visual Studio 2008 (Pre-release) Focus and LostFocus

  Hi, How do i go about refocussing my control on within Lost focus event. I have the following code but it seemed to keep firing the LostFocus event whenever I call Focus _xNameTextBox.LostFocus += new RoutedEventHandler (_xNameTextBox_LostFocus); void _xNameTextBox_LostFocus( object sender, RoutedEventArgs e) { bool found = false ; if (!found) { MessageBoxResult result = MessageBox .Show( "Error or Continue" , MessageBoxButton .YesNo); if (result == MessageBoxResult .Yes) { _xNameTextBox.Focus(); } } } Thanks, Don't use lostfocus event use PreviewLostKeyboardFocus( object sender, KeyboardFocusChangedEventArgs e) and set e ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do I protect my code when distributing it?

  Having read the FAQ. I noticed that in order to share your game creations (and lets face it, you can't get recognised without sharing your games), you need to send the other person the entire uncompiled game. This includes sourcecode, graphics, music, sound etc. etc. They then compile the code and download it to their xbox360 account and then only if they too are on the games creation program. My key worry here is that you send them everything you have just worked incredibly hard to create. Presumably they can then send this stuff on to whoever they please and god forbid, even sell it on! It strikes me that there isn't much incentive to distribute things this way. How is Microsoft going to prevent the above scenario Is there going to be a ...Show All

• Visual Studio Team System Error TF50604 during Installation

  I've got a problem during the installation of the TFS 2005 RC. First I've set up a brand new PC with Windows 2003 Standard, Active Domain Controller (= ADC; and new DNS; the new domain is addc.mydomain, mydomain is an existing NT-domain, but I used "New Tree", so this shouldn't be the problem...) After that I created three new accounts on the ADC-computer (TFSSetup, TFSService, TFSReports), TFSSetup is a Domain Admin, the two others are Domain Users. On the other computer ready for the TFS (SingleServer) I did everything according to the chm-file (TFSInstall.chm), which includes installing hotfixes, sql server 2005 standard, and so on, then starting setup. I entered ADDC\TFSSetup, ADDC\TFSService, ADDC\TFSReports as the user acco ...Show All

• Community Chat Possible logo for the upcoming zunephone

  you guys will most likely not like this at all, but its something that came to me when i was watching television. http://img.photobucket.com/albums/v121/dephy/zunephone.jpg Hi there, Made this for ya just for fun... http://www.alastairq.co.uk/zune.png Regards, Alastairq ...Show All