vgta's Q&A profile

• SQL Server select query based upon results of another select query??

  Hi, not exactly too sure if this can be done but I have a need to run a query which will return a list of values from 1 column. Then I need to iterate this list to produce the resultset for return. This is implemented as a stored procedure declare @OwnerIdent varchar(7) set @OwnerIdent='A12345B' SELECT table1.val1 FROM table1 INNER JOIN table2 ON table1. Ident = table2.Ident WHERE table2.Ident = @OwnerIdent 'Now for each result of the above I need to run the below query SELECT Clients.Name , Clients.Address1 , Clients.BPhone, Clients.email FROM Clients INNER JOIN Growers ON Clients.ClientKey = Growers.ClientKey WHERE Growers.PIN = @newpin) '@newpin being the result from first query Any help appreciated ...Show All

• SQL Server Query in dataview/update form

  Question related to Visual Basic Video Lesson 09 (Databinding.wmv) by Bob Tabor. Made a table and a UI form according to this lesson (table colums: CustomerID, FirstName, LastName). Is it possible to use the same or an identical looking query form to find "Bob" by typing Bob in the Fist Name textbox or "Tabor" by typing Tabor in the Last Name textbox as in FileMaker Thanks, From NewBie to NewBie step by step. How to make a Form with two TabPage TabContol where the TabePage1 is used for data entry with Save, Clear, AddNew and a Find Button to perform Queries. File>New Project>WindowsApplication1>OK ---drag TabControl from Toolbox. (default is two TabPage) ---drag 4 Button(s) into TabPage1. ...Show All

• Visual Basic Application Configuration

  Hello. A question, please. I am working with VS 2005. I don't find how can I set the working enviroment. I mean DEBUG, RELEASE. I know that I must see a bouton called SOLUTION CONFIGURATION, but I dont have it. Can anyone help me Thanks... Not, It is the same if my application compiles fine, Configuration Manager is disable... Any idea ...Show All

• .NET Development return a sql database wif a web service

  im suppose to return a sql database called CustName tru a web service Here's what i wrote im my web service Imports System.Web Imports System.Web.Services Imports System.Data.SqlClient Imports System.Data Imports System.Web.Services.Protocols <WebService(Namespace:= "http://tempuri.org/" )> _ <WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _ < Global .Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _ Public Class Service Inherits System.Web.Services.WebService <WebMethod()> _ Public Function CustName() As String Dim r As SqlCommand Dim con As SqlConnection = New SqlConnection( _ "Data Source=.\SQ ...Show All

• Visual Studio Express Editions whick web hosting is support the asp.net 2.0 and SQL server 2005?

  hello: i have created a web site and now i want to get an asp.net hosting that support my project thanks for all. derin Please visit : The Official ASP.NET Web Hosters Directory (under Special Promotions , select SQL 2005). ...Show All

• Visual Studio Team System Clarification Reg. Chaild Workitem

  I have a parent workitem "MailWorkItem", chaild Workitem "subWorkitem" both the workitems are loded visible, I want to close the child workitem. I am puting the childworkitem id in the parent workitems state and closing. Is there is any way to findout the active child work item. Just to add my opinion to that thread ... that (closing ... or changing the state of a parent work item as a result of the states of all children) is exactly what we are looking for at the moment. Do you have any idea about how to accomplish this right now with the extensibility of TFS I fear, implementing it ourselves might make it more difficult to migrate to any further built in functionality ! Thanks and regard ...Show All

• SQL Server Indirect Configuration with ConfigType 'Indirect SQL Server' fails

  Hi, I have a package that uses a Configuration of type SQL Server where the property values are held. This runs successfully using this direct configurations. When I use an Indirect configuration using an environment variable to point to this SQL Server configuration type the package won't even validate. The Indirect Configuration is: [EHC-SQLD-01.].[SSISConfigsDEV];[dbo].[SSIS Configurations DEV];pkgLRD CED Import; which follows the standard of : db connections, config table, filter This works by the way on my client but on the dev server the error is: Error: The connection "[EHC-SQLD-01].SSISConfigsDEV" is not found. This error is thrown by Connections collection when the specific connection element is not found. ...Show All

• Visual C++ How to make a HID device look like a MIDI device?

  Hi, I'm new to device controller programming. I'm making a MIDI controller with USB support. I want to implement the USB support with a low cost chip programing it's firmware. But i can't implement the USB protocol due to hardware requirements. The only thing i can do is making a firmware for a HID device. How can i then make that device look like a MIDI This is possible, right At least, is possible to connect a MIDI device to a joystick port and use, and if the joystick is HID then it's possible to do it. Any tips here Thx, Best regards, Nuno Santos PS: i know this is not the appropriated forum to ask this but i could not find the right one, so please, if you think that i should be asking this in another place, please tell me. Cheers ...Show All

• SQL Server MDX query with filter clause

  Hi, I have the following MDX query which is supposed to return the number of records with Actual time > TargetTime for each customer, location and editor. Actual Time and Target Time are measures on the Fact table defined in minutes and represented by integer values. The hierarchy I have created is Customer Name Location Name Editor Name The MDX query I have written is: Count ( filter ( Descendants ([DimCustomer].[Customer_Hierarchy]. CurrentMember ,[DimCustomer].[Customer_Hierarchy].[EditorName]), [Measures].[ActualTime]>[Measures].[TargetTime] )) But this query gives me the number of customers rather than the number of records with ActualTime > TargetTime for each customer, location, edit ...Show All

• Visual Studio Express Editions Can I link to more than one AboutBox in a Form?

  I have several AboutBoxes working, but one simply will not. While I was trying to think this through I came up with a couple of other questions. 1) Can I create a drop down button in VS Pro that would allow me to click the drop down and have several options that I could click on to open the various AboutBoxes I need 3 AboutBoxes for various reasons. 2) Am I able to have 2 buttons linking to 2 separate AboutBoxes in a single Form I ask because the first AboutBox button works fine, but the second won't even autocomplete or recognize the other AboutBox. Any information would be greatly appreciated. Thanks. I just tried deleting and re-adding, and that worked fine... Very odd... Thank you very much for your ...Show All

• Windows Forms code translate

  Hi, Do you know the C# version of this vb.net code please For Each dgvCol in DGV.Columns If TypeOf dgvCol Is DataGridViewImageColumn Then bExists = True Exit For End If Next bool bExists; foreach (DataGridViewColumn dgvCol in DGV.Columns) { if (dgvCol is DataGridViewImageColumn) { bExists = true; break; } } ...Show All

• Windows Forms Prepend new rows to DataGridView instead of append?

  Just like the subject says, I'm looking for a method to prepend new rows to a data-bound datagridview instead of the default append. Thanks in advance for any advice. hello I have the same requirement, but your suggestion doesn't work with databound datagridview. Error msg - you cannot add rows to a bound datagridview. so whats the solution to this thanks. ...Show All

• Visual Studio Express Editions Using Visual Basic Express 2005 and Crystal Reports XI Release 2 Together

  Win XP SP2, VB Express 2005, Crystal Reports XI Release 2 (full registered version). I have installed VB Express 2005. I then upgraded Crystal XI to Release 2 and installed. I added the CrystalReportViewer to the vb toolbox. I have the following references in my project: CrystalDecisions.CrystalReports.Engine, .ReportSource, .Shared, .Web, .Windows.Forms All are of .NET type and version 11.5.3700.0 When I put the CrystalReportViewer onto a form from the toolbox, the crviewer does not go onto the form itself but it goes down below the form (where the mainmenu or process components would reside). This means that I cannot resize the viewer myself on the form. After I set up the code and run the report, the parameter di ...Show All

• Software Development for Windows Vista How To Get Software Windows VISTA Certified

  Hi, We have a solution having windows applications, web applications and web services that work all together. We want to get Windows VISTA Logo for our solution, in order to make our application windows vista compliant and get logo where can i get the requiremtns and other related stuff... Any help will be apperciated. Thanks in advace. ...Show All

• Smart Device Development can i make a today-plugin with vb.netcf?

  can i make a today-plugin with vb.netcf or only in c#.netcf has someone a simple sample in vb.netcf. thx mfg. It's not that complicated, but it does have higher degree of complexity than average sample. I’m not aware of such sample in VB, so you’d need to concentrate and make this one work for you. Before you even proceed with conversion make sure you have C# version operational. ...Show All