ADO.NET之查询结果转换如性别

最新推荐文章于 2018-10-14 23:13:16 发布

songyi160

最新推荐文章于 2018-10-14 23:13:16 发布

阅读量628

点赞数

CC 4.0 BY-SA版权

分类专栏： ADO.NET 文章标签： ado.net

本文链接：https://blog.youkuaiyun.com/songyi160/article/details/51707413

ADO.NET 专栏收录该内容

10 篇文章

订阅专栏

本文介绍如何使用C#进行数据库查询，并将查询结果转换为自定义对象类实例的过程。通过具体示例展示了如何定义对象类以及如何从查询结果中读取数据并填充到这些对象中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

(1)创建对象类

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace _查询结果转换
{
   public class Student
    {
        //TSId, TSName, TSGender, TSAddress, TSAge, 
        private int _tSId;

        public int TSId
        {
            get { return _tSId; }
            set { _tSId = value; }
        }
       private string _tSName;

       public string TSName
       {
           get { return _tSName; }
           set { _tSName = value; }
       }
       private char _tSGender; //不声明为boolean，声明为char类型

       public char TSGender
       {
           get { return _tSGender; }
           set { _tSGender = value; }
       }
       private string _tSAddress;

       public string TSAddress
       {
           get { return _tSAddress; }
           set { _tSAddress = value; }
       }
       private int _tSAge;

       public int TSAge
       {
           get { return _tSAge; }
           set { _tSAge = value; }
       }
    }
}

(2)查询并转换

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace _查询结果转换
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            LoadStudent();
        }

        private void LoadStudent()
        {

            List<Student> list = new List<Student>();
            string sql = "select tsid,tsname,tsgender,tsaddress,tsage from student";
            using (SqlDataReader reader=SqlHelper.ExecuteReader(sql))
            {
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        Student stu = new Student();
                        stu.TSAddress = reader["TSAddress"].ToString();
                        stu.TSAge = Convert.ToInt32(reader["TSAge"]);
                        stu.TSId = Convert.ToInt32(reader["TSId"]);
                        stu.TSName = reader["TSName"].ToString();
                        stu.TSGender = Convert.ToBoolean(reader["TSGender"])?'男':'女'; //查询结果转换
                        list.Add(stu);
                    }
                }
            }
            dgvStudent.AutoGenerateColumns = false;
            dgvStudent.DataSource = list;
            dgvStudent.SelectedRows[0].Selected = false;
        }
    }
}