© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
C#C
C#•2y ago•
54 replies
Drew Edwards - Vegas :

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>
    <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 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();
        }
    }

}
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
C# banner
C#Join
We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.
61,871Members
Resources
Was this page helpful?

Similar Threads

Recent Announcements
Next page

Similar Threads

XMl: How to convert IEnumerable<XmlNode> to XmlNodeList ?
C#CC# / help
3y ago
❔ Querying XML via LINQ
C#CC# / help
3y ago
Trouble Connecting to Database
C#CC# / help
2y ago