IT and business subjects
30-May-1414 Leave a comment
28-May-1414 Leave a comment
This is the use of the Visual Studio connection dialog in your own projects, for instance tool kits to inspect databases. Steps are:
Imports Microsoft.Data.ConnectionUI
Private Sub GetDataConnection()
Dim dcd As New DataConnectionDialog
DataSource.AddStandardDataSources(dcd)
dcd.SelectedDataSource = DataSource.SqlDataSource
If DataConnectionDialog.Show(dcd) = Windows.Forms.DialogResult.OK Then
Select Case dcd.SelectedDataProvider.Name
Case DataProvider.SqlDataProvider.Name
Dim cn As New SqlClient.SqlConnection(dcd.ConnectionString)
DataSourceToolStripTextBox.Text = cn.DataSource
DatabaseDefaultToolStripTextBox.Text = cn.Database
'MessageBox.Show(String.Concat("Found SQL: ", cn.ConnectionString))
Case Else
MessageBox.Show(dcd.ConnectionString)
End Select
End If
End Sub
See also
http://wildermuth.com/2007/1/29/Using_the_Visual_Studio_Connection_String_Dialog
20-May-1414 Leave a comment
Project was on one TFS Server and you want to move it to another. In this case to visualstudio.com
End.
19-May-1414 Leave a comment
Started getting adware underlined hyperlinks on IE today. This directs you to svr123.com and then on to a web advert
With thanks to http://geekvisit.com/remove-double-underlined-adware-rrfilter
Found in services and msconfig and disabled in both
15-May-1414 Leave a comment
<ListBox ItemsSource="{Binding}">
<ListBox.ItemTemplate>
<DataTemplate>
<StackPanel>
<StackPanel Orientation="Horizontal">
<StackPanel.Resources>
<Style TargetType="TextBlock">
<Setter Property="Margin" Value="0, 0, 5, 0" />
</Style>
</StackPanel.Resources>
<TextBlock Text="{Binding Path=ID}" />
<TextBlock Text="{Binding Path=Task1}" />
<TextBlock Text="{Binding Path=PercentComplete}" />
</StackPanel>
<TextBlock Text="Resource names here" Margin="50, 0, 0, 0" />
<!--<TextBlock Text="{Binding Path=ResourceName}" Margin="50, 0, 0, 0" />-->
</StackPanel>
</DataTemplate>
</ListBox.ItemTemplate>
</ListBox>
xmlns:scm="clr-namespace:System.ComponentModel;assembly=WindowsBase"
<CollectionViewSource x:Key="taskViewSource" d:DesignSource="{d:DesignInstance my:Task, CreateList=True}">
<CollectionViewSource.SortDescriptions>
<scm:SortDescription PropertyName="CompleteFlag"
Direction="Descending" />
</CollectionViewSource.SortDescriptions>
</CollectionViewSource>
<ListBox ItemsSource="{Binding}">
<ListBox.Resources>
<Style TargetType="{x:Type ListBoxItem}">
<Style.Triggers>
<DataTrigger Binding="{Binding Path=CompleteFlag}"
Value="True">
<Setter Property="Background"
Value="Yellow" />
</DataTrigger>
</Style.Triggers>
</Style>
</ListBox.Resources>
...
</ListBox>
12-May-1414 Leave a comment
A location for me to add justification notes for upgrade to VS 2013 and MSDN Subscription
07-May-1414 Leave a comment
See also Azure Powershell and Azure VM with SQL
If you have a Pluralsight subscription then they have a good course “Windows Azure Infrastructure as a Service Essentials” then chapter “Storage and Disks” and screen cast “Creating Virtual Hard Disks”
28-Apr-1414 1 Comment
Mixed Authentication Mode is required if logging into the SQL Server from another machine in any case.
So if creating a new VM from the image then start from step 7 above
In the VM > Network and Sharing Center > View your active networks
The network had been set to private – reset to public and it now works again
http://azure.microsoft.com/en-us/documentation/articles/virtual-machines-provision-sql-server/
21-Apr-1414 Leave a comment
With help from book “Learning WCF” by Michele Leroux Bustamante
Notes from working through samples:
Surprisingly it is possible/advisable to host the service from a different project or projects. This gives the possibility of one service to have different types of host running
Run Visual Studio as an administrator
Use Tools > WCF Service Configuration Editor then close it
Then right-click on App.Config and the “Edit WCF configuration” will be there
(Nice to have an easy problem)
With thanks to:
http://forums.iis.net/t/1180915.aspx which led to
http://www.hanselman.com/blog/ASPNET4BreakingChangesAndStuffToBeAwareOf.aspx
If you install ASP.Net 4 and then install IIS then you need to make sure IIS is configured to know about ASP.Net 4 otherwise IIS will have no idea how to run ASP.Net 4 applications.
There’s a simple workaround:
or for future reference, try to enable IIS and the ASP.NET extensibility option *first* when your are building machines or VMs. That way when VS 2010 or .NET are subsequently installed, the installation will automatically detect the presence of IIS and will auto-register with it.
Run without debugging – to do this use Ctrl + F5 or use the Debug menu, but the option may not be there, if you start with a VB IDE. If it is not there then you may add it using customise.
If you run with debugging as usual you will not be able to edit the client.
Error no website with code 500
Not surprised that I had issues with hosting here. I had a WSS Windows SharePoint Services and SharePoint Central Administration using my IIS. Took a while to sort, what follows is not comprehensive, but a guide to what I did. I took the view that I have not used SharePoint Central Administration and so was prepared to sacrifice it. Some steps included:
IIS > Sites > Default Web Site > Right-Click > Edit Bindings.
Remove all bindings except http
Then under Default Web Site I had a folder wss -> Virtual Directories -> 80 -> my sample application landed here. Not sure why.
I removed all SharePoint (80) web sites, hope that is ok. And archived the wss folder in its entirety.
Everything started working again.
C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\WcfTestClient.exe
Useful quick test.
20-Apr-1414 Leave a comment
In unit tests I might want to output the results of a returned list of any type. Instead of writing a new method for each type, here are some techniques with thanks to:
http://stackoverflow.com/questions/9655262/common-method-for-printing-arrays-and-lists-of-any-types
Split is a useful function, here is the reverse Join
int[] actual = new int[] {1,2,3}
string actual = new string[] {“one”, “two”, “three”}
TestContext.WriteLine(string.Join(“, “, actual));
public void PrintCollection<T>(IEnumerable<T> col)
{
foreach (var item in col) TestContext.WriteLine(item);
}
http://msdn.microsoft.com/en-us/library/bwabdf9z(v=vs.110).aspx
[TestMethod()]
publicvoid AListTest()
{
List<string> target = newList<string>();
target.ForEach(PrintCollection2);
}
privatevoid PrintCollection2(string s)
{
TestContext.WriteLine(s);
}
Stephen Shakespeare 