Please visit my new Web Site https://coderstechzone.com
Asp.net gives developers a class to build runtime dynamically connectionstring named SqlConnectionStringBuilder. Here in this article I will show you by an example. Please have a look at the below code example which will help you to understand how one can build dynamically connectionstring with less error possibilities.
Code Example:
using System; using System.Data; using System.Data.SqlClient; public partial class Connectionstringbuilder : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //Build connectionstring SqlConnectionStringBuilder ConnBuilder = new SqlConnectionStringBuilder(); ConnBuilder.DataSource = @".\SQLExpress"; // Name of the Sql Server instance ConnBuilder.InitialCatalog = "TestDB"; // Database Name ConnBuilder.UserID = "sa"; ConnBuilder.Password = "your password"; ConnBuilder.ConnectTimeout = 0; ConnBuilder.IntegratedSecurity = false; //How to use DataTable dt; String SQL = "SELECT Name,Description,Size,Color From Product Order BY Name"; using (SqlConnection Conn = new SqlConnection(ConnBuilder.ConnectionString)) { using (SqlCommand comm = new SqlCommand(SQL, Conn)) { Conn.Open(); using (SqlDataAdapter da = new SqlDataAdapter(comm)) { dt = new DataTable("tbl"); da.Fill(dt); } } } GridView1.DataSource = dt; GridView1.DataBind(); } } }Hope now you can dynamically build your connection string if needed.
0 comments:
I WOULD BE DELIGHTED TO HEAR FROM YOU