Jakein2006's Q&A profile

• SQL Server Help with query field parameters

  Hi everyone, within one of my reports I would like to take an input parameter, feed this into a dataset which is then used to populate the dataset of the query used in the main body of the report. It won't allow me todo this, could you guys offer any advice on how this may be possible E.g Sub Query: @personIds = SELECT personid FROM people WHERE name = @name; Main Report Query SELECT * FROM orders WHERE personId IN (@personIds) I cannot change the "main report query" as this is actually a stored procedure from an external application vendor. Please help. Kind regards Taz Bobp, fantastic, this worked perfectly! many thanks for your help here. ...Show All

• Visual C++ Starting off with C++

  I keep hearing it's hard to learn, but that you should try and begin learning with C++...That being said I just downloaded Visual C++ Express and was eager to code for the first time   Only to be even more frustrated; I created a new file under Visual C++, C++ file, then started typing in code from tutorials.  The color of the text is changing, appearing like I'm entering code but there is no output.  Here is what I typed // my first program in C++ #include <iostream> using namespace std; int main () { cout << "Hello World!" ; return 0; } Output doesn't appear and when I click on "Show output from" it makes a noise that I can't do it. Do I have to create a certain type of file or ...Show All

• SQL Server Message Box In Reporting services

  Hello, I am using sql reporting services 2000. I have tried to put a message box in my reports using a VB function. If the report contains 10 pages, the message box pops up 10 times. What do i need to do to make the message box pop up only once during the start of the report Also, if I click CANCEL(vbOkCancel), the cursor should go back to the parameter box prompting me to enter a parameter again. In this case, I enter a date and check whether it is a MONDAY or not. VB function is as below... Function CheckDay(ByVal S As DateTime) As Integer Dim GivenDate as Date Dim GivenDay as Integer Dim intMsg as Integer GivenDate = S GivenDay = WeekDay(GivenDate) If NOT GivenDay = 2 intMsg = MsgBox("The selected day is not a Monday", VbOKCanc ...Show All

• Windows Forms PropertyGrid and ListBox

  Hi All Can someone show me an example of how to place a "ListBox" property within a PropertyGrid I am working on visual studio 2005.   srinivasa rao   i did everthing as mentioned but when compiled i am getting error as follows "Error 1 The type or namespace name 'FileNameEditor' could not be found (are you missing a using directive or an assembly reference ) C:\Documents and Settings\srinu\My Documents\Visual Studio 2005\Projects\aaaaa\aaaaa\Item.cs 20 24 aaaaa " and i have added the namespace System.windows.Forms.Design. ...Show All

• Software Development for Windows Vista ConnectDirect() failing without calling CheckMediaType

  Greetings all. I'm just getting into DirectShow programming, so I apologize if this is a stupid question or anything, and I also apologize for my incessant wordiness. I'm trying to make a renderer filter. For my reference, I'm looking at the DX9 Texture Renderer sample. The sample was surprisingly buggy, but after fixing it up I got it to compile and render onto that lovely cylinder. After taking it apart to find out how I could implement something similar in my own program, I found that it worked by just adding the source filter to the graph, adding the custom renderer, and just calling Connect() on the pins, letting the Graph Builder stick in whatever filters it felt was necessary. This is not acceptable to me, because it seems it always ...Show All

• SQL Server Connecting to Local Database after Application Install

  I have created an application which uses a SQL Express database. The program runs fine on the the computer where I built the app, however when I install the app on another computer I get an error telling me that under default SQL Express does not allow remote connections. The problem is that I dont want a remote connection I want a local connection, the database file is on the commputer. How can do get my application to look for the database on the local machine. My connection string is: Data Source=(local)\SQLEXPRESS;Initial Catalog="C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\PLDAQ.MDF";Integrated Security=True I have made sure that the file is in the correct directory. Any help would be greatly appretiated An ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Animation Keyframes return broken data

  I'm using the content pipeline, and enhancing the mesh processor to attach animation information in the Tag, so that I can animate imported meshes. It seems that the animation keyframes return broken data when importing from .X files. They seem to duplicate the first key (with time and everything), and then fail to include the last key. This makes making an animated game challenging. Here is an example from an animation with 41 frames, ranging from 0.0 to 1.33333: In the .X file: AnimationKey rot { 0; 41; 0;4;1.000000,0.000000,0.000000,0.000000;;, 160;4;0.996917,0.000000,0.000000,-0.078459;;, 320;4;0.987688,0.000000,0.000000,-0.156435;;, 480;4;0.972370,0.000000,0.000000,-0.233445;;, 640;4;0.951056,0.000000,0.000000,-0.3 ...Show All

• Visual Studio Express Editions big problem

  Hi I have serious problem. I wrote an application where people are entering information about machines and then I store it in database. User can retreive machine information by entering starting date and ending date, and then everything that matches that time period should be displayed in excel. However it doesn't wnat to work. My code looks alright to me. I don't know what to do !!!!    this is part of my code:   mydate = InputBox( "Please enter your starting date " , "StartDate request" ) myday = mydate.Day.ToString() mymonth = mydate.Month.ToString() myyear = mydate.Year.ToString()   mydate = InputBox( "Please enter your ending date " , "EndDate request" ) myday1 = mydate. ...Show All

• SQL Server SMO in VBScript

  I've been building some applets in VB.Net and wanted to try and do some similar things in VBScript. (I like to have a collection of scripts to do repetitive tasks.) Anyway, I'm getting an error when I try to set the connection info and am at a bit of a loss to get around the problem. Note that most examples of using VBScript and SMO together only connect to a local instance of SQL Server, so I've struggled with the method to define the server I'm attempting to manage. This method works in VB.Net, but returns the error 'Object required' when I set the object parameters to their desired values. Dim srvMgmtServer Dim srvConn Set srvMgmtServer = CreateObject("Microsoft.SQLServer.Management.SMO.Server") srvConn = srvMgmtServer.Co ...Show All

• Visual C# Value not appearing in textbox

  In a nutshell... I'm new to working with C# in Visual Studio and I have a dilemma. I am populating an arraylist with datetime values via a winform. When I click a certain button on that form I want to see the second arraylist item appear in a textbox. The code I'm using to do that is: ReturnedTimesheetTextBox.Text = theCurrentEmployee.Timesheet[1].ToString(); However, clicking the button produces this text in the textbox: EmployeeProject.Timesheet Now, "Timesheet" is the name of a property which is of a type ArrayList and which resides in another class. "EmployeeProject" is, of course, the name of the VS project this exists in. Can anyone offer any help as to why I'm not seeing my datetime value app ...Show All

• Visual C++ Attemp to use MSIL code from this assembly...

  I have a C/WIN32 program that I have "transformed" into "C++" and build with /CLR. Everything compiled ok - exept from some warning about: warning LNK4248: unresolved typeref token (01000011) for '_IMAGELIST'; image may not run warning LNK4248: unresolved typeref token (01000011) for '_TREEITEM'; image may not run But when I run my program I got the error : "Attemp to use MSIL code from this assembly during native code initialization. This indicates a bug in your application. It is most likely the result og calling an MSIL-compiled (/clr) function from a native constructor or from DLLMain" Does anyone have any tip what may be wrong I'm trying to debug my application now, and I have "some" bugs. e ...Show All

• Software Development for Windows Vista Some basic questions on wwf

  Hi friends, I came across a good article that says, we can host the designer and allow the non-developer types (a.k.a. business people) to design and edit workflows. Can we host the designer in a web application That is i create my set of custom activities and create a web page that shows the designer with my custom activities and the standard one and any non-developer type person can use it to design and edit workflows Is there some demo example of this, so that i can get a better picture of it. One more question :: "Activities can be viewed as instructions to the workflow engine." Are they part of the workflow engine or can we have a set of activity dlls that can be fed to a workflow engine Thanks a Lot Sonali ...Show All

• Visual Basic Error in Connection String

  Dear All, I'm getting error with the following code. can anyone shortout the problem please. Your help is highly appreciated. Code: and calling procedure of this function as Code: Private Sub PopulateProductData() Dim ProdID As Integer = CInt(txtProdID.Text) Try Dim ProductData As TechManagement.DBComponents.ProductDB = New TechManagement.DBComponents.ProductDB Dim myProductDetails As TechManagement.DBComponents.ProductsDetails = ProductData.GetProductDetails(ProdID) txtProdName.Text = myProductDetails.ProductName MsgBox(myProductDetails.ProductName) Catch e As OleDbException MsgBox(e.Message) End Try End Sub Public Function GetProductDetails(ByVal productID As Integer) As ProductsDetails ' Create ...Show All

• Visual Studio Express Editions How Do I Give the user a choice to stop a Popup From poping up Again

  Usualy my Post never get answered but maybe they will this time.. Im new to Visual Basic Express And i am trying to make my own internet explorer (I Has Watched all the tutorials And know a little bit... but i just started 3 days ago... and im Only 14) I made a dialog popup box informing the user on what they were doing... and that is bout it so far... what i really want to know is how can i make it so the user can choose if he wants the popup to not show up again by checking a box... i would really appriciate it if someone could help me with this... Thanks on your checkbox on checkchanged event write to a file or registry the status of the checkbox. Id use private sub box1_checkchanged handle ...Show All

• Visual Studio SP1 fix list?

  Is there a list of ReportViewer fixes that did make it into the VS2005 SP1 release Thanks Brian! We've been waiting for this for a long time now. Probably one should refer to this blog entry by Scott before installing the SP. ...Show All