Asp.Net
How to make connection with Database(SqlServer) using C-sharp
Using Web.config file
if you don't set the username and password on Your Database Server
Write this in your Web.config file
<connectionStrings>
<add name="AnyNameForConnection" connectionString="Data Source= ServerName; initial Catalog=Database_name; integrated Security=SSPI" />
</connectionStrings>
if Your Database server have username and password then write this connection string
Write this in your web.config file
<connectionStrings>
<add name="AnyNameForConnection" connectionString="Data Source= ServerName; initial Catalog=Database_name;User id=YourUserName; Password=YourPassword" />
</connectionStrings>
then create a new class in your application or write in your any existing class
using System.Configuration;
using System.Data.SqlClient;
public class yourclassname
{
public static SqlConnection GetConnected()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["AnyNameForConnection"].ToString());
conn.Open();
return conn;
}
}
then call this method anywhere in your application
Another Way to make your connection, but this way you need to write your connection string again and again, whenever you try t make your connection with database
Standard Connection
using System.Data.SqlClient;SqlConnection conn = new SqlDbConnection();
conn.ConnectionString = "Data Source=ServerName; Initial Catalog=DataBaseName;User id=YourUserName;
Password=YourPassword;";
conn.Open();
Trusted Connection
using System.Data.SqlClient;
SqlConnection conn = new SqlDbConnection();
conn.ConnectionString = "Data Source=ServerName; Initial Catalog=DataBaseName;User Integrated Security=SSPI;";
conn.Open();
SqlConnection conn = new SqlDbConnection();
conn.ConnectionString = "Data Source=ServerName; Initial Catalog=DataBaseName;User Integrated Security=SSPI;";
conn.Open();
Posts
0 comments :
Post a Comment