How to load the datagridview using OOP C#

Question

I am a beginner at C# and .NET oop concepts. I want to load the datagridview. I don't know how to pass the data. What I tried so far I attached below.

I created a class std

public void get()
{
    SqlConnection con = new SqlConnection("server =.; initial catalog=testdb; User ID=sa; Password=123");
    string sql = "select * from std";

    con.Open();

    SqlCommand cm = new SqlCommand(sql, con);
    SqlDataReader dr = cm.ExecuteReader();

    while ( dr.Read())
    {
        string stname = dr["st_name"].ToString();
        string nicnum = dr["nic"].ToString();
    }

    con.Close();
}

Form: I am getting data like this way

 std ss = new std();
 ss.get();

 dataGridView1.Rows.Clear();

If I wrote like this way how to pass data into the datagridview columns? I am stuck in this area

Caius Jard · Accepted Answer · 2021-11-24 07:19:37Z

1

It's easier like this:

    public void FillGrid()
    {
        var dt = new DataTable();
        var da = new SqlDataAdapter("select * from std", "server =.; initial catalog=testdb; User ID=sa; Password=123");
        da.Fill(dt);
        dataGridView1.DataSource = dt;
    }

but if you're going to use such a low level method of database access you should consider adding a DataSet type of file to your project; visual studio will write all this code and more for you with a few mouse clicks, and it makes a good job of creating tables and adapters that are a lot easier to work with

answered Nov 24, 2021 at 7:19

Caius Jard

75k6 gold badges61 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

kobi udemy Over a year ago

sir how get the data from the classs and pass into the grid view

Caius Jard Over a year ago

It is done on the last line of the method. Assigning the filled datatable to the grid's DataSource causes the data to appear in the grid. The data should live in the datatable and be accessed there; if you make changes to the datatable the grid will update to show the changes

kobi udemy Over a year ago

i used above code working but i need the oop concepts. i have created class above std.i want load data from the class in to datagridview

Caius Jard Over a year ago

How about rename the method to GetDataTable, and return dt on the last line instead, then you can do dataGridView1.DataSource = GetDataTable()

kobi udemy Over a year ago

please write the code

|

Dharman · Accepted Answer · 2021-11-24 07:25:57Z

0

you have made multiple mistakes. First you read data wirh dataraeader and in every iteration define two stname and nimnum variables like. So when loop ends variables are destroyed. You have to define data table and read data by dataraeader and and add them to it row by row. Or read by sqldataadapter and read it immediately and pass to datatable object.Finnaly you pass datatable as return object of function. Use this vala as datasource of datagridview property if I'm not wrong.

edited Nov 24, 2021 at 7:25

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Nov 24, 2021 at 7:20

Reza Akraminejad

1,5093 gold badges27 silver badges41 bronze badges

1 Comment

kobi udemy Over a year ago

can you write the code sir

Collectives™ on Stack Overflow

How to load the datagridview using OOP C#

2 Answers 2

6 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related