Sunday 13 January 2013

According Check Box On Grid View Delete The record Or change the Row color….




According Check Box On Grid View Delete The record Or change the Row color….



<%@PageLanguage="VB"AutoEventWireup="false"CodeFile="DeleteMultipleRecordFromGridandTransfertoanotherGrid.aspx.vb"Inherits="DeleteMultipleRecordFromGridandTransfertoanotherGrid"%>

<!DOCTYPEhtmlPUBLIC"-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<htmlxmlns="http://www.w3.org/1999/xhtml">
<headrunat="server">
<title>Untitled Page</title>
<scripttype="text/javascript">
functionCheck_Click(obj)
{
var row = obj.parentNode.parentNode;
if(obj.checked)
            {
row.style.backgroundColor = "aqua";
            }
else
            {   
if(row.rowIndex % 2 == 0)
                {
//Alternating Row Color
row.style.backgroundColor = "#C2D69B";
                }
else
                {
row.style.backgroundColor = "white";
                }
            }
varGridView = row.parentNode;
varinputList = GridView.getElementsByTagName("input");

for (var i=0;i<inputList.length;i++)
            {
var cell = inputList[i].parentNode;
varheaderCheckBox = inputList[0];
var checked = true;
if(inputList[i].type == "checkbox"&&inputList[i] != headerCheckBox)
                {
if(!inputList[i].checked)
                    {
checked = false;
break;
                    }
                }
            }
headerCheckBox.checked = checked;

        }
</script>
<scripttype="text/javascript">
functioncheckAll(objRef)
        {
varGridView = objRef.parentNode.parentNode.parentNode;
varinputList = GridView.getElementsByTagName("input");
for (var i=0;i<inputList.length;i++)
            {
//Get the Cell To find out ColumnIndex
var cell = inputList[i].parentNode;
var row = inputList[i].parentNode.parentNode;
if(inputList[i].type == "checkbox"&&cell.cellIndex == 0 &&objRef != inputList[i])
                {
if (objRef.checked)
                    {
row.style.backgroundColor = "aqua";
inputList[i].checked=true;
                    }
else
                    {
if(row.rowIndex % 2 == 0)
                        {
//Alternating Row Color
row.style.backgroundColor = "#C2D69B";
                        }
else
                        {
row.style.backgroundColor = "white";
                        }
inputList[i].checked=false;
                    }
                }
            }
        }
</script>
<scripttype="text/javascript">
functionMouseEvents(objRef, evt)
{
var checkbox = objRef.getElementsByTagName("input")[0];
if (evt.type == "mouseover")
   {
objRef.style.backgroundColor = "orange";
   }
else
   {
if (checkbox.checked)
        {
objRef.style.backgroundColor = "pink";
        }
elseif(evt.type == "mouseout")
        {
if(objRef.rowIndex % 2 == 0)
            {
//Alternating Row Color
objRef.style.backgroundColor = "#C2D69B";
            }
else
            {
objRef.style.backgroundColor = "white";
            }
        }
   }
}
</script>

</head>
<body>

<formid="form1"runat="server">
<div>
<table>
<tr>
<td>
<asp:LabelID="Label3"runat="server"Text="Check all Using Javascipt"BackColor="#C0FFC0"Font-Bold="True"Width="355px"></asp:Label>
<asp:GridViewID="GridView1"runat="server"BackColor="White"OnRowDataBound="GridView1_RowDataBound"AutoGenerateColumns="false"BorderColor="#3366CC"BorderStyle="None"BorderWidth="1px"CellPadding="4"Width="89px">
<RowStyleBackColor="White"ForeColor="#003399"/>
<FooterStyleBackColor="#99CCCC"ForeColor="#003399"/>
<PagerStyleBackColor="#99CCCC"ForeColor="#003399"HorizontalAlign="Left"/>
<SelectedRowStyleBackColor="#009999"Font-Bold="True"ForeColor="#CCFF99"/>
<HeaderStyleBackColor="#003399"Font-Bold="True"ForeColor="#CCCCFF"/>
<Columns>
<asp:TemplateFieldHeaderText="Select">
<HeaderTemplate>
<asp:CheckBoxID="chkAll"runat="server"onclick="checkAll(this);"/>
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBoxID="chkBox1"runat="server"onclick="Check_Click(this)">
</asp:CheckBox>
<asp:LabelID="lblId"runat="server"Text='<%#Eval("ID") %>'Visible="false"></asp:Label>

</ItemTemplate>
</asp:TemplateField>
<asp:TemplateFieldHeaderText="Si.NO">
<ItemTemplate>
<%#Container.DataItemIndex+1 %>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundFieldDataField="Firstname"HeaderText="Firstname"/>
<asp:BoundFieldDataField="Middlename"HeaderText="Middlename"/>
<asp:BoundFieldDataField="Lastname"HeaderText="Lastname"/>

</Columns>

</asp:GridView>
</td>


<tdstyle="width: 3px">
<asp:LabelID="Label2"runat="server"Text="Check all Using Without Javascipt"BackColor="#C0FFC0"Font-Bold="True"Width="348px"></asp:Label>
<asp:GridViewID="GridView3"runat="server"BackColor="White"OnRowDataBound="GridView3_RowDataBound"AutoGenerateColumns="false"BorderColor="#3366CC"BorderStyle="None"BorderWidth="1px"CellPadding="4"Width="89px">
<RowStyleBackColor="White"ForeColor="#003399"/>
<FooterStyleBackColor="#99CCCC"ForeColor="#003399"/>
<PagerStyleBackColor="#99CCCC"ForeColor="#003399"HorizontalAlign="Left"/>
<SelectedRowStyleBackColor="#009999"Font-Bold="True"ForeColor="#CCFF99"/>
<HeaderStyleBackColor="#003399"Font-Bold="True"ForeColor="#CCCCFF"/>
<Columns>
<asp:TemplateFieldHeaderText="Select">
<HeaderTemplate>
<asp:CheckBoxID="chkAll"runat="server"AutoPostBack="true"OnCheckedChanged="chkSelectAll_CheckedChanged"/>
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBoxID="chkBox1"runat="server"AutoPostBack="true"OnCheckedChanged="chkSelectAll_CheckedChanged1">
</asp:CheckBox>
<asp:LabelID="lblId"runat="server"Text='<%#Eval("ID") %>'Visible="false"></asp:Label>

</ItemTemplate>
</asp:TemplateField>
<asp:TemplateFieldHeaderText="Si.NO">
<ItemTemplate>
<%#Container.DataItemIndex+1 %>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundFieldDataField="Firstname"HeaderText="Firstname"/>
<asp:BoundFieldDataField="Middlename"HeaderText="Middlename"/>
<asp:BoundFieldDataField="Lastname"HeaderText="Lastname"/>

</Columns>

</asp:GridView>

</td>
</tr>
</table>

<asp:LabelID="Label1"runat="server"Text="Label"></asp:Label>
<asp:ButtonID="BtnDelete"CausesValidation="false"OnClick="BtnDelete_Click"OnClientClick="return confirm('Are you sure?')"runat="server"Text="Delete"/>
<asp:ButtonID="Button1"runat="server"OnClick="Button1_Click"Text="Extract Record"/>
<asp:GridViewID="GridView2"runat="server"CellPadding="4"AutoGenerateColumns="false"ForeColor="#333333"GridLines="None">
<RowStyleBackColor="#FFFBD6"ForeColor="#333333"/>
<FooterStyleBackColor="#990000"Font-Bold="True"ForeColor="White"/>
<PagerStyleBackColor="#FFCC66"ForeColor="#333333"HorizontalAlign="Center"/>
<SelectedRowStyleBackColor="#FFCC66"Font-Bold="True"ForeColor="Navy"/>
<HeaderStyleBackColor="#990000"Font-Bold="True"ForeColor="White"/>
<AlternatingRowStyleBackColor="White"/>
<Columns>

<asp:BoundFieldDataField="Firstname"HeaderText="Firstname"/>
<asp:BoundFieldDataField="Middlename"HeaderText="Middlename"/>
<asp:BoundFieldDataField="Lastname"HeaderText="Lastname"/>
</Columns>
</asp:GridView>
</div>

</form>

</body>
</html>


Vb Code::::----------------------------
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
Imports System.Web
Imports System.Web.Security
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.WebControls.WebParts
Imports System.Web.UI.HtmlControls
PartialClassDeleteMultipleRecordFromGridandTransfertoanotherGrid
InheritsSystem.Web.UI.Page
DimoblGFAsNewGlovalFunction
DimobjrunAsNewruntimetable
ProtectedSubPage_Load(ByVal sender AsObject, ByVal e AsSystem.EventArgs) HandlesMe.Load
IfNotPage.IsPostBackThen

binddataGrid3()
binddataGrid4()
EndIf


EndSub
PrivateSubbinddataGrid3()
Dim ds AsNewDataSet
ds = oblGF.selectdataforregtableforaddress()
        GridView1.DataSource = ds
GridView1.DataBind()
EndSub
PrivateSubbinddataGrid4()
Dim ds AsNewDataSet
ds = oblGF.selectdataforregtableforaddress()
        GridView3.DataSource = ds
GridView3.DataBind()
EndSub
ProtectedSubBtnDelete_Click(ByVal sender AsObject, ByVal e AsSystem.EventArgs) HandlesBtnDelete.Click
Try
ForEach row AsGridViewRowIn GridView1.Rows
DimcbAsCheckBox = DirectCast(row.FindControl("chkBox1"), CheckBox)
DimlblAsLabel = DirectCast(row.FindControl("lblId"), Label)
DimuidAsInteger = lbl.Text
Ifcb.CheckedThen
objrun.deletreAddressmaster(uid)

binddataGrid3()

EndIf


Next

Catch ex AsException

EndTry
EndSub

ProtectedSub Button1_Click(ByVal sender AsObject, ByVal e AsSystem.EventArgs) Handles Button1.Click
Try
Dim ds AsNewDataSet
DimdtAsNewDataTable
objrun.InitAdressContacttable()
objrun.dtaddressDetail.Rows.Clear()
Dim i AsInteger = 0
ForEach row AsGridViewRowIn GridView1.Rows
DimcbAsCheckBox = DirectCast(row.FindControl("chkBox1"), CheckBox)
DimlblAsLabel = DirectCast(row.FindControl("lblId"), Label)
DimuidAsInteger = lbl.Text
Ifcb.CheckedThen

dt = objrun.ShowRegdata1(uid)
objrun.dtaddressDetail.Rows.Add(objrun.dtaddressDetail.NewRow)
objrun.dtaddressDetail.Rows(i)(0) = dt.Rows(0).Item(0)
objrun.dtaddressDetail.Rows(i)(1) = dt.Rows(0).Item(1)
objrun.dtaddressDetail.Rows(i)(2) = dt.Rows(0).Item(2)
objrun.dtaddressDetail.Rows(i)(3) = dt.Rows(0).Item(3)
                    i = i + 1
'GridView2.DataSource = objrun.dtaddressDetail
'GridView2.DataBind()
EndIf


Next
            GridView2.DataSource = objrun.dtaddressDetail
GridView2.DataBind()
Catch ex AsException

EndTry
EndSub

ProtectedSubchkSelectAll_CheckedChanged(ByVal sender AsObject, ByVal e AsEventArgs)
ForEach row AsGridViewRowIn GridView3.Rows
DimcbAsCheckBox = DirectCast(row.FindControl("chkBox1"), CheckBox)
cb.Checked = DirectCast(sender, CheckBox).Checked
Ifcb.CheckedThen
row.BackColor = Drawing.Color.BlanchedAlmond
Else
row.BackColor = Drawing.Color.White
EndIf

Next
EndSub
ProtectedSubchkuncheck_CheckedChanged(ByVal sender AsObject, ByVal e AsEventArgs)
Dim row AsGridViewRow = GridView3.SelectedRow
Dim i AsInteger = GridView3.SelectedIndex

'For Each row As GridViewRowIn GridView3.Rows
DimcbAsCheckBox
cb = DirectCast(row.FindControl("chkBox1"), CheckBox)
'    cb.Checked = DirectCast(sender, CheckBox).Checked

Ifcb.Checked = FalseThen

row.BackColor = Drawing.Color.Blue
Else
row.BackColor = Drawing.Color.Cyan

EndIf

'Next
EndSub

ProtectedSub GridView1_RowDataBound(ByVal sender AsObject, ByVal e AsSystem.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
Ife.Row.RowType = DataControlRowType.DataRowThen
e.Row.Attributes.Add("onmouseover", "MouseEvents(this, event)")
e.Row.Attributes.Add("onmouseout", "MouseEvents(this, event)")

EndIf
EndSub

'Protected Sub GridView3_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView3.SelectedIndexChanged
'    Try
'        For Each row As GridViewRowIn GridView3.Rows
'            Dim cb As CheckBox = DirectCast(row.FindControl("chkBox1"), CheckBox)
'            If cb.Checked Then
'                row.BackColor = Drawing.Color.BlanchedAlmond
'            Else
'                row.BackColor = Drawing.Color.Aqua

'            End If
'        Next
'    Catch ex As Exception

'    End Try

'End Sub
'Protected Sub gv_RowCommand(ByVal sender As Object, ByVal e As GridViewCommandEventArgs)
'    If e.CommandName = "Show" Then
'        Dim RowIndex1 As Integer = Convert.ToInt32((e.CommandArgument).ToString())
'        Dim cb As CheckBox = DirectCast(RowIndex1.FindControl("chkBox1"), CheckBox)


'    End If
'End Sub



ProtectedSub GridView3_RowDataBound(ByVal sender AsObject, ByVal e AsSystem.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView3.RowDataBound
'Dim row As GridViewRow = e.Row
''Dim i As Integer = GridView3.SelectedIndex

''For Each row As GridViewRowIn GridView3.Rows
'Dim cb As CheckBox
'cb = DirectCast(row.FindControl("chkBox1"), CheckBox)
''    cb.Checked = DirectCast(sender, CheckBox).Checked

'If cb.Checked = False Then

'    row.BackColor = Drawing.Color.Blue
'Else
'    row.BackColor = Drawing.Color.Cyan

'End If

Ife.Row.RowType = DataControlRowType.DataRowThen
If (String.IsNullOrEmpty(e.Row.Cells(0).Text) <>True) OrElse (e.Row.Cells(0).Text <>" ") Then
'Dim result As String = Convert.ToInt32(e.Row.Cells(2).Text)
'If result = "M.S" Then
e.Row.Cells(0).BackColor = System.Drawing.Color.Aquamarine
'Else
'    e.Row.Cells(3).BackColor = System.Drawing.Color.BlanchedAlmond
'End If
EndIf
EndIf

EndSub
ProtectedSub chkSelectAll_CheckedChanged1(ByVal sender AsObject, ByVal e AsEventArgs)
Try

ForEach row AsGridViewRowIn GridView3.Rows
DimcbAsCheckBox = DirectCast(row.FindControl("chkBox1"), CheckBox)
' cb.Checked = DirectCast(sender, CheckBox).Checked
Ifcb.CheckedThen
row.BackColor = Drawing.Color.BlanchedAlmond
Else
row.BackColor = Drawing.Color.Yellow
EndIf

Next

Catch ex AsException

EndTry
EndSub

'Protected Sub GridView3_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView3.RowCommand
'    Try
'        Dim index As Integer = Convert.ToInt32(e.CommandArgument)

'        Dim gvRow As GridViewRow = GridView1.Rows(index)

'    Catch ex As Exception

'    End Try


'End Sub
EndClass


Posted by at No comments:
Subscribe to: Posts (Atom)