marcy's Q&A profile

• Windows Forms How to retrieve the data in DataGridView?

  Hi, I am using Visual Basic 2005 Express Edition and MSSQL Express Edition for database. I am doing a quotation application and I have the following in my DataGridView: ProductName, Qty, UnitPrice, TotalCost ProductName is a comboBox and its databound to my product database. I am hoping that when a client chooses a product in the comboBox, the UnitPrice will automatically reflects the actual price thats in the product database as well. I know i need to retrieve the data in ProductName column and execute a SQL statement to get the UnitPrice. But how can i get the ProductName data which the client has selected Hoping someone can point me to the right direction here. Thanks In the editing control s ...Show All

• Visual Basic Process not completing

  I have a vb form that runs a command line executable that creates a diff file from two existing files. When I run the program from the command line it creates a 419Mb diff file. When I run it as a process from my VB program it gets to ~400 Mb and stops. If I kill the VB program the command line executable continues to run and finishes the diff file. So I have 2 questions. Why does the process stop before for it finishes when I run it inside vb Why does the program continue to run when I kill the VB app. Here is my code Private Sub xdelta( ByVal strFile1, ByVal strFile2, ByVal strDelta) Dim strError As String Dim p As New Process Dim info As New ProcessStartInfo info.UseShellExecute = False ...Show All

• SQL Server How to hide Calculated Members (in the Measures dimension) using Roles

  My solution requires a large set of Calculated Measures which I would like to hide on a per Role basis. I have managed to add a role and hide particular Measures for this role (using the "Dimension Data" page of the Role properties), but at this point, no Calculated Measures show up for hiding. Even if I go into the Advanced tab and write some MDX to generate the set of allowed members it does not work: FILTER([Measures].ALLMEMBERS, INSTR([Measures].CURRENTMEMBER.NAME, "Prefix_A") > 0) It seems that when role security is evaluated, the cube has no knowledge of it's calculated members... There must be a way to do this. Even if I can't use roles, I need to acheive selective hiding of the calculated measures in an arbitrary client ...Show All

• .NET Development Access query to transpose table data

  Hello, I have the following table structure in my database and would like to create a query or table that displays a single record for each country with the three different RatingsType1 across the top as column headings with the respective rating filled in. Something like this: Country Rating1 Rating2 Rating3 US AAA CCC Baa1 where Rating1, Rating2, Rating3 are one of the three types of ratings from the tblRatingsType1 table. Here's the table structure: tblCountry CountryID (PK autonum) CountryName tblCountryRating CountryRatingID (PK autonum) RatingType1ID (FK to tblRatingType1) Rating RatingDate tblRatingType1 RatingType1ID (PK au ...Show All

• Visual Studio Team System How to check the current code is completely managed or not?

  Is it possible to check that whether give code is completely managed or not through fxcop 1.35 If yes then how can unmanaged code be find out from the given code Hi Jeffrey, Thanks for replying. Actually I want to check that my .NET window based application (in C#.NET) having 100% managed code or not. So, I want to check for both about presence of pinvoke and com interop as well as whether any mix mode c++ assembly is presence or not. ...Show All

• Visual Studio Express Editions File System Tree View and Folder Contents

  I am trying to develop a program like Windows Explorer.  I have searched the forum a little and really have not gotten very many answers that I thought have 100% answered this.  I do not know how to display file structure.  I would like to be able to maniulate files in the Folder contents pane and navigate with the Tree View pane.  Anyone have any good links or source   Thanks. You will have to use the System.IO name space and the DIrectory and File classes pseudo Dim cFolders () As String = IO . Directory . GetDirectories ( "C:\" ) For Each s As String In cFolders Dim di As New IO . DirectoryInfo ( s ) Dim NewNode As TreeNode = Me . TreeView1 . No ...Show All

• Windows Forms some questions about Setup and Deployment Project

  I make a installation by the C# Setup and Deployment project.(I choose the Setup project.) There is a window service application in the installation package. 1. Is it possible to start the service by the installation I have tried, but failed to do that. You know, some service application need to restart computer to start the service. Is there a easy way to start the service during the setup. 2. When user reinstall,(that means user has installed, but user runs the installation package again.) the install package will ask user to repair or remove the installation. Then the user select repair, you can imagin, the system will pop up an error message because it cannot install the service application.(The reason is, the service has been i ...Show All

• Visual C# Embed Excel in WebBrowser on DotNet Form

  I am able to embed Excel into a WebBrowser on a dotnet form on my Dev machine but on a client machine an instance of Excel starts in it's own window outside of my form. I have use the MS example from MSDN and get the same result on non-Dev machine ISomeone remarked it maybe due to IE setting Does anyone know what the setting are and if they can be set on client machines to get my Dev and Non-dev machine to act the same Thanks Browser = new WebBrowser(); Browser.Dock = DockStyle.Fill; Browser.Location = new System.Drawing.Point(0, 0); Browser.Name = "Browser"; Browser.Size = new Size(223, 443); Browser.TabIndex = 0; pnlPreview.Controls.Add(Browser); this.ResumeLayout(); Browser.Url = new Uri(sPath + " \\myxls.xls " ...Show All

• .NET Development Server Control Id and Name from Script

  I have a doubt. I placed a web server Button with in the Content Region of a Master page. i gave the Button ID as "Button1". But at Run time when i access the Button from Javascript thru as alert(document.getElementById( 'ctl00$ContentPlaceHolder1$Button3' ).value); i am getting object not defined error. I checked the view source of the web page. then i saw that my button id and name changed to ctl00$ContentPlaceHolder1$Button3 and ctl00$ContentPlaceHolder1$Button3. Now how i can access my Button from script or how will get the new(changed ) name and id from my script Sreejith If you can count on the text/name of your button staying the same you can use something like this ...Show All

• Visual Studio Team System Adding FxCopCmd.exe to Post-build event command line options

  Hi, I have followed the steps for VS 2005 integration at this page: http://www.gotdotnet.com/team/fxcop/Docs/FxCopCmd/FxCopCmd_VS.html and everything has worked correctly. I wanted to push the integration a step further. So I opened one of my project's properties and under Build Events / Post-build event command line I entered this information: "C:\Program Files\Microsoft FxCop 1.35\FxCopCmd.exe" /p:"D:\Astrum Development\XStrata\Vega Nickel\AstrumFxCop.FxCop" /c When I build my project, after my project has been built, it starts FxCop, performs the analysis it tries to write the error message, but instead the output windows shows an error message saying : Cannot load PDB file. The results from FxCop aren't displayed, and oftentimes thi ...Show All

• Visual Studio Express Editions How do I insert leading zeroes into a number string?

  Visual Basic 2005 Express: I am creating a customer SQL database table. I want the customer number to be a 6 digit number where the first added customer's number will be 000001, etc. If CustomerBindingSource.Current( "CustomerNbr" ).ToString = "" Then CustomerBindingSource.Current( "CustomerNbr" ) = Me .CustomerBindingSource.Count End If This gives me "1". How do I change that to "000001" ...Show All

• .NET Development WebServices project file

  Hello I've noticed that unlike in framework 1.1, a web service in framework 2.0 does not have a project file (csproj). MY question is - without a project file, how does the asp copmiler knows which classes to include in the web service Thanks, Gil, First of all, project files are not related neither with framework version nor with the c# / vb.net compiler. Those files (solution files, project files, user options, etc) are just related with Visual Studio. Visual Studio 2005 manages web projects (web sites) in a different way than Visual Studio 2003. It doesn't use project files for web projects now.... instead of that, it will open all the files that resides in a virtual directory in ...Show All

• SQL Server commenting hyperlinks in query editor window

  Is there a character or character sequence to annotate hyperlinks in your query windows so that it will conform to valid TSQL code and simply ignore the hyperlink, yet still allow the hyperlink to function in the editor For example... Create Proc dbo.Hyperlink as begin --below link is the sql server homepage for MSFT http://www.microsoft.com/sql --commenting it out disables the link in the editor end allready did a LONG time ago lol... http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=124874 so what does ACTIVE mean will this ever be built ...Show All

• Visual Studio Team System How to check variable in property

  Hi: In my test assembly have the two Property public int password { get { int inta1 = 9; return gintYmya + inta1; } set { gintYmya = value; } } public string UserName { get { return gstrName; } set { string strPrifix="str";gstrName =strPrifix+ value.ToString(); } } I want to check 'inta1' and 'strPrifix' but how to check them ...Show All

• SQL Server problem with Server Management Studio Express and diagrames

  so I have had a database in Sql Server 2000, in my DB i have made database diagrams. now I have installed on other PC(where does't install sql 2000) Sql Server Management Studio Express where I have opened my db , bat db diagrams does't work. what can I do how can I solve this problem enyone can explain me thanks. Management Studio can't open SQL 2000 diagrams, if you click on the diagrams branch of the tree it should ask if you want to install diagram support, once this is done you can create new diagrams. ...Show All