C # link SQL and Access database statements

1. SQL database:

1.1, LINK data statement: server=localhost;database=data; uid=sa;pwd=123; Or

Data Source=localhost;database=data; Uid=sa; pwd=123;

1.2. Code Link Database:

SqlConnectionStringBuilder Csbuilder = new SqlConnectionStringBuilder ();

Csbuilder. DataSource = "localhost";//sql link Instance

Csbuilder. InitialCatalog = "data";//Database name

Csbuilder. UserID = "sa";//user ID of linked data

Csbuilder. Password = "123";//user password

2. Number of Access Links:

1.1. LINK Data statement:

Provider=Microsoft.Jet.OLEDB.4.0;Data source=| Datadirectory|\news.mdb

1.2. Code Link Database:

Oledbconnectionstringbuilder olestring = new Oledbconnectionstringbuilder ();

Olestring.provider = "Microsoft.Jet.OLEDB.4.0";

Olestring.datasource = "News.mdb";