|
My database table contains two fields, id and name
What is the way to populate the combobox with the projectnames and have the id of each projectname assigned aswell.
This is required so that if for example, from a list of names in a listbox, a name is selected, then I want the projectname to be selected in the project combobox.
The table returns the name and the projectID
I can populate the combobox with the projectnames from the project table but not sure how to assign the IDs to them.
<ComboBox Name="cboProjects" SelectedIndex="{Binding Path=ProjectID}"
/>
Thanks
|
|
|
|
|
You need to bind to DisplayMemberPath and SelectedValuePath I think.
In your example you're not showing how you're populating the combo at all, so not exactly sure if this is what you are after...
If you have a List<items> collection to which you bind, then each Item has an Id and Description - you bind the DisplayMemberPath to Description and the SelectedValuePath to Id
___________________________________________
.\\axxx
(That's an 'M')
|
|
|
|
|
I have now included the real sample of what I am trying to do...
You see that first I am retrieving data from a stored procedure which then correctly gets populated into a listcollection called grades.
First problem is that the combo box does not get populated.
Note that I can see there is correct data in cboGrades.ItemsSource
Do you see what I am doing wrong please?
Thanks
public static List<clsStudentDetails> GetGrades()
{
DbCommand comm = clsGenericDataAccess.CreateCommand();
comm.CommandText = "uspGetGrades";
DataTable table = new DataTable();
table = clsGenericDataAccess.ExecuteSelectCommand(comm);
List<clsStudentDetails> grades = new List<clsStudentDetails>();
for (int i = 0; i < table.Rows.Count; i++)
{
clsStudentDetails details = new clsStudentDetails();
details.GradeID = int.Parse(table.Rows[i]["GradeID"].ToString());
details.GradeName = table.Rows[i]["GradeName"].ToString();
grades.Add(details);
}
return grades;
}
---------------------
private void PopulateGrades()
{
List<clsStudentDetails> studentDetails = new List<clsStudentDetails>();
cboGrades.ItemsSource = clsStudentAccess.GetGrades();
}
---------------------
<ComboBox Name="cboGrades" DisplayMemberPath="GradeName"
SelectedValuePath="GradeID"
Width="208" />
|
|
|
|
|
A quick squiz shows nothing obviously wrong...
in PopulateGrades I would change so that it reads
studentDetails = clsStudentAccess.GetGrades();
cboGrades.ItemSource = studentDetails;
and check in debug that the studentDetails collection really does contain the data you think it does.
I usually start with some dummy data too - just to make things snappier..
private List<StudentDetails> GetDetails()
{
List<StudentDetails> studentDetails = new List<StudentDetails>();
studentDetails.Add(new StudentDetails()
{
GradeId = "1",
GradeName = "Top Grade"
});
studentDetails.Add(new StudentDetails()
{
GradeId = "2",
GradeName = "Not too bad"
});
studentDetails.Add(new StudentDetails()
{
GradeId = "3",
GradeName = "Try Harder"
});
return studentDetails;
}
___________________________________________
.\\axxx
(That's an 'M')
|
|
|
|
|
So, I have everything completed with no code in the code behind. I have everything separated. How should my view model notify the view that the database update has worked? Any thoughts or examples on how to do this?
I didn't get any requirements for the signature
|
|
|
|
|
You could simply add a dirty flag and bind to this.
|
|
|
|
|
Your VM needs to expose some property that indicates success or failure.
You might need a converter because there are three or four states you're talking about:
1. Don't have a pending update
2. Have a pending update
3. Update failed
4. Update passed
(2. is only appropriate for asynchronous updates)
So your VM has a property that starts off with a value 1.
When the 'save' command is triggered, it is set to 2.
When the results of the Save are returned t is set to 3 or 4 respectively.
You could 'merge' this with any process you are using to enable/disable the Save button - so add another state ...
0. Nothing To Save
___________________________________________
.\\axxx
(That's an 'M')
|
|
|
|
|
Bind the status to a textblock and create a property for it in your view model (assuming everything is bound to the view model).
Once your async web service comese back from the server, fire an action to get to the view model and then let INotifyPropertyChanged take over to update the status.
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
My latest tip/trick
|
|
|
|
|
This is what I did. I guess the user will have to click a link to navigate, or I can put that in the code behind. Thanks for the reply.
I didn't get any requirements for the signature
|
|
|
|
|
Strange. You should not need to - are the datacontext's correct?
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
My latest tip/trick
|
|
|
|
|
We use the MVVMlight framework from Galasoft, it has a messaging construct. In the completed method we send the name of the method via a Completed message pump, the relevant view or viewmodel subscribes to the Completed message, checks the message content and takes action as appropriate.
We use a VERY simplified structure, I know it can get a lot more complex but this meets our current needs.
However I rarely (never) use it to navigate as the datacontext generally meets our needs (data refreshes after the call and updates the UI via onpropertychanged)
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I'm working on a WPF app that has to have rows of controls added at runtime. The rows will be fairly simple - Caption and TextBox, and in some cases, a button to the right.
Since I'm using MVVM, all the View has is:
<ScrollViewer VerticalScrollBarVisibility="Auto">
<StackPanel Name="pnlControls"/>
</ScrollViewer>
Now in the ViewModel when I pull the data that represents the rows, how do I add them to pnlControls?
Thaks
Everything makes sense in someone's mind
|
|
|
|
|
In the code where you read your rows, add something like this:
foreach (var row in myRows) {
var btn = new Button {Content=row.ButtonCaption};
btn.Click += NotifyButtonCallback;
pnlControls.Children.Add(btn);
var txt = new TextBox {Text=row.TextBoxText};
pnlControls.Children.Add(txt);
}
private void NotifyButtonCallback(object sender, RoutedEventArgs e) {
}You will need some additional "bookkeeping" to establish a connection between a UI element that you create dynamically and the row from which you created it, so that you could act upon user's actions, such as editing the text or clicking a button.
|
|
|
|
|
But the problem is that pnlControls is not accessable from within the ViewModel.
Everything makes sense in someone's mind
|
|
|
|
|
You should really handle this in the View not the ModelView. The ModelView should be independent of the View. MVVM light has a nice messenger pattern which you can use. Basically when the ModelView determines a new control needs to be added, it transmits a message which the View subscribes to. The View receives the message and then adds the control.
I'm not a huge fan of MVVM so others may argue the point but that's how I do it.
"You get that on the big jobs."
|
|
|
|
|
You need to bind to a collection in your viewmodel and use a DataTemplate to describe how the buttons are to be displayed.
If it wasn't for the fact that I'm in the middle of debugging MS Access programs, I'd probably be able to find an example!!
___________________________________________
.\\axxx
(That's an 'M')
|
|
|
|
|
Got bored with the MS Access - here's a real simple example...
The temnplate tells it how to display. THe vm has an Options property containing a collection of Option - each of which has an OptionName property
<base:BaseView.Resources>
<DataTemplate x:Key="ButtonTemplate">
<Grid>
<Grid.ColumnDefinitions>
<ColumnDefinition Width="100" />
</Grid.ColumnDefinitions>
<Button Content="{Binding OptionName}" Height="32"/>
</Grid>
</DataTemplate>
</base:BaseView.Resources>
<StackPanel Background="#FFFF00" Height="150">
<ItemsControl ItemsSource="{Binding Options}"
ItemTemplate="{StaticResource ButtonTemplate}">
<ItemsControl.ItemsPanel>
<ItemsPanelTemplate>
<StackPanel Orientation="Vertical" HorizontalAlignment="Center" />
</ItemsPanelTemplate>
</ItemsControl.ItemsPanel>
</ItemsControl>
</StackPanel>
Hope that's enough to get you started - you need to work out how you're going to handle clicks, of course... each button may bind to the same command with a varying parameter, or each to its own command - I haven't done this bit (back to the MS Access now!)
___________________________________________
.\\axxx
(That's an 'M')
|
|
|
|
|
Hi
I'm trying to modify an Xml file. This is the content of the Xml. The problem is that after changes, it will creates a copy of the content of the Xml file without changing the old content.
Before changes :
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<connectionStrings>
<add name="Application.Properties.Settings.DBConnectionString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DB.mdb"
providerName="System.Data.OleDb" />
</connectionStrings>
</configuration>
After changes :
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<connectionStrings>
<add name="Application.Properties.Settings.DBConnectionString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DB.mdb"
providerName="System.Data.OleDb" />
</connectionStrings>
</configuration>
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<connectionStrings>
<add name="Application.Properties.Settings.DBConnectionString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DataBase\DB.mdb"
providerName="System.Data.OleDb" />
</connectionStrings>
</configuration>
The code is :
System.Xml.XmlDocument xdoc = new System.Xml.XmlDocument();
FileStream reader = new FileStream(this._XmlFilePath, FileMode.Open, FileAccess.ReadWrite);
xdoc.XmlResolver = null;
xdoc.Load(reader);
System.Xml.XmlElement Node = (System.Xml.XmlElement)xdoc.DocumentElement.SelectSingleNode("//configuration/connectionStrings/add[@name=\"Application.Properties.Settings.DBConnectionString\"]");
if (Node != null)
{
Node.Attributes.GetNamedItem("Source").Value = "C:\DataDabe\DB.mdb";
xdoc.Save(reader);
reader.Close();
}
"For as long as men massacre animals, they will kill each other. Indeed, he who sows the seed of murder and pain cannot reap joy and love." Pythagoras
|
|
|
|
|
Nope. I don't see what this has to do with WPF or Silverlight. Wrong forum I'm afraid.
|
|
|
|
|
Check out the ConfigurationManager class. It looks like you are trying to edit the app.config file and this would be a better approach.
"You get that on the big jobs."
|
|
|
|
|
You've got the wrong forum unfortunately.
This is the XAML forum and not the XML forum.
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
My latest tip/trick
|
|
|
|
|
Oh sorry..this was an Window form application...wrong forum
sorry again
bye
"For as long as men massacre animals, they will kill each other. Indeed, he who sows the seed of murder and pain cannot reap joy and love." Pythagoras
|
|
|
|
|
I have populated a combo box as follows:
<ComboBox Height="23" HorizontalAlignment="Left" Margin="120,6,0,0"
Name="cboHealth" SelectedIndex="{Binding Path=HealthLevelID}"
VerticalAlignment="Top" Width="256" />
private void PopulateHealthLevels()
{
List<clsDetails> healthlevels = new List<clsDetails>();
healthlevels = clsAccess.GetHealthLevels();
foreach (clsDetails details in healthlevels)
{
cboHealth.Items.Add(details.HealthLevelName);
}
}
The datatable returns the HealthLevelID field as well as otherr fields.
HealthLevelID has values of 1 and 2 for Normal and unNormal respectively.
The combo box does get populated but it does not show the correct item for the selected row.
What am I doing wrong please?
Thanks
|
|
|
|
|
A couple of things here.
1. Your title needs some work. Simply stating wpf is not enough.
2. The code should be enclosed in pre tags.
Now, your problem lies in the fact that SelectedIndex is actually zero based, so your values will not match. SelectedIndex should only be used to indicate the relative position of the object in your collection.
|
|
|
|
|
Hi,
At present the HealthLevelID has only values 1 or 2 in it's tblHealthlevels table.
Do you mean that since I am using selectedindex in xamml, I can change the integer values in the sql server table to be 0 and 1 instead of 1 and 2 and then it will work? If so, what if I add more values in the table such as 1, 2, 3, 4, ...
Will my existing xaml work ok?
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
