我用C#编写winform代码，数据库是SQL Server，登录之后查看个人信息代码怎么编写？

/// 

        /// 登录过程
        /// 

        /// 用户名
        /// 密码
        void Login(string username,string userpwd)
        {
            OleDbConnection con=null;
            try
            {
                con = new OleDbConnection("数据库连接字符串");
                con.Open();
            }
            catch { MessageBox.Show("数据库连接失败"); return; }
            string sql = "select id from table where username='"+username+"' and userpwd='"+userpwd+"'";
            OleDbCommand com = new OleDbCommand(sql, con);
            OleDbDataReader rea = com.ExecuteReader();
            if (rea.Read())
            {
                //string uid=rea.GetValue(0).ToString();//得到用户ID
                //登录成功了,传递一个用户id到主窗体
            }
            else
                MessageBox.Show("用户名或密码错误","登录失败");
            rea.Close();
            com.Dispose();
            con.Close();
        }
        /// 

        /// 个人信息获取
        /// 

        /// 用户ID
        void ShowMyInfo(string uid)
        {
            OleDbConnection con = null;
            try
            {
                con = new OleDbConnection("数据库连接字符串");
                con.Open();
            }
            catch { MessageBox.Show("数据库连接失败"); return; }
            string sql = "select * from table where id='"+uid+"'";
            OleDbCommand com = new OleDbCommand(sql, con);
            OleDbDataReader rea = com.ExecuteReader();
            if (rea.Read())
            {
                //string myName=rea.GetValue(0).ToString();//根据表的结构 取出相应的字段信息
            }
            rea.Close();
            com.Dispose();
            con.Close();
        }

登陆后用户ID件或者用户名保存session，点个人信息根据session信息查找数据库 取得数据库的详细信息