ASP.NET

suriyakaqnnan wrote:

i want to convert the varchar dataype to datetime format

suriyakaqnnan wrote:

f the user enter like 22.3.2004 error msg has to display

CREATE FUNCTION ChangeDateFormat
(
	@STRING NVARCHAR(40),
	@DELIMITER NVARCHAR(40)
)
RETURNS DateTime
AS
BEGIN
	DECLARE @MM as varchar(5)
	DECLARE @DD as varchar(5)
	DECLARE @YY as varchar(5)
	DECLARE @POS INT
	DECLARE @NEXTPOS INT
	DECLARE @INT INT
	DECLARE @TEMP as varchar(50) 
	SET @STRING = @STRING + @DELIMITER
	SET @POS = charindex(@Delimiter,@String)
	SET @INT = 1
	
	WHILE (@POS <> 0)
	BEGIN
		if @INT = 1 
			Begin
				SET @DD = substring(@String,1,@Pos - 1)
			End
		if @INT = 2 
			Begin
				SET  @MM = substring(@String,1,@Pos - 1)	
			End
		if @INT = 3 
			Begin
				SET @YY = substring(@String,1,@Pos - 1)	
			End	
		
		SET @STRING = substring(@String,@pos+1,len(@String))
		SET @POS = charindex(@Delimiter,@String)
		SET @INT = @int + 1
	END 
	SET @TEMP = @MM+'/'+ @DD + '/' + @YY
	
	Return  convert(datetime, @TEMP)
END

suriyakaqnnan wrote:

using hasrows

suriyakaqnnan wrote:

how to check the username and password in login<layer>

SELECT COUNT(ID) from MyUserNameTable WHERE UserName = @userName

sameerbhag wrote:

Can u Please take a look at my Question..

sameerbhag wrote:

it's very urgent.

<INPUT TYPE='CHECKBOX' VALUE='1' ID='Name1'><LABEL FOR='Name1'>bilal khatri yousuf</LABEL><br/>
<INPUT TYPE='CHECKBOX' VALUE='2' ID='Name2'><LABEL FOR='Name2'>faheem chania ali</LABEL>

// The ViewModel
var viewmodel = function (){
    model = ko.mapping.fromJS([]),
    init = function(initialData) {
      model = initialData; 
    },
    save = function(data, event) {
      $.ajax({
         // ....
      });
    },
    delete = function(data, event) {
       $.ajax({
         // ....
      });
    };
    return{
        Init : init,
        Save : save,
        Delete : delete
    };
};

$(document).ready(function () {
   viewmodel.Init(Model.toJSON());
   ko.applyBindings(viewmodel);
});

Model.toJSON

model = ko.mapping.fromJS(initialData);

model = ko.wrap.fromJS(initialData);