Skip to main content

Connecting to MSSQL 2005 Server with VB.net

Connecting to MSSQL Server with VB.net is fairly easy. Just follow the steps below:



1. Create a database in MSSQL Server 2005 (I'm using MSSQL Server Express 2005).
I've created the following database structure:

Database Name: Pawnshop Table: Jewelry Fields: Id Name Type

I filled it up with the following values:

Id Name Type
1 Gold Necklace Necklace
2 Gold Watch Watch
3 Gold Earrings Earrings
4 Silver Bullet Bullet
5 Silver Dust Dust
6 Gold Coin Coin
7 Bronze Medal Medal
8 Bronze bracelet Bracelet
9 Aluminum Foil Foil
10 Gold Ring Ring


2. Create a new VB.net Project
3. Add a DataGridView to the form
4. Double Click on the Form and Replace all codes with the following (my server ip address is 192.168.2.2. Replace with your own ip address. replace the user and password accordingly):

Imports System.Data.SqlClient

Public Class Form1
Dim cn As New SqlConnection("Data Source=192.168.2.2\SQLEXPRESS;Initial Catalog=Pawnshop;User Id=sa;Password=password;")
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
cn.Open()
Dim cmd As New SqlCommand("select * from Jewelry", cn)
Dim adp As New SqlDataAdapter(cmd)
Dim dt As New DataTable()
adp.Fill(dt)
DataGridView1.DataSource = dt
End Sub
End Class

5. Run the program


You can download the source code and database here.


Connect to the best online keno and blackjack games, and try out roulette online at CasinoBonus.org!
Labels:

Comments

daspeac said…
Hi fiShBoN3, you may also try the foxpro dbf repair program, it automates the procedure of database recovery, if something goes wrong
November 16, 2009 at 5:24 AM
Unknown said…
Hi Dmitry, do you mean the recover corrupted sql system database in 2005 utility? I have tried several ways to restore affected databases and I have completely lost in these solutions
December 1, 2009 at 5:05 AM
Post a Comment

Popular posts from this blog

How to register a business name

Attending business summits and conferences is a big help to those who belong to the quite "techy" (technological or technical) industry. Being a graduate of one, I had less knowledge in the field of entrepreneurship. Enrolling myself in business administration gave me quite the knowledge to be a part of the business world and thus improve my entrepreneurial skills. I now would like to share this information that I got familiar with (and I managed to get a copy of the entire process from the 6th Mindanao ICT Congress): How to Register a Business Name (in the Philippines) ----------------------------------------------------------------------------------------------- SINGLE PROPRIETORSHIP Applicant must secure 2 copies of registration form and pay Php 300.00 (rate may change) for single proprietorship registration processing fee. The registration shall be valid for five (5) years. A surcharge of Php 100.00 is imposed if renewal is filed beyond the three (3) month grace period, c...
6 comments
Read more

Adding a Footer to the DataGridView component

I have been searching for sites and forums that would give me a any hint on having a footer on the .net DataGridView control. It was frustrating. I found some, but not what I was looking for. I use windows forms. It would have been easier if I was into web. I decided to create one for myself. It's not complete, but it works with me. It needs improvement and I hope that some programmers who might pass through this blog will help me with it :D. Limitations: Cannot set Footer values during design time. Can sometimes hide a row when scrolled to the last item in the grid. What I did was just create a user control that inherits the DataGridView control and add a StatusStrip to act as the footer. public partial class MyDataGridView : DataGridView { public StatusStrip Footer { get { return (StatusStrip)this.Controls["Footer"]; } } private bool _footerVisible; [Browsable(false)] /// /// Sets or Gets the va...
1 comment
Read more

Using Crystal Reports 10 with C#.net and Firebird

C# express doesn't include a report designer or viewer. Reports however, is very much needed when creating a business software. Since C# express doesn't include a report designer, we need to find other means. One is to use a free report such as MyNeoReport. This however may not work under many circumstances. The other alternative would be to use a proven report engine and designer-Crystal Report. Crystal Report has been used by many developers (in our city). However, using a free programming language and IDE, and a free database is very limiting. Not much information can be gathered on the net either (with regards to reporting as of this writing). Here's a way to use Crystal Reports using Firebird database and C# Express as software development IDE: Pre-requisites: C# Express 2005 EMS SQL Manager 2005 for InterBase & Firebird Lite Crystal Reports 10 Create the following database: Name: TestDB1 Tables: TESTTABLE1 Columns:  ID - PK, INTEGER,AUTOINCREMENT DES...
6 comments
Read more