Guest User

Untitled

a guest
Jun 23rd, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.74 KB | None | 0 0
  1. <?xml version="1.0" encoding="utf-8" ?>
  2. <configuration>
  3. <connectionStrings>
  4. <add name="CONSTRING" connectionString="Data Source=SQL-PC;Initial Catalog=DATABASE;Integrated Security=True"/>
  5. </connectionStrings>
  6. </configuration>
  7.  
  8. using System.Windows.Forms;
  9. using System.Data.SqlClient;
  10. using System.Configuration;
  11.  
  12. namespace Sample {
  13. public partial class Sample: Form
  14. {
  15. public string conn = ConfigurationManager.ConnectionStrings["CONSTRING"].ConnectionString;
  16. }
  17.  
  18. var conString =System.Configuration.ConfigurationManager.ConnectionStrings["connectionStringName"];
  19. string strConnString = conString.ConnectionString;
  20. SqlConnection con = new SqlConnection(strConnString);
  21. SqlCommand cmd = new SqlCommand(String.Format("SELECT * FROM Table;"), con);
  22. con.Open();
  23. SqlDataReader reader = cmd.ExecuteReader();
  24.  
  25. <connectionStrings>
  26. <add name="DefaultConnection" connectionString="Data Source=(localdb)v11.0;Initial Catalog=database;Integrated Security=True; MultipleActiveResultSets=True"
  27. providerName="System.Data.SqlClient" />
  28. </connectionStrings>
  29.  
  30. static string ConStr = "Data Source=DataSourceName;Initial Catalog=DatabaseName;Integrated Security=True";
  31. SqlConnection con = new SqlConnection(ConStr);
  32.  
  33. using System.Configuration;
  34.  
  35. var conString = System.Configuration.ConfigurationManager.ConnectionStrings["CONSTRING"];
  36. string strConnString = conString.ConnectionString;
  37. SqlConnection con = new SqlConnection(strConnString);
  38.  
  39. <connectionStrings>
  40. <add name="CONSTRING" connectionString="Data Source=MONAIT-PC;Initial Catalog=CMS;Integrated Security=True" providerName="System.Data.SqlClient"/>
  41.  
  42. </connectionStrings>
  43.  
  44. ***{Sql Server Authentication}***
  45.  
  46. ***{Windows Server Authentication}***
Add Comment
Please, Sign In to add comment