Ashish.Net's Q&A profile

• SQL Server How to get INSERT-SQL for rows?

  Hi I'm using the SQL Server 2005 Express edition. I've manually created some rows in a table "Books". If I right-click on "dbo.Books" and choose "Script Table As --> Create To --> New Query Editor Window", I get the SQL for creating that table. But how do I get the INSERT-SQL for the rows already inserted Kind Regards hi, there's no support for that task, you have to do it your self.. or you can have a look at a free prj of mine, amInsert, available at http://www.asql.biz/en/Download2005.aspx regards ...Show All

• Visual C# Which is better?help

  i'm currently developing a Multiple Choice Question(MCQ) application in C#, where student can practise their lesson & participate in an test exam. The test exam will be generated page by page. In each page there will be 2 questions(read from database); there may be more than 100 questions. So tell me which one is better: 1) predefined form for each two questions( it will take 50 forms) 2) forms & control will be generate at runtime 3) A predifined form + only generate necessary controls(Label, button etc) at runtime Please Help & Encourage Me. what I don't see is why you would need 50 forms it would seem to me that you can do it with one form without dynamic control placement . ...Show All

• Visual Studio Express Editions Saving Information

  Hello, I a making a program that will be opened once a day probably and some information will be imputed. How can I save the informaition to be used at a later date. I basically need to use something that is like a variable accept that the variable will be saved and after the program is closed and opened again it can be used. thanks Average Joe Your example is: 1.) more difficult to support 2.) more likely to have errors, 3.) is slower and less efficient and 4.) requires more memory and far more machine cycles 5.) is not parsimonoius ie; it's a "Rube Goldberg" 6.) Certainly everything does not have to be standard, but there's goodness to standardize simple things. That s ...Show All

• Windows Search Technologies WDS 3.0 Beta 2 Crash srchadmin.dll

  Hi! Every time I try to go into the filetypes in the Advanced option dialog WDS crashes on me. I get up a box saying "RUNDLL An exception occurred while trying to run "shell32.dll,Control_RunDLL "srchadmin.dll"". I used to have WDS 2.5 with some extra IFilters but I removed all that before I installed the beta. Thanks. Matt It looks like this happens with the RTW (final) version of WDS 3.0 as well. It happened on 2 different PCs here at work that had WDS 2.65 installed. On my PC which did not have any version of WDS installed, this was not a problem, although that could be a coincidence. ...Show All

• SQL Server Read property of "selected" dimension member (AS 2005 filter)

  Hello there I am using Richard Kutchaks CellsetGrid though this issue is of a general kind. I want to filter on a hierarchy. This filtering occurs as a subcube. I intend only to chose one member at a time. The thing is that I want to read the property "level" from the chosen (filtered) member. I can't use currentmember since no member is actually chosen, but the filtered hierarchy points at a member. Is there a way to catch that member and through that actually read properties of it I don't care if it fails when more than one member is chosen. This code worked when I used the old way of filtering which cannot be used with CellsetGrid: CASE WHEN [Prisme Dimension].[Hierarki Prisme Budget]. currentmember . LEVEL . NAME = [ ...Show All

• Visual Studio Team System Feature request: allow "Add as Link" functionality

  In C# project you can add file to the project as link. In other words, multiple projects can share single file. In Database project there is no such ability. In my opinion this feature may simplify version management. See: https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=231613 ...Show All

• Visual Studio 2008 (Pre-release) How to use LINQ in traditional n layer code pattern

  I am pretty impressed with the LINQ technology. And now that I am going to start a new ASP .Net Project I was wondering how to use linq to implement a traditional DAL & BLL layers. Will the linq data context and conceptual model go as a part of DAL or BLL or is it just common rather Many thanks Anubhav LINQ to SQL is the Data Access Layer in my opinion, so the LINQ data context should be part of the business layer. In effect you can dump the DAL entirely, other than for things that aren't possible with LINQ to SQL. There are three problems with putting LINQ to SQL in your DAL: 1. Ratio of plumbing code to real code starts to get a bit high. 2. Incorporating business logic within your projections breaks the abstraction. 3. Object ...Show All

• Visual C++ Compilation problem

  Hi, I've got a weird issue. I've got problems with template operators. When declaring a template operator in private in a class, it seems to be accessible by anyone even if it's private. the same issue can be encountered when deriving a class in private, and accessing template operator outside of the class. Here is a little sample : class CParentClass { public: // CChildClass& operator += (int a_pszString) // { // return *this; // } // Using this operator will not compile, this is normal template <typename t_OtherElement> CParentClass& operator += (t_OtherElement a_pszString) { return *this; } // Using this one is possible from class CChildClass }; class CChildClass: private CParentClass { private: // te ...Show All

• Visual C++ help with dynamically allocating an array?

  hello, ok this code works fine but it still dosnt compute the avearage with the lowest score dropped. here is my code. [code]#include <iostream> #include <iomanip> using namespace std; void sortArray( double arr[], int sz, int scoresPos[], int size ); void displayArray( double arr[], int sz, int scoresPos[], int size ); int main() { double *scores, total = 0; // average; int count; int numAmount; cout << "How many test scores are you going to record "; cin >> numAmount; scores = new double[numAmount]; int *scorePos = new int[numAmount]; cout << "Please enter in your test scores below.\n"; for ( count = 0; count < numAmount; count++ ) { cout <& ...Show All

• Visual Studio Express Editions Confused, please help!

  I did a randomize function in form1 and now I need that value to appear on dialog1. How can I connect the statement It says it's not declared. "Dim floorwalkers() As String = Me .TextBox1.Text.Split( New Char () { "," }) 'split the characters by the comma from the input Dim theRandom As New Random() Dim floorwalkerschosen = theRandom.Next(0, floorwalkers.Length) Dim Floorwalkernumber1 As String = floorwalkers(floorwalkerschosen) My .Forms.Dialog1.Show()" I need floorwalkers(floorwalkerschosen) to appear on my diolag as textbox3.text . How can I do that I would assume that form this code you have a form called dialog1 and this is what you are refering to. My.Forms.Dia ...Show All

• Software Development for Windows Vista Installing MSDTC in a 2003 Cluster - Best Practice for SQL 2005?

  The KB article How to configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 cluster states "When creating the MSDTC, moving the resource group into a group other than SQL Server or Exchange Server group is highly recommended. Creating the MSDTC resource in its own resource group and assigning it to a separate cluster group keeps the resource highly available." We currently have MSDTC in the same group as SQL Server 2005. We also made the SQL Server resource dependant on the MSDTC resource, since the applications that connect to this SQL instance use DTC transactions. Besides preventing unnessesary MSDTC failovers (as stated in the KB article), is there any downside to not configuring MSDTC within ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Preserving relative positions of meshes

  Hi all: I'm playing around with the 3D tutorial still to see what I can do with XNA. I created a model in trueSpace 6.6 that has a hierarchy of meshes that are glued together as siblings: an external tank and 2 SRB meshes I created. When I save and view the model in the DirectX viewer, it looks like what I'd expect: 2 rockets to the side of the external tank. In the XNA tutorial, what I see are the rockets positioned along the centerline of the tank. My question is how to preserve the relative positioning of meshes within the model. Thanks for all your help! Messed up: http://www.spellflight.com/GameModels/MessedUp.JPG AOK: http://www.spellflight.com/GameModels/AOK.JPG You need to look up the rela ...Show All

• .NET Development Simple Insert using a Stored Procedure

  Please help with what I know is a very basic question. I am just trying to learn SQL server use, Stored Procedures in Visual Studio. Here is what I have done. I am trying to use the drag and drop functionality of Visual Studio to do this. I have a table called Table1 with 3 fields: ID, Name, Location The ID field is Type Int, the other 2 are VarChar I have the following Stored Procedure: ALTER PROCEDURE dbo.InputCustomer @Name VarChar (50), @Location VarChar (80), @ID int OUTPUT AS Insert into Table1 (Name,Location) Values (@Name,@Location) SELECT @ID = @@IDENTITY RETURN The ID is the identity field supplied (I assume) by the database. I have a form with 2 simp ...Show All

• .NET Development Fatal Execution Engine Error (7A05E2B3) (80131506)

  hello and thanks in advance for your help :) i am having an issue with the "Fatal Execution Engine Error (7A05E2B3) (80131506) " causing my program to crash. this is an intermittent problem, but i have tracked it down to using some external DLL calls. I have an application that is using the National Instruments GPIB drivers to communicate with some electronic test equipment. I have used these DLLs in VB6 for many years and have NEVER had a problem. here is an example of the declare statements i am using: Declare Function ibwrt32 Lib "Gpib-32.dll" Alias "ibwrt" ( ByVal ud As Integer , <MarshalAsAttribute(UnmanagedType.VBByRefStr)> ByRef sstr As String , ByVal cnt As Inte ...Show All

• Windows Forms Saving contents of a graphics

  Is it possible to save (and restore) the contents of a graphics Graphics.Save only seems to save the properties, such as transfromations, but not the contents. See the example in Visual Studio help under Graphics.Save. My aim is to construct a vertical line cursor on a graph and move it with the mouse. I know how to get the mouse position, but in order to move it I need to restore the picture to what it was before the cursor was added, then add the new one. Paint your graphic into a bitmap, then render the bitmap with Graphic.DrawImage in the Paint event handler. There's sample code in this thread . ...Show All