Mixing
FindNodeBiFieldValue returns null
0
Logics:
- choose from the data table rows by the condition "expand = true";
- perform a search for lines;
- depending on the value of the string field, we find the node in the "tray list".
In the method ExpandCurentNode() in line
TreeListNode node = treeList1.FindNodeByFieldValue("NodeName", name);
we get null.
Question
Why FindNodeByFieldValue returns null?
Description
TreeList fill method DataBinding().
Property PopulateServiceColumns = true.
Connection Code
public void connect()
{
string catBD = @"с:dbdb.01.accdb";
string conBD = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", catBD);
OleDbConnection connection = new OleDbConnection(conBD);
connection.Open();
string query1 = "SELECT * FROM TableTreeViewNoAi_12";
OleDbCommand cmd1 = new OleDbCommand(query1, connection);
dt = new DataTable();
dt.Columns.Add("ID", typeof(int));
dt.Columns["ID"].AutoIncrement = true;
dt.Columns["ID"].AutoIncrementSeed = 44;
dt.Columns["ID"].AutoIncrementStep = 1;
dt.Columns.Add("PrID", typeof(int));
dt.Columns.Add("sorting", typeof(int));
dt.Columns.Add("NodeName", typeof(string));
dt.Columns.Add("Description", typeof(string));
dt.Columns.Add("Comment", typeof(string));
dt.Columns.Add("dateN", typeof(string));
dt.Columns.Add("Cost", typeof(int));
dt.Columns.Add("typeRecord", typeof(string));
dt.Columns.Add("stImageInd", typeof(int));
dt.Columns.Add("expand", typeof(bool));
dt.Columns.Add("focus", typeof(bool));
try
{
adapter = new OleDbDataAdapter(cmd1);
cmdBuilder = new OleDbCommandBuilder(adapter);
adapter.UpdateCommand = cmdBuilder.GetUpdateCommand();
adapter.InsertCommand = cmdBuilder.GetInsertCommand();
}
catch (Exception ex)
{
string s = ex.Message;
throw;
}
adapter.Fill(dt);
dt.RowChanged += new DataRowChangeEventHandler(Row_Changed);
}
public void DataBinding()
{
// Чтобы отобразить поля "KeyFieldName" и "ParentFieldName"
// Свойство - PopulateServiceColumns = true
// Привязка к ключевым полям
treeList1This.KeyFieldName = "ID";
treeList1This.ParentFieldName = "PrID";
treeList1This.DataSource = dt;
// dataGridView1.DataSource = dt;
}
Form code
private void Frm29UC_Load(object sender, EventArgs e)
{
treeList1.BestFitColumns(); // расширить поля
ExpandCurentNode(); // восстановление дерева после открытия
}
public void ExpandCurentNode() // Восстановление состояния после открытия дерева
{
var selectedDt = conectDB.dt.Select("expand = true"); // DataTable.Select
int i = selectedDt.Length;
foreach (var b in selectedDt)
{
string name = b["NodeName"].ToString();
TreeListNode node = treeList1.FindNodeByFieldValue("NodeName", name); // +- string s = node.GetValue("NodeName").ToString();
node.Expand();
ExpandParentNode(node);
}
}
c# winforms devexpress
asked Nov 21 '18 at 9:01
eusatafeusataf
829
add a comment |
0
Logics:
- choose from the data table rows by the condition "expand = true";
- perform a search for lines;
- depending on the value of the string field, we find the node in the "tray list".
In the method ExpandCurentNode() in line
TreeListNode node = treeList1.FindNodeByFieldValue("NodeName", name);
we get null.
Question
Why FindNodeByFieldValue returns null?
Description
TreeList fill method DataBinding().
Property PopulateServiceColumns = true.
Connection Code
public void connect()
{
string catBD = @"с:dbdb.01.accdb";
string conBD = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", catBD);
OleDbConnection connection = new OleDbConnection(conBD);
connection.Open();
string query1 = "SELECT * FROM TableTreeViewNoAi_12";
OleDbCommand cmd1 = new OleDbCommand(query1, connection);
dt = new DataTable();
dt.Columns.Add("ID", typeof(int));
dt.Columns["ID"].AutoIncrement = true;
dt.Columns["ID"].AutoIncrementSeed = 44;
dt.Columns["ID"].AutoIncrementStep = 1;
dt.Columns.Add("PrID", typeof(int));
dt.Columns.Add("sorting", typeof(int));
dt.Columns.Add("NodeName", typeof(string));
dt.Columns.Add("Description", typeof(string));
dt.Columns.Add("Comment", typeof(string));
dt.Columns.Add("dateN", typeof(string));
dt.Columns.Add("Cost", typeof(int));
dt.Columns.Add("typeRecord", typeof(string));
dt.Columns.Add("stImageInd", typeof(int));
dt.Columns.Add("expand", typeof(bool));
dt.Columns.Add("focus", typeof(bool));
try
{
adapter = new OleDbDataAdapter(cmd1);
cmdBuilder = new OleDbCommandBuilder(adapter);
adapter.UpdateCommand = cmdBuilder.GetUpdateCommand();
adapter.InsertCommand = cmdBuilder.GetInsertCommand();
}
catch (Exception ex)
{
string s = ex.Message;
throw;
}
adapter.Fill(dt);
dt.RowChanged += new DataRowChangeEventHandler(Row_Changed);
}
public void DataBinding()
{
// Чтобы отобразить поля "KeyFieldName" и "ParentFieldName"
// Свойство - PopulateServiceColumns = true
// Привязка к ключевым полям
treeList1This.KeyFieldName = "ID";
treeList1This.ParentFieldName = "PrID";
treeList1This.DataSource = dt;
// dataGridView1.DataSource = dt;
}
Form code
private void Frm29UC_Load(object sender, EventArgs e)
{
treeList1.BestFitColumns(); // расширить поля
ExpandCurentNode(); // восстановление дерева после открытия
}
public void ExpandCurentNode() // Восстановление состояния после открытия дерева
{
var selectedDt = conectDB.dt.Select("expand = true"); // DataTable.Select
int i = selectedDt.Length;
foreach (var b in selectedDt)
{
string name = b["NodeName"].ToString();
TreeListNode node = treeList1.FindNodeByFieldValue("NodeName", name); // +- string s = node.GetValue("NodeName").ToString();
node.Expand();
ExpandParentNode(node);
}
}
c# winforms devexpress
asked Nov 21 '18 at 9:01
eusatafeusataf
829
add a comment |
0
0
0
Logics:
- choose from the data table rows by the condition "expand = true";
- perform a search for lines;
- depending on the value of the string field, we find the node in the "tray list".
In the method ExpandCurentNode() in line
TreeListNode node = treeList1.FindNodeByFieldValue("NodeName", name);
we get null.
Question
Why FindNodeByFieldValue returns null?
Description
TreeList fill method DataBinding().
Property PopulateServiceColumns = true.
Connection Code
public void connect()
{
string catBD = @"с:dbdb.01.accdb";
string conBD = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", catBD);
OleDbConnection connection = new OleDbConnection(conBD);
connection.Open();
string query1 = "SELECT * FROM TableTreeViewNoAi_12";
OleDbCommand cmd1 = new OleDbCommand(query1, connection);
dt = new DataTable();
dt.Columns.Add("ID", typeof(int));
dt.Columns["ID"].AutoIncrement = true;
dt.Columns["ID"].AutoIncrementSeed = 44;
dt.Columns["ID"].AutoIncrementStep = 1;
dt.Columns.Add("PrID", typeof(int));
dt.Columns.Add("sorting", typeof(int));
dt.Columns.Add("NodeName", typeof(string));
dt.Columns.Add("Description", typeof(string));
dt.Columns.Add("Comment", typeof(string));
dt.Columns.Add("dateN", typeof(string));
dt.Columns.Add("Cost", typeof(int));
dt.Columns.Add("typeRecord", typeof(string));
dt.Columns.Add("stImageInd", typeof(int));
dt.Columns.Add("expand", typeof(bool));
dt.Columns.Add("focus", typeof(bool));
try
{
adapter = new OleDbDataAdapter(cmd1);
cmdBuilder = new OleDbCommandBuilder(adapter);
adapter.UpdateCommand = cmdBuilder.GetUpdateCommand();
adapter.InsertCommand = cmdBuilder.GetInsertCommand();
}
catch (Exception ex)
{
string s = ex.Message;
throw;
}
adapter.Fill(dt);
dt.RowChanged += new DataRowChangeEventHandler(Row_Changed);
}
public void DataBinding()
{
// Чтобы отобразить поля "KeyFieldName" и "ParentFieldName"
// Свойство - PopulateServiceColumns = true
// Привязка к ключевым полям
treeList1This.KeyFieldName = "ID";
treeList1This.ParentFieldName = "PrID";
treeList1This.DataSource = dt;
// dataGridView1.DataSource = dt;
}
Form code
private void Frm29UC_Load(object sender, EventArgs e)
{
treeList1.BestFitColumns(); // расширить поля
ExpandCurentNode(); // восстановление дерева после открытия
}
public void ExpandCurentNode() // Восстановление состояния после открытия дерева
{
var selectedDt = conectDB.dt.Select("expand = true"); // DataTable.Select
int i = selectedDt.Length;
foreach (var b in selectedDt)
{
string name = b["NodeName"].ToString();
TreeListNode node = treeList1.FindNodeByFieldValue("NodeName", name); // +- string s = node.GetValue("NodeName").ToString();
node.Expand();
ExpandParentNode(node);
}
}
c# winforms devexpress
asked Nov 21 '18 at 9:01
eusatafeusataf
829
Logics:
- choose from the data table rows by the condition "expand = true";
- perform a search for lines;
- depending on the value of the string field, we find the node in the "tray list".
In the method ExpandCurentNode() in line
TreeListNode node = treeList1.FindNodeByFieldValue("NodeName", name);
we get null.
Question
Why FindNodeByFieldValue returns null?
Description
TreeList fill method DataBinding().
Property PopulateServiceColumns = true.
Connection Code
public void connect()
{
string catBD = @"с:dbdb.01.accdb";
string conBD = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", catBD);
OleDbConnection connection = new OleDbConnection(conBD);
connection.Open();
string query1 = "SELECT * FROM TableTreeViewNoAi_12";
OleDbCommand cmd1 = new OleDbCommand(query1, connection);
dt = new DataTable();
dt.Columns.Add("ID", typeof(int));
dt.Columns["ID"].AutoIncrement = true;
dt.Columns["ID"].AutoIncrementSeed = 44;
dt.Columns["ID"].AutoIncrementStep = 1;
dt.Columns.Add("PrID", typeof(int));
dt.Columns.Add("sorting", typeof(int));
dt.Columns.Add("NodeName", typeof(string));
dt.Columns.Add("Description", typeof(string));
dt.Columns.Add("Comment", typeof(string));
dt.Columns.Add("dateN", typeof(string));
dt.Columns.Add("Cost", typeof(int));
dt.Columns.Add("typeRecord", typeof(string));
dt.Columns.Add("stImageInd", typeof(int));
dt.Columns.Add("expand", typeof(bool));
dt.Columns.Add("focus", typeof(bool));
try
{
adapter = new OleDbDataAdapter(cmd1);
cmdBuilder = new OleDbCommandBuilder(adapter);
adapter.UpdateCommand = cmdBuilder.GetUpdateCommand();
adapter.InsertCommand = cmdBuilder.GetInsertCommand();
}
catch (Exception ex)
{
string s = ex.Message;
throw;
}
adapter.Fill(dt);
dt.RowChanged += new DataRowChangeEventHandler(Row_Changed);
}
public void DataBinding()
{
// Чтобы отобразить поля "KeyFieldName" и "ParentFieldName"
// Свойство - PopulateServiceColumns = true
// Привязка к ключевым полям
treeList1This.KeyFieldName = "ID";
treeList1This.ParentFieldName = "PrID";
treeList1This.DataSource = dt;
// dataGridView1.DataSource = dt;
}
Form code
private void Frm29UC_Load(object sender, EventArgs e)
{
treeList1.BestFitColumns(); // расширить поля
ExpandCurentNode(); // восстановление дерева после открытия
}
public void ExpandCurentNode() // Восстановление состояния после открытия дерева
{
var selectedDt = conectDB.dt.Select("expand = true"); // DataTable.Select
int i = selectedDt.Length;
foreach (var b in selectedDt)
{
string name = b["NodeName"].ToString();
TreeListNode node = treeList1.FindNodeByFieldValue("NodeName", name); // +- string s = node.GetValue("NodeName").ToString();
node.Expand();
ExpandParentNode(node);
}
}
c# winforms devexpress
c# winforms devexpress
asked Nov 21 '18 at 9:01
eusatafeusataf
829
asked Nov 21 '18 at 9:01
eusatafeusataf
829
asked Nov 21 '18 at 9:01
eusatafeusataf
829
asked Nov 21 '18 at 9:01
eusatafeusataf
829
asked Nov 21 '18 at 9:01
eusatafeusataf
829
829
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
1
Ensure that TreeList is completely initialized when calling the ExpandCurentNode method. For this, call the TreeList.ForceInitialize method prior your method.
answered Nov 21 '18 at 9:19
SvetlanaSvetlana
33613
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53408454%2ffindnodebifieldvalue-returns-null%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
Ensure that TreeList is completely initialized when calling the ExpandCurentNode method. For this, call the TreeList.ForceInitialize method prior your method.
answered Nov 21 '18 at 9:19
SvetlanaSvetlana
33613
add a comment |
1
Ensure that TreeList is completely initialized when calling the ExpandCurentNode method. For this, call the TreeList.ForceInitialize method prior your method.
answered Nov 21 '18 at 9:19
SvetlanaSvetlana
33613
add a comment |
1
1
1
Ensure that TreeList is completely initialized when calling the ExpandCurentNode method. For this, call the TreeList.ForceInitialize method prior your method.
answered Nov 21 '18 at 9:19
SvetlanaSvetlana
33613
Ensure that TreeList is completely initialized when calling the ExpandCurentNode method. For this, call the TreeList.ForceInitialize method prior your method.
answered Nov 21 '18 at 9:19
SvetlanaSvetlana
33613
answered Nov 21 '18 at 9:19
SvetlanaSvetlana
33613
answered Nov 21 '18 at 9:19
SvetlanaSvetlana
33613
answered Nov 21 '18 at 9:19
SvetlanaSvetlana
33613
33613
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53408454%2ffindnodebifieldvalue-returns-null%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
