Gapper

connection string

cnn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ChessnutsDB;Data Source=GAPPER;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=GAPPER;Use Encryption for Data=False;Tag with column collation when possible=False"

*
keeps returning

An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll

Additional information: Keyword not supported: 'provider'.
*
whats the problem

new User(Kevin.Parkinson)

public void CreateSqlConnection() 
 {
    SqlConnection myConnection = new SqlConnection();
    myConnection.ConnectionString = "Persist Security Info=False;"
          + "Integrated Security=SSPI;database=northwind;"
          + "server=mySQLServer;Connect Timeout=30";
    myConnection.Open();
 }

__________________

Bharathi

Hi,


To retrieve data from the database using Data Reader and Data Commands. When this code is executed, the data in a database is displayed in two textbox controls.

Preparation:

Design a form using .NET environment and place two textbox controls on a form.
Design and create a table using SQL Server 2000.

Name the Database as FinAccounting.
Name the Table as AccountsTable.
Name the form as Form1
Name the controls on the form as Textbox1 and Textbox2.

Tasks:

1. Establish the connection with the Database using Connection object.
2. Execute the command.
3. The data will be read by the Datareader object and the contents of the first record is displayed in the textboxes.

Imports System.Data.SqlClient
Public Class Form1
Inherits System.Windows.Forms.Form
Dim str_sql_user_select As String = “SELECT * FROM AccountsTable”
Dim str_connection As String = “Data Source=VSDOTNET;Integrated Security=SSPI;Initial Catalog=FinAccounting”
Dim mycon As SqlConnection
Dim comUserSelect As SqlCommand
Dim myreader As SqlDataReader

Private Sub Form1_Load(ByVal sender As Object, ByVal e As system.EventArgs) Handles
MyBase.Load
mycon = New SqlConnection(str_connection)
‘Instantiate the commands
comUserSelect = New SqlCommand(str_sql_user_select, mycon)
TextBox1.Text = “ “
TextBox2.Text = “ “
mycon.Open()
myreader = comUserSelect.ExecuteReader
If (myreader.Read = True) Then
TextBox1.Text = myreader(0)
TextBox2.Text = myreader(1)
Else
MsgBox(“You have reached eof”)
End If
End Sub
End Class

This code works for Vb.net.

Log on to : http://www.vkinfotek.com

Application Series Books teach the reader how to develop an accounting package for a client server network. These books also teach all the secrets and logics required to develop an accounting package.