bmgun79's Q&A profile

• .NET Development Connection not Alive

  Sorry to post again, I think the other one has been forgotton I have a Windows Form, (Application). On that I have a TextBox called txtIdNum, a Button, and a TextBox called TxtNombre What i want to happen is when someone types into the txtbox txtIdNum, and press the button, the code will search the MSQL table, and select all the fields where FIELD IDNum is = txtIdNum.Text Straight forward, easy to say. My code is the following System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection("SERVER=localhost;DATABASE=test1;UID=sa"); System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.S ...Show All

• Visual Studio Mass renaming files in Visual SourceSafe 6.0

  Is there a command to change all file names to lower case in Visual SorceSafe 6.0 I have looked in multiple places but have not come up with anything. Thanks, Reid Hochstedler You can do it through IVSS. I added a code snippet which does most of the work. 1. I created a Windows Application project in VB and added reference to the SourceSafeTypeLib. 2. I added a button to the form and added the following code: Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim myDB As New SourceSafeTypeLib.VSSDatabase myDB.Open("C:\SSDB\srcs ...Show All

• SQL Server Errors in the OLAP storage engine:

  Errors in the OLAP storage engine: I am new to Analysis Services. I created a cube using Analysis Services 2005 with 3 fact tables and five dimensions. All the dimensions processed successfully apart from one dimension table which gave the following error. The attribute key cannot be found: Table: dbo_Severity, Column: SeverityCode, Value: 6 When i try to deploy the cube, I also fail. Is it because of this dimension table in which the attribute key can not be found. <Batch xmlns=" http://schemas.microsoft.com/analysisservices/2003/engine "> <Parallel> <Process xmlns:xsd=" http://www.w3.org/2001 ...Show All

• Visual C# Replace main node name

  This might be a simple question.... I have an xml file: < xml version="1.0" encoding="UTF-8" > <Content> <Element1>ele2</Element1> <Element2>ele2</Element2> </Content> I want to replace Content with Page in my C# application and I tried: XmlNode firstNode = xmlDoc.SelectSingleNode("Content"); firstNode.LocalName.Replace("Content","Page"); Obviously I am doing it wrong or not understanding it properly, so, I am not getting the desired output. What is the correct api that I should use hi, i'm still learning too , i ...Show All

• Visual Basic Installing VB.Net without product ID

  I lost my CD box that has product ID on the back. I want to install vb.net 2003 on my new laptop. I have vb.net installed on my desktop. Is there any way I can install vb.net from my desktop or using the original CD without using product ID While I don’t know how to install VB2003 without a product key, this may be an opportune time for you to make a free upgrade to Visual Basic 8 with Visual Basic Express which is a version of Visual Studio 2005 that lacks a few of the advanced features of the paid versions and is simply a language specific version of the more expensive ones and still gives you exa ...Show All

• Visual Studio Team System Test-Driven Development and Interfaces

  Hello! I've got this interface called ISet<T> which my ArraySet<T> class implements but right now I've only created the implementation of the interface and my ArraySet code looks like: public ArraySet<T> : ISet<T> { } When I try to build ofcourse I get alot of errors that my class is not implementing the interface members. When using Test-Driven Development I should not write any code that my tests isn't testing. to be able to build now I have to write empty methods for all my interface members before I've got tests for them. Is there a good practice for how to do this or should I just write empty methods to impleme ...Show All

• Visual Basic Updating a Access Database from Visual Basic

  Hi. I'm havng trouble with updating my Access database from Visual Basic. There are no problems when populating datasets from the database, but as I try to update it after some changes, nothing happens.. Anyone got an idea Hege Hi! Got the same trouble for three days, this mounstruous behaviour happens when you answer YES to the question about copying the database to your solution directory. Just repeat the add new database process, take care to answer NO when prompted to copy the database, and it works fine. (It is important too that the table has an index, and to configure it with the desig ...Show All

• Windows Forms how to know a file has changed on close

  Hi, I'm new to VB .NET and have an MDI app = standard word processor. As per a standard word processor, when I choose the 'Close' menu item I need to determine if the file has been changed. If so, prompt save file dialog. I can do this if the rtb.text.length has changed, but this doesn't always recognize I changed the file (obviously). I trie ...Show All

• Windows Forms Is this a timing Issue with the datagrid column?

  I've got a treeview and a datagrid on a windows form. When the user makes a tree selection, I populate the datagrid by creating a dataset and setting the grid's datasource to it. I also hide some of the columns by setting their width to zero. This is all within the tree's 'After_Select' event handler. However, sometimes when you select a tree node, you ...Show All

• Windows Forms How do I zap the cell formatting when a user enters a cell in datagrid?

  I have a data grid that is populated via dataset which is filled via SQL server.   Some of the columns are numeric and are formatted for display per my users specfications via DataGridTextBoxColumn.format.    It all looks great and the user was initially quite happy.  When the user enters a cell to edit it the formatting remains and the entire cell contents is highlighted as normal. This is fine if the user is going to replace the entire value .... but if the user hits F2 and changes only a single digit in a larger number containing the formatting, the new value is replaced with the old value since the new ...Show All

• Windows Forms How to do form authentication and authorization in my WinForms app?

  I am wanting to use the standard way of authenticating and authorizing a user for my Winforms app. Can someone point me to code that implements the above for a Winforms application you should look in the QuickStarts examples in teh Framework SDK---CommonTasks---if you want Active Directory auth -- there is example there ...Show All

• Visual Studio Tools for Office Invoke action for all Smart Tags in Word document

  Hi, I would like to add a button on this actioin pane that replaces all Smart Tags of the same type with some other text. Is is possible to programmatically invoke a Smart Tag action from the action pane (eg: the user does not click) My problem is to instanciate the ActionEventArgs correctly ... Or is their any other way to run a function on a Smart Tag that replaces text, based on its properties Thanks You can invoke an action programmatically. If I have a button on my ActionsPane, here's the code I can put in the click event: Globals.ThisDocument.SmartTags.Item(1). _ SmartTagA ...Show All

• Visual Studio 2008 (Pre-release) Interoperability and utility

  XML, to me, has always been about interoperability, and XQuery was going to bring the promise of XML to the database world. The promise that my code could work as easily with an Oracle database as it could with SQL Server -- the database would become a black box, and data would become universally accessible. Is LINQ going to bring about an end to that dream My question is born out of ignorance, because I don't understand LINQ well enough. What I'm hoping for is an answer XQuery will continue to flourish, the time of language lock-in has dissapeared forever. You can read the XLinq (Linq for XML) overview her ...Show All

• Architecture Why use an application server?

  My boss wants me to explain to him the advantages of having an application server in our web app. Currently our web app talks directly to SQL Server. What are some of the pros and cons of having an application server in this type of application --SY There are several reasons why you want to separate your User Interface layer (Web) to your Data layer (SQL Server). For example from a scalabiltiy perspective, you could introduce notions of caching and/or you could pool the databases connections so that you can scale out your web farm without increasing the number of connections to the d ...Show All

• .NET Development problem finding an exchange server(s) in Active Directory.

  Hi, I want to find all exchange computers and organization in the active directory i'm using the followed filter strings in C# (.NET 2.0), but it doesn't work. can somebody tell me why filters: echange computer: "(&(objectCategory=msExchExchangeServer)(objectClass=msExchExchangeServer))" exchange organization: "(&(objectCategory=msExchOrganizationContainer))" Thanks, CODE: public DataTable getExchComputer( DirectoryEntry startHere, SearchScope scope) { System.Diagnostics. Debugger .Break(); DataTable dt = new DataTable (); dt.Columns.AddRange( new DataColumn [ ...Show All