Click here to Skip to main content
15,881,139 members
Home / Discussions / C#
   

C#

 
GeneralRe: convert double with decimal places to any base in C# example : 19.879 to any base or -19.345 to any base Pin
Sakhalean25-Dec-22 14:06
Sakhalean25-Dec-22 14:06 
QuestionEF Core 6 Repository Pattern Pin
Kevin Marois23-Dec-22 9:11
professionalKevin Marois23-Dec-22 9:11 
AnswerRe: EF Core 6 Repository Pattern Pin
Richard Deeming5-Jan-23 0:02
mveRichard Deeming5-Jan-23 0:02 
GeneralRe: EF Core 6 Repository Pattern Pin
Kevin Marois5-Jan-23 6:46
professionalKevin Marois5-Jan-23 6:46 
GeneralRe: EF Core 6 Repository Pattern Pin
Richard Deeming5-Jan-23 22:41
mveRichard Deeming5-Jan-23 22:41 
GeneralRe: EF Core 6 Repository Pattern Pin
Kevin Marois6-Jan-23 5:38
professionalKevin Marois6-Jan-23 5:38 
GeneralRe: EF Core 6 Repository Pattern Pin
Richard Deeming8-Jan-23 21:35
mveRichard Deeming8-Jan-23 21:35 
QuestionMysql database freezes with Visual Sudio C# Pin
Member 1405587918-Dec-22 5:44
Member 1405587918-Dec-22 5:44 
I a'm reading values from raspberry pi mysql database with visual studio c#
If the database is not available and I am trying to read from it, the c# app
freezes for about 15 seconds. 

Is it possible to make it not to freeze when checking if the database is available?

Her is the code
<pre lang="C#">string connString = "SERVER='192.168.86.41';DATABASE='spaceinformation';UID='******';PASSWORD='******'";
 private void FormMeasurement_Load(object sender, EventArgs e)
        {
            try
            {
                using (var connection = new MySqlConnection(connString))
                {
                    connection.Open();

                    query = "select * from weather";
                    using (var command = new MySqlCommand(query, connection))
                    {
                        using (var reader = command.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                listBoxMeasurement.Items.Add(string.Format("Temperature: {0}   Humidity: {1}   Date: {2}", reader.GetString("temp"), reader.GetString("hum"), reader.GetString("datecreated")));
                            }
                        }
                    }
                    connection.Close();
                }
            }
            catch
            {
                MessageBox.Show("Database is not available for moment!");
                listBoxMeasurement.Enabled = false;
            }
        }

AnswerRe: Mysql database freezes with Visual Sudio C# Pin
RedDk18-Dec-22 10:10
RedDk18-Dec-22 10:10 
AnswerRe: Mysql database freezes with Visual Sudio C# Pin
Dave Kreskowiak18-Dec-22 11:20
mveDave Kreskowiak18-Dec-22 11:20 
AnswerRe: Mysql database freezes with Visual Sudio C# Pin
Richard Deeming18-Dec-22 21:08
mveRichard Deeming18-Dec-22 21:08 
QuestionMulti-threaded debugging Pin
Richard Andrew x6411-Dec-22 6:12
professionalRichard Andrew x6411-Dec-22 6:12 
AnswerRe: Multi-threaded debugging Pin
Gerry Schmitz11-Dec-22 7:09
mveGerry Schmitz11-Dec-22 7:09 
GeneralRe: Multi-threaded debugging Pin
Richard Andrew x6411-Dec-22 7:48
professionalRichard Andrew x6411-Dec-22 7:48 
GeneralRe: Multi-threaded debugging Pin
Gerry Schmitz11-Dec-22 14:50
mveGerry Schmitz11-Dec-22 14:50 
AnswerRe: Multi-threaded debugging Pin
Randor 11-Dec-22 8:46
professional Randor 11-Dec-22 8:46 
GeneralRe: Multi-threaded debugging Pin
Richard Andrew x6411-Dec-22 14:36
professionalRichard Andrew x6411-Dec-22 14:36 
PraiseRe: Multi-threaded debugging Pin
Randor 11-Dec-22 15:50
professional Randor 11-Dec-22 15:50 
QuestionRegarding a line in code Pin
vineeth s5-Dec-22 7:06
vineeth s5-Dec-22 7:06 
AnswerRe: Regarding a line in code Pin
Richard MacCutchan5-Dec-22 8:02
mveRichard MacCutchan5-Dec-22 8:02 
AnswerRe: Regarding a line in code Pin
OriginalGriff5-Dec-22 8:22
mveOriginalGriff5-Dec-22 8:22 
AnswerRe: Regarding a line in code Pin
BillWoodruff6-Dec-22 0:51
professionalBillWoodruff6-Dec-22 0:51 
GeneralRe: Regarding a line in code Pin
Richard Deeming6-Dec-22 1:08
mveRichard Deeming6-Dec-22 1:08 
GeneralRe: Regarding a line in code Pin
BillWoodruff6-Dec-22 1:29
professionalBillWoodruff6-Dec-22 1:29 
GeneralRe: Regarding a line in code Pin
Richard MacCutchan6-Dec-22 1:34
mveRichard MacCutchan6-Dec-22 1:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.