March 26, 2012 at 6:11 am
I've created a number of selections as stored procedures in sql which include parameters(an example below). I'm using these as data sources for creating windows forms. When I create the forms it adds a toolstrip with the parameters which is all well and good but when I run debug in visual studio I'd like the cursor to appear in the first cell of the toolstrip, but it doesn't, it appears in the first data field of the actual form. I've tried adding a .focus to the toolstrip field but it still won't work. Can anyone help.
USE [HP3000]
GO
/****** Object: StoredProcedure [dbo].[GetMiscChargeVs] Script Date: 03/26/2012 13:11:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetMiscChargeVs]
@TicketNum NVARCHAR(50)
AS
SELECT *
FROM dbo.[VsMiscCharge] a
JOIN dbo.[VsOrder] b
ON a.ArcOrdno = b.ArcOrdno
JOIN dbo.Nad c
on c.IasAcno = a.Acno
LEFT JOIN dbo.Nad NadHaul
on NadHaul.SubAcc = a.HaulCode
LEFT JOIN BRAD d
on d.Branch = b.BradRef
JOIN Plant
on Plant.PlantCode = a.Unit
Join Products
on Products.ProdCode = a.ProdCde
WHERE a.TktNum = @TicketNum and
a.CompanyNo = '01'
March 26, 2012 at 9:58 am
Sounds like a .NET question, more than an SQL question. You may want to try posting to the .NET Development Forum on MSDN.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 27, 2012 at 6:37 am
You're right, I'll do that
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply