SETHA SITE INFORMATION

This article shows you how to create Class Bike in Visual Basic 2008. You will know how to:

• Create Class in Visual Basic .Net and its Methods
• Use objects and its methods that create from the defined class
• Use Microsoft.VisualBasic.PowerPacks Namespace
• Draw Bike using any Shapes such as Circle, Line, Rectangle
• Basic concept of Object-Oriented Programming
• Use Timer Class to animate objects bike

Download Source Code Here

This article shows you Visual Basic .Net 2008 code to open file location.

Shell("explorer.exe /select, " & Me.txtFile.Text, AppWinStyle.NormalFocus, True, 20)

Download Source Code Here

This article consists of video clips that guide you to create Crystal Report for Visual Basic 2008 using ADO.Net data source and Microsoft Access Database.
 
Video Clip Part 1

 
Video Clip Part 2

Download Source Code Here

This article describes about how to insert Unicode data into SQL Server 2000.

• Take not that fields to be stored Unicode data in SQL Server Table must be nvarchar, nchar, or ntext
• Choose Latin1_General_BIN for Collation property of each Unicode field (see image below)
  
  
• Assume that we have one SQL Server table as below:
  Student (stdid: int, lastname: nvarchar(50), firstname: nvarchar(50))
• Write Visual Basic .Net 2008 Code as below:
  

  Dim cn As New OleDb.OleDbConnection
          cn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI; " & _
                                  "Data Source=.; " & _
                                  " Persist Security Info=False; Initial Catalog=Test"
          cn.Open()
  
          Dim cmd As New OleDb.OleDbCommand
          cmd.Connection = cn
          cmd.CommandText = "INSERT INTO student(stdid, lastname, firstname) " & _
                          " VALUES(" & Me.txtID.Text & "," & _
                          "N'" & Me.txtLastName.Text & "'," & _
                          "N'" & Me.txtFirstName.Text & "')"
          cmd.ExecuteNonQuery()
  
          cn.Close()