i am not sure weather there is direct way or not , cos u can take item of list as gettable() method. n as a list has its own hidden filed , so dont think that there wuld be a direct way . may be webserive can help  u in this , u can user XML schema of sql  table n use it to populate data  in lists

Another quick way could be open the SQL DB connection with EXCEL:

office.microsoft.com/.../HA102179561033.aspx

and then save that as excel. Then in Sharepoint you have an option to create a list from Excel sheet. This will be quick and dirty way.

office.microsoft.com/.../HA010346551033.aspx

Try to Use SSIS . Its an add in to Visual studio. You just have to drag and drop the connection. Its very easy and no codding is required.