Archive

Archive for July, 2006

Hello World – Python application for Windows with Tk.

July 31st, 2006 No comments


from Tkinter import *
root = Tk()
w=Button(root,text="Pooooooi!")
w.pack()
root.mainloop()

VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Categories: General, OpenSource

VBA – Connect SQL Server from Excel

July 28th, 2006 1 comment
Private Sub CommandButton1_Click()
 
    Set con = CreateObject("adodb.connection")
    Set rs = CreateObject("adodb.recordset")
    con.Open "Provider=sqloledb; Data Source=db-serv;
             Initial Catalog=test; User Id=admin; Password=admin;"
    rs.Open "select *from test2", con
    i = 2
    Do While Not rs.EOF
        Cells(i, 2) = rs("categorie")
        rs.movenext
        i = i + 1
    Loop
    rs.Close
    Set rs = Nothing
    Set con = Nothing
 
End Sub
VN:F [1.9.18_1163]
Rating: 4.8/5 (8 votes cast)
Categories: General, SQL

SQL Query and DOTNET?

July 21st, 2006 No comments

Yes!!! – The LINQ Project – .NET Language Integrated Query

The LINQ Project is a codename for a set of extensions to the .NET Framework that encompass language-integrated query, set, and transform operations. It extends C# and Visual Basic with native language syntax for queries and provides class libraries to take advantage of these capabilities.

http://msdn.microsoft.com/data/ref/linq/

VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Categories: DOTNET, SQL

div and span – visibility example

July 18th, 2006 No comments

This sample code demonstates “hide” and “show” SPAN and DIV tags.

test div

This is a span



VN:F [1.9.18_1163]
Rating: 3.3/5 (4 votes cast)
Categories: Web Design

.NET Framework 3.0 Technologies

July 18th, 2006 No comments

Get more information on the Microsoft .NET Framework version 3.0 (formerly WinFX) technologies, such as Windows Communication Foundation, Windows Presentation Foundation, and Windows Workflow Foundation.

Windows CardSpace (formerly “InfoCard”):
Windows CardSpace (formerly “InfoCard”) is a Microsoft NET Framework 3.0 (formerly WinFX) component that provides the consistent user experience required by the identity metasystem. It is specifically hardened against tampering and spoofing to protect the end user’s digital identities and maintain end-user control.

Source : http://msdn.microsoft.com/winfx/reference/infocard/default.aspx

Windows Communication Foundation
Windows Communication Foundation (formerly code-named “Indigo”) is a set of .NET technologies for building and running connected systems. It is a new breed of communications infrastructure built around the Web services architecture.

Source:http://msdn.microsoft.com/winfx/technologies/communication/

Windows Presentation Foundation:The Microsoft Windows Presentation Foundation (formerly code named “Avalon”) provides the foundation for building applications and high fidelity experiences in Longhorn, blending together application UI, documents, and media content, while exploiting the full power of your computer.

Source: http://msdn.microsoft.com/winfx/reference/presentation/default.aspx

Windows Workflow Foundation:Windows Workflow Foundation is the programming model, engine and tools for quickly building workflow enabled applications on Windows. It consists of a Microsoft NET Framework version 3.0 (formerly WinFX) namespace, an in-process workflow engine, and designers for Visual Studio 2005.

Source: http://msdn.microsoft.com/winfx/reference/workflow/default.aspx

Microsoft .NET Framework 2.0:Find information on Microsoft .NET Framework 2.0 on the .NET Framework Developer Center.

Soruce: http://msdn.microsoft.com/netframework/

VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Categories: DOTNET

Learn .NET Framework 3.0

July 18th, 2006 No comments

The Microsoft .NET Framework 3.0 (formerly WinFX), is the new managed code programming model for Windows. It combines the power of the .NET Framework 2.0 with four new technologies: Windows Presentation Foundation (WPF), Windows Communication Foundation (WCF), Windows Workflow Foundation (WF), and Windows CardSpace (WCS, formerly “InfoCard”). Use the .NET Framework 3.0 today to build applications that have visually compelling user experiences, seamless communication across technology boundaries, the ability to support a wide range of business processes, and an easier way to manage your personal information online. Now the same great WinFX technology you know and love has a new name that identifies it for exactly what it is – the next version of Microsoft’s development framework. This change does not affect the release schedule of the .NET Framework 3.0 or the technologies included as a part of the package.

The .NET Framework 3.0.

More Info: http://msdn.microsoft.com/winfx/learning/

VN:F [1.9.18_1163]
Rating: 4.0/5 (1 vote cast)
Categories: DOTNET

SQL Server CURSOR – loop through records

July 18th, 2006 No comments

This code demonstates how to loop through records with CURSOR?


DECLARE @mycur CURSOR
DECLARE @test VARCHAR(10)

SET @mycur = CURSOR
FOR
SELECT nummer FROM mytable

OPEN @mycur

FETCH NEXT FROM @mycur INTO @test

WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @test -- sample statements
FETCH NEXT FROM @mycur INTO @test
END

DEALLOCATE @mycur

VN:F [1.9.18_1163]
Rating: 4.0/5 (19 votes cast)
Categories: SQL

MONO for Windows?

July 13th, 2006 No comments

Using Mono on Windows

MONO

Mono runs on Windows, this page describes the various features available for users who want to use Mono on Windows as well as using Mono-based technologies on Windows without Mono (like Gtk#).

http://www.mono-project.com/Mono:Windows

VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Categories: DOTNET, News

OpenSource and DOTNET???

July 7th, 2006 No comments

Yes… Here is some Open Source Content Management Systems (CMS) in C#

ndCMS

DocLib
Go.Kryo
Amplefile
nkCMS
Rainbow
Kodai CMS
umbraco
Cuyahoga
mojoPortal

VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Categories: DOTNET, OpenSource

Tips: Rename SQLServer dababase

July 6th, 2006 No comments


sp_renameDb olddbname, newdbname

VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Categories: SQL