I have a problem about sql server
this is my jsp code
<%
try{
Connection con=DriverManager.getConnection(URL,Username,Password);
Statement stmt=con.createStatement();
String sql="select * from news";
ResultSet rs=stmt.executeQuery(sql);
out.println("<table width='80%' align='center border=1 bordercolor=black' cellpadding='2' cellspacing='0'>");
out.println("<tr bgcolor='#FFCC33'><td>News Order</td><td>Head News</td><td>Reference</td><td>Date</td><td>Edit</td><td>Delete</td></tr>");
while(rs.next()){
out.println("<tr><td>"+rs.getString("NewsID")+"</td>");
out.println("<td>"+rs.getString("HeadNews")+"</td>");
out.println("<td>"+rs.getString("Refer")+"</td>");
out.println("<td>"+rs.getString("NewsDate")+"</td>");
out.println("<td><a href=EditNews.jsp?NewsID="+rs.getString("NewsID")+">Edit</a></td>");
out.println("<td><a href=DeleteNews.jsp?NewsID="+rs.getString("NewsID")+">Del</a></td></tr>");
}
rs.close();
stmt.close();
con.close();
out.println("</table>");
out.println("<br><center><a href='AddNews.jsp'>Add News</a></center>");
}catch(SQLException e2){
out.println("Error Occur2 :"+e2);
}
%>
When i runing this code page i get error:
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
i don't know why. please help me.
Please reply or sent to me by e-mail : chainimit@hotmail
i hope someone can help me to know this problem because I trying to find in website
but i am not clear about that.
Thank you