2 replies to this topic

[tinoymalayil]

How to Bind a MS SQl Table with JTable in Java Swing....

Please reply if anyone knows....

[iGuest]

How To Bind Mssql Table With JtableHow To Bind Mssql Table With Jtable

Here is a sample code from my project... I hope it will help you.

 

void getTableData()   {   Vector<String> heading = new Vector<String>();   heading.AddElement("Code");   heading.AddElement("First Name");   heading.AddElement("Last Name");   Vector data = new Vector();   try   { String table="tbl_cand_primary"; DB_Query.SelectAllQuery(table, null);   while(DB_Query.Rs.Next())   {   codeT = DB_Query.Rs.GetString("cand_code");   fnameT = DB_Query.Rs.GetString("fname");   lnameT = DB_Query.Rs.GetString("lname");   Vector<String> tmp = new Vector<String>();   tmp.AddElement(codeT);   tmp.AddElement(fnameT);   tmp.AddElement(lnameT);   data.AddElement(tmp);   }   }   catch(SQLException e)   { //   }   finally   { if (DBConnect.Conn != null) { try { DB_Query.Rs.Close(); DB_Query.S.Close (); DBConnect.Conn.Close (); } catch (Exception e) {   //Ignore   } }   }   table = new JTable(data, heading);   v=ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS;   h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS;   jsp = new JScrollPane(table,v,h);   panel_Content.SetLayout(null);   jsp.SetBounds( 0, 0, 500, 150 );   panel_Content.Add( jsp );   }

-reply by Prashant Sharma