This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Programming › .Net/C # › [DBHelp] uses reflection technology to encapsulate objects into Lists
View: 41320|Reply: 12

[ASP.NET] [DBHelp] uses reflection technology to encapsulate objects into Lists

[Copy link]
Posted on 4/20/2015 2:52:57 PM | | | |
This post was last edited by Delver_Si on 2015-4-21 16:09

What type of entity is given to me, and what type of entity collection is returned

  1. //得到一个list<T>
  2.         public static List<T> getList<T>(string strSql)
  3.         {
  4.             List<T> list = new List<T>();

  6.             SqlConnection sqlConn = new SqlConnection(strConn);
  7.             SqlCommand sqlComm = new SqlCommand(strSql, sqlConn);
  8.             sqlConn.Open();
  9.             SqlDataReader sqlDR = sqlComm.ExecuteReader();

  11.             while (sqlDR.Read())
  12.             {
  13.                 //得到T的类型
  14.                 Type t = typeof(T); ;

  16.                 //查看类中的属性：
  17.                 PropertyInfo[] pis = t.GetProperties();
  18.                 // 用反射生成对象
  19.                 T model = Activator.CreateInstance<T>();
  20.                 foreach (PropertyInfo pi in pis)
  21.                 {
  22.                     if (pi!= null)
  23.                     {
  24.                         //取得特定字段并赋值
  25.                         pi.SetValue(model, sqlDR[pi.Name].ToString(), null);
  26.                     }
  27.                     }

  29.                 list.Add(model);
  30.             }
  31.             sqlConn.Close();

  33.             return list;

  35.         }
Copy code

The whole DBHelp.cs
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using System.Data;
  6. using System.Data.SqlClient;
  7. using System.Reflection;

  9. namespace ManualAssign
  10. {
  11.     public class DBHelp
  12.     {
  13.         //数据库连接字符串
  14.         private static string strConn = "server=.;database=ManualAssign;integrated security=true";

  16.         //得到一个DataTable
  17.         public static DataTable getTable(string strSql)
  18.         {
  19.             SqlConnection sqlConn = new SqlConnection(strConn);
  20.             SqlDataAdapter sqlDA = new SqlDataAdapter(strSql,sqlConn);
  21.             DataTable dt = new DataTable();
  22.             sqlDA.Fill(dt);
  23.             return dt;
  24.         }

  26.         //增删改
  27.         public static void upDateDB(string strSql)
  28.         {
  29.             SqlConnection sqlConn = new SqlConnection(strConn);
  30.             SqlCommand sqlComm = new SqlCommand(strSql, sqlConn);
  31.             sqlConn.Open();
  32.             sqlComm.ExecuteNonQuery();
  33.             sqlConn.Close();
  34.         }


  37.         //得到一个list<T>
  38.         public static List<T> getList<T>(string strSql)
  39.         {
  40.             List<T> list = new List<T>();

  42.             SqlConnection sqlConn = new SqlConnection(strConn);
  43.             SqlCommand sqlComm = new SqlCommand(strSql, sqlConn);
  44.             sqlConn.Open();
  45.             SqlDataReader sqlDR = sqlComm.ExecuteReader();

  47.             while (sqlDR.Read())
  48.             {
  49.                 //得到T的类型
  50.                 Type t = typeof(T); ;

  52.                 //查看类中的属性：
  53.                 PropertyInfo[] pis = t.GetProperties();
  54.                 // 用反射生成对象
  55.                 T model = Activator.CreateInstance<T>();
  56.                 foreach (PropertyInfo pi in pis)
  57.                 {
  58.                     if (pi!= null)
  59.                     {
  60.                         //取得特定字段并赋值
  61.                         pi.SetValue(model, sqlDR[pi.Name].ToString(), null);
  62.                     }
  63.                     }

  65.                 list.Add(model);
  66.             }
  67.             sqlConn.Close();

  69.             return list;

  71.         }

  73.     }
  74. }
Copy code



Score

Number of participants1MB+1 contribute+1 Collapse reason
Little scum + 1 + 1 Very powerful!

See all ratings





Previous:Ruijie school network is unstable and often drops, I have a solution!
Next:Japan develops ultra-high-speed cameras

Related Posts
 Landlord| Posted on 4/20/2015 3:56:40 PM |
Xiao Zhazha Posted on 2015-4-20 15:36
I'll try this at night, it would be better if there was an example

There are examples
 Landlord| Posted on 4/20/2015 3:56:38 PM |
Xiao Zhazha Posted on 2015-4-20 15:36
I'll try this at night, it would be better if there was an example

There are examples
Posted on 8/1/2015 3:57:53 PM |
Attached is a DBHelp transaction execution code

Posted on 4/20/2015 3:36:14 PM |
I'll try this at night, it would be better if there was an example
 Landlord| Posted on 4/21/2015 4:10:01 PM |
updated
Posted on 4/21/2015 4:50:50 PM |
Can you upload an example of a compressed package?
 Landlord| Posted on 4/21/2015 9:06:48 PM |
source

ManualAssign.rar

180.66 KB, Download times: 6, Download credits: -1 prestige, -1 contribution
 Landlord| Posted on 4/21/2015 9:07:00 PM |
Xiao Zhazha Posted on 2015-4-21 16:50
Can you upload an example of a compressed package?

sent
Posted on 4/22/2015 8:31:39 AM |
Delver_Si Posted on 2015-4-21 21:07
sent

Okay, I'll take a look
Posted on 4/22/2015 10:51:19 AM |
Delver_Si Posted on 2015-4-21 21:06
source

Take it away, and say thank you
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com