DevExpress Gridcontrol shows empty column...

Dinesh Kudale

DevExpress Gridcontrol shows empty column after adding repositoryItemLookUpEdit.

I have created windows VB.Net application using 'Visual Studio Express 2015 for windows' with .Net Framework 4.6. In that I have used Devexpress 19.1.6.0 Gridcontrol on the form. I want to bind Student details to gridcontrol. In 'Name' column of gridview, I want to show combobox to select any Name to update particular cell.

For that purpose I have used repositoryItemLookUpEdit.

'Name' column must contain Name of sutdent. But when I will run the program, then 'Name' column shows empty cells. Why? How to overcome this issue?

Also If I will implement same program Without using repositoryItemLookUpEdit, then all column's correct data will get bind to the gridview and 'Name' column will also not showing empty.

Form1.vb

Imports System.Data.SqlClient
Public Class Form1
Dim cn As SqlConnection = New SqlConnection("Data Source=PC161\SQLEXPRESS;Database=Student;Integrated Security=true")
Dim da As New SqlDataAdapter
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
LoadGrid()
End Sub
Private Function FetchAllDetails() As DataTable
Dim dt As New DataTable
da = New SqlDataAdapter("select * from StudentInfo", cn)
da.Fill(dt)
Return dt
End Function
Private Function FetchIdName() As DataTable
Dim dt As New DataTable
da = New SqlDataAdapter("select ID, NAME from StudentInfo", cn)
da.Fill(dt)
Return dt
End Function
Private Sub LoadGrid()
Try
GridControl1.DataSource = FetchAllDetails()
RepositoryItemLookUpEdit1.DataSource = FetchIdName()
RepositoryItemLookUpEdit1.ValueMember = "ID"
RepositoryItemLookUpEdit1.DisplayMember = "NAME"
RepositoryItemLookUpEdit1.NullText = ""
RepositoryItemLookUpEdit1.PopulateColumns()
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
End Sub
End Class

In-place Editor Repository option to add RepositoryItemLookupEdit

Added columns after click on Run Design option on Gridcontrol

Form1_Design

Output window after click on cell

Output_after_running_the_project

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ciro Romero4y ago
Thank you Dinesh, without your help I would be stuck. What you found out was just what I needed.
0
Dinesh Kudale7y ago
I have just change FieldName=ID for GridColumn2 in 'In-place Editor Repository' window and It works fine.

One think I have understand from this that is we need to put same 'ID' word in FieldName and RepositoryItemLookUpEdit1.ValueMember = "ID".

I have also observed that we need to put same upper case letters of ID and NAME in both design and code.
+1