retrieve data from data base

yesubabu k

7y752.NET

Dear Experts,

need to retrive data from database

can any one help to

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

yesubabu k7y ago

need assign that result to var gateway in web api sir
Sourav Kumar Das7y ago
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(""));
                return;
            }
        }
        catch (Exception ex)
        {
            Page.Controls.Add(new LiteralControl(""));
            return;
        }
    }
At here objHelper has a ConnectionString.
@ yesubabu k
Salman Beg7y ago
Follow that article which I sent you and implement in asp.net. Thanks
yesubabu k7y ago
asp.net c#
Salman Beg7y ago
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
Sourav Kumar Das7y ago
In which language you need?

SQL or Asp.Net C#

@ yesubabu k
Sourav Kumar Das7y ago
SELECT Environment, MerchantId, PublicKey, PrivateKey FROM TableName