C# Discussion Boards - CodeProject

Get the value from a checklistbox

5-May-21 8:24

If you installed it with package manager, I would inspect it under package manager; and then update or reinstall. Or look under "Windows". Or under Tools. Or Data. Or, restart VS in "default mode". Reinstall VS. etc.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Luis M. Rojas5-May-21 6:35

Luis M. Rojas

5-May-21 6:35

I have a checklistBox where i populate only name. But the valueMember is an id.
The user can select several name.
I have this code to read the checklistbox (only checked value) and extract the valuemember.
but i only get the item it is selected not all chechking
if (chkListClienteEmail.CheckedItems.Count != 0)
{
for (int i = 0; i <=;= chkListClienteEmail.CheckedItems.Count - 1; i++)
{
string s = chkListClienteEmail.SelectedValue.ToString();
more code...
}
}

Gerry Schmitz5-May-21 8:19

5-May-21 8:19

You didn't mention .SelectionMode (but did mention "only" and "not all")

CheckedListBox.SelectionMode Property (System.Windows.Forms) | Microsoft Docs

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Luis M. Rojas5-May-21 11:01

Luis M. Rojas

5-May-21 11:01

I have chkListClienteEmail.SelectionMode = SelectionMode.One;
The problem is: if the user check 3 clients, even i read every checked=true, i just get one selectedValue(valueMember) and it is the Last one, which of course it is selected on the form.

I want that on every loop, if the item it is checked, i need that valuemember.

Gerry Schmitz5-May-21 11:18

CheckedListBox.CheckedItems Property (System.Windows.Forms) | Microsoft Docs

5-May-21 11:18

You're no really "indexing" in your for loop (nothing happens with i).

Use a foreach to iterate either the indexes or the "checked" items.

Quote:
The following example enumerates the checked items in the CheckedListBox.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Richard MacCutchan5-May-21 21:16

Richard MacCutchan

5-May-21 21:16

Look at your loop. You extract every email value to the string s, so at the end of the loop it contains the last selected item.

Alan N6-May-21 4:06

Alan N

6-May-21 4:06

There is some confusion here as selection and checking are quite separate things and a selected item need not be checked. There is a SelectedValue property but there is no CheckedValue property.

I'll assume that the checkedlistbox item collection stores instances of a class such as

class NameID {
  public String Name {get; set;};
  public Int32 ID {get; set;}
}

To iterate though the ID's of the checkeditems do something like this

for (int i = 0; i <= chkListClienteEmail.CheckedItems.Count - 1; i++)
{
  
  Object rawObj = chkListClienteEmail.CheckedItems[i];
  NameID typedObj = (NameID)rawObj;

  string s = typedObj.ID.ToString();

  more code...
}

How convert SQL Server Pivot functionality in C# uisng LINQ

Luis M. Rojas7-May-21 3:30

Luis M. Rojas

7-May-21 3:30

That is correct, i am very sorry, because i did not explain me well.

Thanks to all

Mou_kol3-May-21 5:45

Mou_kol

3-May-21 5:45

I am using SQL Server Pivot which works fine. Here is sample data below which transpose by SQL server pivot function. this is sample data which convert to pivot by SQL server.

+------------+--------------+-----------+--------------+--------+-------------+--------------------+----------+
     | RowNumber  |   Section    | LineItem  | DisplayInCSM | Broker | BrokerName  | ItemValue_NoFormat |  Period  |
     +------------+--------------+-----------+--------------+--------+-------------+--------------------+----------+
     |          1 | Operational  | NG Sales  | NGL          | CR     | Credit Suse |                200 | 2010 FYA |
     |          2 | Operational  | NG Sales  | NGL          | GR     | Max 1       |                300 | 2010 FYA |
     |          3 | Operational  | NG Sales  | NGL          | PX     | Morgan      |                100 | 2010 FYA |
     |          4 | Operational  | NG Sales  | NGL          | WB     | Wells Fargo |                500 | 2010 FYA |
     +------------+--------------+-----------+--------------+--------+-------------+--------------------+----------+

This is dynamic sql i used in sql server to represent data in pivot format. here it is.

SET @SQL='SELECT *                                      
     FROM                                                                              
     (                      
       SELECT RowNumber,CAST(ISNULL(EarningID,0) AS INT) EarningID,    
       Section,    
       LineItem,    
       DisplayInCSM,     
       Type,     
       Broker,    
       BrokerName,     
       ItemValue_NoFormat,     
       TRIM(ISNULL(Period,'''')) Period,hierarchy,                
       from #tmpData1 WHERE TYPE<>''SHEET''                                                                      
     ) t                                                                              
     PIVOT                                                                              
     (                                                                              
      MAX(ItemValue_NoFormat)                                                                              
      FOR Broker IN ([5W], [8K], [CL], [DA], [EQ], [FA], [GS], [HM], [HQ], [JY], [KW], [ML], [MS], [MV], [SL], [UA],[WB])                                                                              
     ) AS P                                                                              
     order by hierarchy,PeriodOrder

Now due to some problem i have to use C# to pivot data which is stored in list. suppose my first sample stored in list now how can i pivot that data by c# LINQ.

i saw these post Is it possible to Pivot data using LINQ?
https://stackoverflow.com/questions/167304/is-it-possible-to-pivot-data-using-linq/6282689#6282689

Pivot data using LINQ
https://stackoverflow.com/questions/963491/pivot-data-using-linq

but still not clear to me how to write the code for my scenario which display broker name horizontally. so please some one give me some hint which help me to start the coding part as a result i can show my data in pivot format where broker name will be shown horizontally. thanks

Re: How convert SQL Server Pivot functionality in C# uisng LINQ

Eddy Vluggen3-May-21 6:10

Eddy Vluggen

3-May-21 6:10

Mou_kol wrote:
i saw these post Is it possible to Pivot data using LINQ?

Prolly is, but why move that to the client in the first place?

Why do you prefer to hold a dataset in memory, when it is more efficient on the server?

Bastard Programmer from Hell Suspicious | :suss:

"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Re: How convert SQL Server Pivot functionality in C# uisng LINQ

Mou_kol3-May-21 6:50

Mou_kol

3-May-21 6:50

SQL server taking long time to return result set and we have network problem. also we do not have a DBA. using my knowledge i am not being able to suppress the issue. so decided to move the whole part in c#. so please guide me how to achieve it in c# alone. thanks

Re: How convert SQL Server Pivot functionality in C# uisng LINQ

Eddy Vluggen3-May-21 6:57

Eddy Vluggen

3-May-21 6:57

Mou_kol wrote:
SQL server taking long time to return result set and we have network problem. also we do not have a DBA

You missing DBA is prolly reason why it takes that time.

Mou_kol wrote:
using my knowledge i am not being able to suppress the issue

Welcome to my world.

Mou_kol wrote:
so decided to move the whole part in c#

Without knowing if that would improve anything?

Mou_kol wrote:
so please guide me how to achieve it in c# alone. thanks

No. Ethics. Not going to reccomend you wrong because you ask/want/need it.

Get someone who knows databases. Profit that way.

Bastard Programmer from Hell Suspicious | :suss:

"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Re: How convert SQL Server Pivot functionality in C# uisng LINQ

Gerry Schmitz3-May-21 7:49

Re: How convert SQL Server Pivot functionality in C# uisng LINQ

3-May-21 7:49

Your answer to meeting a deficiency is to ignore it and pursue a less efficient alternative.

(You can look at it as a question or a statement).

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Eddy Vluggen3-May-21 11:23

Eddy Vluggen

3-May-21 11:23

Damn. You brutal Big Grin | :-D

Bastard Programmer from Hell Suspicious | :suss:

"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Re: How convert SQL Server Pivot functionality in C# uisng LINQ

Gerry Schmitz3-May-21 21:56

Re: How convert SQL Server Pivot functionality in C# uisng LINQ

3-May-21 21:56

Existentialism.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Pete O'Hanlon3-May-21 23:18

Pete O'Hanlon

3-May-21 23:18

This could mean anything. When you say that SQL Server is taking a long time to return the result set, you have left a wide open area here. Does the pivot table take a long time to create on the server? Is it returning a massive amount of data? Has anyone run a profiling session on the pivot operation to see if you are doing sequential scans? Doing an analysis in SQL Server does not need a DBA - the developers should be able to pick this up.

In reality, I doubt you could build a pivot that would work as quickly as the SQL Server implementation which is heavily optimised. In order to pivot, you would have to pull all of the data back from the server then write your own code to transform the data, applying aggregation operations yourself, so you will need to potentially drag back large amounts of data.

My advice - profile the PIVOT operation.

Advanced TypeScript Programming Projects

Re: How convert SQL Server Pivot functionality in C# uisng LINQ

OriginalGriff4-May-21 1:34

OriginalGriff

4-May-21 1:34

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

Binding Textblock Text and Textbox Text

mnkdrt3-May-21 4:09

mnkdrt

3-May-21 4:09

Hello,

I am teaching myself xaml and C# and have a question which is probably trivial but I cannot find a resource that is pointing me in the correct direction. If I have a simple app with a copy button, a textblock and a textbox is there a way to bind the textblock text to the entered textbox text? In other words the textblock text is predefined and will not change, once the user enters something in the textbox and hits copy the string copies to the clipboard with the textblock text and the entered textbox text i.e.:

What is your age:(this is the textblock static text) 14 years old (entered text in textbox)

XML

<Grid>
        <Button x:Name="button" Content="Copy" HorizontalAlignment="Left" Height="39" Margin="10,10,0,0" VerticalAlignment="Top" Width="110"/>
        <Grid HorizontalAlignment="Left" Height="287" Margin="138,10,0,0" VerticalAlignment="Top" Width="370">
            <TextBlock x:Name="textBlock" HorizontalAlignment="Left" Height="22" Margin="10,10,0,0" TextWrapping="Wrap" Text="Enter your age:" VerticalAlignment="Top" Width="87"/>
            <TextBox x:Name="textBox" HorizontalAlignment="Left" Height="22" Margin="113,10,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="247"/>
        </Grid>

    </Grid>

public partial class MainWindow : Window
   {
       public MainWindow()
       {
           InitializeComponent();
       }

       private void button_Click(object sender, RoutedEventArgs e)
       {
           // I can achieve this with 2 list and a zip then easily building the stringbuilder or string.
           // Trying to see if a more efficient way to bind the textblock text and textbox entered text in xml
       }
   }

Re: Binding Textblock Text and Textbox Text

Gerry Schmitz3-May-21 8:07

Debug decompile - urgent project restore

3-May-21 8:07

private void button_Click(object sender, RoutedEventArgs e) {

   string s = textblock.Text + " " + textbox.Text;
   Clipboard.SetText( s );
}

(I'd pick better "names" for my controls).

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Ahmedtsadek2-May-21 19:05

Ahmedtsadek

2-May-21 19:05

Hello all,
I have a client project that I was working on for around 6 months and my HDD got infected with ransomware and I lost all the data.
I have the last debug version and I want help to decompile it and recreate the project

I tried .net Reflector and Jetbrains Dotpeek but I don't know how to use any of them I can see the code but can't recreate the full project.

the project debug is uploaded at github here: https://github.com/ahmedtsadek/Elmrkt-Inventory-Tool/raw/main/Debug24-04-2021V2.rar

If anyone can help please contact me asap Cry | :((

OriginalGriff2-May-21 19:32

OriginalGriff

2-May-21 19:32

First off, restore from your latest backup - it's always the best way. you can then re-implement any changes you made since then.

While decompilation can regenerate code from a compiled EXE, it won't be exactly what you had, and if it's only the release version you can access then it may be useless to you - if you use an obfuscation tool when you created it then it's going to be pretty useless by design. Regardless, the production version will not contain any comments and may be very different to your original source due to optimisations.

Some tools can generate project and solution files for you: ReflectorFileDisassembler[^] but I've never used them.

Basically, restoring from the backup is the best way. You do take regular backups, don't you?

Kuolung19673-May-21 0:48

Kuolung1967

3-May-21 0:48

or Maybe U can use "JustDecompile" [^]

it is good for me

Gerry Schmitz3-May-21 7:42

3-May-21 7:42

If you can't rebuild a one-man (6 month) project in a day or two, having recovered the source code, then it wasn't "your" project in the first place.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food