for (int i = pageList.Count; i-- > 0; )
{
if (itemsToRemoveList.Contains(mainList[i]))
mainList.RemoveAt(i);
}
public static class ObjectExtensions
{
public static T SelectiveClone(this Object obj, string[] properties)
where T: new()
{
T temp = new T();
PropertyInfo[] propertyInfos = typeof(T).GetProperties();
foreach (PropertyInfo pi in propertyInfos)
{
if(properties.Contains(pi.Name))
pi.SetValue(temp, pi.GetValue(obj, null), null);
}
return temp;
}
}
/* Product is a class with the properties "title", "titleAlias", "subTitle", "description", "price", "stock" and "id" "original" is an existing object of the class Product */ // The following copies all properties except "id" Product product = original.SelectiveClone(new string[] { "title", "titleAlias", "subTitle", "description", "price", "stock" });
<riaData:ControlParameter ParameterName="title"
ControlName="filterTextBox"
PropertyName="Text" />
<riaControls:DomainDataSource Name="ExampleSource" QueryName="GetExampleQuery" AutoLoad="True">
<riaControls:DomainDataSource.FilterDescriptors>
<riaControls:FilterDescriptor PropertyPath="title"
Operator="Contains" Value="{Binding Text, ElementName=filterTextBox}">
</riaControls:FilterDescriptor>
</riaControls:DomainDataSource.FilterDescriptors>
<riaControls:DomainDataSource.DomainContext>
<domain:ExampleDataContext />
</riaControls:DomainDataSource.DomainContext>
</riaControls:DomainDataSource>
Hey guys, this morning (yeah, beginning 7.00) I tried to implement what seemed to be quite an easy task: Dragging files out of my app onto the desktop or into an open explorer Window.
It’s not quite easy. So let’s start this small tutorial. First (of course) you create an ListView – let’s call it “FileView”.
<ListView x:Name="FileView"
PreviewMouseLeftButtonDown="FileView_PreviewMouseLeftButtonDown"
MouseMove="FileView_MouseMove">
<ListView.View>
<GridView>
<!-- Put in here whatever you need -->
<GridViewColumn Header="Name" CellTemplate="{StaticResource file}" />
</GridView>
</ListView.View>
</ListView>
Now to the code behind the xaml. You might have noticed that I added two events to the ListView. The PreviewMouseLeftButtonDown (the dragging starts) and the MouseMove (the dragging is happening).
private Point start;
private void FileView_PreviewMouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
this.start = e.GetPosition(null);
}
private void FileView_MouseMove(object sender, MouseEventArgs e)
{
Point mpos = e.GetPosition(null);
Vector diff = this.start - mpos;
if (e.LeftButton == MouseButtonState.Pressed &&
Math.Abs(diff.X) > SystemParameters.MinimumHorizontalDragDistance &&
Math.Abs(diff.Y) > SystemParameters.MinimumVerticalDragDistance)
{
if (this.FileView.SelectedItems.Count == 0)
{
return;
}
// right about here you get the file urls of the selected items.
// should be quite easy, if not, ask.
//string[] files = ...;
string dataFormat = DataFormats.FileDrop;
DataObject dataObject = new DataObject(dataFormat, files);
DragDrop.DoDragDrop(this.FileView, dataObject, DragDropEffects.Copy);
}
}
Now that’s that, thanks for reading.
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + fileName + ";" + "Extended Properties=Excel 8.0;";
string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=" + fileName + ";" +
"Extended Properties=Excel 12.0;";
using System.Data.OleDb;
using System.Data.OleDb;
namespace Examples.Data
{
class ExcelAdapter
{
private OleDbDataAdapter dataAdapter;
private DataSet dataSet;
private DataTable dataTable;
private String fileName;
public ExcelAdapter(String fileName)
{
this.Load(fileName);
this.fileName = fileName;
}
public void Reload()
{
this.Load(this.fileName);
}
private List Load(String fileName)
{
string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=" + fileName + ";" +
"Extended Properties=Excel 12.0;";
this.dataAdapter = new OleDbDataAdapter("SELECT * FROM [Blonskij$]", connectionString);
this.dataSet = new DataSet();
this.dataAdapter.Fill(this.dataSet, "ExcelInfo");
this.dataTable = this.dataSet.Tables["ExcelInfo"];
foreach (DataRow row in this.dataTable.AsEnumerable())
{
}
return new List();
}
}}
this.dataAdapter = new OleDbDataAdapter("SELECT * FROM [MySheet$]", connectionString);