<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title>Untitled Page</title></head><body> <form id="form1" runat="server"> <div> Enter Eno<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br /> Enter Empname<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><br /> Enter Sal<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox><br /> <asp:Button ID="Button1" runat="server" Text="Submit" onclick="Button1_Click" /><br /> <asp:GridView ID="GridView1" runat="server" DataKeyNames="eno" AutoGenerateColumns="false" onrowediting="GridView1_RowEditing" onrowcancelingedit="GridView1_RowCancelingEdit" onrowdeleting="GridView1_RowDeleting" onpageindexchanging="GridView1_PageIndexChanging" PageSize="6" AllowPaging="true" onrowcreated="GridView1_RowCreated" onrowdatabound="GridView1_RowDataBound"> <Columns> <asp:TemplateField HeaderText="Employee no"> <ItemTemplate> <%#Eval("eno")%> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Emp name"> <ItemTemplate> <%#Eval("empname")%> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Salary"> <ItemTemplate> <%#Eval("sal")%> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Delete"> <ItemTemplate> <asp:LinkButton ID="lnkDelete" CommandName="Delete" runat="server" OnClientClick="return confirm('Are you sure you want to delete this record?');" >Delete</asp:LinkButton> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> </div> </form></body></html>
using System.Data;public partial class _Default : System.Web.UI.Page { DataTable dt = new DataTable(); DataTable dt1 = new DataTable(); DataRow dr; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { dt.Columns.Add("eno"); dt.Columns.Add("empname"); dt.Columns.Add("sal"); Session["reptable"] = dt; GridData(); } } protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { GridView1.EditIndex = e.NewEditIndex; GridData(); } void GridData() { GridView1.DataSource = (DataTable)Session["reptable"]; GridView1.DataBind(); } protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { GridView1.EditIndex = -1; GridData(); } protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string eno; eno = GridView1.DataKeys[e.RowIndex].Value.ToString(); if (Session["reptable"] != null) { DataTable dt1 = new DataTable(); dt1.Clear(); dt1 = Session["reptable"] as DataTable; for (int i = 0; i <= dt1.Rows.Count - 1; i++) { DataRow dr; if (dt1.Rows[i][0].ToString() == eno) { dr = dt1.Rows[i]; dt1.Rows[i].Delete(); //dt1.Rows.Remove(dr); } } Session.Remove("reptable"); Session["reptable"] = dt1; } GridData(); } protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridView1.PageIndex = e.NewPageIndex; GridData(); } protected void Button1_Click(object sender, EventArgs e) { dt = (DataTable)Session["reptable"]; dr = dt.NewRow(); dr["eno"] = TextBox1.Text; dr["empname"] = TextBox2.Text; dr["sal"] = TextBox3.Text; dt.Rows.Add(dr); Session.Remove("reptable"); Session["reptable"] = dt; GridData(); } protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { } //here i cah change back color each two records protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e) { if (e.Row.RowIndex != -1) { GridViewRow row = e.Row; if (e.Row.RowIndex < 2) { row.BackColor = System.Drawing.Color.LightBlue; } else if (e.Row.RowIndex < 4) { row.BackColor = System.Drawing.Color.Pink; } else if (e.Row.RowIndex < 6) { row.BackColor = System.Drawing.Color.Aqua; } } }}
namespace DataGridViewColorChange{ public partial class Form1 : Form { SqlConnection sqlcon = new SqlConnection(@"Server=RAVI-PC\SQLEXPRESS;database=test1;uid=ravindran;pwd=srirangam;"); SqlCommand sqlcmd = new SqlCommand(); SqlDataAdapter da = new SqlDataAdapter(); DataTable dt = new DataTable(); public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { LoadGrid(); //Change back color using below method after bind data colorchange(); } void colorchange() { if (dt.Rows.Count > 2) { for (int i = 0; i < 2; i++) { dataGridView1.Rows[i].DefaultCellStyle.BackColor = Color.Aqua; } } else { for (int i = 0; i <= dt.Rows.count-1; i++) { dataGridView1.Rows[i].DefaultCellStyle.BackColor = Color.Aqua; } } if (dt.Rows.Count > 4) { for (int i = 2; i < 4; i++) { dataGridView1.Rows[i].DefaultCellStyle.BackColor = Color.Pink; } } else { for (int i = 2; i <= dt.Rows.count - 1; i++) { dataGridView1.Rows[i].DefaultCellStyle.BackColor = Color.Pink; } } }}}