|
Resources » .NET programming » ASP.NET/Web Applications
GridView Insert, Update, Delete in ASP.Net 2.0 code:
|
GridView Insert, Update, Delete in ASP.Net 2.0 code:
Table Design:
1)create a table named StudentMarks with the following Columns as mentioned below
a)StudentID
b)StudentName
c)Class
d)English
e)Tamil
f)Maths
g)Science
h)Social
i)Total
j)Average
And declare the appropriate data types as mentioned above
Also set the Primary Key for StudentId and set the Identity for it and Increment by 1.
Procedure Creations:
1)Create 3 Procedures for Insert, Update and Delete like as shown below
2)Important thing is go to your respective database
And run this use database name (specify your databasename)
3)Just copy and paste the below code in your Sql Server 2000 / 2005 screen and execute it to create the below mentioned 3 Procedure for Insert, Update and Delete.
use databasename
-- Insert Procedure for StudentMarks table
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
Create procedure [dbo].[insert_StudentMarks]
@StudentName nvarchar(50),
@Class nvarchar(5),
@English int,
@Tamil int,
@Maths int,
@Science int,
@Social int,
@Total int,
@Average int
As
insert into StudentMarks
(
StudentName,
Class,
English,
Tamil,
Maths,
Science,
Social,
Total,
Average
)
values
(
@StudentName,
@Class,
@English,
@Tamil,
@Maths,
@Science,
@Social,
@Total,
@Average
)
-- Update Procedure for StudentMarks table
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
Create procedure [dbo].[update_StudentMarks]
@StudentID int,
@StudentName nvarchar(50),
@Class nvarchar(5),
@English int,
@Tamil int,
@Maths int,
@Science int,
@Social int,
@Total int,
@Average int
As
update StudentMarks set
StudentName=@StudentName,
Class=@Class,
English=@English,
Tamil=@Tamil,
Maths=@Maths,
Science=@Science,
Social=@Social,
Total=@Total,
Average=@Average
where
StudentID = @StudentID
-- Delete Procedure for StudentMarks table
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
Create procedure [dbo].[delete_StudentMarks]
@StudentID int
As
delete from StudentMarks
where
StudentID = @StudentID
4)Database part is over now.
Screen Design:
1)Create a screen or copy the below Inline coding as mentioned below and just copy it in the Source tab of the .aspx screen.
The first one is the GridView which is displayed horizontally.
The Second one is the DetailView which is displayed vertically of the individual rows.
Inline Coding:
< %@ Page Language="C#" AutoEventWireup="true" CodeFile="StudentMarks.aspx.cs" Inherits="StudentMarks" % >
< !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 > Student Marks< /title >
< /head >
< body bgcolor="Silver" >
< form id="form1" runat="server" >
< div >
< h2 > STUDENT MARKS< /h2 >
< table >
< tr >
< td > < asp:Label ID="lblStudentName" Text="Student Name" runat="server" > < /asp:Label > < /td >
< td > < asp:TextBox ID="txtStudentName" runat="server" > < /asp:TextBox > < /td >
< td > < asp:Button ID="btnSearch" Text="Search" runat="server" OnClick="btnSearch_Click" / > < /td >
< /tr >
< tr >
< td > < asp:Label ID="lblStudentClass" Text="Class :" runat="server" > < /asp:Label > < /td >
< td > < asp:DropDownList ID="ddlStudentClass" runat="server" > < /asp:DropDownList > < /td >
< /tr >
< tr >
< td > < asp:Label ID="lblEnglish" Text="English Mark :" runat="server" > < /asp:Label > < /td >
< td > < asp:TextBox ID="txtEnglish" runat="server" > < /asp:TextBox > < /td >
< /tr >
< tr >
< td > < asp:Label ID="lblTamil" Text="Tamil Mark :" runat="server" > < /asp:Label > < /td >
< td > < asp:TextBox ID="txtTamil" runat="server" > < /asp:TextBox > < /td >
< /tr >
< tr >
< td > < asp:Label ID="lblMaths" Text="Maths Mark :" runat="server" > < /asp:Label > < /td >
< td > < asp:TextBox ID="txtMaths" runat="server" > < /asp:TextBox > < /td >
< /tr >
< tr >
< td > < asp:Label ID="lblScience" Text="Science Mark :" runat="server" > < /asp:Label > < /td >
< td > < asp:TextBox ID="txtScience" runat="server" > < /asp:TextBox > < /td >
< /tr >
< tr >
< td > < asp:Label ID="lblSocial" Text="Social Mark :" runat="server" > < /asp:Label > < /td >
< td > < asp:TextBox ID="txtSocial" runat="server" > < /asp:TextBox > < /td >
< /tr >
< tr >
< td align="center" > < asp:Button ID="btnSave" Text="Save" runat="server" OnClick="btnSave_Click" / > < /td >
< td align="center" > < asp:Button ID="btnClear" Text="Clear" runat="server" OnClick="btnClear_Click" / > < /td >
< td align="center" > < /td >
< /tr >
< /table >
< /div >
< asp:GridView ID="gvwStudentMarks" runat="server" BackColor="#CCCCCC" BorderColor="#999999"
BorderStyle="Solid" BorderWidth="3px" CellPadding="4" CellSpacing="2" ForeColor="Black" AutoGenerateColumns="False" OnRowEditing="gvwStudentMarks_RowEditing" OnRowCancelingEdit="gvwStudentMarks_RowCancelingEdit" AllowPaging="True" AllowSorting="True" OnPageIndexChanging="gvwStudentMarks_PageIndexChanging" PageSize="3" OnRowDeleting="gvwStudentMarks_RowDeleting" OnSorting="gvwStudentMarks_Sorting" OnRowUpdating="gvwStudentMarks_RowUpdating" OnSelectedIndexChanging="gvwStudentMarks_SelectedIndexChanging" >
< FooterStyle BackColor="#CCCCCC" / >
< RowStyle BackColor="White" / >
< SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" / >
< PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" / >
< HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" / >
< Columns >
< asp:TemplateField HeaderText="StudentID" Visible="false" SortExpression="StudentID" >
< ItemTemplate >
< asp:Label ID="lblStudentId" Text='< % #Eval("StudentID") % > ' runat="server" > < /asp:Label >
< /ItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Student Name" SortExpression="StudentName" >
< ItemTemplate >
< asp:Label ID="lblStudentName" runat="server" Text='< % #Eval("StudentName") % > ' > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtStudentName" TextMode="SingleLine" runat="server" Text='< % #Eval("StudentName") % > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Class" SortExpression="Class" >
< ItemTemplate >
< asp:Label ID="lblClass" Text='< % #Eval("Class") % > ' runat="server" > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtClass" TextMode="SingleLine" Text='< % #Eval("Class") % > ' runat="server" > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="English" SortExpression="English" >
< ItemTemplate >
< asp:Label ID="lblEnglish" Text='< % #Eval("English") % > ' runat="server" > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtEnglish" TextMode="SingleLine" runat="server" Text='< %#Eval("English")% > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Tamil" SortExpression="Tamil" >
< ItemTemplate >
< asp:Label ID="lblTamil" Text='< % #Eval("Tamil") % > ' runat="server" > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtTamil" TextMode="SingleLine" runat="server" Text='< % #Eval("Tamil") % > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Maths" SortExpression="Maths" >
< ItemTemplate >
< asp:Label ID="lblMaths" Text='< % #Eval("Maths") % > ' runat="server" > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtMaths" TextMode="SingleLine" runat="server" Text='< % #Eval("Maths")% > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Science" SortExpression="Science" >
< ItemTemplate >
< asp:Label ID="lblScience" Text='< % #Eval("Science") % > ' runat="server" > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtScience" TextMode="SingleLine" runat="server" Text='< % #Eval("Science") % > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Social" SortExpression="Social" >
< ItemTemplate >
< asp:Label ID="lblSocial" Text='< % #Eval("Social") % > ' runat="server" > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtSocial" TextMode="SingleLine" runat="server" Text='< % #Eval("Social") % > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Total" SortExpression="Total" >
< ItemTemplate >
< asp:Label ID="lblTotal" runat="server" Text='< % #Eval("Total") % > ' > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtTotal" ReadOnly="true" TextMode="SingleLine" runat="server" Text='< % #Eval("Total") % > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Average" SortExpression="Average" >
< ItemTemplate >
< asp:Label ID="lblAverage" runat="server" Text='< % #Eval("Average") % > ' > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtAverage" ReadOnly="true" runat="server" TextMode="SingleLine" Text='< % #Eval("Average") % > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:CommandField ShowEditButton="True" / >
< asp:CommandField ShowDeleteButton="True" / >
< asp:CommandField ShowSelectButton="true" / >
< /Columns >
< /asp:GridView >
< h4 > Student Mark Details:< /h4 >
< asp:DetailsView ID="detvwStudentMarks" runat="server" Height="50px" Width="125px" BorderStyle="Solid" BorderColor="Gray" BorderWidth="2px" CellPadding="4" CellSpacing="2" ForeColor="Black" AutoGenerateRows="False" OnItemDeleting="detvwStudentMarks_ItemDeleting" >
< Fields >
< asp:TemplateField HeaderText="StudentID" Visible="False" SortExpression="StudentID" >
< ItemTemplate >
< asp:Label ID="lblStudentId" Text='< % #Eval("StudentID") % > ' runat="server" > < /asp:Label >
< /ItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Student Name" SortExpression="StudentName" >
< ItemTemplate >
< asp:Label ID="lblStudentName" runat="server" Text='< % #Eval("StudentName") % > ' > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtStudentName" TextMode="SingleLine" runat="server" Text='< % #Eval("StudentName") % > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Class" SortExpression="Class" >
< ItemTemplate >
< asp:Label ID="lblClass" Text='< % #Eval("Class") % > ' runat="server" > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtClass" TextMode="SingleLine" Text='< % #Eval("Class") % > ' runat="server" > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="English" SortExpression="English" >
< ItemTemplate >
< asp:Label ID="lblEnglish" Text='< % #Eval("English") % > ' runat="server" > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtEnglish" TextMode="SingleLine" runat="server" Text='< %#Eval("English")% > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Tamil" SortExpression="Tamil" >
< ItemTemplate >
< asp:Label ID="lblTamil" Text='< % #Eval("Tamil") % > ' runat="server" > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtTamil" TextMode="SingleLine" runat="server" Text='< % #Eval("Tamil") % > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Maths" SortExpression="Maths" >
< ItemTemplate >
< asp:Label ID="lblMaths" Text='< % #Eval("Maths") % > ' runat="server" > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtMaths" TextMode="SingleLine" runat="server" Text='< % #Eval("Maths")% > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Science" SortExpression="Science" >
< ItemTemplate >
< asp:Label ID="lblScience" Text='< % #Eval("Science") % > ' runat="server" > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtScience" TextMode="SingleLine" runat="server" Text='< % #Eval("Science") % > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Social" SortExpression="Social" >
< ItemTemplate >
< asp:Label ID="lblSocial" Text='< % #Eval("Social") % > ' runat="server" > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtSocial" TextMode="SingleLine" runat="server" Text='< % #Eval("Social") % > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Total" SortExpression="Total" >
< ItemTemplate >
< asp:Label ID="lblTotal" runat="server" Text='< % #Eval("Total") % > ' > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtTotal" ReadOnly="true" TextMode="SingleLine" runat="server" Text='< % #Eval("Total") % > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< asp:TemplateField HeaderText="Average" SortExpression="Average" >
< ItemTemplate >
< asp:Label ID="lblAverage" runat="server" Text='< % #Eval("Average") % > ' > < /asp:Label >
< /ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID = "txtAverage" ReadOnly="true" runat="server" TextMode="SingleLine" Text='< % #Eval("Average") % > ' > < /asp:TextBox >
< /EditItemTemplate >
< /asp:TemplateField >
< /Fields >
< /asp:DetailsView >
< /form >
< /body >
< /html >
2)Now the Screen is ready for use.
3)Create the Business logic layer in a separate class as BSStudentMarks.cs
BSStudentMarks.cs Should Contain
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
///
/// Summary description for BSStudentMarks
///
public class BSStudentMarks
{
public BSStudentMarks()
{
//
// TODO: Add constructor logic here
//
}
private int _StudentID;
private string _StudentName;
private string _Class;
private int _English;
private int _Tamil;
private int _Maths;
private int _Science;
private int _Social;
private int _Total;
private int _Average;
public int StudentID
{
get
{
return _StudentID;
}
set
{
_StudentID = value;
}
}
public string StudentName
{
get
{
return _StudentName;
}
set
{
_StudentName = value;
}
}
public string Class
{
get
{
return _Class;
}
set
{
_Class = value;
}
}
public int English
{
get
{
return _English;
}
set
{
_English = value;
}
}
public int Tamil
{
get
{
return _Tamil;
}
set
{
_Tamil = value;
}
}
public int Maths
{
get
{
return _Maths;
}
set
{
_Maths = value;
}
}
public int Science
{
get
{
return _Science;
}
set
{
_Science = value;
}
}
public int Social
{
get
{
return _Social;
}
set
{
_Social = value;
}
}
public int Total
{
get
{
return _Total;
}
set
{
_Total = value;
}
}
public int Average
{
get
{
return _Average;
}
set
{
_Average = value;
}
}
public Boolean insertStudMark()
{
DSStudentMarks ds = new DSStudentMarks();
return ds.insertStudentMarks(_StudentName,_Class,_English,_Tamil,_Maths,_Science,_Social,_Total,_Average);
}
public Boolean deleteStudMark()
{
DSStudentMarks ds = new DSStudentMarks();
return ds.deleteStudentMarks(_StudentID);
}
public DataSet updateStudMark()
{
DSStudentMarks ds = new DSStudentMarks();
return ds.updateStudentMarks(_StudentID, _StudentName, _Class, _English, _Tamil, _Maths, _Science, _Social, _Total, _Average);
}
public DataSet BindStudMarks()
{
DSStudentMarks ds = new DSStudentMarks();
return ds.BindStudentMarks();
}
public DataSet SelectStudMark()
{
DSStudentMarks ds = new DSStudentMarks();
return ds.SelectStudentMarks(_StudentID);
}
}
4) Create the Data Access layer in a separate class as DSStudentMarks.cs.
DSStudentMarks.cs
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
///
/// Summary description for DSStudentMarks
///
public class DSStudentMarks
{
SqlConnection sqlcon = new SqlConnection("server=servername;Database=databasename;User ID=userid;Password=password");
public DSStudentMarks()
{
//
// TODO: Add constructor logic here
//
}
public Boolean insertStudentMarks(string studentname,string Class,int English,int Tamil,int Maths,int Science,int Social,int Total,int Average)
{
Boolean bln;
int retValue;
try
{
sqlcon.Open();
SqlCommand sqlcmd = new SqlCommand("insert_StudentMarks", sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add("@StudentName", SqlDbType.NVarChar, 50);
sqlcmd.Parameters.Add("@Class", SqlDbType.NVarChar, 5);
sqlcmd.Parameters.Add("@English", SqlDbType.Int);
sqlcmd.Parameters.Add("@Tamil", SqlDbType.Int);
sqlcmd.Parameters.Add("@Maths", SqlDbType.Int);
sqlcmd.Parameters.Add("@Science", SqlDbType.Int);
sqlcmd.Parameters.Add("@Social", SqlDbType.Int);
sqlcmd.Parameters.Add("@Total", SqlDbType.Int);
sqlcmd.Parameters.Add("@Average", SqlDbType.Int);
sqlcmd.Parameters["@StudentName"].Value = studentname;
sqlcmd.Parameters["@Class"].Value = Class;
sqlcmd.Parameters["@English"].Value = English;
sqlcmd.Parameters["@Tamil"].Value = Tamil;
sqlcmd.Parameters["@Maths"].Value = Maths;
sqlcmd.Parameters["@Science"].Value = Science;
sqlcmd.Parameters["@Social"].Value = Social;
sqlcmd.Parameters["@Total"].Value = Total;
sqlcmd.Parameters["@Average"].Value = Average;
retValue = sqlcmd.ExecuteNonQuery();
if (retValue > 0)
bln = true;
else
bln = false;
return bln;
}
catch (Exception ex)
{
ex.Message.ToString();
return false;
}
finally
{
sqlcon.Close();
}
}
public DataSet updateStudentMarks(int studentid,string studentname, string Class, int English, int Tamil, int Maths, int Science, int Social, int Total, int Average)
{
DataSet ds = new DataSet();
try
{
sqlcon.Open();
SqlCommand sqlcmd = new SqlCommand("update_StudentMarks", sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add("@StudentID", SqlDbType.Int);
sqlcmd.Parameters.Add("@StudentName", SqlDbType.NVarChar, 50);
sqlcmd.Parameters.Add("@Class", SqlDbType.NVarChar, 5);
sqlcmd.Parameters.Add("@English", SqlDbType.Int);
sqlcmd.Parameters.Add("@Tamil", SqlDbType.Int);
sqlcmd.Parameters.Add("@Maths", SqlDbType.Int);
sqlcmd.Parameters.Add("@Science", SqlDbType.Int);
sqlcmd.Parameters.Add("@Social", SqlDbType.Int);
sqlcmd.Parameters.Add("@Total", SqlDbType.Int);
sqlcmd.Parameters.Add("@Average", SqlDbType.Float);
sqlcmd.Parameters["@StudentID"].Value = studentid;
sqlcmd.Parameters["@StudentName"].Value = studentname;
sqlcmd.Parameters["@Class"].Value = Class;
sqlcmd.Parameters["@English"].Value = English;
sqlcmd.Parameters["@Tamil"].Value = Tamil;
sqlcmd.Parameters["@Maths"].Value = Maths;
sqlcmd.Parameters["@Science"].Value = Science;
sqlcmd.Parameters["@Social"].Value = Social;
sqlcmd.Parameters["@Total"].Value = Total;
sqlcmd.Parameters["@Average"].Value = Average;
sqlcmd.ExecuteNonQuery();
SqlDataAdapter sqlada = new SqlDataAdapter("select * from StudentMarks", sqlcon);
sqlada.Fill(ds, "StudentMarks");
return ds;
}
catch (Exception ex)
{
ex.Message.ToString();
return ds;
}
finally
{
sqlcon.Close();
}
}
public Boolean deleteStudentMarks(int studentid)
{
Boolean bln;
int retValue;
try
{
sqlcon.Open();
SqlCommand sqlcmd = new SqlCommand("delete_StudentMarks", sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add("@StudentID", SqlDbType.Int);
sqlcmd.Parameters["@StudentID"].Value = studentid;
retValue = sqlcmd.ExecuteNonQuery();
if (retValue > 0)
bln = true;
else
bln = false;
return bln;
}
catch (Exception ex)
{
ex.Message.ToString();
return false;
}
finally
{
sqlcon.Close();
}
}
public DataSet BindStudentMarks()
{
DataSet ds = new DataSet();
try
{
sqlcon.Open();
SqlCommand sqlcmd = new SqlCommand("select * from StudentMarks", sqlcon);
sqlcmd.CommandType = CommandType.Text;
SqlDataAdapter sqlada = new SqlDataAdapter(sqlcmd);
sqlada.Fill(ds, "StudentMarks");
return ds;
}
catch (Exception ex)
{
ex.Message.ToString();
return ds;
}
finally
{
sqlcon.Close();
}
}
public DataSet SelectStudentMarks(int studentid)
{
DataSet ds = new DataSet();
try
{
sqlcon.Open();
SqlCommand sqlcmd = new SqlCommand("select_studentmarks", sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add("@StudentId", SqlDbType.Int);
sqlcmd.Parameters["@StudentId"].Value = studentid;
SqlDataAdapter sqlada = new SqlDataAdapter(sqlcmd);
sqlada.Fill(ds, "StudentMarks");
return ds;
}
catch (Exception ex)
{
ex.Message.ToString();
return ds;
}
finally
{
sqlcon.Close();
}
}
}
5)In StudentMarks.aspx.cs copy and paste the following code
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class StudentMarks : System.Web.UI.Page
{
BSStudentMarks bs = new BSStudentMarks();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
fillClass();
ClearScreen();
BindGridView();
}
}
private void fillClass()
{
ArrayList ar = new ArrayList();
ar.Add("");
ar.Add("I");
ar.Add("II");
ar.Add("III");
ar.Add("IV");
ar.Add("V");
ar.Add("VI");
ar.Add("VII");
ar.Add("VIII");
ar.Add("IX");
ar.Add("X");
ar.Add("XI");
ar.Add("XII");
ddlStudentClass.DataSource = ar;
ddlStudentClass.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
BSStudentMarks bs = new BSStudentMarks();
bs.StudentName = txtStudentName.Text.ToString();
bs.Class = ddlStudentClass.SelectedItem.Value.ToString();
bs.English = Convert.ToInt16(txtEnglish.Text.ToString());
bs.Tamil = Convert.ToInt16(txtTamil.Text.ToString());
bs.Maths = Convert.ToInt16(txtMaths.Text.ToString());
bs.Science = Convert.ToInt16(txtScience.Text.ToString());
bs.Social = Convert.ToInt16(txtSocial.Text.ToString());
bs.Total = Convert.ToInt16(txtEnglish.Text) + Convert.ToInt16(txtTamil.Text) + Convert.ToInt16(txtMaths.Text) + Convert.ToInt16(txtScience.Text) + Convert.ToInt16(txtSocial.Text);
int avg = (Convert.ToInt16(txtEnglish.Text) + Convert.ToInt16(txtTamil.Text) + Convert.ToInt16(txtMaths.Text) + Convert.ToInt16(txtScience.Text) + Convert.ToInt16(txtSocial.Text))/5;
bs.Average = avg;
if (bs.insertStudMark())
{
BindGridView();
Response.Write("Added Successfully");
}
else
Response.Write("Not Added Successfully");
ClearScreen();
}
protected void gvwStudentMarks_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow gvr = gvwStudentMarks.Rows[e.RowIndex];
Label lblStudId = (Label)gvr.FindControl("lblStudentId");
TextBox txtStudName = (TextBox)gvwStudentMarks.Rows[e.RowIndex].FindControl("txtStudentName");
TextBox txtcls = (TextBox)gvwStudentMarks.Rows[e.RowIndex].FindControl("txtClass");
TextBox txtEng = (TextBox)gvwStudentMarks.Rows[e.RowIndex].FindControl("txtEnglish");
TextBox txtTam = (TextBox)gvwStudentMarks.Rows[e.RowIndex].FindControl("txtTamil");
TextBox txtMat = (TextBox)gvwStudentMarks.Rows[e.RowIndex].FindControl("txtMaths");
TextBox txtSci = (TextBox)gvwStudentMarks.Rows[e.RowIndex].FindControl("txtScience");
TextBox txtSoc = (TextBox)gvwStudentMarks.Rows[e.RowIndex].FindControl("txtSocial");
TextBox txtTot = (TextBox)gvwStudentMarks.Rows[e.RowIndex].FindControl("txtTotal");
TextBox txtAvg = (TextBox)gvwStudentMarks.Rows[e.RowIndex].FindControl("txtAverage");
bs.StudentID = Convert.ToInt16(lblStudId.Text);
bs.StudentName = txtStudName.Text.ToString();
bs.Class = txtcls.Text.ToString();
bs.English = Convert.ToInt16(txtEng.Text.ToString());
bs.Tamil = Convert.ToInt16(txtTam.Text.ToString());
bs.Maths = Convert.ToInt16(txtMat.Text.ToString());
bs.Science = Convert.ToInt16(txtSci.Text.ToString());
bs.Social = Convert.ToInt16(txtSoc.Text.ToString());
bs.Total = Convert.ToInt16(txtEng.Text.ToString()) + Convert.ToInt16(txtTam.Text.ToString()) + Convert.ToInt16(txtMat.Text.ToString()) + Convert.ToInt16(txtSci.Text.ToString()) + Convert.ToInt16(txtSoc.Text.ToString());
int avg = (Convert.ToInt16(txtEng.Text.ToString()) + Convert.ToInt16(txtTam.Text.ToString()) + Convert.ToInt16(txtMat.Text.ToString()) + Convert.ToInt16(txtSci.Text.ToString()) + Convert.ToInt16(txtSoc.Text.ToString())) / 5;
bs.Average = avg;
gvwStudentMarks.EditIndex = -1;
gvwStudentMarks.DataSource = bs.updateStudMark();
gvwStudentMarks.DataBind();
}
protected void gvwStudentMarks_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow gvr = gvwStudentMarks.Rows[e.RowIndex];
Label lblStudId = (Label)gvr.FindControl("lblStudentId");
bs.StudentID = Convert.ToInt16(lblStudId.Text);
if (bs.deleteStudMark())
{
BindGridView();
Response.Write("Deleted Successfully");
}
else
{
Response.Write("Not deleted");
}
}
protected void gvwStudentMarks_RowEditing(object sender, GridViewEditEventArgs e)
{
gvwStudentMarks.EditIndex = e.NewEditIndex;
BindGridView();
}
protected void gvwStudentMarks_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
gvwStudentMarks.EditIndex = -1;
BindGridView();
}
protected void gvwStudentMarks_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvwStudentMarks.PageIndex = e.NewPageIndex;
BindGridView();
}
protected void gvwStudentMarks_Sorting(object sender, GridViewSortEventArgs e)
{
}
protected void btnClear_Click(object sender, EventArgs e)
{
ClearScreen();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
BindGridView();
}
private void ClearScreen()
{
txtStudentName.Text = string.Empty;
ddlStudentClass.Text = string.Empty;
txtEnglish.Text = string.Empty;
txtTamil.Text = string.Empty;
txtMaths.Text = string.Empty;
txtScience.Text = string.Empty;
txtSocial.Text = string.Empty;
}
private void BindGridView()
{
BSStudentMarks bs = new BSStudentMarks();
gvwStudentMarks.DataSource = bs.BindStudMarks();
gvwStudentMarks.DataBind();
gvwStudentMarks.Visible = true;
}
protected void gvwStudentMarks_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
GridViewRow gvr = gvwStudentMarks.Rows[e.NewSelectedIndex];
Label lblStudId = (Label)gvr.FindControl("lblStudentId");
bs.StudentID = Convert.ToInt16(lblStudId.Text);
detvwStudentMarks.DataSource = bs.SelectStudMark();
detvwStudentMarks.DataBind();
Response.Write("Shown Successfully");
}
}
Select:
On Clicking the Select Button in the GridView the respective data is shown in a Separate DetailView.
That’s it !!!!!
So now are able to do any thing in the GridView in ASP.Net 2.0 like Insert, Update and Delete as well in a 3 Tier Architecture.
Happy Programming !!!!!!!!! :)
If any doubts you can call me @ 09821819561 – Vinoth (Mumbai)
 Attachments
GridView Insert, Update, Delete in ASP.Net 2.0 code (25550-281154-GridView Code.doc)
|
Did you like this resource? Share it with your friends and show your love!
|
|
|
| Author: priyanka 27 Feb 2011 | Member Level: Bronze Points : 1 | Hello Sir,
i am new in .net and i implement this article and getting error of text box and class 'ddlStudentClass,txtstudentname,txtmatha and all this type of errors' does not exist in the current context'. so is there any reference to add or something else.
kindly guide me how to solve this.
Regards
Priyanka
| | Author: priyanka 27 Feb 2011 | Member Level: Bronze Points : 1 | Hello Sir,
i am new in .net and i implement this article and getting error of text box and class 'ddlStudentClass' does not exist in the current context'. so is there any reference to add or something else.
kindly guide me how to solve this.
Regards
Priyanka
| | Author: satyajee srivastava 07 Mar 2011 | Member Level: Silver Points : 1 | Hi Priyanka
Drop the DropdownList and textbox from Tools box as event handlers is not defined and add the Class from properties ddlStudentClass
| | Author: KUNDAN KUMAR SRIVASTAVA 31 Mar 2011 | Member Level: Gold Points : 1 | Is not a too lengthy code?
Use update control for edit. Insert control for new item and edit button for editing any records in Gridview.
Do not put much length code. It will confuse others mainly freshers.
soon I will post the simple way of this problem...
| | Guest Author: Nicole 02 May 2012 | Hey, you saved my day!!!!When I copied the error into the Google secarh I felt this would hardly get me anywhere, but yeah here I am and my code works. Just changed the ID of my textBox to TitleTxtBox' instead of Title' and it worked. I know it would have taken me ages to figure this out, too. Thank you!!! Have you notified Microsoft. I think title textboxes will appear in a lot of forms and give people a strong head ache.
|
Follow us on Twitter: https://twitter.com/dotnetspider
|
|