How to bind to QSqlTableView with data from Microsoft SQL Server?

[Hany]

Hi
i have a problem when i want to bind data from Microsoft SQL Server with QSqlTableView,

QSqlTableModel *model;
 
    model->setTable("tblArtist"); // table Name
    cdb.GetClientDataSet("SELECT tblArtist.* FROM tblArtist", model); //this function get the Query and return by 
                                                                                                               // reference Table Model
    ui->tblView->setModel(model);

QSqlTableModel *model;

    model->setTable("tblArtist"); // table Name
    cdb.GetClientDataSet("SELECT tblArtist.* FROM tblArtist", model); //this function get the Query and return by 
                                                                                                               // reference Table Model
    ui->tblView->setModel(model);

To copy to clipboard, switch view to plain text mode 

this is the first application with C++ Qt4, i'm a C# developer.
i use Qt4.6 under Windows 7 and Microsoft Sql Server 2005 Express
Thanks

[Hany]

hi
any know the solve of the problem please write it.
i really need to know how to fill table view with a database from Microsoft SqlServer
Thanx

[tbscope]

Change

cdb.GetClientDataSet("SELECT tblArtist.* FROM tblArtist", model);

cdb.GetClientDataSet("SELECT tblArtist.* FROM tblArtist", model);

To copy to clipboard, switch view to plain text mode 

to

model->select();

model->select();

To copy to clipboard, switch view to plain text mode 

and see what happens