bind MS sql data to Visual JSF Table

[bourn3]

mostly for databases like MySQL and JavaDB netbeans has option to drag drop and bind data but it is not present for MS Sql database, i am confused
how to bind data of MS Sql to Visual JSF Table.

I am making project with Visual JSF and backend as MS SQL

can any one help ! please do, i know JDBC but i am not able to bind it to the table in Visual JSF Web Page

[Andreas Ernst]

bourn3 schrieb:

[nicumarius]

is very simple ....I'm in a similar situation.I'm using MS SQL database with netbeans and I can drag and drop without problems.
you should download a jdbc driver . I've chooosed net.sourceforge.jtds.jdbc.Driver .It's free and u can download it from internet ...just google it.
in Netbeans -> Services-> Drivers-> Add new driver....
After ading the jTDS driver just right click -> connect using and set the host, user, port, db etc... and that's all. You should be able to connect and work with SQL tables from netbeans interface .Be aware of security settings for the user that u choosed to login to db .
Good luck!

[hobnob24]

the mapping of the mysql table is done by simply dragging it on to the table.But plz somebody suggest me if i want to add only partial columns of the table to it then how to do it?What i mean is suppose that login table has three fields in it name ,password and id ....in a table i want that only the name and password should come and not the id how to do it?

[jhalupka]

You should be able to edit the table's layout and remove the columns you
don't want.

I build web apps using VWP. Right-click on the table and select Table
Layout.

I'm not sure how it works with Java Desktop Apps.


hobnob24 wrote: