110,535
社区成员
发帖
与我相关
我的任务
分享
OleDbConnection OleDbConnection_local = new OleDbConnection(@"Provider=SQLOLEDB.1;Password=801;
Persist Security Info=True;Auto Translate=false;User ID=sa;Initial Catalog=MyTest;Data Source=.");
OleDbConnection_local.Open();
OleDbDataAdapter OleDbDataAdapter_Test = new OleDbDataAdapter(@"SELECT * from Test001", OleDbConnection_local);
DataTable dt_Col = new DataTable();
OleDbDataAdapter_Test.Fill(dt_Col);
OleDbConnection_local.Close();
DataTable dt = new DataTable();
dt.Columns.Add("IP地址", typeof(string));
dt.Columns.Add("扫描端口是否成功", typeof(string));
dt.Columns.Add("测试列", typeof(object));
for (int i = 0; i < 3; i++)
{
DataRow dr = dt.NewRow();
dr["IP地址"] = "192.168.226."+i.ToString();
dr["扫描端口是否成功"] = "好" + i.ToString();
dt.Rows.Add(dr);
}
gridView1.OptionsBehavior.Editable = true;
gridView1.OptionsView.ColumnAutoWidth = true;
gridView1.OptionsView.RowAutoHeight = true;//打开自动换行设置。
gridView1.OptionsView.ShowIndicator = true;
gridView1.OptionsView.ShowGroupPanel = false;//不显示上方的拖动列分组
gridView1.VertScrollVisibility = DevExpress.XtraGrid.Views.Base.ScrollVisibility.Always;//显示垂直滚动条。
gridView1.HorzScrollVisibility = DevExpress.XtraGrid.Views.Base.ScrollVisibility.Always;//显示水平滚动条。
gridView1.IndicatorWidth = 35;
gridControl1.DataSource = dt;
DevExpress.XtraEditors.Repository.RepositoryItemGridLookUpEdit memoedit50 = new DevExpress.XtraEditors.Repository.RepositoryItemGridLookUpEdit();
memoedit50.Name = "respositoryitem50";
memoedit50.DataSource = dt_Col;
memoedit50.DisplayMember = dt_Col.Columns[0].ColumnName;
memoedit50.ValueMember = dt_Col.Columns[0].ColumnName;
memoedit50.View.PopulateColumns(dt_Col);
memoedit50.AllowNullInput = DevExpress.Utils.DefaultBoolean.True;
memoedit50.View.OptionsBehavior.Editable = true;
memoedit50.ReadOnly = false;
gridView1.Columns["测试列"].ColumnEdit = memoedit50;
gridView1.Columns["测试列"].OptionsColumn.AllowEdit = true;
gridView1.Columns["测试列"].OptionsColumn.ReadOnly = false;
参见以上代码,但是我只解决了一半的问题,没有解决如何可以编辑,也就是能打勾的问题。
你研究一下,如果解决了,告诉我一下。