http://snippets.dzone.com/posts Sat, 26 Jul 2008 22:49:48 GMT DZone Snippets: Ivan_cursos's Code Snippets http://snippets.dzone.com/posts/show/1854 // description of your code here <br /> <br /><code> <br />SqlConnection conn = null; <br />SqlCommand cmd = null; <br />SqlDataReader dr = null; <br /> <br />String s = null; <br />Product prod = null; <br /> <br />try <br />{ <br /> conn = new SqlConnection("Provider=SQLOLEDB;SERVER=sissql2;UID=sa;PWD=AlfaRoma440;DATABASE=genericatest2"); <br /> <br /> s = " "; <br /> <br /> <br /> cmd = new SqlCommand(s,conn); <br /> dr = cmd.ExecuteReader(); <br /> // lleno el objeto producto <br /> <br /> while( dr.Read()) <br /> { <br /> <br /> } <br /> <br /> <br />} <br />catch (Exception ex) <br />{ <br /> // poner el manejo de errores <br />} <br />finally <br />{ <br /> dr.Close(); <br /> conn.Close(); <br />} <br />dr.Close(); <br />conn.Close(); <br />return prod; <br />} <br /></code> Thu, 06 Apr 2006 21:44:35 GMT http://snippets.dzone.com/posts/show/1854 ivan_cursos (Ivan)