when using dataset ,is it recommended to open and close connection
i know the default connrction is closed
by this code
SqlConnection con = new SqlConnection("Password=asd;Persist Security Info=True;User ID=sa;Initial Catalog=ajax;Data Source=NEWLOOK");
Response.Write(con.State