How to use store procedure in asp.net with example

Default2.aspx=>

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
<asp:Label ID="Label1" runat="server" Text="ID"></asp:Label>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br /><br />
<asp:Label ID="Label2" runat="server" Text="Password"></asp:Label>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><br /><br />
<asp:Label ID="Label3" runat="server" Text="Confirm Password"></asp:Label>
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox><br /><br />
<asp:Label ID="Label4" runat="server" Text="Email ID"></asp:Label>
<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox><br /><br /><br />
<asp:Label ID="l1" runat="server"></asp:Label>
<asp:Button ID="Button1" runat="server" Text="Submit Record" OnClick="Button1_Click" />
<asp:Button ID="show" runat="server" Text="Show" onclick="show_Click" /><br />
<div id="d1" runat="server">
<asp:GridView ID="DetailsView1" runat="server" Height="16px">
</asp:GridView></div>
</asp:Content>
 Default2.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.SqlClient;
using System.Data;
using System.Configuration;
public partial class Default2 : System.Web.UI.Page
{string s = ConfigurationManager.ConnectionStrings["conn"].ToString();
SqlConnection con;
//DataSet ds = new DataSet();
////Here we declare the parameter which we have to use in our application
SqlCommand cmd = new SqlCommand();
//SqlParameter sp1 = new SqlParameter();
//SqlParameter sp2 = new SqlParameter();
//SqlParameter sp3 = new SqlParameter();
//SqlParameter sp4 = new SqlParameter();
protected void Page_Load(object sender, EventArgs e)
{
d1.Visible = false;if (!IsPostBack)
{
Bindlogin();
}
 }private void Bindlogin()
{
con =new SqlConnection(s);
con.Open();SqlCommand cmd = new SqlCommand("select * from login", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();if (ds.Tables[0].Rows.Count > 0)
{
DetailsView1.DataSource = ds;
DetailsView1.DataBind();
}else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
DetailsView1.DataSource = ds;
DetailsView1.DataBind();int columncount = DetailsView1.Rows[0].Cells.Count;
DetailsView1.Rows[0].Cells.Clear();
DetailsView1.Rows[0].Cells.Add(
new TableCell());
DetailsView1.Rows[0].Cells[0].ColumnSpan = columncount;
DetailsView1.Rows[0].Cells[0].Text = 
"No Records Found";
}
}protected void Button1_Click(object sender, EventArgs e)
{
con =new SqlConnection(s);
cmd =new SqlCommand("submitrecord", con);
cmd.CommandType =CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = TextBox1.Text;
cmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = TextBox2.Text;
cmd.Parameters.Add("@ConfirmPassword", SqlDbType.VarChar).Value = TextBox3.Text;
cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = TextBox4.Text;
con.Open();
 cmd.ExecuteNonQuery();
l1.Text = 
"Insert Successfully";
con.Close();
 }protected void show_Click(object sender, EventArgs e)
{
d1.Visible = true;
}
}