Managed C++/CLI

George L. Jackson wrote:

Templates, in contrast, resolve into ordinary types at compile time and the resulting types may not be specialized in other assemblies

for each (DataRow^ r in myDataSet->Tables[0]->Rows)
{
                            //Create a listView Item and add the first column of the dataset to it
    ListViewItem^ lvindex = gcnew ListViewItem(r[0]->ToString());
                            //Create a subitem and add the seconed column to it
    ListViewItem::ListViewSubItem^ sublvindex = gcnew ListViewItem::ListViewSubItem(lvindex,r[1]->ToString());
                            //Add the 1st subitem to the listview item
    myListView1->SubItems->Add(sublvindex);
                            //Create the seconed ListView SubItem and add the third column of the Dataset to it.
    sublvindex = gcnew ListViewItem::ListViewSubItem(lvindex,r[2]->ToString());
                            //Add the 2nd subitem to the listview item
    myListView1->SubItems->Add(sublvindex);
                            //Add the entire ListViewItem to the next available row in myListView
    myListView1->Items->Add(lvindex);
}

System::String ^ SqlStr;
ListView ^ listView1 = gcnew ListView();
try
{
    SqlStr = "Select IC, Part_Code, PART_NUMBER, PART_NAME from vdcsssp_PARTS_mst" ;

    SqlCommand^ objCmd = gcnew SqlCommand();
    SqlDataAdapter^ objDA = gcnew SqlDataAdapter();
    DataSet^ objDS = gcnew DataSet();
    SqlConnection^ objCon = gcnew SqlConnection();
    objCon->ConnectionString = "User ID=sa;pwd=qil2004;Data Source=qipl-server;Initial Catalog=Qvdcsssp";
    if(objCon->ConnectionString != "")
    {
        objCon->Open();
        objCmd->CommandText = SqlStr;
        objCmd->Connection = objCon;
        objDA->SelectCommand = objCmd;
        objDA->Fill(objDS);
    }
    else
        MessageBox::Show("Error connection Failed");
    return;

    for each (DataRow^ r in objDS->Tables[0]->Rows)
    {
        //Create a listView Item and add the first column of the dataset to it
        ListViewItem^ lvindex = gcnew ListViewItem(r[0]->ToString());
        //Create a subitem and add the seconed column to it
        ListViewItem::ListViewSubItem^ sublvindex = gcnew ListViewItem::ListViewSubItem(lvindex,r[1]->ToString());
        //Add the 1st subitem to the listview item
        lvindex->SubItems->Add(sublvindex);
        //Create the seconed ListView SubItem and add the third column of the Dataset to it.
        sublvindex = gcnew ListViewItem::ListViewSubItem(lvindex,r[2]->ToString());
        //Add the 2nd subitem to the listview item
        lvindex->SubItems->Add(sublvindex);
        //Add the entire ListViewItem to the next available row in myListView
        listView1->Items->Add(lvindex);
    }
}
catch(Exception^ ex)
{
        MessageBox::Show(ex->Message);
}