Vegas Posts - Answer Overflow

Vegas

Posts Comments

CC#

•Created by Vegas on 7/3/2024 in #help

WPF - Using RTF as a Notes section.

1 replies

CC#

•Created by Vegas on 6/28/2024 in #help

new command fixing memory leak.

So i have been able to fix memory leak on Windows and forms but cant figure out how todo it with pages. So i am calling specific pages to show inside a frame on button press. Upon changing pages you end up keeping the memory used instead of clearing the data.

        private void btn_home_Click(object sender, RoutedEventArgs e)
        {
            workarea.Content = new Store_My_Client.Pages.Page1();
        }

        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            workarea.Content = new Store_My_Client.Pages.Page2();
        }

        private void btn_home_Click(object sender, RoutedEventArgs e)
        {
            workarea.Content = new Store_My_Client.Pages.Page1();
        }

        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            workarea.Content = new Store_My_Client.Pages.Page2();
        }

Any ideas? Thanks

7 replies

CC#

•Created by Vegas on 6/21/2024 in #help

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

55 replies

Gaming

Programming