c# - 使用 LINQ 查询在窗体网格视图中添加组合框

Question

我正在尝试使用 LINQ 查询将组合框添加到数据网格视图中，我也没有使用采用者。

  var record = from x in dc.GetTable<Detail>()
                           where x.RaisedBy ==  Global.Username
                           orderby x.Datetime descending
                            select new
                            {
                                x.id,
                                x.Name,
                                x.Contact,
                                x.Segment,
                                x.Datetime,
                                x.RaisedBy
                            };



               gvRecord.DataSource = record;

标签： c#winformsgridview

Answer 1

  DataClasses1DataContext dc = new DataClasses1DataContext();

    public MainPage()
    {
        InitializeComponent();

        DataClasses1DataContext dc = new DataClasses1DataContext();
        var details = (from x in dc.Details
                       select x).ToList();
        comboBox1.ValueMember = "Contact";
        comboBox1.DataSource = details;


        try
        {

            var combocolumn = new DataGridViewComboBoxColumn();
            combocolumn.ValueMember = "Contact";// Column name
            combocolumn.DataSource = details;//Convert.ToString(combocolumn).ToList(); //new string[] {"1","2" };// dc.Details; 

            gvRecord.Columns.Add(combocolumn);
        }
        catch (Exception)
        {
            MessageBox.Show("ERROR");
        }




    }