protected void SaveDepartmentDetails() { if (txtDepartmentName.Text != "") { using (SqlConnection con = new SqlConnection(CS)) { SqlCommand cmd = new SqlCommand("INSERT INTO Department (DepartmentName) VALUES(@name)", con); cmd.Parameters.AddWithValue("@name", txtDepartmentName.Text); con.Open(); int rowCount = cmd.ExecuteNonQuery(); if (rowCount > 0) { SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Department", con); DataTable dt = new DataTable(); da.Fill(dt); GrdViewDepartment.DataSource = dt; GrdViewDepartment.DataBind(); } } } }
protected void UpdateDepartmentDetails() { if (txtDepartmentName.Text != "") { using (SqlConnection con = new SqlConnection(CS)) { SqlCommand cmd = new SqlCommand("UPDATE Department SET DepartmentName = @name WHERE DepartmentID = @id", con); cmd.Parameters.AddWithValue("@name", txtDepartmentName.Text); cmd.Parameters.AddWithValue("@id", ViewState["id"]); con.Open(); int rowCount = cmd.ExecuteNonQuery(); if (rowCount > 0) { SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Department", con); DataTable dt = new DataTable(); da.Fill(dt); GrdViewDepartment.DataSource = dt; GrdViewDepartment.DataBind(); } } ClearControls(); } Response.RedirectToRoute("DepartmentDetails"); }
private void ViewAllDepartment() { if (GrdViewDepartment.Rows.Count < 1) { GrdViewDepartment.EmptyDataText = "There is no Department to view."; } using (SqlConnection con = new SqlConnection(CS)) { SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Department", con); con.Open(); DataTable dt = new DataTable(); da.Fill(dt); GrdViewDepartment.DataSource = dt; GrdViewDepartment.DataBind(); } }