WPF Discussion Boards

Re: try to add data on wpf DataGridColumn

7-May-12 10:55

Hi, I try to import data from an Excel file and display it in a datagrid, the data are email addresses. i want that data will be shown on

XML

<DataGridTemplateColumn Header="Adress" Width="500" IsReadOnly="True">

but when i click on boutton, another DataGridColumn appears with data, but i want that data shown on DataGridColumn="Adress"

code of parse:

public class ExcelParser
    {
        public DataTable GetDataTableExcel(string datasource)
        {

            OleDbConnection theConnection = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;data source=" + datasource + ";Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1;\"");
            theConnection.Open();

            OleDbDataAdapter theDataAdapter = new OleDbDataAdapter("SELECT * FROM [Feuil1$]", theConnection);

            DataTable dt = new DataTable();

            theDataAdapter.Fill(dt);

            return dt;
        }

xaml:

XML

<DataGrid HeadersVisibility="Column" AutoGenerateColumns="True" Height="296" HorizontalAlignment="Left" Margin="23,8,0,0" Name="dgvreceipient" VerticalAlignment="Top" Width="582" MinRowHeight="30" MinWidth="0" DataContext="{StaticResource {x:Static SystemColors.ActiveCaptionBrushKey}}" MinColumnWidth="100" SelectedValuePath="id" ItemsSource="{Binding Customers}"  AlternatingRowBackground="Gainsboro"  AlternationCount="2">
                                <DataGrid.Columns>
                                    <DataGridTemplateColumn Header="Adress" Width="500" IsReadOnly="True">
                                    </DataGridTemplateColumn>
                                    <DataGridTemplateColumn Header="Validate" Width="200" IsReadOnly="True">
                                    </DataGridTemplateColumn>
                                </DataGrid.Columns>

boutton click excel
code behined:

private void btnExcel_Click(object sender, RoutedEventArgs e)
       {

           wpfOpenfiledialog o = new wpfOpenfiledialog();
           o.openfich(1);
           datasource = o.filename;

           ExcelParser exc = new ExcelParser();// class to get data from excel files
           DataTable dt = exc.GetDataTableExcel(datasource);
           //dgvreceipient.ItemsSource = dt.DefaultView;=========>the problem that this ligne will show another column


       }

Mycroft Holmes7-May-12 12:26

Mycroft Holmes

7-May-12 12:26

Your view binding is to Customers

Then you assign the resulting dataset! to the datagrid directly - the data should be put into Customers not the control

Check the content of the datatable after it has loaded and make sure the columns are all what you expected. Then put the rows into the customer container, presuming it is an observablecollection

Never underestimate the power of human stupidity
RAH

Re: try to add data on wpf DataGridColumn

Wayne Gaylard7-May-12 20:09

Wayne Gaylard

7-May-12 20:09

The issue is that you are setting the AutoGenerateColumns property of the DataGrid to true, which will generate it's own columns (one for each field in the datatable) as well as show your template columns (which are not bound to anything by the way, so will not display any results). You have 2 options here:-
1. Forget about your template columns, and leave AutoGenerateColumns on. Then in your SQL query you should only select the columns you want displayed, and use aliases to get the correct headers for your columns i.e.

SQL

SELECT name AS Name, emailaddress AS Address FROM youtable

. This will give you the results you want except for column width.
2. Turn AutoGenerateColumns off in your DataGrid, and the use the DisplayMemberBinding property of your template columns to bind the column to the datatable field i.e

<DataGridTemplateColumn Header="Adress" DisplayMemnerBinding={Binding Path=emailaddress} Width="500" IsReadOnly="True">

. This will also get you your desired result with column widths.

Personally I never use DataTables to bind to WPF controls, preferring to have a class that holds my object properties, and then having an ObservableCollection of that class that holds all instances of that class to bind to the DataGrid.

Hope this helps

When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman

Re: try to add data on wpf DataGridColumn

MemberDotNetting7-May-12 23:23

7-May-12 23:23

thnk you, please I tried to use interface: this is the code but it doesn't work

public interface Iimportdata
    {
        DataView GridData { get; set; }
    }




//traitement2--Excel
        private DataView Data = null;
        public DataView GridData
        {    
           get
            {   return Data;
            }
           set
            {
                Data = value;
                NotifyPropertyChanged("GridData");
            }
       }

public event PropertyChangedEventHandler PropertyChanged;

        private void NotifyPropertyChanged(String info)
        {
            if (PropertyChanged != null)
            {
                PropertyChanged(this, new PropertyChangedEventArgs(info));
            }
        }






  private void btnExcel_Click(object sender, RoutedEventArgs e)
        {
          
            ExcelParser exc = new ExcelParser();
            DataTable dt = exc.GetDataTableExcel(datasource);
          
            Iimportdata imp = Window.GetWindow(this) as Iimportdata;
            imp.GridData = dt.DefaultView;
            gbReceipient.Visibility = Visibility.Visible;
            btnValidate.Visibility = Visibility.Visible;
        }

XAML:

XML

<DataGridTemplateColumn Header="Adress" Width="100" IsReadOnly="True">
                                      <DataGridTemplateColumn.CellTemplate>
                                      <DataTemplate>
                                              <TextBlock Text="{Binding Path=GridData}"/>
                                      </DataTemplate>
                                      </DataGridTemplateColumn.CellTemplate>
                                  </DataGridTemplateColumn>

WPF DataGrid cell click

LAPEC7-May-12 9:27

LAPEC

7-May-12 9:27

Hello Everyone

I did asked a question to my problem couple of days ago on: How can I display all the details of the employee in the textboxes, comboboxes, and checkbox when I click on the cell of the DataGrid?

Well somehow I managed to solve my problem with the help on searching on the internet, but I'm facing another problem.

When I run my application I'm displaying only the names of the employee from the database on the DataGrid, then when I click on DataGrid cell (of the employee name, to display all the details of that employee into textboxes, comboboxes, and checkbox) some-how it repeats the details of the employee into textboxes.

To be more clear to my problem:

In my database table (EmployeeDetails table) I have 2 employee record details,
These 2 employees (their names will be displayed on the DataGrid)
When I click on the first employee name on the DataGrid cell to display his/her details
When I click on the second employee name on the DataGrid cell to display his/her details etc. etc...

Could someone please view the code I provided below and tell me what am I doing wrong...

DataGrid xaml code:

XML

<DataGrid Height="490" HorizontalAlignment="Left" Margin="6,8,0,0" Name="GridViewEmployeeName" VerticalAlignment="Top" Width="200" HorizontalScrollBarVisibility="Disabled" VerticalScrollBarVisibility="Auto" Background="{x:Null}" FontFamily="Verdana" FontWeight="Bold" FontSize="16" GridLinesVisibility="None" BorderBrush="Silver" RowDetailsVisibilityMode="Visible" CanUserResizeRows="False" ItemsSource="{Binding}" SelectionChanged="GridViewEmployeeName_SelectionChanged" SelectionMode="Single" IsSynchronizedWithCurrentItem="{x:Null}" CanUserResizeColumns="False" AutoGenerateColumns="False" HeadersVisibility="Column" EnableRowVirtualization="False" CanUserAddRows="False" RowHeight="22">
                        <DataGrid.Columns>
                            <DataGridTextColumn FontSize="12" FontWeight="Bold" Header="Employee Name" IsReadOnly="True" Width="200" Binding="{Binding Name}" CanUserResize="False" FontFamily="Verdana" />
                        </DataGrid.Columns>
                    </DataGrid>

C# code Window Load displaying only names of the employee in DataGrid

private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            string ConString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
            string CmdString = string.Empty;

            using (OleDbConnection conn = new OleDbConnection(ConString))
            {
                CmdString = "SELECT Name FROM EmployeeDetails";

                OleDbCommand comm = new OleDbCommand(CmdString, conn);
                OleDbDataAdapter sda = new OleDbDataAdapter(comm);
                DataTable dt = new DataTable("EmployeeDetails");

                sda.Fill(dt);
                GridViewEmployeeName.ItemsSource = dt.DefaultView;
            }
        }

C# code

private void GridViewEmployeeName_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            string ConnStr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\USER\Desktop\iPosSystem\iPosSystemMenu\iPosSystemMenu\DataBase\RestaurantMenu.accdb;Persist Security Info=False;";
            OleDbConnection conn = new OleDbConnection(ConnStr);

            string sql = "SELECT Name, NIN, Phone, Address, PostCode, City, JobTitle, AccessCode, AccessLevel, AssignTableAccess FROM EmployeeDetails";

            OleDbCommand cmd = new OleDbCommand(sql, conn);

            conn.Open();

            OleDbDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                txtFullName.Text += dr["Name"].ToString();
                
                txtNIN.Text += dr["NIN"].ToString();
                
                txtPhoneNumber.Text += dr["Phone"].ToString();
                
                txtAddress.Text += dr["Address"].ToString();
                
                txtPostCode.Text += dr["PostCode"].ToString();
                
                txtCity.Text += dr["City"].ToString();
                
                JobTitleComboBox.Text += dr["JobTitle"].ToString();
                txtAccessCode.Text += dr["AccessCode"].ToString();
                
                AccessLevelComboBox.Text += dr["AccessLevel"].ToString();
                
                AssignTableAccessCheckBox.IsChecked = dr["AssignTableAccess"].Equals(true);
            }
            dr.Close();
            conn.Close();
        }
    }

Could someone help me on this please I'm new to WPF...

Kind Regards to everyone

Lapeci

wpf ritchbox

MemberDotNetting6-May-12 3:41

6-May-12 3:41

i try to change the size of text in ritchbox with code behind

TextRange tr = new TextRange(rtb.Document.ContentStart, rtb.Document.ContentEnd);
tr.ApplyPropertyValue(FontSizeProperty, (double)9);

but i want to change

tr.ApplyPropertyValue(FontSizeProperty, (double)9)

double size=Convert.ToDouble(comboboxfontsize.selectedItem)// or selected value;
tr.ApplyPropertyValue(FontSizeProperty, size)

i get an exception

Impossible d'effectuer un cast d'un objet de type 'System.Windows.Controls.ComboBoxItem' en type 'System.IConvertible'.

so how can i get the value selected item?

Re: WPF RichTextBox

Wayne Gaylard6-May-12 21:07

Wayne Gaylard

6-May-12 21:07

I don't know how you are populating the ComboBox, but I assume it is in the XAML. In this case the SelectedItem would be a ComboBoxItem which does not implement the IConvertible interface and so cannot be converted to a double. Personally, I would use WPF's binding mechanism to implement this using 2 properties, and ObservableCollection<int> to hold the allowed font sizes, and an int property to hold the selected font size, something like this:-

public ObservableCollection<int> Fonts
{
get
{
    return new ObservableCollection<int>() { 8, 9, 10, 12, 14 };
}
}

int selectedFontSize;
public int SelectedFontSize
{
get
{
    return selectedFontSize;
}
set
{
    if (selectedFontSize != value)
    {
        selectedFontSize = value;
        OnPropertyChanged("SelectedFontSize");
    }
}
}

(this assumes you user control / window implements INotifyPropertyChanged). Then you can just create the bindings in your XAML like this:

XML

<Grid>
    <Grid.RowDefinitions>
        <RowDefinition Height="Auto"/>
        <RowDefinition />
    </Grid.RowDefinitions>
    <ComboBox ItemsSource="{Binding Fonts}" SelectedItem="{Binding SelectedFontSize}" Width="200" HorizontalAlignment="Left"/>
    <RichTextBox Grid.Row="1">
        <FlowDocument FontSize="{Binding SelectedFontSize}">
            <Paragraph >
                Hello World!
            </Paragraph>
        </FlowDocument>
    </RichTextBox>
</Grid>

and that is all there is to it, not forgetting to set the DataContext of your user control / window to itself like this in the constructor:

public MainWindow()
{
    InitializeComponent();
    this.DataContext = this;
}

Hope this helps

When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman

add wpf user control

MemberDotNetting4-May-12 22:22

4-May-12 22:22

Hi,

i have a wpf user control wich allow me to show print window .

how can i show wpf user control when i click on button in another window??

Re: add wpf user control

Abhinav S5-May-12 21:40

Abhinav S

5-May-12 21:40

Place it in a window and display it on button click.

private void myButton_Click(object sender, EventArgs e)
{
    Window myWindow = new Window
    {
        Content = new myUserControl()
    };
    window.ShowDialog();
}

WPF DataGrid cell click

LAPEC4-May-12 1:06

LAPEC

4-May-12 1:06

Hello Everyone

I have this slight problem maybe someone can help me please...

I have created a WPF project on VS2010. In this project I have a window with one DataGrid (on the left side of the window), seven TextBoxes, two ComboBoxes and one CheckBox (on the right side of the window).
When I run application, on the DataGrid I display only the name of employee from the database.

My Question:
How can I display all the details of the employee in the textboxes, comboboxes, and checkbox when I click on the cell of the datagrid?
Could someone help me on this please I'm new to WPF...

Kind Regards to everyone

Lapeci

Erik Rude4-May-12 1:31

Erik Rude

4-May-12 1:31

You could consider presenting your data in a ListBox or a ListView and set IsSyncronisedWithCurrentItem="True" using the autamatic Parent Child binding in WPF.

LAPEC4-May-12 1:51

LAPEC

4-May-12 1:51

Is any way to do it with datagrid rather then with listbox, and is it possible to show me with some sample code according to my question please...

kind regards

lapeci

Erik Rude4-May-12 2:46

Erik Rude

4-May-12 2:46

I don't know any quick way to do it with Grid, but you can get a very similar look by using a list view - maybe something along these lines: Other than that wait for some one else to come up with the answer. Or read up on Binding.

<ListView Name="lvwCommandLog" 
                  ItemsSource="{Binding Path=CommandLog, Mode=TwoWay}" 
                  MouseDoubleClick="lvwCommandLog_MouseDoubleClick" 
                  ToolTip="Double click to run this command again" >
            <ListView.View >
                <GridView >
                    <GridViewColumn Header="Name" DisplayMemberBinding="{Binding Name, Mode=TwoWay}" ></GridViewColumn>
                    <GridViewColumn Header="Age" DisplayMemberBinding="{Binding Age}" ></GridViewColumn>
                    <GridViewColumn Header="Time" DisplayMemberBinding="{Binding Path=Time, StringFormat=\{0:h\\:mm\\:ss\}}"></GridViewColumn>
                </GridView>
            </ListView.View>
            <ListView.ContextMenu>
                <ContextMenu>
                    <MenuItem Header="Do Something" Click="MenuItem_Click" />
                </ContextMenu>
            </ListView.ContextMenu>
        </ListView>
        <Text Text="{Binding Name}"/>

Jeremy Hutchinson4-May-12 2:46

4-May-12 2:46

There are two ways to do this:
1. Bind the DataGrid's SelectItem to a property in your ViewModel (or code behind if you're not using MVVM Frown | :(

), then in the setter for that property populate properties for the TextBoxes, ComboBoxes etc.

This method has the advantage of being able to add a Cancel button.

2. Bind the TextBoxes, ComboBoxes etc to the DataGrid's SelectedItem property. Something like this:

XML

{Binding ElementName=DataGrid1, Path=SelectedItem.TextPropertyName}

This method saves you a bit of coding but doesn't offer an easy way to cancel changes.

user control

MemberDotNetting3-May-12 13:40

3-May-12 13:40

I create a library of these classes contains a user control that contains images as background to some button, I add it to the main page such as referance, I added this code to retrieve the control xaml user

XML

<Window x: Class = "WpfApplication3.MainWindow"
         xmlns = "http://schemas.microsoft.com/winfx/2006/xaml/presentation"
         xmlns: x = "http://schemas.microsoft.com/winfx/2006/xaml"
         Title = "MainWindow" Height = "350" width = "525"
          xmlns: usercontrol = "clr-namespace: usercontrol; assembly = usercontrol">
     <Grid>
         <usercontrol:myeditor> </ usercontrol: myeditor>
     </ Grid>
</ Window>

but i get an exception: the user control Cannot locate resource Sniff | :^)

Re: user control

Jeremy Hutchinson4-May-12 2:34

4-May-12 2:34

What are the values of the 'Build Action' and 'Copy to Output' properties of the background image (right click - properties)?

What does the xaml (or code) look like for assigning the image as the background of the UserControl look like?

How to get the value of textbox in ViewModel in WPF - MVVM

Re: user control

Alisaunder6-May-12 2:23

Alisaunder

6-May-12 2:23

Your error is going to be in the myeditor usercontrol. Like Jeremy suggested check to ensure that your image sources on the control are correct, and that the control is able to locate them during runtime.

Rocky#3-May-12 4:02

Rocky#

3-May-12 4:02

Hi guys,

I'm working for the first time in WPF with MVVM pattern and I have a datagrid that is populated according to search terms in textbox on top. Right now, I'm able to populate the grid with all the data but I'm not able to get the value of the TextBox so I can filter it.

So here's a bit of the code:

In ViewModel:

private string p_searchName;
public string _searchName
        {
            get
            {
                return p_searchName;
            }
            set
            {
                p_searchName = value;

                base.RaisePropertyChanged(&quot;_searchName&quot;);
            }
        }

In xaml file

<TextBox Height="23" HorizontalAlignment="Left"  Margin="2,45,0,0" Text="{Binding _searchName}" 
                         Name="tb_SearchName" VerticalAlignment="Top" Width="99" FontFamily="Lucida Console" TabIndex="10" 
                         Grid.Column="1" />

Any help is greatly appreciated!

Thanks

Rocky

My Blog

Re: How to get the value of textbox in ViewModel in WPF - MVVM

Jeremy Hutchinson3-May-12 5:30

3-May-12 5:30

The binding looks right, but are there any errors in the output window when loading that form?

The other thing that it may be, is that the TextBox control doesn't update the ViewModel until it loses focus. Not sure about that though...

Re: How to get the value of textbox in ViewModel in WPF - MVVM

Rocky#3-May-12 20:42

Rocky#

3-May-12 20:42

There are no errors in the output window. But you are quite right about the focus. I just added

UpdateSourceTrigger=PropertyChanged

like this

<TextBox Text="{Binding Name, UpdateSourceTrigger=PropertyChanged}"/>

and it actually works... But I really don't see why this is so.

Thanks for the help!

Rocky

My Blog

Re: How to get the value of textbox in ViewModel in WPF - MVVM

Jeremy Hutchinson4-May-12 1:48

4-May-12 1:48

I assume the default for UpdateSourceTrigger is LostFocus, and it is set that way for performance reasons. Every time you call the setter, the setter raises the OnPropertyChanged event, WPF listens to that event and calls the getter.