通过DataTable对象在C＃gridView中显示mongoDB 2.6集合数据。 [英] Show mongoDB 2.6 collection data in a C# gridView through DataTable object.

问题描述

我是mongoDB的新手，我们将不胜感激。

我创建了一个类，我正在使用Entity类将数据插入到集合中Windows窗体。

Hi,
I'm new to mongoDB and the help will be appreciated.
I created a class where I'm inserting data into collection using Entity class in a Windows form.

namespace MongoDB_Setup
{
    private void btnInsertInDB_Click(object sender, EventArgs e)
    {        
          String connectionString = "mongodb://localhost";
          MongoClient client = new MongoClient(connectionString);
          MongoServer server = client.GetServer();
          MongoDatabase database = server.GetDatabase("NetCrawlerDemo");
          MongoCollection collection = database.GetCollection<SGATable>("SGATable");
          
          try
            {
              var SGATable1 = new SGATable()
                {
                    DA_TrackerID = ObjectId.GenerateNewId().Pid,
                    DA_Group = "Next word",
                    DA_SubGroup = "Over",                     
                    DA_DateTime = System.DateTime.Now
                };

                collection.Insert(SGATable1);
            }
catch(Exception ex){MessageBox.Show("Error: "+ex);}
}}

实体类

Entity Class

namespace MongoDB_Setup
{
    class SGATable
    {        
        public ObjectId _id { get; set; }
        public Int32 DA_TrackerID { get; set; }
        public string DA_Group { get; set; }
        public string DA_SubGroup { get; set; }        
        public DateTime DA_DateTime { get; set; }
    }
}

现在我想在FORM上的gridView中显示所有插入的数据DataTable对象。怎么做？请帮忙。

Now I want to show all the inserted data in a gridView on FORM using a DataTable object. How to do it? Please help.

推荐答案

我自己解决了，代码：

I solved it myself, the code:

String connectionString = "mongodb://localhost";
MongoClient client = new MongoClient(connectionString);
MongoServer mdb= client.GetServer();
MongoDatabase database = mdb.MongoConnections("NetCrawlerDemo");
MongoCollection collection = database.GetCollection<"SGATableFind">("DA_TrackerInfo_SGA");

MongoCursor<"BsonDocument"> cursor = collection.FindAllAs<"BsonDocument">();

DataTable dt = new DataTable();
dt.Columns.Add("_id", typeof(MongoDB.Bson.ObjectId));
dt.Columns.Add("DA_TrackerID", typeof(Int32));
dt.Columns.Add("DA_Group", typeof(string));
dt.Columns.Add("DA_SubGroup", typeof(string));
dt.Columns.Add("DA_SearchEngine", typeof(string));
dt.Columns.Add("DA_WebSiteURL", typeof(string));
dt.Columns.Add("DA_ArticleHeader", typeof(string));
dt.Columns.Add("DA_ArticleDescription", typeof(string));
dt.Columns.Add("DA_ArticleDetails", typeof(string));
dt.Columns.Add("DA_CompanyName", typeof(string));
dt.Columns.Add("DA_AdditionalKeyword", typeof(string));
dt.Columns.Add("DA_ArticleDateTime", typeof(string));
dt.Columns.Add("DA_ArticleYear", typeof(string));
dt.Columns.Add("DA_ArticleMonth", typeof(string));
dt.Columns.Add("DA_ArticleDay", typeof(string));
dt.Columns.Add("DA_DateTime", typeof(DateTime));

foreach (var item in cursor)
{
    dt.Rows.Add(item["_id"], item["DA_TrackerID"], item["DA_Group"], item["DA_SubGroup"], item["DA_SearchEngine"],
        item["DA_WebSiteURL"], item["DA_ArticleHeader"], item["DA_ArticleDescription"], item["DA_ArticleDetails"], item["DA_CompanyName"]
        , item["DA_AdditionalKeyword"], item["DA_ArticleDateTime"], item["DA_ArticleYear"], item["DA_ArticleMonth"], item["DA_ArticleDay"]
        , item["DA_DateTime"]);
}

grid1.DataSource = dt;

这篇关于通过DataTable对象在C＃gridView中显示mongoDB 2.6集合数据。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！