database_mentor's Q&A profile

• Windows Forms Tool bar buttons

  Dear All, I have compiled a c# program which includes a tool bar where tool bar buttons were placed Icons for those buttons were added by using an image list When the exe was run in my computer it displays the buttons with icons correctly But when exe file  was run in other computers buttons were displayed with out icons Is there a way to solve this problem Any help is appreciated Thanks Try commenting out Application.EnableVisualStyles().  If this starts working on other people's computers then check out this FAQ to further diagnose.  http://blogs.msdn.com/rprabhu/archive/2003/09/28/565 ...Show All

• SQL Server Help with SUM

  Take a look at the link below.  Look at InHouse2.  I want @InHouse1 in the InHouse2's query not to reference the whole sum like @InHouse1 currently is but rather the same fomula from InHouse1 based on the record level I'm not sure how to do this other than combine all the previous queries somehow in this select so that it only references individual records. InHouse2 = InHouse1 * commision % for each record. Here's my SQL : http://www.photopizzaz.biz/projfee.txt Firstly, your query can be rewritten as: Select SUM(@InHouse1 * CASE WHEN FeeSchedule = 0 THEN 1 WHEN FeeSchedule = 1 THEN FeeSchedule / 100 ...Show All

• Visual C# mdac version problem

  Ok, so I just installed VC# express and SQL Express... I am setting up a data source for a data grid. The data source is an access database. I get this error: The .Net Framework OleDb Data Provider requires Microsoft Data Access Components(MDAC) version 2.6 or later. Version 2.50.4403.12 was found currently installed. I am running XP Pro SP2 and all WinUpdates. I downloaded and ran Component Checker version 2.0 and it says that all the MDAC files are version 2.7 Refresh or version 2.7 SP1 Refresh. I can't just reinstall MDAC because it was distributed in XP SP2 and it won't run the install because it "knows" that. --> MDAC 2.8 RTM is inco ...Show All

• Visual Studio Team System Cannot connect to TFS from Visual Studio

  I am not sure if TFS is even running.  I can get to sharepoint no problem, create new sites etc.... I can get to the report services no problem and when I browse to the TFS host machine from a workstation I get the sharepoint site.  I have tried running Visual Studio as the the tfsservice account and still I get the cannot connect dialog.  How can I tell that TFS is installed and working   Is there an admin utility What directories should I have in IIS Thank you in advance! You are missing the STSAdm commands... ALSO, you must separate the Report Server and Reports Virtual Directories ...Show All

• .NET Development Difference between Dispose() and Close()

  Hello All, This regarding the difference between Dispose and close(). I have quite large amount of data transactions and queries taking place in the database. when huge data is proceed i get connection closed error. Then i changed my code to close() dispose() I wanted to know whhether this the right way to implement. Please advice !!! Regards, Shalini No you just need to call close..no need to call dispose. IDisposable is an interface that is implemented by objects that wish to clear any resources that are used and need to tell the user that the object holds some resources( so dipose can be called to releas ...Show All

• SQL Server All Level Name - How do I change for each attribute?

  It looks like if I set the AttributeAllMemberName property at the dimension level, all attributes will inherit this name. If I have multiple attributes within a dimension, how do I change the 'All' level to read 'All <attribute name>' for each attribute ...Show All

• .NET Development Threading

  Hi all, In my pocket pc applicaiton, I'm trying to send data from internal database on the pocket to a main database on a remote server. Every thing is OK till I have communication problems (No internet, Server is down , low signal ,...). Whn I have a prolem the pocket is locked while it recieves an exception there is a problem. So, I separated the connection and sending data by a thread. Each thim I call the function SyncData() I call it with a thread T . What about if the user call this function many times, then I'll get many threads run in the background.  How I can control the background threads Is there a way to know how ...Show All

• Visual Basic Start application as Administrator.

  Hello, Is it possible to run a program as a different user, like Administrator. For example: I define the Administrators password in the program, the program starts, and then runs with Administrator priveleges. I know about the option 'Run as', but i want the program to start at startup, run as an Administrator and do his work. Thanks in advance. Hi, Yes, this is working fine, now i can continue working on my program. Do you have any idea for 'hiding' the Administrator password in the code Edit: I also use a SQL Database for my settings, maybe i should store the Administrator password ...Show All

• Visual Studio How to track the solution node, project node and item selection?

  Hi Gurus, I am working on a project with VSIP and C#. I used OleMenuCommand and ctc file to add menu items and command items to file menu and context menu. The problem I am facing is the menu items should be enabled and disabled based on the selection of solution node, project node and item node in the solution explorer. I tryed to use IVsMonitorSelection.GetCurrentSelection(...) to get the selections. But as for the seelction is often multiple, what I can get are IVsMultiItemSelect and ISelectionContainer. The problem here is these two things don't help too much, we still don't know what are being selected. Then I use IVsSolution.GetPr ...Show All

• Visual Studio 2008 (Pre-release) Some viewbox questions

  Hello, I'm using the viewbox to show a part of an image. This image has the following properties: -72 dpi -1024*1280 Thanks you so very much for your patience, excellent explenation of the pixel vs. DPI issue, and your provided solution. To answer your question at the bottom of your post. My image is indeed a part of my application, but I want to use it in 72DPI. Again thanks, Kimme ...Show All

• Visual Studio Team System Team Project Portal: Report Subscription Error

  Hello, I have created a some scheduled email subscriptions on a few reports in a team project portal.  When the schedule fires, the report fails with the following error: Failure sending mail: The Value expression for the textbox ‘textbox13’ has a user profile dependency. It always does this.  I haven't changed anything, except to add a schedule to the subscription.  What is it looking for Thanks for any help! Cindy Hello, It appears that the upgrade to the beta 3 refresh solved the problem. Thanks for everyone's help! Cindy ...Show All

• .NET Development in WinForm Designer - empty Data Sources Window

  I tried to reproduce the example explained in the article of Jackie Goldstein http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnvs05/html/NewDtaStVS05.asp I connect to a database and I see my connected database in the Data Sources Window. Now, when I change to the WinForm designer I can't see my Databases in the Data Sources Window. So I'm not able to drag my tables to the Form. After changing back to Code View of my Form all connected Databases are visible in my Data Sources Window. Is this a problem of my database or Visual Studio or did I understand something wrong My Version of VS 2005  is: 8.0.50727.42 ...Show All

• Windows Forms interface not registered?

  Hi, I'm trying to save an HTML file to a MHT file. This is what I'm doing: CDO.MessageClass msg = new CDO.MessageClass(); msg.CreateMHTMLBody("http://www.microsoft.com/", CDO.CdoMHTMLFlags.cdoSuppressNone, "", ""); ADODB.Stream stream = msg.GetStream(); stream.SaveToFile("test.mht", ADODB.SaveOptionsEnum.adSaveCreateOverWrite); But i get an 'Interface not registered' error... I've seen in lots of web sites&nbs ...Show All

• Windows Forms null value for databound lookup combo

  I have a databound combobox lookup e.g. display member is "custName" value member is "id" Selected value = "custFk" tblCustomers - id - custName tblOrders - id - custFk - etc.... How can i set the tblOrders.custFk to null when the user changes the combobox.Text to "" I've tried this.. private void exp_customer_fkComboBox_Validated(object sender, EventArgs e) { ComboBox cb = (ComboBox)sender; if (cb.Text.Length == 0) { try { this.exportsDataSet.exports[this.exportsBindingSource.Position].Setexp_customer_fkNull(); } catch (Exception ex) { MessageBox.S ...Show All

• .NET Development Framework 2.0 and 1.1

  Should the system have both versions of Framework (ie. 1.1 /2.0) or its safe to remove the old one (1.1)  I know that both versions can co-exist but , why to have both, compatibilty issues I haven't seen an FAQ specific to 2.0 come out online just yet (a lot of the docs are still getting published) but I haven't heard of any reason or changes that would prevent side by side execution from working the same way as is supported for 1.1 and 1.0.  VS 2003 and VS 2005 both will continue to function as normal if installed on the same machine. http://msdn.microsoft.com/library/en-us/dnnetdep/htm ...Show All