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 Tp · Answer

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

Call connection string from class inside sqldatasource

Answers (4)