C#

var Result = from x in db.vams
                        join y in db.ghests
                        on new { X1 = x.code_sabt } equals new { X1 = y.code_sabt }
                        where y.code_vam == (from z in db.vams where z.code_sabt == myuser select z.row_codevam).Max()
                        group y by x.row_codevam into g
                        select new
                        {
                          sum_ghest = g.Sum(k=>k.price),
                          //---------------------

                            i need-----> x.colimns  :(  :(  :(
//---------------------


                        };

db.vams

<ComboBox Margin="2,2,2,2" BorderThickness="0,0,0,1" Grid.Row="3" Grid.Column="1" ItemsSource="{Binding DataCategoryList}" SelectedIndex="{Binding DataCategory}" DisplayMemberPath="Name" />
<ComboBox Margin="2,2,2,2" BorderThickness="0,0,0,1" Grid.Row="4" Grid.Column="1" ItemsSource="{Binding DataColourList}" SelectedIndex="{Binding DataColour}" DisplayMemberPath="Name"/>
<ComboBox Margin="2,2,2,2" BorderThickness="0,0,0,1" Grid.Row="5" Grid.Column="1" ItemsSource="{Binding DataShapeList}" SelectedIndex="{Binding DataShape}" DisplayMemberPath="Name"/>

public class Base : INotifyPropertyChanged
{
  private string _ID;
  private string _Name;

  public string ID { get { return _ID; } set { _ID = value; OnPropertyChanged( "ID" ); } }
  public string Name { get { return _Name; } set { _Name = value; OnPropertyChanged( "Name" ); } }

  public event PropertyChangedEventHandler PropertyChanged;
  protected void OnPropertyChanged( string propertyName )
  {
    if( PropertyChanged != null )
      PropertyChanged( this, new PropertyChangedEventArgs( propertyName ) );
  }
}

public class MyData : INotifyPropertyChanged
{
  private Base _Category;
  private Base _Colour;
  private Base _Shape;

  public event PropertyChangedEventHandler PropertyChanged;
  protected void OnPropertyChanged( string propertyName )
  {
    if( PropertyChanged != null )
      PropertyChanged( this, new PropertyChangedEventArgs( propertyName ) );
  }

  public Base Category
  {
    get { return _Category; }
    set
    {
      _Category = value;
      OnPropertyChanged( "Category" );
    }
  }

  public Base Colour
  {
    get { return _Colour; }
    set
    {
      _Colour = value;
      OnPropertyChanged( "Colour" );
    }
   }
  public Base Shape
  {
    get { return _Shape; }
    set
    {
      _Shape = value;
      OnPropertyChanged( "Shape" );
    }
  }
}

public class MyWindow : INotifyPropertyChanged
{
  private MyData _Data;

  public MyData Data { get { return _Data; } set { _Data = value; } }

  public MyWindow( ) : base( )
  {
    Data = new MyData( )
    {
      Category = new Base( ) { ID = "A", Name = "Category A" },
      Colour = new Base( ) { ID = "RD", Name = "Red" },
      Shape = new Base( ) { ID = "RND", Name = "Round" },
    };

    Data.PropertyChanged += Data_PropertyChanged;
  }

  private void ValidateCategoryChange( string id)
  {
    Base result = null;

    foreach( Base colour in DataColourList )
      if( colour.ID == id )
        result = colour;

    Data.Colour = result ?? DataColourList[ 0 ];
  }

  private void ValidateColourChange( string id )
  {
    Base result = null;

    foreach( Base shape in DataShapeList )
      if( shape.ID == id )
        result = shape;

    Data.Shape = result ?? DataShapeList[ 0 ];
  }

  private void Data_PropertyChanged( object sender, PropertyChangedEventArgs e )
  {
    // Amend and re-throw this to update the UI control.
    OnPropertyChanged( String.Format( "Cable{0}", e.PropertyName ) );
  }

  public event PropertyChangedEventHandler PropertyChanged;
  protected void OnPropertyChanged( string propertyName )
  {
    if( PropertyChanged != null )
      PropertyChanged( this, new PropertyChangedEventArgs( propertyName ) );
  }

  public List<Base> BuildCategoryList( )
  {
    List<Base> result = new List<Base>();

    result.Add( new Base( ) { ID = "A", Name = "Category A" } );
    result.Add( new Base( ) { ID = "A", Name = "Category B" } );

    return result;
  }

  public List<Base> BuildColourList( string categoryID )
  {
    List<Base> result = new List<Base>();

    if( categoryID == "A" )
    {
      result.Add( new Base( ) { ID = "RD", Name = "Red" } );
      result.Add( new Base( ) { ID = "BL", Name = "Blue" } );
    }
    else
    {
      result.Add( new Base( ) { ID = "BK", Name = "Black" } );
      result.Add( new Base( ) { ID = "OR", Name = "Green" } );
      result.Add( new Base( ) { ID = "RD", Name = "Red" } );
      result.Add( new Base( ) { ID = "BL", Name = "Blue" } );
    }

    return result;
  }

  public List<Base> BuildShapeList( string colourID )
  {
    List<Base> result = new List<Base>();

    if( colourID == "RD" || colourID == "BK" )
    {
      result.Add( new Base( ) { ID = "RND", Name = "Round" } );
      result.Add( new Base( ) { ID = "SQR", Name = "Square" } );
      result.Add( new Base( ) { ID = "TNG", Name = "Triangle" } );
    }
    else
    {
      result.Add( new Base( ) { ID = "RCT", Name = "Rectangle" } );
    }

    return result;
  }

  public List<Base> DataCategoryList { get; set; }

  public int DataCategory
  {
    get
    {
      for( int index = 0; index < DataCategoryList.Count; index++ )
        if( Data.Category == DataCategoryList[ index ] )
          return index;

      return -1;
    }
    set
    {
      if( value == -1 ) // Prevent the following from failing with an invalid index;
        return;

      Data.Category.ID = DataCategoryList[ value ].ID;
      OnPropertyChanged( "DataCategory" );
      DataColourList = BuildColourList( Data.Category.ID ); // We need to update the list of colours now that the category has changed
      ValidateCategoryChange( Data.Category.ID );
    }
  }

  public List<Base> DataColourList { get; set; }

  public int DataColour
  {
    get
    {
      for( int index = 0; index < DataColourList.Count; index++ )
        if( Data.Colour == DataColourList[ index ] )
          return index;

      return -1;
    }
    set
    {
      if( value == -1 ) // Prevent the following from failing with an invalid index;
        return;

      Data.Colour.ID = DataColourList[ value ].ID;
      OnPropertyChanged( "DataColour" );
      DataShapeList = BuildShapeList( Data.Colour.ID ); // We need to update the list of colours now that the shape has changed
      ValidateColourChange( Data.Colour.ID );
    }
  }

  public List<Base> DataShapeList { get; set; }

  public int DataShape
  {
    get
    {
      for( int index = 0; index < DataShapeList.Count; index++ )
        if( Data.Category.ID == DataShapeList[ index ].ID )
          return index;

      return -1;
    }
    set
    {
      if( value == -1 ) // Prevent the following from failing with an invalid index;
        return;

      Data.Category = DataShapeList[ value ];
      OnPropertyChanged( "DataShape" );
    }
  }
}

<pre>private void button1_Click(object sender, EventArgs e)
        {
            SysDBADM obj = new SysDBADM();
            ArrayList arr = new ArrayList();

            try
            {
                arr.Add(TB_cod.Text);
                arr.Add(TB_nome.Text);
                arr.Add(TB_idade.Text);
                arr.Add(TB_endereco.Text);
                arr.Add(TB_quadra_lote.Text);
                arr.Add(MD_telefoneCel.Text);
                arr.Add(TB_email.Text);
                arr.Add(TB_cidade.Text);
                arr.Add(TB_uf.Text);
                arr.Add(TB_nomepai.Text);
                arr.Add(TB_nomemae.Text);
                arr.Add(CB_ativo.Text);
                arr.Add(CLB_atividade.Text);// esse é meu checkedlistbox 

                if (obj.Update(arr))
                    {

                        TB_cod.Clear();
                        TB_nome.Clear();
                        TB_idade.Clear();
                        TB_endereco.Clear();
                        TB_quadra_lote.Clear();
                        MD_telefoneFixo.Clear();
                        MD_telefoneCel.Clear();
                        TB_email.Clear();
                        TB_cidade.Clear();
                        TB_uf.Clear();
                        TB_nomepai.Clear();
                        TB_nomemae.Clear();
                        CB_ativo.Text = "";
                        



                    while (CLB_atividade.CheckedItems.Count > 0)
                    {
                        CLB_atividade.SetItemChecked(CLB_atividade.CheckedIndices[0],false);
                    }
                       MessageBox.Show("Cadastro Atualizado.", "Mensagem do Sistema", MessageBoxButtons.OK, MessageBoxIcon.Information);


                    }

                    else
                    {
                        MessageBox.Show("Erro ao Atualizar!", "Mesagem do Sistema", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
               }

            catch (Exception erro)
            {
                MessageBox.Show(erro + "Erro Ocorrido");
            }

        }

this is my class where are the parameters to perform the update.

public bool Update(ArrayList p_arrUpdate)
            {
            vsql = "UPDATE alunos SET nome = @nome, idade = @idade, endereco = @endereco, quadra_lote = @quadra_lote, telefone = @telefone, email = @email, cidade = @cidade, uf = @uf, nome_pai = @nome_pai, nome_mae = @nome_mae, situacao = @situacao, atividade = @atividade  WHERE id_aluno = @id_aluno";

                SqlCommand objcmd = null;

                if (this.conectar())

                    try // ele responsavel por tentar executar o array, se der alguma coisa errada e vai cair no finally
                    {

                        objcmd = new SqlCommand(vsql, objCon);
                        objcmd.Parameters.Add(new SqlParameter("@id_aluno", p_arrUpdate[0]));
                        objcmd.Parameters.Add(new SqlParameter("@nome", p_arrUpdate[1]));
                        objcmd.Parameters.Add(new SqlParameter("@idade", p_arrUpdate[2]));
                        objcmd.Parameters.Add(new SqlParameter("@endereco", p_arrUpdate[3]));
                        objcmd.Parameters.Add(new SqlParameter("@quadra_lote", p_arrUpdate[4]));
                        objcmd.Parameters.Add(new SqlParameter("@telefone", p_arrUpdate[5]));
                        objcmd.Parameters.Add(new SqlParameter("@email", p_arrUpdate[6]));
                        objcmd.Parameters.Add(new SqlParameter("@cidade", p_arrUpdate[7]));
                        objcmd.Parameters.Add(new SqlParameter("@uf", p_arrUpdate[8]));
                        objcmd.Parameters.Add(new SqlParameter("@nome_pai", p_arrUpdate[9]));
                        objcmd.Parameters.Add(new SqlParameter("@nome_mae", p_arrUpdate[10]));
                        objcmd.Parameters.Add(new SqlParameter("@situacao", p_arrUpdate[11]));
                        objcmd.Parameters.Add(new SqlParameter("@atividade", p_arrUpdate[12])); // esse é meu parametro onde atualiza meus dados do meu checkedlistbox.


                    objcmd.ExecuteNonQuery();
                        return true;

                    }
                    catch (SqlException sqlerr)
                    {

                        throw sqlerr;
                    }
                    finally
                    {

                        this.desconectar();
                    }
                else
                {
                    return false;
                }
            }

using System;

namespace Shipment_WS_Test_App
{
	
	class Class1
	{
		/// <summary>
		/// The main entry point for the application.
		/// </summary>
		[STAThread]
		static void Main(string[] args)
		{
			try
			{
                string flg = string.Empty;
                while (flg != "q")
                {

                    System.Text.StringBuilder request = new System.Text.StringBuilder();
                    saia.shipment.Shipment shipment = new saia.shipment.Shipment();
                    shipment.Timeout = 120000;
                    request.Append("<GetByProNumber>");
                    request.Append("<UserID>userid</UserID>");
                    request.Append("<Password>password</Password>");
                    request.Append("<TestMode>N</TestMode>");
                    request.Append("<ProNumber>983579110</ProNumber>");
                    request.Append("</GetByProNumber>");


                    string xmlreq = "<AmazonTrackingRequest xmlns:xsi=\"www.w3.org/2001/XMLSchema-instance\" xsi:noNamespaceSchemaLocation=\"AmazonTrackingRequest.xsd\"><Validation><UserID>AMZN</UserID><Password>12345</Password></Validation><APIVersion>4.0</APIVersion><TrackingNumber>123456789</TrackingNumber></AmazonTrackingRequest> ";
                 

                    //string response = shipment.ProcessXML(request.ToString());

                    string response = shipment.ProcessXML(xmlreq);
                    System.Xml.XmlDocument xmlResponse = new System.Xml.XmlDocument();
                    
                    xmlResponse.LoadXml(response);

                    // Note: These examples use SelectSingleNode() which accepts a string 
                    // containing a XPath expression. This is a common way to retrieve a node 
                    // from a small XML Document. 

                    if (xmlResponse.SelectSingleNode("/Response/Code").InnerText != "")
                    {
                        // Add error handling code in case Saia responds 
                        // with an Error Code

                        System.Console.WriteLine(xmlResponse.SelectSingleNode("/Response/Code").InnerText);
                        System.Console.WriteLine(xmlResponse.SelectSingleNode("/Response/Element").InnerText);
                        System.Console.WriteLine(xmlResponse.SelectSingleNode("/Response/Fault").InnerText);
                        System.Console.WriteLine(xmlResponse.SelectSingleNode("/Response/Message").InnerText);
                    }
                    else
                    {
                        
                        System.Console.WriteLine(xmlResponse.SelectSingleNode("/Response/Consignee/AccountNumber").InnerText);
                        System.Console.WriteLine(xmlResponse.SelectSingleNode("/Response/Consignee/Address1").InnerText);
                        System.Console.WriteLine(xmlResponse.SelectSingleNode("/Response/Consignee/Address2").InnerText);
                        System.Console.WriteLine(xmlResponse.SelectSingleNode("/Response/Consignee/City").InnerText);
                        System.Console.WriteLine(xmlResponse.SelectSingleNode("/Response/Consignee/State").InnerText);
                        System.Console.WriteLine(xmlResponse.SelectSingleNode("/Response/Consignee/Zipcode").InnerText);
                        );

                    }
                    shipment.Dispose();
                    request = null;
                }
			}
			catch (System.Exception ex)
			{
                Console.WriteLine(ex.ToString());
                Console.ReadLine();
			}
		}
	}
}

AutoGenerateColumns=false

<pre>var book = context.Books
                .Where(b => b.ISBN == txtISBN.Text).ToList();

            dataGridViewBook.DataSource = book;

<pre>using System;
using System.Windows.Forms;
using IniParser;
using IniParser.Model;
using System.Collections.Generic;

namespace WindowsFormsApp1
{
    public partial class Form1 : Form
    {
        public string myFilePath;
        public string searchItem;

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            searchBtn.Enabled = false;
            writeIniBtn.Enabled = false;
            saveBtn.Enabled = false;
            AcceptButton = this.searchBtn;
        }

        private void openIniBtn_Click(object sender, EventArgs e)
        {
            OpenFileDialog openFile = new OpenFileDialog();

            openFile.InitialDirectory = "c:\\";
            openFile.Filter = "INI files (*.ini)|*.ini";
            openFile.Title = "Select a INI file for edit";

            if (openFile.ShowDialog() == DialogResult.OK)
            {
                myFilePath = openFile.FileName; // full path to a file
                
                // enable buttons
                searchBtn.Enabled = true;
                writeIniBtn.Enabled = true;
                saveBtn.Enabled = true;
                openIniBtn.Enabled = false; // disable open ini button
            }
        }

        private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            // populate listbox with founded items
            List<string> selectedItems = new List<string>();

            string item = listBox1.SelectedItem.ToString();

            if (!selectedItems.Contains(item))
            {
                selectedItems.Add(item);
            }

            // get clicked item value, section / key
            foreach (string i in listBox1.SelectedItems)
            {
                itemIdTxt.Text = i.Split('[', ']')[1];
                nameInput.Text = i.Split('[', ']')[2];
            }

            
        }

        private void searchBtn_Click(object sender, EventArgs e)
        {
            var searchItem = searchInput.Text; // read value from search input
            
            // start ini
            var parser = new FileIniDataParser();
            parser.Parser.Configuration.AllowDuplicateKeys = true;  // allow duplicate keys
            IniData data = parser.ReadFile(myFilePath);             // opens ini and search in it , myFilePath = path to ini file

            listBox1.Items.Clear(); // clear list

            searchItem = searchInput.Text;  // getting data from input to search for
            
            // loop through sections
            foreach (var item in data.Sections)
            {
                // search for string under key 1
                if (item.Keys["1"].IndexOf(searchItem, 0, StringComparison.CurrentCultureIgnoreCase) != -1)
                {
                    // founded items
                    var foundedItems = ($"[{item.SectionName}] {item.Keys["1"]}");
                    
                    // add founded items to list
                    ListBox list = new ListBox();
                    listBox1.Items.Add(foundedItems);
                }
            }
        }

        private void saveBtn_Click(object sender, EventArgs e)
        {
            var id = itemIdTxt.Text;    // read id
            var name = nameInput.Text;  // read name

            // write to ini file
            var parser = new FileIniDataParser();
            parser.Parser.Configuration.AllowDuplicateKeys = true;
            IniData data = parser.ReadFile(myFilePath);
            data[id]["1"] = name;
            parser.WriteFile(myFilePath, data);

            // update changed item in listbox
            string index = listBox1.SelectedItem.ToString();
            listBox1.Items.Remove(index);
            listBox1.Items.Add(name);
        }

        
    }
}

using System;
using System.Windows.Forms;
using IniParser;
using IniParser.Model;
using System.Collections.Generic;
using System.IO;

namespace WindowsFormsApp1
{
    public partial class Form1 : Form
    {
        public string myFilePath;
        //string myFilePath;

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            searchBtn.Enabled = false;
            writeIniBtn.Enabled = false;
            saveBtn.Enabled = false;
        }

        private void openIniBtn_Click(object sender, EventArgs e)
        {
            OpenFileDialog openFile = new OpenFileDialog();

            openFile.InitialDirectory = "c:\\";
            openFile.Filter = "INI files (*.ini)|*.ini";
            openFile.Title = "Select a INI file for edit";

            if (openFile.ShowDialog() == DialogResult.OK)
            {
                string myFilePath = openFile.FileName;
                // MessageBox.Show("my file path : " + myFilePath); // shows full path to file
                
                // enable buttons
                searchBtn.Enabled = true;
                writeIniBtn.Enabled = true;
                saveBtn.Enabled = true;
                openIniBtn.Enabled = false;
            }
        }

        private void listView1_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (listView1.SelectedItems.Count != 0)
            {
                ListViewItem item = listView1.SelectedItems[0];

                string output = item.Text.Split('[', ']')[1];
                string outputt = item.Text.Split('[', ']')[2];
                
                // set name and id
                itemIdTxt.Text = output.ToString();
                nameInput.Text = outputt.ToString();
            }
        }

        private void searchBtn_Click(object sender, EventArgs e)
        {
            MessageBox.Show("my file path : " + myFilePath); // show me a blank message