Dim DSNWind As DataSet
Dim CNnwind As New SqlClient.SqlConnection("DATA SOURCE=servername;USER ID=;PASSWORD=;INITIAL CATALOG=northwind;") '<==== CHANGE HERE
Dim DACustomers As New SqlClient.SqlDataAdapter("SELECT CustomerID, CompanyName, ContactName, Country FROM customers WHERE country = 'Germany'", CNnwind)
Dim DAOrders As New SqlClient.SqlDataAdapter("SELECT CustomerID, OrderID, OrderDate, ShippedDate, ShipVia, Freight FROM orders where customerid in (select customerid from customers where country = 'Germany')", CNnwind)
Dim DAOrderDetails As New SqlClient.SqlDataAdapter("Select * from [Order Details] where OrderID in (SELECT OrderID FROM orders where customerid in (select customerid from customers where country = 'Germany'))",...
Leggi il seguito »
Riempire una treeview da un dataset
Informazioni sullo Schema
19 gennaio 2008 - Fonte: http://addshare.blogspot.com/
In ADO.NET 2.0 per recuperare informazioni dello schema da un oggetto SqlConnection è estremamente semplice, grazie all'uso del metodo GetSchema:
1: Imports System.Data
2: Imports System.Data.SqlClient
3: .....4: Dim connectionSQL As String = "Data Source=.;Initial Catalog=aspnetdb;Integrated Security=True"
5: ...
Leggi il seguito »
Funzione per riempire una treeview da un dataset
17 gennaio 2008 - Fonte: http://ilpas.blogspot.com/
Dim DSNWind As DataSet
Dim CNnwind As New SqlClient.SqlConnection("DATA SOURCE=servername;USER ID=;PASSWORD=;INITIAL CATALOG=northwind;")
Dim DACustomers As New SqlClient.SqlDataAdapter("SELECT CustomerID, CompanyName, ContactName, Country FROM customers WHERE country = 'Germany'", CNnwind)
Dim DAOrders As New SqlClient.SqlDataAdapter("SELECT CustomerID, OrderID, OrderDate, ShippedDate, ShipVia, Freight FROM orders where customerid in (select customerid from customers where country = 'Germany')", CNnwind)
Dim DAOrderDetails As New SqlClient.SqlDataAdapter("Select * from [Order Details] where OrderID in (SELECT OrderID FROM orders where customerid in (select customerid from customers where country = 'Germany'))", CNnwind)
DSNWind = New...
Leggi il seguito »
Dim CNnwind As New SqlClient.SqlConnection("DATA SOURCE=servername;USER ID=;PASSWORD=;INITIAL CATALOG=northwind;")
Dim DACustomers As New SqlClient.SqlDataAdapter("SELECT CustomerID, CompanyName, ContactName, Country FROM customers WHERE country = 'Germany'", CNnwind)
Dim DAOrders As New SqlClient.SqlDataAdapter("SELECT CustomerID, OrderID, OrderDate, ShippedDate, ShipVia, Freight FROM orders where customerid in (select customerid from customers where country = 'Germany')", CNnwind)
Dim DAOrderDetails As New SqlClient.SqlDataAdapter("Select * from [Order Details] where OrderID in (SELECT OrderID FROM orders where customerid in (select customerid from customers where country = 'Germany'))", CNnwind)
DSNWind = New...
Leggi il seguito »
Mac OS X: Come connettersi ad un server remoto Windows
21 settembre 2007 - Fonte: http://www.space4tutorial.com
Girovando su Internet, mi domandavo dove poter recuperare un client VNC per connettermi ad un server remoto Windows… e casualmente capito sul sito Mactopia della Microzozz (aahhhh……) e a ben vedere, quando i cugini di Redmond si affacciano sul mondo Mac, iniziano anche loro a produrre software fatto bene, anche se non aggiornato con una certa frequenza (non a caso stiamo parlando di Microsoft, quindi è tutto normale 
.
Cliccando nella sezione ...
Leggi il seguito »
