Call connection string from class inside sqldatasource

Question

Hi Can anyone tell how can I call connection string from class inside sql datasource for example like  SelectCommand=SELECT * FROM [Course_details]>

Bikesh Srivastava · Answer

Hi use this. using (SqlConnectionconn= new SqlConnection()) { conn.ConnectionString= Server=[server_name];Database=[database_name];Trusted_Connection=true ; //usingthecodehere... }

Vinay Singh · Answer

check the link https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.connectionstring(v=vs.110).aspx

Rajeesh Menoth · Answer

Hi Example : protected void Page_Load( object sender EventArgs e) { if (!IsPostBack) { SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ID = SqlDataSource1 ; this .Page.Controls.Add(SqlDataSource1); SqlDataSource1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings[ conString ].ConnectionString; SqlDataSource1.SelectCommand = SELECT top 10 ContactName City Country PostalCode from Customers ; GridView1.DataSource = SqlDataSource1; GridView1.DataBind(); } } Reference : http://www.aspsnippets.com/Articles/Bind-GridView-using-SqlDataSource-Programmatically-from-code-in-ASPNet.aspx

Midhun T P · Answer

Hi you can change it programatically. Why don't you try this - SqlDataSource1.ConnectionString = yourconnectionstring;