.aspx.cs

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;

public partial class Lockers_stue_sektion_A : System.Web.UI.Page
{
    string connectionString = @"Data Source=iXXXX\sqlexpress;Integrated Security=true;Initial Catalog=Lockers";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            PopulatedGridView();
        }
    }

    void PopulatedGridView()
    {
        DataTable dtbl = new DataTable();
        using (SqlConnection sqlCon = new SqlConnection(connectionString))
        {
            sqlCon.Open();
            SqlDataAdapter sqlDa = new SqlDataAdapter("SELECT * FROM Lockers_stue_sektion_A", sqlCon);

            sqlDa.Fill(dtbl);
        }
        if (dtbl.Rows.Count > 0)
        {
            gvLockers.DataSource = dtbl;
            gvLockers.DataBind();
        }
        else
        {
            dtbl.Rows.Add(dtbl.NewRow());
            gvLockers.DataSource = dtbl;
            gvLockers.DataBind();
            gvLockers.Rows[0].Cells.Clear();
            gvLockers.Rows[0].Cells.Add(new TableCell());
            gvLockers.Rows[0].Cells[0].ColumnSpan = dtbl.Columns.Count;
            gvLockers.Rows[0].Cells[0].Text = "Ingen Data ..!";
            gvLockers.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
        }
    }
    protected void gvLockers_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        try
        {
            if (e.CommandName.Equals("AddNew"))
            {
                using (SqlConnection sqlCon = new SqlConnection(connectionString))
                {
                    sqlCon.Open();
                    string query = "INSERT INTO Lockers_stue_sektion_A (Locker,Navn,Efternavn,Klasse,Laaskode) VALUES (@Locker,@Navn,@Efternavn,@Klasse,@Laaskode) ";
                    SqlCommand sqlCmd = new SqlCommand(query, sqlCon);
                    sqlCmd.Parameters.AddWithValue("@Locker", (gvLockers.FooterRow.FindControl("txtLockerFooter") as TextBox).Text.Trim());
                    sqlCmd.Parameters.AddWithValue("@Navn", (gvLockers.FooterRow.FindControl("txtNavnFooter") as TextBox).Text.Trim());
                    sqlCmd.Parameters.AddWithValue("@Efternavn", (gvLockers.FooterRow.FindControl("txtEfternavnFooter") as TextBox).Text.Trim());
                    sqlCmd.Parameters.AddWithValue("@Klasse", (gvLockers.FooterRow.FindControl("txtKlasseFooter") as TextBox).Text.Trim());
                    sqlCmd.Parameters.AddWithValue("@Laaskode", (gvLockers.FooterRow.FindControl("txtLaaskodeFooter") as TextBox).Text.Trim());
                    sqlCmd.ExecuteNonQuery();
                    PopulatedGridView();
                    lblSuccesMessage.Text = "Nyt Skab er tilføjet";
                    lblErrorMessage.Text = "";
                }
            }
        }
        catch (Exception ex)
        {
            lblSuccesMessage.Text = "";
            lblErrorMessage.Text = ex.Message;
        }
    }
    protected void gvLockers_RowEditing(object sender, GridViewEditEventArgs e)
    {
        gvLockers.EditIndex = e.NewEditIndex;
        PopulatedGridView();

    }
    protected void gvLockers_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        gvLockers.EditIndex = -1;
        PopulatedGridView();
    }

    protected void gvLockers_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        try
        {
            using (SqlConnection sqlCon = new SqlConnection(connectionString))
            {
                sqlCon.Open();
                string query = "UPDATE Lockers_stue_sektion_A SET Locker=@Locker,Navn=@Navn,Efternavn=@Efternavn,Klasse=@Klasse,Laaskode=@Laaskode WHERE LockersID = @id";
                SqlCommand sqlCmd = new SqlCommand(query, sqlCon);
                sqlCmd.Parameters.AddWithValue("@Locker", (gvLockers.Rows[e.RowIndex].FindControl("txtLocker") as TextBox).Text.Trim());
                sqlCmd.Parameters.AddWithValue("@Navn", (gvLockers.Rows[e.RowIndex].FindControl("txtNavn") as TextBox).Text.Trim());
                sqlCmd.Parameters.AddWithValue("@Efternavn", (gvLockers.Rows[e.RowIndex].FindControl("txtEfternavn") as TextBox).Text.Trim());
                sqlCmd.Parameters.AddWithValue("@Klasse", (gvLockers.Rows[e.RowIndex].FindControl("txtKlasse") as TextBox).Text.Trim());
                sqlCmd.Parameters.AddWithValue("@Laaskode", (gvLockers.Rows[e.RowIndex].FindControl("txtLaaskode") as TextBox).Text.Trim());
                sqlCmd.Parameters.AddWithValue("@id", Convert.ToInt32(gvLockers.DataKeys[e.RowIndex].Value.ToString()));
                sqlCmd.ExecuteNonQuery();
                gvLockers.EditIndex = -1;
                PopulatedGridView();
                lblSuccesMessage.Text = "Skab er opdateret";
                lblErrorMessage.Text = "";
            }
        }
        catch (Exception ex)
        {
            lblSuccesMessage.Text = "";
            lblErrorMessage.Text = ex.Message;
        }
    }

    protected void gvLockers_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        try
        {
            using (SqlConnection sqlCon = new SqlConnection(connectionString))
            {
                sqlCon.Open();
                string query = "DELETE FROM Lockers_stue_sektion_A WHERE LockersID = @id";
                SqlCommand sqlCmd = new SqlCommand(query, sqlCon);
                sqlCmd.Parameters.AddWithValue("@id", Convert.ToInt32(gvLockers.DataKeys[e.RowIndex].Value.ToString()));
                sqlCmd.ExecuteNonQuery();
                PopulatedGridView();
                lblSuccesMessage.Text = "Skab er Slettet";
                lblErrorMessage.Text = "";
            }
        }
        catch (Exception ex)
        {
            lblSuccesMessage.Text = "";
            lblErrorMessage.Text = ex.Message;
        }
    }
}