Get cell or column value from selectedData type DevExpress XPO DB

using DevExpress.Xpo;
using DevExpress.Xpo.DB;

Session xpoSession = new Session();
XpoDataSource1.Session = xpoSession;
string sql = "SELECT password,username FROM apotek2.dbo.account WHERE username = 'agung.helmi'";
SelectedData resultSet = XpoDataSource1.Session.ExecuteQuery(sql);
string u = (String)resultSet.ResultSet[0].Rows[0].Values[1];
TextBox1.Text = u;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: