Forbindelse til SQL Server

http://www.codeproject.com/useritems/sql_in_csharp.asp
http://www.csharphelp.com/archives/archive103.html
http://www.codeproject.com/books/1861005563_10.asp

Snowball

Du gør blot sådan her:

public DataSet Query(string query)
{
    OdbcConnection conn = new OdbcConnection("Driver={SQL Server};SERVER=localhost;UID=root;PWD=;DATABASE=test");
    OdbcDataAdapter adapter = new OdbcDataAdapter(query, conn);
    DataSet ds = new DataSet();
    adapter.Fill(ds, table);
    return ds;
}

//>Rune

http://www.connectionstrings.com/




Standard Security:
"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
  - or -
"Server=Aron1;Database=pubs;User ID=sa;Password=asdasd;Trusted_Connection=False"
(both connection strings produces the same result)


Trusted Connection:
"Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
  - or -
"Server=Aron1;Database=pubs;Trusted_Connection=True;"
  (booth connection strings produces the same result)

(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)


Connect via an IP address:
"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))


Declare the SqlConnection:

C#:
using System.Data.SqlClient;
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString="my connectionstring";
oSQLConn.Open();

Jeg takker for points. Elsker cut&paste.