I just stripped away the XML all I was interested in was old values and new values so I created a table see below and I only add fields that have changed, I will release my sample on my blog once it is completed
Would you mind including in you solution the ID value and also the selected text displayed in the combobox at the same time?
Or, is there a way in which you might indicate me when to do this a little more rapidly than waiting for your blog's solution? (is just a matter of rush with my own side. Of course that I'll be willing to see your final project finished)
At what event this information is "triggered and is available for me to performs the linq query"
(let's say "available" in the form of a DataSet I guess) so I can get also the label of the corresponding ID value?)
I'd also like to know how to do the iteration among the set of values available at that specific time because most of the time is not rally easy to define the kind of casting required .... OMG is like crazy when you see the syntax of some other similar solutions
for running iterations
Would you mind including in you solution the ID value and also the selected text displayed in the combobox at the same time?
That is already there RecordId hold the ID of the record updated not sure about that for foreign keys but I will look into it should have it finished in a couple of weeks as that is low priority on my current project.
klca
Or, is there a way in which you might indicate me when to do this a little more rapidly than waiting for your blog's solution? (is just a matter of rush with my own side. Of course that I'll be willing to see your final project finished)
I can send you a small sample once I have it done
klca
At what event this information is "triggered and is available for me to performs the linq query"
(let's say "available" in the form of a DataSet I guess) so I can get also the label of the corresponding ID value?)
not sure what you mean, my sample will update the aufit records at the same time as the record is saved.
klca
I'd also like to know how to do the iteration among the set of values available at that specific time because most of the time is not rally easy to define the kind of casting required .... OMG is like crazy when you see the syntax of some other similar solutions
for running iterations
again not sure what you mean here, I make the audit tables available for reporting to administrators.
klca
Is that much to ask for now?
I will do my best it is on the radar I have the classes outlined and the current project does require this so I think I will have the sample in a week or two.
See my blog C# Bits | Twitter @sjnaughton Always seeking an elegant solution.
At what event this information is "triggered and is available for me to performs the linq query"
(let's say "available" in the form of a DataSet I guess) so I can get also the label of the corresponding ID value?)
not sure what you mean, my sample will update the aufit records at the same time as the record is saved.
Talking in code terms: when is this done and how in the audit example ?
If I knew this, I could write a case sentence where I can query and get the corresponding text of the selected index in the combobox
(I'm trying to say that even tough the ID value and stored in the database in this example I'd also like to grab and store the corresponding "string" for taht selectedindex value?
...
sjnaughton
klca
I'd also like to know how to do the iteration among the set of values available at that specific time because most of the time is not rally easy to define the kind of casting required .... OMG is like crazy when you see the syntax of some other similar solutions
for running iterations
again not sure what you mean here, I make the audit tables available for reporting to administrators.
What I'm trying to say is that you must know how to do the right casting so you can iterate and query thata dataset or that bunch of data whose name I'm not quite sure of]
I'll mention some of your examples of sentences used in your examples to cast and iterate sets of data.
I don't even understand them . I am putting them here just trying to make my point clear ... :(
foreach(var metaColumn
inmetaColumns)
foreach (var column in _table.Columns)
foreach(stringkey in
defaultValues.Keys)
foreach(Control control
in references)
foreach (DataBinding db
in dba.DataBindings)
foreach (var row in itemlist)
foreach(var tp intablePermissions)
foreach (var keyColumn in metaForeignKeyColumn.ParentTable.PrimaryKeyColumns)
foreach (String fkName in metaForeignKeyColumn.ForeignKeyNames)
foreach (SubDetails SubGridDetails in subGridTables)
foreach (RepeaterItem item in filterRepeater.Items)
I'm not going to do case or serialization I am just converting to string and saving all I and my clients need is a string, you could do a lot more if you like this is just an audit trail for my purposes.
See my blog C# Bits | Twitter @sjnaughton Always seeking an elegant solution.
In El Salvador is ok to simply say "no" when you are not willing to disclose something that you don't want to disclose. Don't take me wrong, please !
Doing what you say your code will do will be probably less writting than the whole set of things we have written in common up to this point, ins't it?
It will be so hard for you to disclose the way in which you are going to save the string you have mentioned before?
If you show me how to do that I could probably do the query I need (in that very precise moment that until now is way beyond my capacity to understand) so I could save as well the "text" which I need to save too
Can you please show me how to do in code?
Carlos N. Porras
(El Salvador)
P.S.: By the way, I'm just asking ... ... nor will I ever be demanding !!!!
He shows all along the chapter how to do some of the iterations I need. I just needed to know how to do that (iterate trough the set of values)
I'm not quite sure of what I',m trying to do is the bes (in performance terms) because it would be much easier if the control itself could pass me as well the "text" plus the selectedindex number so I wouldn't need to do some additional queries
in the step shown in the book (just a little bit before saving changes)
I understand that my english is crappy so is ok if you don't arrive to the point I need you to go
In a few words (try just to understand in simple terms ... please) if I have a detailsview which has 10 dropdownlists (obviously they belong to 10 FK of 10 other different entities in my model) I'd like to have it all at once: the 10 selectedindexes selected
by the end-user when filling the form with data plus the "text" that the user also selected.
Is that so hard to understand ... I don't mean in Dynamic data terms but in my way of speaking ?
sjnaughton
All-Star
27308 Points
5458 Posts
MVP
Re: Passing filter values among forms
Dec 04, 2012 01:01 PM|LINK
I just stripped away the XML all I was interested in was old values and new values so I created a table see below and I only add fields that have changed, I will release my sample on my blog once it is completed
Always seeking an elegant solution.
klca
Member
507 Points
412 Posts
Re: Passing filter values among forms
Dec 04, 2012 01:10 PM|LINK
Hi Steve,
Would you mind including in you solution the ID value and also the selected text displayed in the combobox at the same time?
Or, is there a way in which you might indicate me when to do this a little more rapidly than waiting for your blog's solution? (is just a matter of rush with my own side. Of course that I'll be willing to see your final project finished)
At what event this information is "triggered and is available for me to performs the linq query"
(let's say "available" in the form of a DataSet I guess) so I can get also the label of the corresponding ID value?)
I'd also like to know how to do the iteration among the set of values available at that specific time because most of the time is not rally easy to define the kind of casting required .... OMG is like crazy when you see the syntax of some other similar solutions for running iterations
Is that much to ask for now?
Carlos N. Porras
(El Salvador)
sjnaughton
All-Star
27308 Points
5458 Posts
MVP
Re: Passing filter values among forms
Dec 04, 2012 02:23 PM|LINK
That is already there RecordId hold the ID of the record updated not sure about that for foreign keys but I will look into it should have it finished in a couple of weeks as that is low priority on my current project.
I can send you a small sample once I have it done
not sure what you mean, my sample will update the aufit records at the same time as the record is saved.
again not sure what you mean here, I make the audit tables available for reporting to administrators.
I will do my best it is on the radar I have the classes outlined and the current project does require this so I think I will have the sample in a week or two.
Always seeking an elegant solution.
klca
Member
507 Points
412 Posts
Re: Passing filter values among forms
Dec 04, 2012 03:42 PM|LINK
Talking in code terms: when is this done and how in the audit example ?
If I knew this, I could write a case sentence where I can query and get the corresponding text of the selected index in the combobox
(I'm trying to say that even tough the ID value and stored in the database in this example I'd also like to grab and store the corresponding "string" for taht selectedindex value?
...
What I'm trying to say is that you must know how to do the right casting so you can iterate and query thata dataset or that bunch of data whose name I'm not quite sure of]
I'll mention some of your examples of sentences used in your examples to cast and iterate sets of data.
I don't even understand them . I am putting them here just trying to make my point clear ... :(
foreach(var metaColumninmetaColumns)foreach(stringkeyindefaultValues.Keys)foreach(var tpintablePermissions)just to mention a few
Carlos N. Porras
(El Salvador)
sjnaughton
All-Star
27308 Points
5458 Posts
MVP
Re: Passing filter values among forms
Dec 04, 2012 06:25 PM|LINK
I'm not going to do case or serialization I am just converting to string and saving all I and my clients need is a string, you could do a lot more if you like this is just an audit trail for my purposes.
Always seeking an elegant solution.
klca
Member
507 Points
412 Posts
Re: Passing filter values among forms
Dec 04, 2012 08:12 PM|LINK
Hi Steve,
In El Salvador is ok to simply say "no" when you are not willing to disclose something that you don't want to disclose. Don't take me wrong, please !
Doing what you say your code will do will be probably less writting than the whole set of things we have written in common up to this point, ins't it?
It will be so hard for you to disclose the way in which you are going to save the string you have mentioned before?
If you show me how to do that I could probably do the query I need (in that very precise moment that until now is way beyond my capacity to understand) so I could save as well the "text" which I need to save too
Can you please show me how to do in code?
Carlos N. Porras
(El Salvador)
P.S.: By the way, I'm just asking ... ... nor will I ever be demanding !!!!
sjnaughton
All-Star
27308 Points
5458 Posts
MVP
Re: Passing filter values among forms
Dec 04, 2012 08:54 PM|LINK
I will disclose as soon as it's done
as I said I will send a you a copy as soon as I finished
it only a week or so.
Always seeking an elegant solution.
klca
Member
507 Points
412 Posts
Re: Passing filter values among forms
Dec 09, 2012 01:35 PM|LINK
Hi,
Chapter 8 Dynamic Data (Oleg Sych's book) ..... !
Carlos N. Porras
(El Salvador)
sjnaughton
All-Star
27308 Points
5458 Posts
MVP
Re: Passing filter values among forms
Dec 09, 2012 06:14 PM|LINK
Glad you have an answer, where is he doing what you want, in the data model of the page template?
Always seeking an elegant solution.
klca
Member
507 Points
412 Posts
Re: Passing filter values among forms
Dec 09, 2012 06:26 PM|LINK
Hi,
It is just a broader explanation of what you find in the link you already suggested : http://www.codeproject.com/Articles/34491/Implementing-Audit-Trail-using-Entity-Framework-Pa
He shows all along the chapter how to do some of the iterations I need. I just needed to know how to do that (iterate trough the set of values)
I'm not quite sure of what I',m trying to do is the bes (in performance terms) because it would be much easier if the control itself could pass me as well the "text" plus the selectedindex number so I wouldn't need to do some additional queries in the step shown in the book (just a little bit before saving changes)
I understand that my english is crappy so is ok if you don't arrive to the point I need you to go
In a few words (try just to understand in simple terms ... please) if I have a detailsview which has 10 dropdownlists (obviously they belong to 10 FK of 10 other different entities in my model) I'd like to have it all at once: the 10 selectedindexes selected by the end-user when filling the form with data plus the "text" that the user also selected.
Is that so hard to understand ... I don't mean in Dynamic data terms but in my way of speaking ?
Carlos N. Porras
(El Salvador)