This is my webform code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using BLLRHS;
namespace RHSWebApplication
{
public partial class Home : System.Web.UI.Page
{
BLLClass obj = new BLLClass();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
}
}
public void BindGrid()
{
GridView1.DataSource = obj.SelectStudent();
GridView1.DataBind();
}
public void Clear()
{
TextBox1.Text = ""; RadioButtonList1.ClearSelection(); TextBox2.Text = ""; DropDownList1.Text = ""; CheckBoxList1.Text = "";
}
protected void Button1_Click(object sender, EventArgs e)
{
obj.InsertData(TextBox1.Text,RadioButtonList1.SelectedItem.Text,TextBox2.Text,DropDownList1.SelectedItem.Text,CheckBoxList1.SelectedItem.Text);
BindGrid();
Clear();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
GridView1.DataSource = obj.SelectStudent();
GridView1.DataBind();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int Id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
string Name = (GridView1.Rows[e.RowIndex].FindControl("TextBoxName") as TextBox).Text;
string Gender = (GridView1.Rows[e.RowIndex].FindControl("RadioButtonListGender") as RadioButtonList).Text;
string DOB = (GridView1.Rows[e.RowIndex].FindControl("TextBoxDOB") as TextBox).Text;
string City = (GridView1.Rows[e.RowIndex].FindControl("DropDownListCity") as DropDownList).Text;
string Qualification = (GridView1.Rows[e.RowIndex].FindControl("CheckBoxListQualification") as CheckBoxList).Text;
obj.UpdateStudent(Id.ToString(), Name, Gender, DOB, City, Qualification);
GridView1.EditIndex = -1;
BindGrid();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int Id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
obj.DeleteStudent(Id.ToString());
BindGrid();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
BindGrid();
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataRowView dRowView = (DataRowView)e.Row.DataItem;
if (e.Row.RowType == DataControlRowType.DataRow)
{
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
RadioButtonList rblGender = (RadioButtonList)e.Row.FindControl("RadioButtonListGender");
DropDownList ddlCity = (DropDownList)e.Row.FindControl("DropDownListCity");
CheckBoxList chkQua = (CheckBoxList)e.Row.FindControl("CheckBoxListQualification");
rblGender.SelectedValue = dRowView[2].ToString();
ddlCity.SelectedValue = dRowView[4].ToString();
chkQua.SelectedValue = dRowView[5].ToString();
}
}
}
}
}
This is my Data Access Layer
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
namespace DALRHS
{
public class DALClass
{
SqlConnection cn = new SqlConnection("Data Source=.;Initial Catalog=RHS;Integrated Security=True");
public void InsertDetails(string Name, string Gender, string DOB,string City, string Qualification)
{
SqlCommand cmd = new SqlCommand("Sp_SaveData1", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", Name);
cmd.Parameters.AddWithValue("@Gender", Gender);
cmd.Parameters.AddWithValue("@DOB",DateTime.Parse (DOB));
cmd.Parameters.AddWithValue("@City", City);
cmd.Parameters.AddWithValue("@Qualification", Qualification);
cn.Open();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
cn.Close();
}
}
public void UpdateDetail(string Id,string Name, string Gender, string DOB, string City, string Qualification)
{
SqlCommand cmd = new SqlCommand("spUpdate", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", Id);
cmd.Parameters.AddWithValue("@Name", Name);
cmd.Parameters.AddWithValue("@Gender", Gender);
cmd.Parameters.AddWithValue("@DOB",DateTime.Parse(DOB));
cmd.Parameters.AddWithValue("@City", City);
cmd.Parameters.AddWithValue("@Qualification", Qualification);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
public object getDetail()
{
SqlDataAdapter da = new SqlDataAdapter("sp_GetAllStudent", cn);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
public void deleteDetail(string Id)
{
SqlCommand cmd = new SqlCommand("Sp_Delete", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", Id);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
}
}
Bussiness Layer is
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using DALRHS;
namespace BLLRHS
{
public class BLLClass
{
DALClass obj = new DALClass();
public void InsertData(string Name, string Gender, string DOB, string City, string Qualification)
{
obj.InsertDetails(Name, Gender, DOB, City, Qualification);
}
public void UpdateStudent(string Id,string Name, string Gender, string DOB, string City, string Qualification)
{
obj.UpdateDetail(Id,Name, Gender, DOB, City, Qualification);
}
public object SelectStudent()
{
return obj.getDetail();
}
public void DeleteStudent(string Id)
{
obj.deleteDetail(Id);
}
}
}
Please check my code standrad. Any changes needed?