ASP.net forms - connect to a ms sql db and use CRUD operations.

Create a table called customer to store customer information.


USE [cypad]
GO

/****** Object:  Table [dbo].[customer]    Script Date: 20-Jan-20 3:03:53 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[customer](
[customerid] [numeric](18, 0) NULL,
[name] [nvarchar](50) NULL,
[country] [nvarchar](50) NULL
) ON [PRIMARY]
GO

insert few records to it. 

USE [cypad]

GO

INSERT INTO [dbo].[customer]

           ([customerid]

           ,[name]

           ,[country])

     VALUES

           (<customerid, numeric(18,0),>

           ,<name, nvarchar(50),>

           ,<country, nvarchar(50),>)

GO

add a asp.net web form 

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace cypad

{

    public partial class customerList : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

            try

            {

                if (!this.IsPostBack)

                {

                    this.loadCustomerList();

                }

            }catch (Exception ex)

            {

                Console.Write(ex.Message);

            }

        }

        private void loadCustomerList()

        {

            try

            {

                string consting = ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString;

                string query = "SELECT * FROM customer";

                using (SqlConnection con = new SqlConnection(consting))

                {

                    using (SqlDataAdapter sda = new SqlDataAdapter(query, con))

                    {

                        using (DataTable dt = new DataTable())

                        {

                            sda.Fill(dt);

                            gvCustomerList.DataSource = dt;

                            gvCustomerList.DataBind();

                        }

                    }

                }

            }

            catch

            {

                throw;

            }

        }

    }

}

Conections string should be stored in web.config file 

  <connectionStrings>

    <add name ="MyConnection"

    connectionString ="Data Source=DENISP\SQLEXPRESS;Initial Catalog=cypad;Integrated Security=true"/>

  </connectionStrings>

add the newly created form to site master.  

use the page notation to add the created form to the master page 

<%@ Page Title="Customer List" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" 

    CodeBehind="customerList.aspx.cs" Inherits="cypad.customerList" %>

<asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server">

    <asp:GridView ID="gvCustomerList" runat="server" AutoGenerateColumns="False">

        <Columns>

            <asp:BoundField DataField="customerid" HeaderText="Customer ID" />

            <asp:BoundField DataField="name" HeaderText="Customer Name" />

            <asp:BoundField DataField="country" HeaderText="Country" />

        </Columns>

    </asp:GridView>

</asp:Content>

        private void loadCustomerList()

        {

            try

            {

                DBconnections DBconnet = new DBconnections();

                string consting = DBconnet.getConnectionString().consting;

                string query = string.Concat( "insert into customer (name,country) values('{0}',{1})",txt;

                using (SqlConnection con = new SqlConnection(consting))

                {

                    SqlDataAdapter adapter = new SqlDataAdapter();

                    sql = 

                        connection.Open();

                        adapter.InsertCommand = new SqlCommand(sql, connection);

                        adapter.InsertCommand.ExecuteNonQuery();

                    }

                    catch (Exception ex)

                    {

                        MessageBox.Show(ex.ToString());

                    }

                }

            }

            catch

            {

                throw;

            }

        }