select from a sql database

Hi,
i am trying to run this program, but it sends error:

No controled exception of type: 'System.Data.SqlClient.SqlException' in system.data.dll
additional info: system error

i am using visual studio 2003 and sql server 2000

what can i do to solve this?

thanks...

Imports System
Imports System.Data
Imports System.Windows.Forms
Imports System.Data.SqlClient

Public Class Form1
Inherits System.Windows.Forms.Form

#Region " Windows Form Designer generated code "

Public Sub New()
MyBase.New()

'This call is required by the Windows Form Designer.
InitializeComponent()

'Add any initialization after the InitializeComponent() call

End Sub


Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
If disposing Then
If Not (components Is Nothing) Then
components.Dispose()
End If
End If
MyBase.Dispose(disposing)
End Sub


Private components As System.ComponentModel.IContainer

'NOTE: The following procedure is required by the Windows Form Designer
'It can be modified using the Windows Form Designer.
'Do not modify it using the code editor.
Friend WithEvents TextBox1 As System.Windows.Forms.TextBox
Friend WithEvents TextBox2 As System.Windows.Forms.TextBox
Friend WithEvents DataSet1 As System.Data.DataSet
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
Me.TextBox1 = New System.Windows.Forms.TextBox
Me.TextBox2 = New System.Windows.Forms.TextBox
Me.DataSet1 = New System.Data.DataSet
CType(Me.DataSet1, System.ComponentModel.ISupportInitialize).BeginInit()
Me.SuspendLayout()
'
'TextBox1
'
Me.TextBox1.Location = New System.Drawing.Point(8, 8)
Me.TextBox1.Name = "TextBox1"
Me.TextBox1.Size = New System.Drawing.Size(200, 20)
Me.TextBox1.TabIndex = 0
Me.TextBox1.Text = "TextBox1"
'
'TextBox2
'
Me.TextBox2.Location = New System.Drawing.Point(8, 32)
Me.TextBox2.Name = "TextBox2"
Me.TextBox2.Size = New System.Drawing.Size(200, 20)
Me.TextBox2.TabIndex = 1
Me.TextBox2.Text = "TextBox2"
'
'DataSet1
'
Me.DataSet1.DataSetName = "NewDataSet"
Me.DataSet1.Locale = New System.Globalization.CultureInfo("en-GB")
'
'Form1
'
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
Me.ClientSize = New System.Drawing.Size(216, 61)
Me.Controls.Add(Me.TextBox2)
Me.Controls.Add(Me.TextBox1)
Me.Name = "Form1"
Me.Text = "Form1"
CType(Me.DataSet1, System.ComponentModel.ISupportInitialize).EndInit()
Me.ResumeLayout(False)

End Sub

#End Region

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim thisConnection As New SqlConnection _
("server=(local)\SQLEXPRESS;" & _
"integrated security=sspi;" & _
"database=MyDatabase")


Dim sql As String = _
"SELECT * FROM Employee"


Dim da As New SqlDataAdapter(sql, thisConnection)


da.Fill(DataSet1, "Employee")
Dim dt As DataTable = DataSet1.Tables("Employee")


Dim dv As New DataView(dt, _
"ID='1'", "FirstName", _
DataViewRowState.CurrentRows)


TextBox1.DataBindings.Add("text", dv, "FirstName")


TextBox2.DataBindings.Add("text", dv, "LastName")
End Sub
End Class
[4255 byte] By [derok] at [2007-11-20 11:51:27]
# 1 Re: select from a sql database
I found this: Prolly VS 2005 though

Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind")

Dim selectCMD As SqlCommand = New SqlCommand("SELECT CustomerID, CompanyName FROM Customers", nwindConn)
selectCMD.CommandTimeout = 30

Dim custDA As SqlDataAdapter = New SqlDataAdapter
custDA.SelectCommand = selectCMD

nwindConn.Open()

Dim custDS As DataSet = New DataSet
custDA.Fill(custDS, "Customers")

nwindConn.Close()
dglienna at 2007-11-10 3:08:12 >
# 2 Re: select from a sql database
i inserted that code in a button click, and i get this error:

No controled exception of type: 'System.Data.SqlClient.SqlException' in system.data.dll
additional info: system error

and pointing at:
nwindConn.Open()

is there something else i have to configure in my visual basic .net or in my database configuration in Windows?

what can i do?

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind")

Dim selectCMD As SqlCommand = New SqlCommand("SELECT CustomerID, CompanyName FROM Customers", nwindConn)
selectCMD.CommandTimeout = 30

Dim custDA As SqlDataAdapter = New SqlDataAdapter
custDA.SelectCommand = selectCMD

nwindConn.Open()

Dim custDS As DataSet = New DataSet
custDA.Fill(custDS, "Customers")

nwindConn.Close()
End Sub
derok at 2007-11-10 3:09:12 >
# 3 Re: select from a sql database
The first thing you should be doing is adding a Try...Catch block to handle the exception. The next thing you should be doing is interrogating the SqlException object to get as much information as you can about what happened. To see what members the SqlException class has you (wait for it) read the MSDN documentation for that class. Once you're armed with all the information the system is trying to give you, then you can make an informed determination of what's causing the issue.
jmcilhinney at 2007-11-10 3:10:13 >
# 4 Re: select from a sql database
The next thing you should be doing is interrogating the SqlException object to get as much information as you can about what happened.

i did the try catch

Catch instance As SqlException

End Try

but,

how do i interrogate the sqlexception object?
derok at 2007-11-10 3:11:19 >
# 5 Re: select from a sql database
You did change this part?

Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind")
dglienna at 2007-11-10 3:12:18 >
# 6 Re: select from a sql database
You did change this part?

Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind")

yes
derok at 2007-11-10 3:13:11 >
# 7 Re: select from a sql database
i did this console application:

it is oriented in the same issue, i did the exceptions, and this is what it sended me:

Index #0
Error: System.Data.SqlClient.SqlError: The server SQL Server does not exist or the access has been denied.

what can i do?

Imports System
Imports System.Xml
Imports System.Xml.Schema
Imports System.IO
Imports System.Data.OleDb
Imports System.Collections
Imports System.Data

Imports System.Data.SqlClient

Module Module1

Sub Main()
Try
Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind")

Dim selectCMD As SqlCommand = New SqlCommand("SELECT CustomerID, CompanyName FROM Customers", nwindConn)
selectCMD.CommandTimeout = 30

Dim custDA As SqlDataAdapter = New SqlDataAdapter
custDA.SelectCommand = selectCMD

nwindConn.Open()

Dim custDS As DataSet = New DataSet
custDA.Fill(custDS, "Customers")

nwindConn.Close()
Catch ex As SqlException
DisplaySqlErrors(ex)
End Try

End Sub

Private Sub DisplaySqlErrors(ByVal exception As SqlException)
Dim i As Integer

For i = 0 To exception.Errors.Count - 1
Console.WriteLine("Index #" & i & ControlChars.NewLine & _
"Error: " & exception.Errors(i).ToString() & ControlChars.NewLine)
Next i
Console.ReadLine()
End Sub

End Module
derok at 2007-11-10 3:14:15 >
# 8 Re: select from a sql database
ok, i had to change this line:

Data Source=localhost
to
Data Source=.

thanks for the help
derok at 2007-11-10 3:15:18 >