Skip to content

Instantly share code, notes, and snippets.

@NickersF
Created May 21, 2021 01:06
Show Gist options
  • Save NickersF/483af110f2988ac16cc496ab1c55d2a7 to your computer and use it in GitHub Desktop.
Save NickersF/483af110f2988ac16cc496ab1c55d2a7 to your computer and use it in GitHub Desktop.
ADO.NET SQL Server connection
private string connectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=WPF_Data;Integrated Security=True;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
string SQL_SELECT = "SELECT * Data_Table";
SqlConnection conn = new SqlConnection(connectionString);
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand sql = conn.CreateCommand();
sql.CommandText = SQL_SELECT;
da.SelectCommand = sql;
DataSet ds = new DataSet();
da.Fill(ds);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment