Eric March

Eric March

  • 919
  • 820
  • 213

SQL bind to DataGridView

Jul 15 2024 3:06 AM

UPDATE : Can now see desired data in design mode.  Still no go at runtime.  Attached Datasets (capture.jpg)

Where can I find a YouTube report for following problem? 

membershipDataSet.v_ProjectCard is a view on MS SQL and works well on frmMain.  I want bind another membershipDataSet to the DataGridView on a frmEditAdd.  This form is opened from frmMain.  I can't create the new membershipDataSet   This is probably a dumb question, but I'm 77 with limited memory.

        private void FormMain_Load(object sender, EventArgs e)
        {
            InitProjectClass();
            db.openConnection();
            DgvMainShow();
        }

        private void InitProjectClass()
        {
            // TODO: This line of code loads data into the 'membershipDataSet.v_ProjectCard' table.
            // You can move, or remove it, as needed.
            this.v_ProjectCardTableAdapter.Fill(this.membershipDataSet.v_ProjectCard);
            aProjectClass.sSelect = "select TOP (200) * From v_ProjectCard ";
            aProjectClass.sWhere = " where piCompleted = convert(nVarChar(20), '1900-01-01', 112) ";
            aProjectClass.sOrderBy = "Order by piStarted desc;\r\n";
        }