Click here to Skip to main content
15,881,687 members
Articles / Programming Languages / Visual Basic
Alternative
Tip/Trick

An Easy Way To Query a Database

Rate me:
Please Sign up or sign in to vote.
0.00/5 (No votes)
14 Feb 2011CPOL 4.6K   1  
You are both wrong with the DataAdapter.Why do you think there is an overload with the querystring and the connectionstring?public DataSet select_query(string query, string con_str){ try { using (SqlDataAdapter da = new SqlDataAdapter(query,con_str)) { ...
You are both wrong with the DataAdapter.
Why do you think there is an overload with the querystring and the connectionstring?
C#
public DataSet select_query(string query, string con_str)
{
  try
  {
         using (SqlDataAdapter da = new SqlDataAdapter(query,con_str))
         {
           DataSet ds = new DataSet();
           da.Fill(ds);  // Automatically opens/closes connection.
           return ds;
         }
       }
       catch (Exception ex)
       {
            MessageBox.Show(ex.Message);  // Bad mojo, but better than nothing I guess.
            return null;
       }
}

License

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


Written By
Web Developer
Germany Germany
Software-Developer since 1990
Specialiced in LAN/WAN Tracers ( sniffer )
now developing in .NET ( c#, VB, ASP ..)

Comments and Discussions

 
-- There are no messages in this forum --