|
hello,i'm developping a wpf application
i want to add the result of parser class in a datagrid
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);
DataSet theDS = new DataSet();
DataTable dt = new DataTable();
theDataAdapter.Fill(dt);
return dt;
}
private void btnExcel_Click(object sender, RoutedEventArgs e)
{
ExcelParser exc = new ExcelParser();
dgvreceipient.ItemsSource=exc.GetDataTableExcel(datasource).DefaultView;
dgvreceipient.DataContext = exc.GetDataTableExcel(datasource);
}
|
|
|
|
|
MemberDotNetting wrote: i want to add the result of parser class in a datagrid
And what is your problem? BTW please edit the above and put <pre> tags around your code to make it more readable.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
the lines are empty, for example, I have 3 line in the excel file, I receive in the datagrid 3 line, but they are empty
|
|
|
|
|
MemberDotNetting wrote: the lines are empty, for example, I have 3 line in the excel file, I receive in the datagrid 3 line, but they are empty
Sorry, but that does not give us anywhere near enough information to help you. You need to set to work with your debugger to see what gets imported into your data objects.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
I test The same code works with wf but it does not work with wpf datagrid
|
|
|
|
|
Whatever your problem is, I see some bad code:
dgvreceipient.ItemsSource=exc.GetDataTableExcel(datasource).DefaultView;
dgvreceipient.DataContext = exc.GetDataTableExcel(datasource);
You call GetDataTableExcel() twice with the same parameter, and that call might take some time. Better do it once, assign the result to a local variable, and then use that. E.g.
DataTable tmp=exc.GetDataTableExcel(datasource);
dgvreceipient.ItemsSource=tmp.DefaultView;
dgvreceipient.DataContext =tmp;
Perhaps that will also solve your problem (some inconsistent behavior?), which you did not communicate to us.
|
|
|
|
|
the lines are empty, for example, I have 3 line in the excel file, I receive in the datagrid 3 line, but they are empty
|
|
|
|
|
Hello,
I have a collection of objects which implemepts IEditableCollectionView. I bind this collection to dataSource of DataGrid (Actually XamGrid)
In my AddNew i prepare the item i want to add to the collection .
Than i enter the indexer of the object i am adding and setting it's attributes (i have a dynamic DataGrid columns)
Than in my CommitAdd i add the prepared item to the collection.
I do it like this:
private Boolean _isAdding = false;
public object AddNew()
{
_isAdding = true;
_attributeRow = new FilterSetDefinitionAttributeRowViewModel() {ParentViewModel = _parent};
return _attributeRow;
}
private FilterSetDefinitionAttributeRowViewModel _attributeRow;
public void CommitNew()
{
Add(_attributeRow);
_isAdding = false;
}
public void CancelNew()
{
_isAdding = false;
}
But after it's complete i get an exception saying "Parameter count mismatch" from mscorlib
Maybe i miss something? i even don't enter the CommitNew method
|
|
|
|
|
I have this working. However, the data doesn't show up initially in the text box. The first click highlights the textbox. The second click shows the data and the 3rd click puts it in edit mode.
What property do I use to fill the data in initially?
Does it always take 3 clicks to get into edit mode? Is this how it works or are there different user options?
Thanks.
Sutton
|
|
|
|
|
Hi!
I'm new to WPF. I want to add a button(initially invisible) and every minute I've to make it visible. How to do this?
|
|
|
|
|
Add a button
set it's visibility to a property in your VM/code behind
add a timer to your vm that toggles the property
start the timer when you load the view
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Or use the entirely XAML way and use a Storyboard.
|
|
|
|
|
Pete O'Hanlon wrote: use a Storyboard
Advanced xaml work, I have not started working with more than the basics in xaml so a storyboard did not occur to me. I can see myself going through these apps in a couple of years and shaking the head in despair.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Instead of changing the visibility you could control the button's oppacity.
Something like:
DoubleAnimation animation = new DoubleAnimation(0, 1, new Duration(TimeSpan.FromMilliseconds(1400)));
yourButton.BeginAnimation(Load.OpacityProperty, animation);
|
|
|
|
|
Paste this into a window...
<Window.Resources>
<Style x:Key="SelectionButton3"
TargetType="{x:Type Button}">
<Setter Property="Template">
<Setter.Value>
<ControlTemplate TargetType="{x:Type Button}">
<Grid HorizontalAlignment="Stretch"
VerticalAlignment="Stretch"
ClipToBounds="False">
<Grid.RowDefinitions>
<RowDefinition Height="75"/>
</Grid.RowDefinitions>
<Grid.ColumnDefinitions>
<ColumnDefinition Width="100"/>
<ColumnDefinition Width="*"/>
</Grid.ColumnDefinitions>
<Border BorderThickness="0,1.5,1.5,1.5"
Background="SteelBlue"
Height="35"
Grid.Column="1"
Grid.Row="0"
Margin="-31"
BorderBrush="DarkSlateBlue">
<Border.BitmapEffect>
<DropShadowBitmapEffect ShadowDepth="4"/>
</Border.BitmapEffect>
</Border>
<Rectangle Fill="SteelBlue"
Stroke="DarkSlateBlue"
Grid.Row="0"
Grid.Column="0">
<Rectangle.LayoutTransform>
<RotateTransform Angle="-45" />
</Rectangle.LayoutTransform>
<Rectangle.BitmapEffect>
<DropShadowBitmapEffect ShadowDepth="5"/>
</Rectangle.BitmapEffect>
</Rectangle>
<ContentPresenter x:Name="ContentArea"
VerticalAlignment="Center"
HorizontalAlignment="Center"
Content="{Binding Path=Content, RelativeSource={RelativeSource TemplatedParent}}" />
</Grid>
</ControlTemplate>
</Setter.Value>
</Setter>
<Setter Property="Foreground"
Value="LightGray" />
<Setter Property="FontFamily"
Value="Segoe UI" />
</Style>
</Window.Resources>
<Grid Margin="50">
<Button Click="Button_Click"
Style="{StaticResource SelectionButton3}"
Width="185">
</Button>
</Grid>
You see that both the rectangle and the border have drop shadows. How can I make the borders drop shadow only appear when the mouse is over any part of the control?
Thanks
Everything makes sense in someone's mind
|
|
|
|
|
Wonder why the univote.
removed is not a supported keyword when I try and compile. I was curious, can't help with gui stuff...
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: Wonder why the univote.
I think he has a uni-stalker.
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
|
|
|
|
|
You can do this via animations and the visual state manager.
This[^] manages the states between transitions in a control.
|
|
|
|
|
Hi!
I've loaded a picture into a Pictrue control. When I double click the picture,I've to write some values to a file. What Event Handler do I've to add for double clicking a picture?
|
|
|
|
|
You need the DoubleTap event. Remember that Windows Phone uses taps, rather than clicks.
|
|
|
|
|
I have to write a desktop business application with the required constraint that each function (page) of the app must be completely written in a scripted language.
So my idea is to use uncompiled XAML for scripting the user interface in WPF, and CodeDOM+CSharpCompiler for the code behind, thus making C# a sort of scripted language. I know the WPF navigation model can't be used in uncompiled XAML so I'll have to write a Custom navigation implementation.
My question is: is the above architecture a good choice (considering the constraint I am subject to)? Or it's just too crazy?
Has any of you ever written something similar?
Any suggestion will be greatly appreciated.
|
|
|
|
|
I don't think I quite understand your problem correctly.
If each page needs to be written in a scripting language, why use xaml in the first place?
You could consider using JQuery + Html5.
|
|
|
|
|
it needs to be a standard desktop app (.exe that is, no browser). Unfortunately I can't change this choice of design.
|
|
|
|
|
Get another job/course whoever set the constraints does not live in the real world.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Yup, I tried to convince the people in charge to switch to another architecture but they insist it's a winning model because they are using it since the MS-DOS age. Currently the application runs under WinForms, it has a proprietary script language, proprietary virtual machine, proprietary component library, proprietary editor with syntax highlighting and proprietary "form" editor.
But due to WinForms and limited component library the app isn'tt graphically attractive, so that's why a move to WPF was planned. And while we are moving, I would like to eliminate the virtual machine and embrace full .NET languages (via CodeDom/Reflection). But I'm not sure it's the right choice.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
