Connecting to database via String in XML

So i have done searching after searching and i keep getting stuck on having the connection error as a string.

    <connectionStrings>
        <clear />
        <add name="Test"
         providerName="localhost"
         connectionString="Data Source=DESKTOP-6L5A1E6;Integrated Security=True;Connect Timeout=30;Encrypt=True;Trust Server Certificate=True;Application Intent=ReadWrite;Multi Subnet Failover=False" />
    </connectionStrings>


        private SqlConnection cont;

        static class Program
        {
            static void Main()
            {
                GetConnectionStrings();
                Console.ReadLine();
            }

            static void GetConnectionStrings()
            {
                ConnectionStringSettingsCollection settings = ConfigurationManager.ConnectionStrings;

                foreach (ConnectionStringSettings cs in settings)
                {
                    Console.WriteLine(cs.Name);
                    Console.WriteLine(cs.ProviderName);
                    Console.WriteLine(cs.ConnectionString);
                }
            }
        }


private void button1_Click(object sender, EventArgs e)
{

    var Connect = ConfigurationManager.ConnectionStrings["Test"];
    var qury = "SELECT * FROM users WHERE Username = @username and password=@password";
    string returnValue = "";
    using (SqlConnection conn = new SqlConnection(**Connect**))
    {
        using (SqlCommand sqlcmd = new SqlCommand(qury, conn))
        {
            sqlcmd.Parameters.Add("@username", SqlDbType.VarChar).Value = textBox1.Text;
            sqlcmd.Parameters.Add("@password", SqlDbType.VarChar).Value = textBox2.Text;
            conn.Open();
            returnValue = (string)sqlcmd.ExecuteScalar();
        }
    }

}

Creating the new Connection is throwing error
cannot convert from 'System.Configuration.ConnectionStringSettings' to 'string'

Thanks
Was this page helpful?