Data from the Database doesn't load on the datagrid view

Asked Jun 27 '19 at 14:42

Active Jun 27 '19 at 14:42

Viewed 32 times

I was currently working on a project and wants to load the called data on the datagridview upon form_load, But I wasn't sure why the supposed data wasn't loading. Attached are my codes, could you help me pinpoint whats wrong with this? Needed it badlly.

Code:

   private void Form1_Load(object sender, EventArgs e)
        {
            dataGridView1.DataSource = GetV9_data();

        }

        private DataTable GetV9_data()
        {
            DataTable V9db = new DataTable();

            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = "Data Source = 10.47.48.80; Initial Catalog = V9_Hirata_L2; User ID = Guest; Password = ************;";
            SqlCommand cmd = new SqlCommand("Select ID, MotorSN, StationNo, PT_NestNo, PT_TS_AW_Pin_1, PT_TimeIn FROM tbl_V9_Datalog", conn);

            conn.Open();

            SqlDataReader reader = cmd.ExecuteReader();

            V9db.Load(reader);

            return V9db;
        }

asked Jun 27 '19 at 14:42

sophia kylie taylor

1

try using an SqlDataAdapter in stead of a SqlDataReader – GuidoG Jun 27 '19 at 14:57
What does the debugger say: Has the Table rows & data? – TaW Jun 27 '19 at 15:06
Debugger says nothing, as I am able to run the code. No red highlights nor error logs – sophia kylie taylor Jun 27 '19 at 15:17
@GuidoG whats the difference between the two? – sophia kylie taylor Jun 27 '19 at 15:20
you can read about that [here](https://stackoverflow.com/questions/1676753/sqldataadapter-vs-sqldatareader) – GuidoG Jun 28 '19 at 06:11
_Debugger says nothing, as I am able to run the code_ You need to __learn__ about using the debugger then! It will tell you all the more if the code __is__ running!! Set a __breakpoint__ after the load and look at the datatable!! – TaW Jun 28 '19 at 08:51

Data from the Database doesn't load on the datagrid view

0 Answers0