Access Data from DB which its constring located in registry

Jim tan

Hello ,

I am working on a windows Form in C# to get some data from an external application that has an SQL Connection String Saved in the registry, since it is an external applciation we are obliged to use the Connection String from Registry to connect to its DB.

My question is how to get the data needed from Specific table by connecting to this DB from this Connection String and display the results in a DataGridView.

As a note : the connection string contains as well the user name and Password .

I know how to display data when we have the connection string in an app.config file or in a local DB.

We can maybe use the below function to get the value of the connection string , but I don't know how to move forward

string text = registry.GetValue("HKEY_LOCAL_MACHINE\\SOFTWARE\\myappname", "CONNECTIONSTRING"). and we create a query to the Db " Select *from tablex valueabc...

Appreciate your help and ideas

Regards,

Jim

3 Replies

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

Sachin Singh4y ago
You already have the key-value for connection string stored in Registery.
so first step is to retrieve it from there and then use ADO.NET to get data from database as shown below.
private void btn1_Click(eventargs........)
{
RegistryKey objRegistryKey = Registry.LocalMachine;
string CS= (string)objRegistryKey.GetValue("MyConnectionString");
using(SqlConnection con =new SqlConnection(cs))
{
SqlCommand cmd= new SqlCommand("select * from tblName",con);
con.Open();
DataGrid1.DataSource=cmd.ExecuteReader();
DataGrid1.DataBind();


}


}
Jignesh Kumar4y ago
hi Jim,

Please refer this link which will help you to get connection string from registry

https://www.c-sharpcorner.com/UploadFile/f9f215/windows-registry/

once you get connection string then you can use below link,
https://www.aspsnippets.com/Articles/Retrieve-data-from-Database-in-Windows-Forms-Application-using-C-and-VBNet.aspx
Srinivasan Ramamoorthi4y ago
This link has the steps to store and read the connection string from registry. After getting the connection string, you can create sql connection and execute the sql query.

https://amitpatriwala.wordpress.com/2008/05/15/get-connection-string-from-windows-registry-using-cnet/