retrieve data from data base

Question

Dear Experts, need to retrive data from database can any one help to me my code : ========= public IBraintreeGateway CreateGateway() { Environment = "sandbox"; MerchantId = "3zvbxsx8b37wkcwd"; PublicKey = "hsq33wp3wh2f3j98"; PrivateKey = "302aadc3ccdb1b28d0f031a5121163ec"; return new BraintreeGateway(Environment, MerchantId, PublicKey, PrivateKey); } yelloow color values are stored in db so how can code

Salman Beg · Answer

Hi. To retrieve the data from db you need to use sqlconnection. Follow this article and retrieve the data and bind in those variable and use it. https://www.codeproject.com/Articles/837599/Using-Csharp-to-Connect-to-and-Query-from-a-SQL-Da. Thanks

yesubabu k · Answer

need assign that result to var gateway in web api sir

Sourav Kumar Das · Answer

Hi, This is the sample code try to modify based on your basis. public void getTypeId() { DataTable dtbl = new DataTable(); string sQuery = string .Empty; string sError = string .Empty; string sSno = string .Empty; try { sQuery = "SELECT Environment, MerchantId, PublicKey, PrivateKey FROM Tablename" ; objHelper.CreateConnection( "Connect" ); if (objHelper.FillDataTableByQueryString( ref dtbl, ref sError, sQuery) == true ) { if (dtbl.Rows.Count > 0) { txtEnvironment.Text = dtbl.Rows[0][ "Environment" ].ToString(); txtMerchantId.Text = dtbl.Rows[0][ "MerchantId" ].ToString(); txtPublicKey.Text = dtbl.Rows[0][ "PublicKey" ].ToString(); txtPrivateKey.Text = dtbl.Rows[0][ "PrivateKey" ].ToString(); } else { // Show Error msg for not retrieving } } else { Page.Controls.Add( new LiteralControl( " alert('" + sError + "'); " )); return ; } } catch (Exception ex) { Page.Controls.Add( new LiteralControl( " alert('" + ex.Message.Replace( "'" , "" ).Replace( "" , "" ).Replace( "
" , "" ) + "'); " )); return ; } } At here objHelper has a ConnectionString. @ yesubabu k

Salman Beg · Answer

Follow that article which I sent you and implement in asp.net. Thanks

yesubabu k · Answer

asp.net c#

Sourav Kumar Das · Answer

In which language you need? SQL or Asp.Net C# @ yesubabu k

Sourav Kumar Das · Answer

SELECT Environment, MerchantId, PublicKey, PrivateKey FROM TableName