Hallo Community,
hab mal wieder ein Verständnisproblem welches ich allein nicht lösen kann.
Ich habe ein Viewmodel mit einer ObsevableCollection in der Adressdaten enthalten sind.
Diese Property binde ich an eine Listbox. In der Listbox befindet sich ein Expander, darin ein Grid mit TextBoxen and denen die einzelnen Were wie Staße, Plz usw. gebunden sind. Ohne Binding der Listbox and die Property der Collection sind die Texboxen
und Textblöcke zu sehen. Nach dem Bindig ist alles weg.
Ist mein Binding falsch?
Hier die Codeteile:
Gruß
Jürgen
<ListBox Name="lbxAddInfo" ItemsSource="{Binding Companydet}" Height="150" Background="Transparent" Grid.Row="1">
<ListBox.ItemTemplate>
<DataTemplate>
<Expander x:Name="addInformation" IsExpanded="True">
<Expander.Header>
<StackPanel>
<TextBlock Text="Zusätzliche Informationen"/>
</StackPanel>
</Expander.Header>
<Grid>
<Grid.ColumnDefinitions>
<ColumnDefinition Width="5.407"/>
<ColumnDefinition Width="95.593"/>
<ColumnDefinition Width="100"/>
<ColumnDefinition Width="100"/>
<ColumnDefinition Width="100"/>
</Grid.ColumnDefinitions>
<Grid.RowDefinitions>
<RowDefinition Height="Auto"/>
<RowDefinition Height="Auto"/>
</Grid.RowDefinitions>
<TextBlock Text="UST-Id" Grid.Column="0" Grid.Row="0" Grid.ColumnSpan="2"/>
<TextBlock x:Name="tbxTaxID" Text= "{Binding Taxid, Mode=TwoWay}" Grid.Column="2" Grid.Row="0"/>
<TextBlock Text="Steuer-Nr." Grid.Column="3" Grid.Row="0"/>
<TextBlock x:Name="tbxTaxNr" Text="{Binding Taxnbr, Mode=TwoWay}" Grid.Column="4" Grid.Row="0"/>
<TextBlock Text="Branche" FontSize="14" FontFamily="Arial" FontStyle="Normal" Grid.Column="0" Grid.Row="1" Grid.ColumnSpan="2"/>
<TextBox x:Name="tbxBranche" Text="{Binding Branche, Mode=TwoWay}" FontSize="14" FontFamily="Arial" FontStyle="Normal" Grid.Column="2" Grid.Row="1"/>
<TextBlock Text="Zahlungsziel" FontSize="14" FontFamily="Arial" FontStyle="Normal" Grid.Column="3" Grid.Row="1"/>
<TextBox x:Name="tbxPaymentGoal" Text="{Binding Payment, Mode=TwoWay}" FontSize="14" FontFamily="Arial" FontStyle="Normal" Grid.Column="4" Grid.Row="1"/>
</Grid>
</Expander>
</DataTemplate>
</ListBox.ItemTemplate>
</ListBox>
private ObservableCollection<contactModel> _Companydet;
public ObservableCollection<contactModel> Companydet
{
get { return _Companydet; }
set { _Companydet = value;
OnPropertyChanged("Companydet");
}
}
private void PgDetailComp(string companyid)
{
const string conString = "xxxx";
Companydet = new ObservableCollection<contactModel>();
using (SqlConnection connection = new SqlConnection(conString))
{
try
{
connection.Open();
string firstSql = @"SELECT * FROM dbo.Company where company_id = @company_id"; // Company_id schein leer zu sein
SqlCommand cmd = new SqlCommand(firstSql, connection);
//Parsen der übergebenen ID von String in Int und übergabe an SQLPrameter
if (int.TryParse(companyid, out int id))
{
var companyid1 = new SqlParameter("@company_id", SqlDbType.Int);
cmd.Parameters.Add(companyid1);
cmd.Parameters["@company_id"].Value = id;
}
else { MessageBox.Show("Fehler beim Parsen"); }
using (SqlDataReader reader = cmd.ExecuteReader())
{
try
{
while (reader.Read())
{
Companydet.Add(new contactModel()
{
CompanyID = reader.GetInt32(0),
CompanyName = reader.GetString(1),
Street = reader.GetString(2).ToString(),
City = reader.GetString(3),
Zip = reader.GetString(4),
County = reader.GetString(5),
Country = reader.GetString(6),
Status = reader.GetString(7),
Relation = reader.GetString(8),
Lead_Level = reader.GetString(9),
Phone = reader.GetString(10),
Fax = reader.GetString(11),
Web = reader.GetString(12),
Mail = reader.GetString(13),
Tag_1 = reader.GetString(14),
Tag_2 = reader.GetString(15),
Tag_3 = reader.GetString(16),
Tag_4 = reader.GetString(17),
Tag_5 = reader.GetString(18),
Vat = reader.GetString(19),
Branche = reader.GetString(20),
Payment = reader.GetInt32(21),
Tax_Nr = reader.GetString(22),
Newsletter = reader.GetInt32(23),
Revenue = reader.GetDouble(24),
Tradefair = reader.GetInt32(25),
Buyingbehavor = reader.GetString(26),
Comments = reader.GetString(27),
CreateAt = reader.GetDateTime(28),
CreateBy = reader.GetString(29),
ChangeAt = reader.GetDateTime(30),
ChangeBy = reader.GetString(31)
});
}
reader.Close();
}
catch (Exception ex)
{ MessageBox.Show("Fehler", ex.Message); }
connection.Close();
}
}
catch (SqlException ex)
{
MessageBox.Show("Can't open connection to Database! ", ex.Message);
}
}
return;
}
