C#简单控制台循环日程管理程序

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

namespace rch
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("我的日程管理");
            Console.WriteLine("===================================================================");

            Console.WriteLine("1 查看日程");
            Console.WriteLine("2 录入日程");
            Console.WriteLine("3 删除日程");
            Console.WriteLine("===================================================================");
            Console.WriteLine("按序号选择功能，0号键退出");
            Console.WriteLine("===================================================================");
            while (true)
            {
                int index = int.Parse(Console.ReadLine());
                if (index==1)
                {
					getrch();
                }
                if (index == 2)
                {
					addrch();
                }
                if (index ==3)
                {
					delrch();
                }
                if (index ==0)
                {
                    Console.WriteLine("退出系统");
                }
                
            }
            Console.ReadKey();
        }
		
		private static void getrch()
		{
			string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Environment.CurrentDirectory + @"/rch.mdb";
            OleDbConnection conn = new OleDbConnection(connstr);
            conn.Open();
            string sql = "select * from rch";
            OleDbCommand command = new OleDbCommand(sql, conn);
            OleDbDataReader reader = command.ExecuteReader();
            try
            {
                while (reader.Read())
                {
                    for (int i = 0; i < reader.FieldCount;i++ )
                    {
                        Console.Write("{0} ", reader[i]);
                    }
                    Console.WriteLine();                    
                }
            }
            finally
            {
                reader.Close();
                conn.Close();
            }
		}
		
		private static void addrch()
		{
			int nResult=0;
			string lines="";
			string rchname="",rchtime="",address="",content="";
                        string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Environment.CurrentDirectory + @"/rch.mdb";
            OleDbConnection conn = new OleDbConnection(connstr);
            conn.Open();
			Console.Write("请输入日程：");
			lines=Console.ReadLine();
			
			try
            {
			string[] param=lines.Split(',');
			rchname=param[0];
			rchtime = param[1];
			address = param[2];
			content = param[3];

			string sql = "insert into rch (rchname, rchtime, address, content) values ('" + rchname + 

"','" + rchtime + "','"+  address + "','"+ content + "')";
			
            OleDbCommand command = new OleDbCommand(sql, conn);
            nResult = command.ExecuteNonQuery();
            

            }
			catch(System.Exception e)
            {
                Console.WriteLine(e.ToString());
            }
            finally
            {
                conn.Close();
            }
		}
		
		private static void delrch()
		{
			int nResult=0;
			string lines="";
			int id=0;
            string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Environment.CurrentDirectory + @"/rch.mdb";
            OleDbConnection conn = new OleDbConnection(connstr);
            conn.Open();
			Console.Write("请输入要删除日程的ID：");
			lines=Console.ReadLine();
			
			try
            {
			id = Convert.ToInt32(lines);

			string sql = "delete from rch where ID=" + id;
			
            OleDbCommand command = new OleDbCommand(sql, conn);
            nResult = command.ExecuteNonQuery();
            

            }
			catch(System.Exception e)
            {
                Console.WriteLine(e.ToString());
            }
            finally
            {
                conn.Close();
            }
		}
		
    }
}

数据库使用Access，见此；

https://blog.csdn.net/bcbobo21cn/article/details/109234496

构建以后如下；

运行情况；

    现在一个简单版本控制台循环的日程管理程序可用；可查看，添加，删除日程；