Click here to Skip to main content
Click here to Skip to main content
Alternative Tip
Go to top

An Easy Way To Query a Database

, 14 Feb 2011
Rate this:
Please Sign up or sign in to vote.
The sample code provided by Andrew Rissing is a huge improvement over the original, but incorrectly catches the exception and displays a MessageBox. (Andrew correctly points out this is not a good idea.)A better solution is to allow the exception to fail:public DataSet...
The sample code provided by Andrew Rissing is a huge improvement over the original, but incorrectly catches the exception and displays a MessageBox. (Andrew correctly points out this is not a good idea.)
 
A better solution is to allow the exception to fail:
 
public DataSet select_query(string query, string con_str)
{
    using (SqlConnection con = new SqlConnection(con_str))
    {
       using (SqlCommand comd = new SqlCommand(query, con))
       {
         using (SqlDataAdapter da = new SqlDataAdapter(comd))
         {
           DataSet ds = new DataSet();
           da.Fill(ds);  // Automatically opens/closes connection.
           return ds;
         }
       }
     }
  }
}
;
 
public int modify_query(string query, global_data data)
{
    using (SqlConnection con = new SqlConnection(data.Con_Str))
    {
      using (SqlCommand comd = new SqlCommand(query, con))
      {
        con.Open();
        try
        {
          int x = comd.ExecuteNonQuery();
          return x;
        }
        finally
        { 
          con.Close();
        }
      }
    }
  }
}

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

woric
Web Developer
Australia Australia
I am a C#/XML developer with almost 10 years professional web development experience and over 15 years experience with Client Server applications.
 
In the past I wrote ISAPI dlls, but these days I stick to ASP.NET, AJAX and CSS based designs.
 
Favourite Technologies: C#, XSLT, NUnit.
 
Pet Hates: Webforms are evil. Developers who cannot write their own HTML shouldn't develop websites. (Seriously, websites made with hand coded HTML/CSS by a decent web-coder are developed quicker and work better. If you can't learn to do it by hand then please stop fooling yourself.)

Comments and Discussions

 
Generalthanx sir for improving PinmemberAbdur Rehman Raza Khan - dontumindit14-Feb-11 18:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web03 | 2.8.140916.1 | Last Updated 14 Feb 2011
Article Copyright 2011 by woric
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid