Let's discuss the disadvantages of connecting to SQL database:
<summary>
Connect to SQL database
</summary>
<param name= "Services" > Database servers </param>
<param name= "SqlUser" > Username </param>
<param name= "sqlpwd" > Password </param>
<returns></returns>
public static string connection (string services, String SqlUser, String sqlpwd)
{
Return "Data source=" + Services + "; User id= "+ SqlUser +"; Password= "+ sqlpwd +" ";
}
<summary>
SQL connection string
</summary>
<param name= "Services" > Database servers </param>
<param name= "SqlUser" > Username </param>
<param name= "sqlpwd" > Password </param>
<param name= "Databases" > Database name </param>
<returns></returns>
public static string connection (string services, String SqlUser, String sqlpwd, string databases)
{
Return "Data source=" + Services + "; Initial catalog=" + databases + "; User id= "+ SqlUser +"; Password= "+ sqlpwd +" ";
}
SQL connection string