November 21st, 2008
I decided that it would be fun to automate the creation of good history tables since that is something that many people leave until the end, or skip all together. I am going to start with a simple case and try to push through into Triggers and automatic Stored Procedure creation. To begin with, let’s take a look at the sp_help command and it’s results. sp_help is useful in looking at the details of objects, user defined types, and sql types. I am using the SQL Server Books Online from MSDN (http://doc.ddart.net/mssql/sql70/sp_help.htm) for reference.
A call to sp_help with no arguments will return a list of all objects, their owner, and their type. For example, calling sp_help on the master database of a SQLExpress returns 1831 rows, beginning with:
I will be ignoring the second table for the foreseeable future, and concentrating on the first. I am going through the top list and getting the information about all ‘user table’ rows and presenting it in a ListBox. To help accomplish this, I have created a class SP_HelpResults with a constructor that accepts a DataSet. It then uses the number of tables returned along with the column names to determine what type of results the DataSet represents and parses it into usable objects. Once I have the objects describing an individual table, I will begin constructing the new table and Triggers. I will publish more details as the project continues.
Posted in Programming | No Comments »
November 20th, 2008
http://www.microsoft.com/iplicensing/productDetail.aspx?productTitle=Detours
Posted in Programming | No Comments »
November 20th, 2008
Community Clips is a pretty neat project from Microsoft Office Labs that allows users to create video tutorials and upload them. The Community Clips Recorder is free to use to create your videos and the videos created by it can be uploaded anywhere.
Posted in Programming, Links | No Comments »
September 20th, 2008
So this is a little off topic for me, but I have been following stackoverflow for a while and just answered a question on this topic and thought I might as well get some use out of the screen shot.
The method I describe is server-side. There is probably a cool client side javascript hack that also be done, but I tend to think server-side so here it is.
The Page_Load event handler is called with every postback. So I propose adding logic in it to compare the currently selected value to the value stored in the last SelectedNodeChanged event handler.
Here is the screen shot:
Here is the HTML:
HTML:
-
<form id="form1" runat="server">
-
-
<asp:TreeView ID="TreeView1" runat="server" OnSelectedNodeChanged="TreeView1_SelectedNodeChanged"
-
ShowLines="True">
-
<Nodes>
-
<asp:TreeNode Text="Root" Value="Root">
-
<asp:TreeNode Text="RootSub1" Value="RootSub1"></asp:TreeNode>
-
<asp:TreeNode Text="RootSub2" Value="RootSub2"></asp:TreeNode>
-
</asp:TreeNode>
-
<asp:TreeNode Text="Root2" Value="Root2">
-
<asp:TreeNode Text="Root2Sub1" Value="Root2Sub1">
-
<asp:TreeNode Text="Root2Sub1Sub1" Value="Root2Sub1Sub1"></asp:TreeNode>
-
</asp:TreeNode>
-
<asp:TreeNode Text="Root2Sub2" Value="Root2Sub2"></asp:TreeNode>
-
</asp:TreeNode>
-
</Nodes>
-
</asp:TreeView>
-
<asp:Label ID="Label1" runat="server" Text="Selected"></asp:Label>
-
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
-
<asp:Label ID="Label2" runat="server" Text="Label"></asp:Label></div>
-
</form>
and here is the C#:
C#:
-
protected void Page_Load(object sender, EventArgs e)
-
{
-
if(TreeView1.SelectedNode!=null && this.TextBox1.Text == TreeView1.SelectedNode.Value.ToString())
-
{
-
Label2.Text = (int.Parse(Label2.Text) + 1).ToString();
-
}
-
else
-
{
-
Label2.Text = "0";
-
}
-
}
-
protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
-
{
-
this.TextBox1.Text = TreeView1.SelectedNode.Value.ToString();
-
}
Posted in Programming | No Comments »