MongoDB CRUD Operation In WPF C# With GridView

Building the sample

You have to install and configure it in your Windows system. Please make sure though MongoDB command prompt that it works.

For MongoDB installation and configuration on Windows sytem, you can go through

http://social.technet.microsoft.com/wiki/contents/articles/26542.mongo-db-installation-in-windows-7.aspx
http://prmdpandit.jbko.in/Archive/2014/9/mongo%20db%20installation%20in%20windows

Follow the steps given below.

MongoDB installation

Open mongo.config file and paste this.
dbpath=C:\mongodb\Data
logpath=C:\mongodb\Log\mongodb.log
diaglog=3
Save the file.
Go to the Wind+R or run and type cmd and open with an administrator.
or
Open DOS as an administrator.
Change Directory c:\mongodb\bin\>
c:\mongodb\bin\>mongod.exe --config="c:\mongodb\mongo.config" press enter
Open new command prompt with an administrator.
Go to c::\mongodb\bin\> mongo.
Now, the Server will start and you are in MongoDB prompt.
> use test
>db

Description

Befor starting, please check your MongoDB Service, if it's running or not.

Follow the steps given below.

After installing MongoDB in your system, let's test some DB query in to MongoDB environment.

>Use mydb <press enter>

switch to my db

For other commands, please refer to the image given below.

WPF

This Application shows how the basic CRUD opration on MongoDB runs by using wpf C# and .NET with WPF GridView control.

In this Application, you have the functionality given below.

It is immediately reflected in the GridView after any transaction on MongoDB by our Application.

You have to add MongoDB driver DLL for .NET.

WPF

To downlaod, .NET driver DLL, you can refer the link given below.

https://github.com/mongodb/mongo-csharp-driver/releases

I had already inserted it in to the debug folder but if you have any problem, you can get from there.

After the execution, the Application image is given below.

WPF

This is all the basic code, which I am using for simple CRUD operations in WPF C# and .NET, please go through the code.

using MongoDB.Bson;
using MongoDB.Driver;
using MongoDB.Shared;
using MongoDB.Bson.Serialization.Attributes;
using MongoDB.Driver.Builders;
MongoClient mongo = new MongoClient("mongodb://localhost");
MongoServer server ;
MongoDatabase database;
MongoCollection<info> _infos;
//This all the global variable in your project.
//we will initiate this all in to the intialization method
server = mongo.GetServer();
server.Connect();
database= server.GetDatabase("mydb");
//"mydb" is the mongodb database name in my system //where database is there for curd opration.
//for insert the record in db
public void addinfo(info _info)
{
_info.Id = ObjectId.GenerateNewId();
_infos.Insert(_info);
}
//For binding the gridview
public void bindgrid()
{
// bind the existing info collection<table> record in grid
_infos = database.GetCollection<info>("info");
infogrid.DataContext = _infos.FindAll();
infogrid.ItemsSource = _infos.FindAll();
}
//update the data
public void updateInfo(info _info)
{
IMongoQuery query = Query.EQ("info_id", _info.info_id);
IMongoUpdate update = Update
.Set("firstname", _info.firstname)
.Set("lastname", _info.lastname)
.Set("age", _info.age);
SafeModeResult result = _infos.Update(query, update);
}
//delete the record
IMongoQuery query = Query.EQ("info_id", _info.info_id);
SafeModeResult result = _infos.Remove(query); bindgrid();

Source Code files

Model, which I have created for mapping of the info collection <table>

C#

3 Comments

Join the conversation! Your thoughts help the community grow.

Nathan Nelson9y ago
Nice article, since I am learning WPF can I see your entire code including xaml?
- pramod pandit9y ago
  You can download from https://code.msdn.microsoft.com/windowsapps/mongo-DB-Crud-operation-in-c4c59b9d
Rafnas T P9y ago
Nice beginning, keep going...