Configuration database:
Connection string: server= Pinchamp \\sqlexpress;database=db_test; Trusted_connection=true
Connection code:
Using system;using system.collections.generic;using system.data.sqlclient;using system.linq;using System.Text;using System.threading.tasks;namespace sqltest{ class program { static void Main (string[] args) { // Connection database String connection = "server= Pinchamp \\sqlexpress;database=db_test; Trusted_connection=true "; SqlConnection sc = new SqlConnection (); Sc. ConnectionString = connection; Try { sc. Open (); Console.WriteLine ("Already Open database connection!"); } catch (Exception ex) { Console.WriteLine ("Open database error: {0}", ex. Message); } Finally { sc. Close (); Console.WriteLine ("Database connection closed!"); System.Console.ReadLine ();}}}
Connection Result:
Copyright notice: This article blog original article. Blogs, without consent, may not be reproduced.
ADO 2-Successfully connected to database---Shinepans