How to update data on C# console application

See more:

C#

C#4.0

actually it is reterive data on console application. it is work correctly but i want to update data

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace project
{
    class data
    {
        static void getdata()
        {

            SqlConnection con = new SqlConnection("Data Source=SANKALPA-PC;Initial Catalog=libray;Integrated Security=True");
            con.Open();
            DataSet ds = new DataSet();
            try
            {
                string sql = "select * from book1";
                SqlCommand cmd = new SqlCommand(sql, con);
                SqlDataReader dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    printrow(Convert.ToString(dr["bookid"]), Convert.ToString(dr["title"]), Convert.ToString(dr["author"]), Convert.ToString(dr["publisher"]), Convert.ToString(dr["price"]));

                }
             
                con.Close();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);

            }
        }
    

        static void printline()
        {
            Console.WriteLine(new string('-', 80));
        }
        static void printrow(string bookid, string title, string author, string publisher, string price)
        {
            Console.WriteLine(string.Format("|{0}|{1}|{2}|{3}|{4}|",AlignCenter(bookid,17),AlignCenter(title,17),AlignCenter(author,17),AlignCenter(publisher,17),AlignCenter(price,17)));
        }
        static string AlignCenter(string text, int width)
        {

            if (string.IsNullOrEmpty(text))
            {
                return new string(' ', width);

            }

            else
            {

                //return text.PadRight(width - (width – text.Length) / 2).PadLeft(width);
                return text.PadRight(width - (width - text.Length) / 2).PadLeft(width);

            }

        }
        
          
   

        static void Main(string [] args)
        {
            printline();
            printrow("bookid","title","author","publisher","price");
            printline();
            getdata();
            Console.ReadKey();
        }

        
    }
}

actually it is reterive data on console application. it is work correctly but i want to update data ,please help me.