I want to show Components in a tabs , so first of all create few components. In this project we have three components, First View Component public class AllViewComponent : ViewComponent { private readonly UserManager<ApplicationUser> _userManager; public AllViewComponent(UserManager<ApplicationUser> userManager) { _userManager = userManager; } public async Task<IViewComponentResult> InvokeAsync() { List<StudentViewModel> allUsers = new List<StudentViewModel>(); var items = await _userManager.Users.ToListAsync(); foreach (var item in items) { allUsers.Add(new StudentViewModel {Id=item.Id, EnrollmentNo = item.EnrollmentNo, FatherName = item.FatherName, Name = item.Name, Age = item.Age, Birthdate = item.Birthdate, Address = item.Address, Gender = item.Gender, Email = item.Email }); }
Introduction
In Previous article we have already learn that how to connect MS-Access with windows form. Today we will take a example of binding Gridview with MS-Access in asp.net c#. Also learn how to create connection using OleDbConnection class which is exist in System.Data.OleDb namespace.
Description:
First to read, How to create Database table in Ms-Access and how to create connection with MS-Access using c#. Now, after creating the database you can create the command using OleDbCommand class which is also available in System.Data.OleDb namespace. Use OleDbDataReader Class which is used to read the database table in forward only mode. Now, Bind the DataGridView with Data Reader. Check the below mentioned code as well as video:
Database table
Database table
Source code :
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default6.aspx.cs" Inherits="Default6" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</form>
</body>
</html>
Connection String in web.config file
<connectionStrings>
<add name ="Connection" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\Dbase.accdb;Persist Security Info=False;"/>
</connectionStrings>
<connectionStrings>
<add name ="Connection" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\Dbase.accdb;Persist Security Info=False;"/>
</connectionStrings>
Code Behind
using System;
using System.Configuration;
using System.Data.OleDb;
using System.Web.UI;
public partial class Default6 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
loadgrid();
}
}
private void loadgrid()
{
OleDbConnection con = new OleDbConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["Connection"].ToString();
con.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = "Select * from [Employee]";
cmd.Connection = con;
OleDbDataReader rd = cmd.ExecuteReader();
GridView1.DataSource = rd;
GridView1.DataBind();
}
}
Comments
Post a Comment