vb.net connection.open

[Bardamù]

Ciao a tutti, come posso aprire una connessione ado in modo tale da poter scrivere nel db?
Graziescri

[Jc_]

questa su SqlServer 2000

		/// <summary>
		/// Connessione database Release
		/// </summary>
		/// <returns>SqlConnection</returns>
		public System.Data.SqlClient.SqlConnection ReleaseConnection()
		{
			System.Data.SqlClient.SqlConnection testConn = new System.Data.SqlClient.SqlConnection();
			testConn.ConnectionString = "Data Source=<ip>;Initial Catalog=<db>;User Id=<username>;Password=<password>;";
			if (testConn.State != System.Data.ConnectionState.Open)
			{
				testConn.Open();
			}
			return testConn;
		}