Posts

Donate

WPF CRUD Application Using DataGrid, MVVM Pattern, Entity Framework, And VB.NET

Image
Good day guys! Here's the VB.NET version of this article WPF CRUD Application Using DataGrid, MVVM Pattern, Entity Framework, And C#.NET which is a CRUD (Create,Update and Delete) application using the DataGrid control, ADO.NET Entity Framework 6.x and Model–View–Viewmodel(MVVM) architectural pattern. The project structure and the logic were derived from that article except that this application incorporates Visual Basic.NET/VB.NET as the programming language. I. Project Setup 1. Create a table in your database called Students using the script from this post WPF CRUD With DataGrid, Entity Framework And C#.NET . 2. Create a WPF Project and add four folders called DataAccess, Model, View and ViewModel. The project structure may resemble with the screenshot provided below. II. Coding The Model and Repository Class 1. Inside the Model folder, add an ADO.NET Entity Data Model object that connects to the Students table in your database. On my part, I named it StudentModel . 2. Fo

WPF CRUD Application Using DataGrid, MVVM Pattern, Entity Framework, And C#.NET

Image
Good day to all! Here's an example of a WPF CRUD (Create,Update and Delete) project using the DataGrid control, ADO.NET Entity Framework 6.x, C#.NET and Model–View–Viewmodel(MVVM) architectural pattern. This post was based from this tutorial WPF CRUD With DataGrid, Entity Framework And C#.NET except that we are now using the MVVM framework. The steps below are pretty straightforward and easy to follow. I. Project Setup 1. Add a table called Students in you database. The complete script is found in this post WPF CRUD With DataGrid, Entity Framework And C#.NET 2. Create a WPF Project and add four folders called DataAccess, Model, View and ViewModel. 3. Your project structure may look similar with the screenshot provided below. II. Coding The Model and Repository Class 1. Inside the Model folder, add an ADO.NET Entity Data Model that connects to the Students table in your database. On my part, I named it StudentModel . 2. For the connectionstring name in App.config file, I

How To Setup Or Configure Row-Level Security (RLS) In Power BI Using Domain Credentials

Image
Good Evening All! While I was creating a Power BI report last year,I was tasked to make a report restrict information for a given set of users in our organization. After googling for a few minutes or so, most of the results were pointing me to Row-Level Security. One of the few points mentioned by Microsoft's RLS documentation is that members of a workspace defined in the Power BI service have access to the datasets. In which case are the admins of the workspace. In this report project we have to restrict data through domain account emails. So to start setting up RLS, I need to tweak some settings for both Power BI Desktop and Power BI Service. I. Power BI Desktop 1. In my sample report, click on Modelling menu then choose Manage Roles. 2. Add New Role called Supervisor Information then click Create. 3. Select Supervisor Information Dataset that contains email or information that will be used to Filter data based on a current role. In this case, I chose the Supervisor Informati

Donate