User Profile & Activity

George Fahnbulleh Member
Page
of 4
Posted: September 7, 2009 1:59 AM

Handy can you attach a sample with serverside code.  I also need to be able to launch a dialog window on button click. 

Posted: September 3, 2009 12:11 PM

This would be so much easier if there was a Webgrid.rows.CurrentRow or SelectedRow

Posted: September 3, 2009 12:18 AM

Handy,

Thanks for your answer, I need to do this on the server, because I'm passing those values to a stored proc.

Posted: September 1, 2009 10:54 PM

Gordon, the insert stored proc, does not require the id.  The ID is passed internally. Here it is:


[dbo].[sp_Business_Insert]
(
 
 @BusinessName nvarchar(100),
 @Address1 nvarchar(100),
 @Address2 nvarchar(50),
 @City nvarchar(50),
 @State nvarchar(20),
 @PostalCode nvarchar(20),
 @Country nvarchar(30),
 @ProfessionalID1 nvarchar(50),
 @ProfessionalID2 nvarchar(50),
 @ProfessionalID3 nvarchar(50),
 @StatusID tinyint,
 @AdminFirstName nvarchar(20),
 @AdminLastName nvarchar(20),
 @AdminPhone nvarchar(20),
 @AdminPhoneExt nvarchar(10),
 @AdminEmail nvarchar(50),
 @GName nvarchar(20)
)
AS
DECLARE @BusinessID uniqueidentifier
SET @BusinessID=NEWID()

 SET NOCOUNT OFF;
INSERT INTO [dbo].[Business] ([BusinessID], [BusinessName], [Address1], [Address2], [City], [State], [PostalCode], [Country], [ProfessionalID1], [ProfessionalID2], [ProfessionalID3], [StatusID], [AdminFirstName], [AdminLastName], [AdminPhone], [AdminPhoneExt], [AdminEmail], [GName]) VALUES
(@BusinessID, @BusinessName, @Address1, @Address2, @City, @State, @PostalCode, @Country, @ProfessionalID1, @ProfessionalID2, @ProfessionalID3, @StatusID, @AdminFirstName, @AdminLastName, @AdminPhone, @AdminPhoneExt, @AdminEmail, @GName);
 
SELECT BusinessID, BusinessName, Address1, Address2, City, State, PostalCode, Country, ProfessionalID1, ProfessionalID2, ProfessionalID3, StatusID, AdminFirstName, AdminLastName, AdminPhone, AdminPhoneExt, AdminEmail, GName FROM ArcBusiness WHERE (BusinessID = @BusinessID)

Posted: September 1, 2009 1:30 PM

You can find the video Here

Posted: September 1, 2009 9:52 AM

Gordon,

My issue is not in retrieving the GUID.  It is in INSERTING the GUID.  I will post a video for you.

Thanks

All times are GMT -5. The time now is 11:34 PM.
Previous Next