Click here to Skip to main content
15,903,854 members
Home / Discussions / C#
   

C#

 
GeneralRe: Changing Windows registry with C# Pin
Dave Kreskowiak3-Sep-22 9:51
mveDave Kreskowiak3-Sep-22 9:51 
AnswerRe: Changing Windows registry with C# Pin
OriginalGriff31-Aug-22 18:51
mveOriginalGriff31-Aug-22 18:51 
GeneralRe: Changing Windows registry with C# Pin
Ismael_19993-Sep-22 4:20
Ismael_19993-Sep-22 4:20 
GeneralRe: Changing Windows registry with C# Pin
OriginalGriff3-Sep-22 4:43
mveOriginalGriff3-Sep-22 4:43 
GeneralRe: Changing Windows registry with C# Pin
Ismael_19994-Sep-22 11:41
Ismael_19994-Sep-22 11:41 
GeneralRe: Changing Windows registry with C# Pin
Dave Kreskowiak4-Sep-22 13:12
mveDave Kreskowiak4-Sep-22 13:12 
GeneralRe: Changing Windows registry with C# Pin
OriginalGriff4-Sep-22 19:19
mveOriginalGriff4-Sep-22 19:19 
GeneralRe: Changing Windows registry with C# Pin
Dave Kreskowiak5-Sep-22 3:43
mveDave Kreskowiak5-Sep-22 3:43 
GeneralRe: Changing Windows registry with C# Pin
Ismael_19996-Sep-22 4:10
Ismael_19996-Sep-22 4:10 
GeneralRe: Changing Windows registry with C# Pin
Dave Kreskowiak6-Sep-22 4:30
mveDave Kreskowiak6-Sep-22 4:30 
GeneralRe: Changing Windows registry with C# Pin
Ismael_19996-Sep-22 4:47
Ismael_19996-Sep-22 4:47 
GeneralRe: Changing Windows registry with C# Pin
Dave Kreskowiak6-Sep-22 4:48
mveDave Kreskowiak6-Sep-22 4:48 
GeneralRe: Changing Windows registry with C# Pin
Ismael_19996-Sep-22 10:29
Ismael_19996-Sep-22 10:29 
GeneralRe: Changing Windows registry with C# Pin
Dave Kreskowiak6-Sep-22 10:31
mveDave Kreskowiak6-Sep-22 10:31 
GeneralRe: Changing Windows registry with C# Pin
Ismael_19998-Sep-22 13:00
Ismael_19998-Sep-22 13:00 
GeneralRe: Changing Windows registry with C# Pin
Dave Kreskowiak8-Sep-22 14:02
mveDave Kreskowiak8-Sep-22 14:02 
AnswerRe: Changing Windows registry with C# Pin
Eddy Vluggen6-Sep-22 5:17
professionalEddy Vluggen6-Sep-22 5:17 
GeneralRe: Changing Windows registry with C# Pin
Ismael_19996-Sep-22 10:22
Ismael_19996-Sep-22 10:22 
GeneralRe: Changing Windows registry with C# Pin
Eddy Vluggen6-Sep-22 10:47
professionalEddy Vluggen6-Sep-22 10:47 
QuestionVery slow deeper queries Pin
Antennista Televes30-Aug-22 2:57
Antennista Televes30-Aug-22 2:57 
hello everyone, I'm a young developer c#, I'm using dapper for data manipulation, I have a database on which making a particular query I get 100K + 18 rows that will have to be exported to excel . The problem lies in the fact that, to get the results, it takes almost 12 minutes....to have array_channel_list[i],Can you speed it up in some way ?thank you very much! (sorry for my bad english)
C#
<pre> 
List<string> query = new List<string>();
                    List<EntityFramework.Channels>[] array_channel_list = new List<EntityFramework.Channels>[dim];

   using (var conn = new SqlConnection(connection))
         {
         for (int i = 0; i < dim; i++)
             {
             query.Add("SELECT ID, matricola, disegno, descrizione, nodeid, result, coppia, angolo, prgnr, prgname, date, NomeFile, lastcmd, laststeprow, laststepcolumn, qualitycode, rootobj_ID FROM dbo.Channels where rootobj_ID IN (" + string.Join(",", array_id[i]) + ") ORDER BY ID");

               try
                  {
                  array_channel_list[i] = conn.Query<EntityFramework.Channels>(query[i], commandTimeout: queryTimeoutInSeconds,buffered:false).ToList();

                   }
                   catch (SqlException error)
                        {
                        Console.WriteLine("Errore: " + error.ToString());
                        }

                 }

             }


AnswerRe: Very slow deeper queries Pin
OriginalGriff30-Aug-22 5:05
mveOriginalGriff30-Aug-22 5:05 
SuggestionRe: Very slow deeper queries Pin
Richard Deeming30-Aug-22 5:08
mveRichard Deeming30-Aug-22 5:08 
AnswerRe: Very slow deeper queries Pin
Gerry Schmitz30-Aug-22 5:22
mveGerry Schmitz30-Aug-22 5:22 
QuestionCheck Register Control Pin
Member 1575067028-Aug-22 17:54
Member 1575067028-Aug-22 17:54 
AnswerRe: Check Register Control Pin
OriginalGriff28-Aug-22 19:55
mveOriginalGriff28-Aug-22 19:55 

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.