Alok_sriashoka_Patna _city's Q&A profile

• SQL Server Data Extract - Partitioning

  Hello, I have a table containing 3 columns Department Name, RiskScenario and Cost. I am trying to create a data extract that contains the top 3 Risk Scenarios (sorted by Cost) per Department. I tried using this sql statement in MSQuery but it doesn't work. Any ideas where I'm going wrong or if there is a simpler way to do this Select * from ( Select DepartmentName, `Risk Scenario`, Cost, row_number() OVER (PARTITION BY DepartmentName order by Cost) rn FROM 'Departmental Risks`) where rn <=3 Please help. Just can't figure this out! Meera Is your target database an Access database or a SQL Server 2000 database The errors you are getting indicates that the target database is not SQL S ...Show All

• SQL Server Dividing a Column

  I have a column that contains the persons Full name. I would like to split it so that it contains the persons First Name and Surname. Can i do this from a select command. Hope you can help e.g. Full Name -------------- Dave Smith Want to acheive First Name Surname Dave Smith Louis: I agree with you completely. I should have been less terse with my first alternative and stated something more along the lines that led to a corrected design. I am guilty of frequently trying to answer the questions too fast for the sake of being more brief. Please continue to try to keep me straight. What I need to do is commit to slowing down and discussing the root proble ...Show All

• Visual Basic 101Samples but can't use

  I downloaded the 101Samples for VB, it says, and installed them, but the first one I try to examine, WorkingWithTheInbox, I get error "Project type is not supported by this installation." Of course, it doesn't mention what the type is or what is missing from the installation or how to find out. Another following dialog box says "Make sure the application for the project type () is installed." Suggestions And while I am asking, after making cut and paste a major feature of Windows, why can't I copy the text out of the message box to paste here Same thing with Help About - as in "Please give the date and version information from the Help About." And copying will not work to pick up the strange small detai ...Show All

• Software Development for Windows Vista Problem with test case 13

  Certified for Windows Vista Test Cases Version 1.2.000 of December 7, 2006 states in test case number 13 that " Verify application’s installer contains an embedded manifest ". To pass this test case I do the following steps: 1. I generate the setup.exe.manifest file using the "mageui.exe" tool. 2. I Add a line under the <Security></Security> tag. as follows: <requestedPrivileges> <requestedExecutionLevel level="asInvoker" uiAccess="false"/> </requestedPrivileges> 3. Using the "mt.exe" tools I embedded the manifest file into my setup.exe file using the command line as follows: mt.exe -manifest setup.exe. ...Show All

• SQL Server General Network Error Check network documentation

  Hi I get a "General Network Error Check network documentation" error sometimes, but its only while insert or update statements are fired while selects keep working perfectly. The Error details are as follows: General network error. Check your network documentation. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the orig ...Show All

• Windows Forms Visual cue between groupings in DataGridView

  I want to give a visual cue to distinguish groups of rows with the same CompanyID in a DataGridView.  Is it possible to insert a separator on a break in CompanyID  Or would alternating background color be better/easier  What is the best way to achieve   Thanks. Take a look at the datagridviewadvancedborderstyle class ...Show All

• Visual Studio dexplore.exe from VS2005 takes a lot of memory to run

  Hi, Installed VS2005 professional (Release), and when I run MSDN library for Visual 2005, it takes above 200mb on start - dexplore.exe takes that abount of physical memory. Also, the same problem happens with VS2005 itself - it takes more than 200mb while it starts. If I will start another VS2005 instance - it will take 200mb too, and thats a problem for add-ins development. Please, let me know, is there any way to fix this issue. Few lines from the about box: Microsoft Visual Studio 2005 Version 8.0.50727.42 (RTM.050727-4200) Microsoft .NET Framework Version 2.0.50727 Installed Edition: Enterprise Sorry to say but I am running the VS2005 SP1 Beta (from Microsoft Connect Beta Program) and the problem occurs here ...Show All

• .NET Development Automation Error Raised by VB6 App on a .NET component ever since installing .NET 2.0 Framework

  I noticed that a VB 6 app is no longer able to properly call a .NET component exposed with a COM interface that was compile via Visual Studio 2005, it raises an Automation error . Setting the application configuration file to point to the .NET framework v2.0.50727 does not help the situation. However, when the .NET component is compiled via Visual Studio 2003 it works provided I have the infamous application configuration for the VB6 app set to: < xml version ="1.0" >  <configuration>     <startup>          <requiredRuntime version="v1.1.4322"/>          <supportedRuntime version="v1.1.4322 ...Show All

• Visual Studio August 2006 Sandcastle is now available for download

  August 2006 Sandcastle CTP is currently available at http://www.microsoft.com/downloads/details.aspx FamilyID=e82ea71d-da89-42ee-a715-696e3a4873b2&DisplayLang=en . This blog http://blogs.msdn.com/sandcastle/archive/2006/08/27/727310.aspx , details what's new, xsltransform syntax changes and bug fixes in this version of CTP. I have also modifed the CHM generatation steps at http://blogs.msdn.com/sandcastle/archive/2006/07/29/682398.aspx . I plan to post additional blogs with details about steps for CHM generation, new MSDN link option in Sandcastle. Visit http://www.sandcastledocs.com  wiki site for additional details.   Anand.. I've found a way around this, in sandcastle.config there is the fo ...Show All

• Visual Studio Express Editions Rounding TextBox Value to 2 Decimal Places

  How do you let a user only put a number to 2 decimal places in a texbox like this: Private Sub TextBox1_KeyPress ( ByVal sender As Object , ByVal e As System . Windows . Forms . KeyPressEventArgs ) Handles TextBox1 . KeyPress If Char . IsLetter ( e . KeyChar ) Then e . Handled = True End If End Sub Private Sub TextBox1_TextChanged ( ByVal sender As System .Object, ByVal e As System . EventArgs ) Handles TextBox1 . TextChanged If Not Me . TextBox1 . Text ( Me . TextBox1 . Text . Length - 1) = "." Then Try Me . TextBox1 . Text = CStr ( Math . Round ( CDbl ( Me . TextBox1 . Text ), 2)) Me . Tex ...Show All

• Visual Basic Error updating Exchange via web dav from vb

  I am trying to run some VB.net code to update our public contacts folder. I can manually update the contact folder from Outlook or OWA without any problems. However, when I use the same username/password from VB.net to try to update a contact I get an "Access Denied" error. However, I can view the contacts without any problems. Any suggestions would be greatly appreciated. thanks, Luis ...Show All

• Visual Studio 2008 (Pre-release) Why a GeometryModel3D which Opacity setted as 0 can blot out other GeometryModel3Ds ?

  When I Set a GeometryModel3D object's Opacity to 0 in a viewport3D, it has been lucency,but it blot out other Model3D objects ! I think when I set a Opacity of GeometryModel3D object to 0,the GeometryModel3D object should be disappear ,and not hidden other Model .Anybody can tell me why You may just need to re-order the models you have in the scene so they render from furthest away from the camera to nearest to the camera. I don't know if this is true for Avalon but in DirectX, you have to render 3D things in the corect order for translucent surfaces to work as expected. Say you have the following scene: ------------ <- triangle A z=-1 ------------ <- translucent triangle B z=0 \/ <- camera z=1 If you re ...Show All

• Visual Studio DebuggableAttribute in ILDASM Manifest for Release Builds

  A while back we were having problems with a client of ours and after working with Microsoft, they told us that the assemblies the client had were debug versions. They pointed out that the DebuggableAttribute was in the ILDASM manifest of our release assemblies and that this meant they were debug and not release. After changing a few parameters being passed to the compile r we were able to get pdb from release builds without the attribute. However after upgrading to VS2005 and using MSBuild no matter what setting I have /p:DebugType=pdbonly or /p:DebugType=full I get the attribute in the assembly. Even though the documentation states the difference in pdbonly vs full is that the when using "full" the compiler emits the Debug ...Show All

• Visual C# can i create a new object using a variable?

  for example.. i want to create a new Panel everytime i click on the "next button" .. but each time i want its name to be different,, like for example onButton_Click(...) { Panel panel(here i want to add a variable or whatever to make it unique) = new Panel(); } using System.Collections.Generic; Dictionary<String, Control> MyControls = new Dictionary<String, Control> public void Button1_OnClick(Object sender, EventArgs e) { MyControls["somevariable" + "name" + 1].add(new Panel); MyControls["somevariable" + "name" + 1].Name = "somevariablename1"; } void SomeWhereElse() { Panel pnlNameDoesntMatter = (Panel) MyControls["somevaraiblename1" ...Show All

• Visual Studio Tools for Office VSTO assembly for multiple word document

  Hi All, In our application we generate multiple word documents and the user can preview one or more documents through the application. We attach a VSTO assembly to the word document when the user tries to preview/open a generated document. We currently are creating a new Winword.exe process using the code snippet as given below : objmoword = New Word.Application We then attach the VSTO assembly to the word document using the code snippet given below.We do not face any issues in attaching the VSTO assembly and it works fine. If Not Microsoft.VisualStudio.Tools.Applications.Runtime.ServerDocument.IsCustomized(sFilePath) Then Microsoft.VisualStudio.Tools.Applications.Runtime.ServerDocument.AddCustomization(sFilePat ...Show All