Itemdatabound of radgrid in javascript

function ResponseEnd() {
  Databound(); 
  }
$(document).ready(function (){

  var grid = $find("<%=rgMilestoneSummaryReport.ClientID %>");
    var MasterTable = grid.get_masterTableView();
    var Rows = MasterTable.get_dataItems();
    //alert(Rows.length);
    if(Rows.length>0){
       Databound();
    }
});
function Databound()
{
     var grid = $find("<%=rgMilestoneSummaryReport.ClientID %>");
    var MasterTable = grid.get_masterTableView();
    var selectedRows = MasterTable.get_dataItems();
    for (var i = 0; i < selectedRows.length; i++) {
      var row = selectedRows[i];
      var cell = MasterTable.getCellByColumnUniqueName(row, "IsResource");
      var cell1 = MasterTable.getCellByColumnUniqueName(row, "YTBR");
      var cell2 = MasterTable.getCellByColumnUniqueName(row, "NoOfInvoicesRaised");
      var cell3 = MasterTable.getCellByColumnUniqueName(row, "NoOfInvoicesPaid");
//      var cell4 = MasterTable.getCellByColumnUniqueName(row, "NoOfInvoicesPaid");
      var cell5 = MasterTable.getCellByColumnUniqueName(row, "ProjectName");
      if(cell.innerHTML=="Yes" && cell1.innerHTML=="0")
      {
        cell5.style.backgroundColor="red";
      }
     if(cell2.innerHTML==cell3.innerHTML)
     {
        if(cell2.innerHTML!=0 && cell3.innerHTML!=0)
        {
            cell3.style.backgroundColor="green";
        }
     }
     else
     {
        cell3.style.backgroundColor="red";
     }
     
      //here cell.innerHTML holds the value of the cell   
    }
}

when using ajaxpanel

<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" LoadingPanelID="RadAjaxLoadingPanel1"
    ClientEvents-OnRequestStart="onRequestStart" ClientEvents-OnResponseEnd="ResponseEnd">

Max Id of table find out by linq

Var idd = dt.bankdetails.Max(s => s.id);
        if (idd == null)
        {
            idd = 0;
        }
        bt.id = idd + 1;

Here dt is dataclass and bankdetails is table name.

Reterive Result Value In Linq (Using C#)

var s = dt.maxid().ToList();
        int id = 0; ;
        foreach (var a in s)
        {
           id= a.id.Value;
        }
       var aa= dt.insertuser(id, txtuname.Text, txtpas.Text, txtname.Text, txtcnum.Text, txtadd.Text, txtemail.Text,DateTime.Now.Date);
       string a1 = "";
       foreach (var aaa in aa)
       {
           a1 = aaa.sts.ToString();
       }
       ScriptManager.RegisterStartupScript(this, typeof(Page), "1", "alert('"+a1.ToString()+"')", true);

Stored Procedure To Select User From Table

Alter proc selectuser
@uname nvarchar(max),
@pas nvarchar(max)

as

select count(*) as count1 from ulogin where username=@uname and password=@pas

return

Execute SP

Execute selectuser @uname=k,@pas=124

Stored Procedure For Insert With Check Duplicasy

Create procedure insertuser
@id int,
@uname nvarchar(max),
@pas nvarchar(max),
@name nvarchar(max),
@ponnumber nvarchar(max),
@add nvarchar(max),
@emailid nvarchar(max),
@regtime nvarchar(max)
as
declare @ss as int
declare @msg as nvarchar(50)
set @ss=(select count(*) from ulogin where emailid=@emailid)

if @ss>0
begin
set @msg=('Email Address Already Exists.')
select @msg as sts
end
else
begin
insert into ulogin values(@id,@uname,@pas,@name,@ponnumber,@add,@emailid,@regtime)
set @msg=('Registration Sucessfully.')
select @msg as sts
end
return

Execute Store Procedure

execute insertuser @id=1,@uname=asd,@pas=asdd,@name=qwewe,@ponnumber=awqwewq,@add=sdadad,@emailid=14,@regtime=sdd

Select By Stored Procedure

Create proc maxid

 as

(select isnull(max(id),0) as id from tablename)

return

 To Execute 

Exec maxid

Open a page in ModalPopUP

To Open a page in modal pop up   extender of ajax we have to use these source:

<ajaxToolkit:ModalPopupExtender ID="ModalPopupExtender1" runat="server" TargetControlID="lnkPopup" PopupControlID="panOpen" BackgroundCssClass="ModalBackground" CancelControlID="btnCancel" PopupDragHandleControlID="panOpen" > </ajaxToolkit:ModalPopupExtender>

<asp:Panel ID="panOpen" runat="server" Height="400px" Width="400px" CssClass="ModalWindow">

<IFRAME id="frame1" src="SourcePage.Extension / URL of the external Site" Scrolling="auto">

</IFRAME>

<asp:Button ID="btnCancel" runat="server" Text="Close" />

</asp:Panel>

<a id="lnkPopup" runat="server">Show Popup</a>