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