gridcontrol绑定ibatis.net数据源

首先我们要清楚iBATIS.net的结构，大致是这么几个文件SqlMap.config，provider.config，和我们自身的映射xml文件。SqlMap.config和provider.config需要依据自身实际情况来弄，具体参见iBATIS教程。

我的xml映射文件如下：<?xml version="1.0" encoding="utf-8" ?> <sqlMap namespace="TestTableEditor.Infrastructure.Repositories.Maps" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <alias> <typeAlias alias="User" type="TestTableEditor.Domain.Users.User,TestTableEditor.Domain" /> </alias> <resultMaps> <resultMap id="UserResult" class="User"> <result property="Key" column="USE_KEY" type="int" dbType="NUMBER"/> <result property="Id" column="USE_ID" type="string" dbType="VARCHAR2(8)"/> <result property="Name" column="USE_NAME" type="string" dbType="VARCHAR2(16)"/> <result property="Password" column="USE_PASSWORD" type="string" dbType="VARCHAR2(16)"/> <result property="Admin" column="USE_ADMIN" type="int" dbType="NUMBER(1)"/> <result property="Dept" column="USE_DEPT" type="string" dbType="VARCHAR2(16)"/> <result property="Job" column="USE_JOB" type="string" dbType="VARCHAR2(16)"/> <result property="Tel" column="USE_TEL" type="string" dbType="VARCHAR2(16)"/> <result property="Email" column="USE_EMAIL" type="string" dbType="VARCHAR2(16)"/> </resultMap> </resultMaps> <statements> <select id="SelectAllUser" resultMap="UserResult"> SELECT USE_KEY,USE_ID,USE_NAME,USE_PASSWORD,USE_ADMIN,USE_DEPT,USE_JOB,USE_TEL,USE_EMAIL FROM USERS <!--<dynamic prepend="WHERE"> <isParameterPresent> USER_KEY = #value# </isParameterPresent> </dynamic>--> </select> <select id="GetUserByName" parameterClass="string" resultMap="UserResult"> SELECT USE_KEY,USE_ID,USE_PASSWORD,USE_ADMIN,USE_DEPT,USE_JOB,USE_TEL,USE_EMAIL FROM USERS WHERE USE_NAME = #Name# </select> <insert id="InsertUser" parameterClass="User"> INSERT INTO USERS (USE_KEY,USE_ID,USE_NAME,USE_PASSWORD,USE_ADMIN,USE_DEPT,USE_JOB,USE_TEL,USE_EMAIL) VALUES(#Key#,#Id#,#Name#,#Password#,#Admin#,#Dept#,#Job#，#Tel#，#Email#) </insert> <update id="UpdateUser" parameterClass="User"> UPDATE USERS SET USE_ID=#Id#,USE_NAME=#Name#,USE_PASSWORD=#Password#,USE_ADMIN=#Admin#,USE_DEPT=#Dept#,USE_JOB=#Job#,USE_TEL=#Tel#,USE_EMAIL=#Email# WHERE USE_KEY = #Key# </update> <delete id="DeleteUser" parameterClass="string"> DELETE FROM USERS WHERE USE_NAME = #Name# </delete> </statements> </sqlMap>

我的user.cs文件如下：using System; using System.Collections.Generic; using System.Text; using TestTableEditor.Infrastructure.DomainBase; using TestTableEditor.Infrastructure.Helpers; namespace TestTableEditor.Domain.Users { public class User: EntityBase,IAggregateRoot { private string _id; private string _name; private string _password; private int _admin; private string _dept; private string _job; private string _tel; private string _email; //private string _realName; //private string _department; public User() :base(null) { } public User(object key, string id, string name, string password, int admin, string dept, string job, string tel, string email) :base(key) { _id = id; _name = name; _password = password; _admin = admin; _dept = dept; _job = job; _tel = tel; _email = email; //_realName = realName; //_department = department; } public User(string id, string name, string password, int admin, string dept, string job, string tel, string email) : this(null, id,name, password, admin, dept,job,tel,email) { } public string Id { get { return _id; } set { StringHelper.IsNotNullOrEmpty(value); StringHelper.LengthIsLessThan(value, 50); _id = value; } } public string Name { get { return _name; } set { StringHelper.IsNotNullOrEmpty(value); StringHelper.LengthIsLessThan(value, 50); _name = value; } } public string Password { get { return _password; } set { StringHelper.IsNotNullOrEmpty(value); StringHelper.LengthIsLessThan(value, 50); _password = value; } } public int Admin { get { return _admin; } set { //StringHelper.IsNotNullOrEmpty(value); //StringHelper.LengthIsLessThan(value, 50); _admin = value; } } public string Dept { get { return _dept; } set { StringHelper.IsNotNullOrEmpty(value); StringHelper.LengthIsLessThan(value, 50); _dept = value; } } public string Job { get { return _job; } set { StringHelper.IsNotNullOrEmpty(value); StringHelper.LengthIsLessThan(value, 50); _job = value; } } public string Tel { get { return _tel; } set { StringHelper.IsNotNullOrEmpty(value); StringHelper.LengthIsLessThan(value, 50); _tel = value; } } public string Email { get { return _email; } set { StringHelper.IsNotNullOrEmpty(value); StringHelper.LengthIsLessThan(value, 50); _email = value; } } protected override void Validate() { return; } protected override BrokenRuleMessages GetBrokenRuleMessages() { return new UserRuleMessages(); } } }

截下来是业务层的gridcontrol的连接: public void gridControl1_Bind() { UserService us = new UserService(); IList<User> list = us.GetAllUser(); gridControl1.DataSource = list; } private void gridControl1_Load(object sender, EventArgs e) { gridControl1_Bind(); }

然后要注意的就是我们的gridcontrol的FieldName的写法// // gridControl1 // this.gridControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.gridControl1.Location = new System.Drawing.Point(2, 23); this.gridControl1.MainView = this.gridView1; this.gridControl1.Name = "gridControl1"; this.gridControl1.Size = new System.Drawing.Size(760, 356); this.gridControl1.TabIndex = 0; this.gridControl1.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] { this.gridView1}); this.gridControl1.Load += new System.EventHandler(this.gridControl1_Load); // // gridView1 // this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] { this.gridColumn1, this.gridColumn2, this.gridColumn3, this.gridColumn4, this.gridColumn5, this.gridColumn6, this.gridColumn7, this.gridColumn8}); this.gridView1.GridControl = this.gridControl1; this.gridView1.Name = "gridView1"; this.gridView1.OptionsView.ShowGroupPanel = false; // // gridColumn1 // this.gridColumn1.Caption = "用户ID"; this.gridColumn1.FieldName = "Id"; this.gridColumn1.Name = "gridColumn1"; this.gridColumn1.Visible = true; this.gridColumn1.VisibleIndex = 0; // // gridColumn2 // this.gridColumn2.Caption = "用户名"; this.gridColumn2.FieldName = "Name"; this.gridColumn2.Name = "gridColumn2"; this.gridColumn2.Visible = true; this.gridColumn2.VisibleIndex = 1; // // gridColumn3 // this.gridColumn3.Caption = "用户密码"; this.gridColumn3.FieldName = "Password"; this.gridColumn3.Name = "gridColumn3"; this.gridColumn3.Visible = true; this.gridColumn3.VisibleIndex = 2; // // gridColumn4 // this.gridColumn4.Caption = "所属部门"; this.gridColumn4.FieldName = "Dept"; this.gridColumn4.Name = "gridColumn4"; this.gridColumn4.Visible = true; this.gridColumn4.VisibleIndex = 3; // // gridColumn5 // this.gridColumn5.Caption = "职务"; this.gridColumn5.FieldName = "Job"; this.gridColumn5.Name = "gridColumn5"; this.gridColumn5.Visible = true; this.gridColumn5.VisibleIndex = 4; // // gridColumn6 // this.gridColumn6.Caption = "联系电话"; this.gridColumn6.FieldName = "Tel"; this.gridColumn6.Name = "gridColumn6"; this.gridColumn6.Visible = true; this.gridColumn6.VisibleIndex = 5; // // gridColumn7 // this.gridColumn7.Caption = "电子邮件"; this.gridColumn7.FieldName = "Email"; this.gridColumn7.Name = "gridColumn7"; this.gridColumn7.Visible = true; this.gridColumn7.VisibleIndex = 6; // // gridColumn8 // this.gridColumn8.Caption = "权限"; this.gridColumn8.FieldName = "Admin"; this.gridColumn8.Name = "gridColumn8"; this.gridColumn8.Visible = true; this.gridColumn8.VisibleIndex = 7;

这里面要注意的是：FieldName的名字要和xml映射文件的property一致，而不是像原来那样与数据表中的字段对应，虽然我们的datasourse最后是和list绑定的，FieldName也不是与list文件中的一致。那样将导致gridcontrol只显示条数，不显示数据。