Youtube RSS Feed
Learn with Vikas Suhag
Design an application to Retrive data from Database using SqlDataReader(Sql Server).
Nov 16, 2021   Vikas Suhag
Program to fetch data from SQL Server database

AIM: Design an application to Retrive data from Database using SqlDataReader(Sql Server).

Source Code :

// Main Page

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 WindowsFormsApplication2

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

 

        private void button1_Click(object sender, EventArgs e)

        {

            try

            {

                sqlConnection1.Open();

                sqlCommand1.Connection = sqlConnection1;

                sqlCommand1.CommandText = "insert into student values('" + textBox1.Text + "','" + textBox2.Text + "','" + comboBox1.Text + "','" + textBox3.Text + "','" + textBox4.Text + "')";

                sqlCommand1.ExecuteNonQuery();

                MessageBox.Show("Data Inserted");

            }

            catch (Exception ex)

            {

                MessageBox.Show(ex.Message);

            }

            sqlConnection1.Close();

        }

 

        private void searchToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form2 f = new Form2();

            f.Show();

        }

    }

}

// Search Page

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;

 

namespace WindowsFormsApplication2

{

    public partial class Form2 : Form

    {

        public Form2()

        {

            InitializeComponent();

        }

      

 

        private void button1_Click(object sender, EventArgs e)

        {

            Form3 o = new Form3(textBox1.Text);

            o.Show();

            this.Hide();

        }

    }

}

 

// Data Page

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 WindowsFormsApplication2

{

    public partial class Form3 : Form

    {

        SqlDataReader dr;

        String roll;

        public Form3()

        {

            InitializeComponent();

        }

        public Form3(String str)

        {

            roll = str;

            InitializeComponent();

        }

 

        private void Form3_Load(object sender, EventArgs e)

        {

            try

            {

                sqlConnection1.Open();

                sqlCommand1.Connection = sqlConnection1;

                sqlCommand1.CommandText = "select * from student where roll=roll";

                dr = sqlCommand1.ExecuteReader();

                while (dr.Read())

                {

                    label6.Text = dr.GetValue(0).ToString();

                    label7.Text = dr.GetValue(1).ToString();

                    label8.Text = dr.GetValue(2).ToString();

                    label9.Text = dr.GetValue(3).ToString();

                    label10.Text = dr.GetValue(4).ToString();

                }

            }

            catch (Exception ex)

            {

                MessageBox.Show(ex.Message);

            }

            sqlConnection1.Close();

        }

    }

}

Output:


Leave a Comment

* Email will not be published.
All comments are only visible after approval.
Most Viewed articles
Search
Subscribe to Email Updates
Vikas Suhag

I am Engineer, Developer, Teacher, Blogger, Vlogger, Traveller, Photographer...

I have been developing websites, writing blogs and recording videos during my travel while being a full tim ...

Youtube Channel
Podcast
Subscribe to Email Updates
Connect With Us
Youtube RSS Feed
© 2021 Learn with Vikas Suhag. All Rights Reserved.