C# mongoDB 驱动程序数据库连接
本文关键字:数据库连接 驱动程序 mongoDB | 更新日期: 2023-09-27 18:35:38
所以我刚刚进入编程以及C#和noSQL数据库。我目前正在开发一个小程序,该程序在ASP.NET
Web应用程序上显示MongoDB
数据库的数据。我坚持连接到我的本地数据库。
数据需要存储在 lblMotherboard 中:这是我的代码。建造者.aspx:
<asp:Label ID="lblMotherboard" runat="server" Text=""></asp:Label>
建造者.aspx.cs:
using MongoDB.Bson;
using MongoDB.Driver;
public void showMobos_Click(object sender, EventArgs e)
{
var name = "";
var connectionString = "mongodb://localhost:27017/";
var mongoClient = new MongoClient(connectionString);
MongoServer server = mongoClient.GetServer();
MongoDatabase database = server.GetDatabase("mydb");
MongoCollection<Post> mobos = database.GetCollection<Post>("moederborden");
foreach (Post parts in mobos.FindAll())
{
name = name + " " + parts.Aanbieder + " " + parts.ProductNaam;
}
lblMotherboard.Text = name;
}
单击按钮时showMobos_Click
开始。它不打印任何数据。出了什么问题?
示例文档:
{
"_id" : ObjectId("54a287ef0d0a7f888510d14e"),
"Aanbieder" : "Coolblue",
"Productlink" : "http://computerstore.nl/product/470130/category-208983/asrock-z97-extreme6.html",
"Productnaam" : "Asus H97-Pro Gamer",
"Prijs" : "129,-",
"Socket" : "1150"
}
帖子.class:
public class Post
{
public ObjectId _id { get; set; }
public String Aanbieder { get; set; }
public String Productlink { get; set; }
public String Productnaam { get; set; }
public decimal Prijs { get; set; }
public int Socket { get; set; }
}
您必须将Prijs
更改为数字
在 mongo 控制台中运行以下命令:
db.moederborden.find().forEach(function(doc)
{
var price = doc.Prijs.replace(',', ''); // it may be vary for your other document
price = price.replace('-', '');
doc.Prijs = Number(price);
db.moederborden.update({_id : doc._id} , doc);
})