using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Text;
using System.Data;



namespace Restauracja
{
    public partial class Dodaj : System.Web.UI.Page
    {

        protected void Page_Load(object sender, EventArgs e)
        {

            //if (!Page.User.IsInRole("administratorzy")) {Visible = false;}

            m_delete.Attributes.Add("onclick", "return(confirm('Czy na pewno chcesz usunąć?'));");
            m_update.Attributes.Add("onclick", "return(alert('Zaktualizowano.'));");
            m_delete.Attributes.Add("onclick", "return(alert('Usunięto.'));");

            String strSearch = this.m_wpisz_id.Text;
            this.m_wpisz_id.Text = null;
            if (strSearch == null)
            {
                if (IsPostBack) return;
            }

            string cs = ConfigurationManager.AppSettings["DBConnectionString"];


            using (SqlConnection con = new SqlConnection(cs))
            {
                StringBuilder sb1 = new StringBuilder();
                sb1.Append("select ID_adresu,Ulica,Numer_domu,Numer_mieszkania,Kod_pocztowy,Miejscowosc from [2PUrban].[dbo].[Adresy] WHERE ID_adresu=@ID");
                SqlCommand cmd = new SqlCommand(sb1.ToString(), con);
                cmd.CommandType = CommandType.Text;


                cmd.Parameters.Add(new SqlParameter("@ID", strSearch));

                con.Open();
                SqlDataReader rdr = cmd.ExecuteReader();
                while (rdr.Read())
                {

                    m_id.Text = rdr["ID_adresu"].ToString().Trim();
                    m_ulica.Text = rdr["Ulica"].ToString().Trim();
                    m_numer_domu.Text = rdr["Numer_domu"].ToString().Trim();
                    m__numer_mieszkania.Text = rdr["Numer_mieszkania"].ToString().Trim();
                    m_kod_pocztowy.Text = rdr["Kod_pocztowy"].ToString().Trim();
                    m_miasto.Text = rdr["Miejscowosc"].ToString().Trim();

                    break;
                }
                con.Close();

        }
}

        protected void m_update_Click(object sender, EventArgs e)
        {
            string cs = ConfigurationManager.AppSettings["DBConnectionString"];
            using (SqlConnection con = new SqlConnection(cs))
            {

                SqlCommand cmd = new SqlCommand("2PUrban.dbo.sp_aktualizuj_adres", con);
                cmd.CommandType = CommandType.StoredProcedure;

                SqlParameter parameter1 = new SqlParameter("@Id", m_id.Text);
                cmd.Parameters.Add(parameter1);
                SqlParameter parameter2 = new SqlParameter("@Ulica", m_ulica.Text);
                cmd.Parameters.Add(parameter2);
                SqlParameter parameter3 = new SqlParameter("@Numer_domu", m_numer_domu.Text);
                cmd.Parameters.Add(parameter3);
                SqlParameter parameter4 = new SqlParameter("@Numer_mieszkania", m__numer_mieszkania.Text);
                cmd.Parameters.Add(parameter4);
                SqlParameter parameter5 = new SqlParameter("@Kod_pocztowy", m_kod_pocztowy.Text);
                cmd.Parameters.Add(parameter5);
                SqlParameter parameter6 = new SqlParameter("@Miejscowosc", m_miasto.Text);
                cmd.Parameters.Add(parameter6);

                con.Open();
                cmd.ExecuteNonQuery();
            }

            Response.Redirect("Edytuj_adres.aspx");

        }

        protected void m_cancel_Click(object sender, EventArgs e)
        {
            Response.Redirect("Edytuj_adres.aspx");
        }

        protected void m_delete_Click(object sender, EventArgs e)
        {

            string cs = ConfigurationManager.AppSettings["DBConnectionString"];
            using (SqlConnection con = new SqlConnection(cs))
            {

                SqlCommand cmd = new SqlCommand("2PUrban.dbo.sp_sp_usun_adres", con);
                cmd.CommandType = CommandType.StoredProcedure;

                SqlParameter parameter1 = new SqlParameter("@Id", m_id.Text);
                cmd.Parameters.Add(parameter1);
                SqlParameter parameter2 = new SqlParameter("@Ulica", m_ulica.Text);
                cmd.Parameters.Add(parameter2);
                SqlParameter parameter3 = new SqlParameter("@Numer_domu", m_numer_domu.Text);
                cmd.Parameters.Add(parameter3);
                SqlParameter parameter4 = new SqlParameter("@Numer_mieszkania", m__numer_mieszkania.Text);
                cmd.Parameters.Add(parameter4);
                SqlParameter parameter5 = new SqlParameter("@Kod_pocztowy", m_kod_pocztowy.Text);
                cmd.Parameters.Add(parameter5);
                SqlParameter parameter6 = new SqlParameter("@Miejscowosc", m_miasto.Text);
                cmd.Parameters.Add(parameter6);

                con.Open();
                cmd.ExecuteNonQuery();
            }

            Response.Redirect("Edytuj_adres.aspx");
        }

        protected void m_wyslij_id_Click(object sender, EventArgs s)
        { }
    }

}


__________________________

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Edytuj_adres.aspx.cs" Inherits="Restauracja.Dodaj" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <center>
    <hgroup class="title">
        <h2>- edycja adresów -</h2>
    </hgroup>

    <asp:TextBox ID="m_wpisz_id" runat="server">    </asp:TextBox>
    <asp:Button ID="m_wyslij_id" runat="server" Text="Szukaj">  </asp:Button>
    <asp:Repeater ID="m_rptID" runat="server"/>
        <br />

     Numer ID: <asp:Label ID="m_id" runat="server" Text=""></asp:Label>
    <br />
    Ulica: <asp:TextBox ID="m_ulica" runat="server"></asp:TextBox>
     <br />
    Numer domu: <asp:TextBox ID="m_numer_domu" runat="server"></asp:TextBox>
     <br />
    Numer mieszkania: <asp:TextBox ID="m__numer_mieszkania" runat="server"></asp:TextBox>
     <br />
    Kod pocztowy: <asp:TextBox ID="m_kod_pocztowy" runat="server"></asp:TextBox>
     <br />
     Miejscowość: <asp:TextBox ID="m_miasto" runat="server"></asp:TextBox>
     <br />


    <asp:Button ID="m_update" runat="server" Text="Aktualizuj" onclick="m_update_Click" />
    <br />
    <asp:Button ID="m_cancel" runat="server" Text="Anuluj" onclick="m_cancel_Click"/>
    <br />
    <asp:Button ID="m_delete" runat="server" Text="Usuń" onclick="m_delete_Click"/>

    </center>
</asp:Content>

USE [2PUrban]
GO
/****** Object:  StoredProcedure [dbo].[sp_sp_usun_adres]    Script Date: 2017-01-16 20:20:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE Procedure [dbo].[sp_sp_usun_adres](@Ulica char(30),@Numer_domu char(4),@Numer_mieszkania char(5),@Kod_pocztowy char(6),@Miejscowosc char(20),@ID int)

as

DELETE
FROM [dbo].[Adresy]

 WHERE [ID_adresu] = @id