Guest User

Untitled

a guest
Jan 21st, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. <connectionStrings>
  2. <add name="FaribaEntities" connectionString="metadata=res://*/Classes.MyWorkShopModel.csdl|res://*/Classes.MyWorkShopModel.ssdl|res://*/Classes.MyWorkShopModel.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Fariba.MDF;Integrated Security=true;User Instance=True;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient"/>
  3. </connectionStrings>
  4.  
  5. string Connection_String= ConfigurationManager.ConnectionStrings["FaribaEntities"].ToString();
  6.  
  7. SqlConnection con1 = new SqlConnection();
  8. con1.ConnectionString = Connection_String;
  9. con1.Open();
  10. SqlCommand cmd = new SqlCommand();
  11. cmd.Connection = con1;
  12. cmd.CommandText = "Select name from Users where(code = '1')";
  13. cmd.ExecuteNonQuery();
  14. con1.Close();
  15.  
  16. con1.ConnectionString = "Server= ... ";
Add Comment
Please, Sign In to add comment