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"; }