NRSolution4u Dot net Learning : December 2023

Database Create

Student : roll , name , city , cost

Fix 6 Value in Database Record

====================================================================

Default.aspx Page

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="default.aspx.cs" Inherits="WebApplication1._default" %>

<!DOCTYPE html>

</head>

<body>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

OnRowDataBound = "OnRowDataBound" ShowFooter="True">

<asp:BoundField DataField="roll" HeaderText="Roll" ItemStyle-Width = "100">

</asp:BoundField>

<asp:BoundField DataField="name" HeaderText="Name" ItemStyle-Width = "100">

</asp:BoundField>

<asp:BoundField DataField="city" HeaderText="Name" ItemStyle-Width = "100">

</asp:BoundField>

<asp:TemplateField HeaderText="City">

<asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("cost") %>'></asp:TextBox>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</form>

</body>

</html>

=====================================================================

C# Coading Concept

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

namespace WebApplication1

{

public partial class _default : System.Web.UI.Page

{

SqlConnection cn;

SqlCommand cm;

SqlDataReader dr;

protected void Page_Load(object sender, EventArgs e)

{

if(!IsPostBack)

{

display();

}

protected void display()

{

string path = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\dell\Desktop\gridvcont\WebApplication1\WebApplication1\App_Data\Database1.mdf;Integrated Security=True";

cn = new SqlConnection(path);

cn.Open();

string k = "select * from student";

cm = new SqlCommand(k, cn);

dr = cm.ExecuteReader();

GridView1.DataSource = dr;

GridView1.DataBind();

dr.Close();

}

protected void OnRowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

TextBox tb = (TextBox)e.Row.FindControl("TextBox1");

TableCell cell = e.Row.Cells[2];

string cityname = cell.Text;

if (cityname == "NAGPUR")

{

tb.BackColor = System.Drawing.Color.Red;

}

NRSolution4u Dot net Learning

Wednesday, December 20, 2023

GRIDVIEW ON ROW DATA BOUND EVENT

GRIDVIEW ON ROW DATA BOUND EVENT

Report Abuse