.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Home >> Code Snippets >> Visual Studio >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

Display records from database to datagridview using datareader

Posted By:satyapriyanayak       Posted Date: October 09, 2014    Points: 40    Category: Visual Studio    URL: http://www.dotnetspark.com  

In this Code Snippets we will know how to Display records from database to datagridview using datareader.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Datareader_datagridview
    public partial class Form1 : Form
        SqlConnection con = new SqlConnection(@"server = HOME-SAT/SQLEXPRESS;data source = .; initial catalog = test; user id=sa;pwd =pintu ;integrated security = SSPI");
        SqlCommand com;
        string str;

        public Form1()

        private void btn_Show_Click(object sender, EventArgs e)

                com = new SqlCommand();
                com.Connection = con;
                com.CommandText = "select * from emp";
                SqlDataReader reader = com.ExecuteReader();
                if (reader.HasRows)

                    DataTable dt = new DataTable();
                    dataGridView1.DataSource = dt;


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend