ASP.NET

ALTER PROCEDURE [dbo].[JobsDb_ContactInfo_InsertUpdateSingleItem]

    @Userid int ,
	@UserName varchar(50),
	@Title varchar(50),
	@FirstName varchar(50) ,
	@LastName varchar(50),
	@Email varchar(50),
	@StreetAddress1 Varchar(50),
	@StreetAddress2 Varchar(50),
	@ZiporPost varchar(40),
	@CountryId int,
	@StateId int,
	@City varchar(50),
	@PrimaryPhone varchar(50),
	@SecondaryPhone varchar(50),
	@WorkStatus smallint,
	@SHMyName char(1),
	@SHMyEmail char(1),
	@SHMyPhones char(1),
	@ActivityDate datetime

	AS

	DECLARE @ReturnValue int

	IF (@Userid IS NULL) -- New Item
	BEGIN
		INSERT INTO JobsDb_ContactInformation
		([UserName] ,
	[Title],
	[FirstName] ,
	[LastName] ,
	[Email],
	[StreetAddress1],
	[StreetAddress2] ,
	[ZiporPost] ,
	[CountryID],
	[StateId],
	[City],
	[PrimaryPhone] ,
	[SecondaryPhone],
	[WorkStatus],
	[SHMyName] ,
	[SHMyEmail],
	[SHMyPhones],
	[ActivityDate]
)
VALUES
(
	@UserName,
	@Title,
	@FirstName,
	@LastName,
	@Email,
	@StreetAddress1,
    @StreetAddress2,
	@ZiporPost,
	@CountryId,
	@StateId,
	@City,
    @PrimaryPhone,
	@SecondaryPhone,
	@WorkStatus,
    @SHMyName,
    @SHMyEmail,
    @SHMyPhones,
	@ActivityDate
		)

		SELECT @ReturnValue = SCOPE_IDENTITY()
	END
	ELSE
	BEGIN
		UPDATE JobsDb_ContactInformation SET
			[UserName] = @UserName,
	[Title] = @Title,
	[FirstName] = @FirstName,
	[LastName] = @LastName,
	[Email] = @Email,
	[StreetAddress1] = @StreetAddress1,
	[StreetAddress2] = @StreetAddress2,
	[ZiporPost] = @ZiporPost,
	[CountryId]= @CountryId,
	[StateId] = @StateId,
	[City] = @City,
	[PrimaryPhone] = @PrimaryPhone,
	[SecondaryPhone] = @SecondaryPhone,
	[WorkStatus]=@WorkStatus,
	[SHMyName] = @SHMyName,
	[SHMyEmail]=@SHMyEmail,
	[SHMyPhones]=@SHMyPhones,
	[ActivityDate]= @ActivityDate
		WHERE 
			UserId = @Userid

		SELECT @ReturnValue = @Userid
	END

	IF (@@ERROR != 0)
	BEGIN
		RETURN -1
	END
	ELSE
	BEGIN
		RETURN @ReturnValue
	END 

function SelectAllCheckboxes(spanChk)
{
    document.getElementById("ctl00_ContentPlaceHolder1_TextBox1").value="prashant"

   // Added as ASPX uses SPAN for checkbox
   var oItem = spanChk.children;
   var theBox= (spanChk.type=="checkbox") ? 
        spanChk : spanChk.children.item[0];
   xState=theBox.checked;
   elm=theBox.form.elements;

   for(i=0;i<elm.length;i++)
     if(elm[i].type=="checkbox" && 
              elm[i].id!=theBox.id)
     {
       //elm[i].click();
       if(elm[i].checked!=xState)
         elm[i].click();
       //elm[i].checked=xState;
     }
 } 

ashok kr yadav wrote:

i want to save html file to server
by asp.net 1.1,

The Knowledge wrote:

Can anybody tell me wht extention this page having
http://en.wikipedia.org/wiki/Sanjay_Dutt[^]

The Knowledge wrote:

Can a client create web pages oneself whenever he/she wants........

The Knowledge wrote:

Can a client create web pages oneself whenever he/she wants........