.Net Programming in Simple: 2014

Thursday, 14 August 2014

Call OnChange along with selectedindexchanged in dropdownlist

Thursday, 7 August 2014

Check and Uncheck all the checkbox in the grid and check wheather any checkbox is checked or not

Wednesday, 6 August 2014

Disable Future Dates in Calendar Extendar

http://aspsnippets.com/Articles/Disable-Future-Dates-in-ASPNet-AJAX-Calendar-Extender-Control.aspx

Thursday, 31 July 2014

Converting String to DateTime

public void SetDate()
{
txt_FromDate.Text = "25/05/2013";
string TodaysDate = System.DateTime.Now.ToString("dd/MM/yyyy");
string[] dateArray = TodaysDate.Split(' ');
txt_ToDate.Text = dateArray[0].ToString();
DateTime FromDate = DateTime.ParseExact(txt_FromDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
string ModifiedFromDate = FromDate.AddDays(-1).ToString();
string[] ModifiedFromDateArray = ModifiedFromDate.Split(' ');
ModifiedFromDate = ModifiedFromDateArray[0].ToString();
//Session["FromDate_Chart"] = ChangeDateFormat(ModifiedFromDate);
Session["FromDate_Chart"] = ModifiedFromDate;

DateTime ToDate = DateTime.ParseExact(txt_ToDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
string ModifiedToDate = ToDate.AddDays(1).ToString();
string[] ModifiedToDateArray = ModifiedToDate.Split(' ');
ModifiedToDate = ModifiedToDateArray[0].ToString();
//Session["ToDate_Chart"] = ChangeDateFormat(ModifiedToDate);
Session["ToDate_Chart"] = ModifiedToDate;
}

public string ChangeDateFormat(string Date)
{
try
{
string[] dateArray = Date.Split('/');
Date = dateArray[1] + "/" + dateArray[0] + "/" + dateArray[2];
}
catch (Exception ex)
{

}
return Date;

}

Monday, 7 July 2014

Maintain Tab index after post back

up vote0down vote

Add following script in js file called i.e focus.js:

var lastFocusedControlId = "";

function focusHandler(e) {
    document.activeElement = e.originalTarget;
}

function appInit() {
    if (typeof(window.addEventListener) !== "undefined") {
        window.addEventListener("focus", focusHandler, true);
    }
    Sys.WebForms.PageRequestManager.getInstance().add_pageLoading(pageLoadingHandler);
    Sys.WebForms.PageRequestManager.getInstance().add_pageLoaded(pageLoadedHandler);
}

function pageLoadingHandler(sender, args) {
    lastFocusedControlId = typeof(document.activeElement) === "undefined" 
        ? "" : document.activeElement.id;
}

function focusControl(targetControl) {
    if (Sys.Browser.agent === Sys.Browser.InternetExplorer) {
        var focusTarget = targetControl;
        if (focusTarget && (typeof(focusTarget.contentEditable) !== "undefined")) {
            oldContentEditableSetting = focusTarget.contentEditable;
            focusTarget.contentEditable = false;
        }
        else {
            focusTarget = null;
        }
        targetControl.focus();
        if (focusTarget) {
            focusTarget.contentEditable = oldContentEditableSetting;
        }
    }
    else {
        targetControl.focus();
    }
}

function pageLoadedHandler(sender, args) {
    if (typeof(lastFocusedControlId) !== "undefined" && lastFocusedControlId != "") {
        var newFocused = $get(lastFocusedControlId);
        if (newFocused) {
            focusControl(newFocused);
        }
    }
}

Sys.Application.add_init(appInit);

Reference it using Scriptmanager like below:

<ajax:ScriptManager ID="ScriptManager1" runat="server">
        <Scripts>
            <ajax:ScriptReference Path="~/Js/FixFocus.js" />
        </Scripts>
    </ajax:ScriptManager>

Thursday, 26 June 2014

Javascript Function to get the selected items in Checkboxlist

Custom Validation for CheckBoxList in Javascript

Monday, 19 May 2014

Close all Open divs to show the clicked One in Javascript

Tuesday, 4 February 2014

Convert Comma separated values into Rows in Sql

create FUNCTION Split(@String varchar(MAX), @Delimiter char(1))
returns @temptable TABLE (items varchar(MAX))
as
begin
    declare @idx int
    declare @slice varchar(8000)

    select @idx = 1
        if len(@String)<1 or @String is null return

    while @idx!= 0
    begin
        set @idx = charindex(@Delimiter,@String)
        if @idx!=0
            set @slice = left(@String,@idx - 1)
        else
            set @slice = @String

        if(len(@slice)>0)
            insert into @temptable(Items) values(@slice)

        set @String = right(@String,len(@String) - @idx)
        if len(@String) = 0 break
    end
return
end;

Thursday, 30 January 2014

Retrieve Salary With Range in sql

Declare @MaxSal bigint,
@NoOfRange int,@lowerlimit bigint,@higherlimit bigint,
@Initial int,
@RangeQuery nvarchar(max),@No_Of_Employee int,@UpdateQuery nvarchar(max)
set @Initial=0
set @MaxSal=(select Max(sal) from tbl_Salary)
--print @MaxSal
set @NoOfRange=(@MaxSal/999)+1
--print @NoOfRange
if OBJECT_ID('tempdb..#tblRange') is not null
drop table #tblRange
create Table #tblRange(LowerRange varchar(max),HigherRange varchar(max),
No_Of_Employee int)
--set @RangeQuery='insert into #tblRange(LowerRange,HigherRange) values '
while(@Initial<@NoOfRange)
begin
set @lowerlimit=@Initial*1000
set @higherlimit=@Initial*1000+999
--print @lowerlimit
--print @higherlimit
--set @RangeQuery=@RangeQuery+'('+@lowerlimit+','+@higherlimit+'),'
insert into #tblRange(LowerRange,HigherRange) values(@lowerlimit,@higherlimit)
print @RangeQuery
set @Initial=@Initial+1
end
--select * from #tblRange
Declare C1 Cursor for select LowerRange,HigherRange from #tblRange
open C1
fetch next from C1 into @lowerlimit,@higherlimit
while(@@FETCH_STATUS=0)
begin
set @No_Of_Employee=(select count(*) from tbl_Salary where sal between @lowerlimit and @higherlimit)
print @No_Of_Employee
--set @UpdateQuery='Update #tblRange set No_Of_Employee = '+@No_Of_Employee+' where LowerRange ='+@lowerlimit+' and HigherRange ='+@higherlimit+''
--print @UpdateQuery
--exec (@UpdateQuery)
Update #tblRange set No_Of_Employee =@No_Of_Employee where LowerRange=@lowerlimit and HigherRange=@higherlimit
fetch next from C1 into @lowerlimit,@higherlimit
end
close C1
deallocate C1
select LowerRange+'-'+HigherRange as Range, No_Of_Employee from #tblRange
--select LowerRange,HigherRange, No_Of_Employee from #tblRange

Wednesday, 22 January 2014

Get the records separated by comma in sqlserver

CREATE Procedure sp_GetMobileNo_CommaSeparated

@Fcode varchar(20) ,

@FromDate varchar(20),

@ToDate varchar(20)

as

begin

DECLARE @List VARCHAR(max)

SELECT @List = ISNULL(@List + ',', '') + CAST(F_MOBILE AS VARCHAR)

FROM XStudentMasterCopy

WHERE FranchiseCode = @Fcode

and ADMNDATE between convert(varchar(15),@FromDate,103) and convert(varchar(15),@ToDate,103)

SELECT @List

end

Paging in sqlserver

DECLARE @RowsPerPage INT = 10, @PageNumber INT = 15

SELECT RowNum,AutoID,ADMNNO,STDFIRSTNAME,F_MOBILE,ADMNDATE

FROM (

SELECT AutoID,ADMNNO,STDFIRSTNAME,F_MOBILE,ADMNDATE,

ROW_NUMBER() OVER (ORDER BY AutoID) AS RowNum

FROM XStudentMasterCopy where ADMNDATE

between convert(varchar(15),'06/14/2013',103) and convert(varchar(15),'06/15/2013',103) ) AS SOD

WHERE SOD.RowNum BETWEEN ((@PageNumber-1)*@RowsPerPage)+1

AND @RowsPerPage*(@PageNumber)

Sunday, 12 January 2014

Get the Procedure name in which particular table is used

SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so on sc.id=so.id WHERE sc.text LIKE '%BatchMaster%'

Export Radgrid to Excel in .Net

protected void btn_Export_Click(object sender, EventArgs e)
{
try
{
if (grd_AdmnReg.Items.Count > 0)
{
grd_AdmnReg.MasterTableView.AllowPaging = false;
grd_AdmnReg.PageSize = grd_AdmnReg.Items.Count + 1;
grd_AdmnReg.ExportSettings.FileName = "ServerApps Online";
grd_AdmnReg.GridLines = GridLines.Both;
grd_AdmnReg.ExportSettings.ExportOnlyData = true;
grd_AdmnReg.ExportSettings.OpenInNewWindow = false;
grd_AdmnReg.MasterTableView.ExportToExcel();
}
else
{
Alert.WithoutUpdatePanelMessage("Sorry,there is no records.");
}

}
catch (Exception ex)
{

}
}