Author: Evgeni

I’ll be working with Sharepoint 2010 for the next few months, so will have quite a few of sharepoint-related notes in a near future.

Anyways, if you need to check which connection string sharepoint is using to connect to db, open regedit, and go to

HKEY_LOCAL_MACHINESOFTWAREMicrosoftShared ToolsWeb Server Extensions14.0SecureConfigDB

 – you’ll find it in dsn key.

Dapper doesn’ t read return values from stored proc, so this

CREATE PROC MyProc
AS
-- code....
return 1;

and then

int success = connection.Query<int>("MyProc", parameters, commandType: CommandType.StoredProcedure).First();

will fail, because nothing is actually returned.

As a fix, instead of returning value select it:

CREATE PROC MyProc
AS
-- code....
select 1;

Make sure the build target is compatible between importing/imported projects.

I had one of the projects set to Mixed, and another to Any CPU. Setting them both to Any CPU fixed the problem.

.. except for InitializeComponent.

That was a quick wtf moment when I moved a method from a WPF app to a class library project.

Adding a reference to PresentationFramework helps. You’ll also need references to PresentationCore,  System.Xaml and WindowsBase.

Took me a while to figure this out.

So I’m adding a context menu to rows of DataGrid.

This is the markup (taken from SavePoint):

<DataGrid Name="dgSavePoints" HorizontalAlignment="Stretch" VerticalAlignment="Stretch" Grid.Row="1"

	  AutoGenerateColumns="False" ItemsSource="{Binding SavePoints}"

	  AlternatingRowBackground="GhostWhite"  AlternationCount="2" IsReadOnly="True" SelectionMode="Single" Margin="5" KeyUp="dgSavePoints_KeyUp">

	<DataGrid.Resources>

		<ContextMenu x:Key="DataRowContextMenu">

			<MenuItem Name="mnuRestore" Header="Restore"  Click="mnuRestore_Click" >

				<MenuItem.Icon >

					<Image Source="/SavePoint;component/Images/Restore.png" Width="20" Height="20"></Image>

				</MenuItem.Icon>

			</MenuItem>

			<MenuItem Name="mnuDelete"  Header="Delete" Click="mnuDelete_Click" >

				<MenuItem.Icon >

					<Image Source="/SavePoint;component/Images/Delete.png" Width="20" Height="20"></Image>

				</MenuItem.Icon>

			</MenuItem>

			<MenuItem  Name="mnuDeleteAll" Header="Delete all" Click="mnuDeleteAll_Click" >

				<MenuItem.Icon >

					<Image Source="/SavePoint;component/Images/DeleteAll.png" Width="20" Height="20" ></Image>

				</MenuItem.Icon>

			</MenuItem>

		</ContextMenu>

	</DataGrid.Resources>



	<DataGrid.RowStyle>

		<Style TargetType="{x:Type DataGridRow}" x:Name="styleForDataRow">

			<Setter Property="ContextMenu" Value="{StaticResource DataRowContextMenu}">

			</Setter>

		</Style>

	</DataGrid.RowStyle>



	<DataGrid.Columns>

		<DataGridTextColumn Header="Document" Binding="{Binding DocumentRelativePath}" Width="auto"></DataGridTextColumn>

		<DataGridTextColumn Header="Project" Binding="{Binding ProjectName}" Width="auto"></DataGridTextColumn>

		<DataGridTextColumn Header="Date Saved" Binding="{Binding DateSaved, StringFormat=d MMM yyyy HH:mm:ss}" Width="auto"></DataGridTextColumn>

		<DataGridTextColumn Header="Description" Binding="{Binding Description}" Width="*"></DataGridTextColumn>

	</DataGrid.Columns>

</DataGrid>