TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
anish shres
NA
3
24.5k
WPF and Code Behind Issues
Dec 26 2010 10:27 PM
Hello, I am trying to develop a simple gallery like application using C# - WPF and SQL Server 2005. The issues I am having are:
1. I have designed the Listbox styles and data templates where I plan to show the images.
The part of a datatemplate code:
<DataTemplate x:Key="GroupDataTemplate" >
<Grid VerticalAlignment="Center" HorizontalAlignment="Center" Margin="6">
<!-- Image Template -->
<Border Padding="4" Background="White" BorderBrush="#22000000" BorderThickness="1">
<StackPanel Orientation="Horizontal">
<Image Source="{Binding Picture}" Grid.Row="1" Margin="0" Height="200"/>
<Label Name="lblGroup" Content="{Binding Name}" HorizontalAlignment="Center" Background="#FF13212F" VerticalAlignment="Center" Foreground="White" Height="175" Width="275"/>
</StackPanel>
</Border>
</Grid>
</DataTemplate
>
Tjhe parf of the ListBox Code:
<GroupBox Grid.Column="0" Grid.Row="1">
<ScrollViewer VerticalScrollBarVisibility="Auto" HorizontalScrollBarVisibility="Disabled">
<ListBox
ItemTemplate="{StaticResource GroupDataTemplate}"
ItemsSource="{Binding Tables[0]}"
IsSynchronizedWithCurrentItem="True"
Name="GroupListBox"
Style="{StaticResource PhotoListBoxStyle}"
Margin="10"
SelectionMode="Extended"
SelectedIndex="0"
MouseDoubleClick="GroupListBox_MouseDClick">
</ListBox>
</ScrollViewer>
</GroupBox>
The Code behing in .cs file:
DataSet dtSet = new DataSet(); using (connection = new SqlConnection(connectionString)) {
command = new SqlCommand(sql, connection);
SqlDataAdapter adapter = new SqlDataAdapter();
connection.Open();
adapter.SelectCommand = command;
adapter.Fill(dtSet, "Product_Group");
GroupListBox.DataContext = dtSet;
}
First of all, I could not get the picture displayed the picture in the database. Second of all, How can I trap the Primary key the selected ListBoxItem so that I can show the next Window with the details of the Selected ListBox Item.
What I have done here but does not work is:
private void GroupListBox_MouseDClick(object sender, MouseButtonEventArgs e)
{
using (connection = new SqlConnection(connectionString))
{
connection.Open();
DataSet ds = new DataSet();
ListBoxItem lb = (GroupListBox.SelectedItem as ListBoxItem);
SqlDataAdapter sqa = new SqlDataAdapter("Select Code from Product_Group where name='" + lb.Content + "'", connection);
sqa.Fill(ds);
connection.Close();
this.Close();
}
}
I'd be grateful if I could any help. Thanking you in advance. :)
Reply
Answers (
1
)
Unique Key Problem
Video is not playing after site is hosted on the server. It is working in Local.