For civil, family, housing and small claims cases that are 
disclosable, limited information may be available through 
the Case Lookup section of the Judicial Branch?s website. 
More detailed information may be obtained from disclosable 
information in the clerk's file.
Information that is disclosable in a pending criminal case 
may be obtained through the clerk?s office in the 
courthouse where the case is pending. Please note that a 
court clerk can provide only limited information, such as a 
continuance date, over the telephone. In addition, a file 
may still be in court when you call, so the information may 
not be available at that point. 
Disclosable documents may be reviewed in the clerk?s 
office. Copy fees are $1 a page. 

/*DrugNames DblCls.cs*/
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySql.Data.MySqlClient;

/// <summary>
/// Summary description for DrugNamesDblCls
/// </summary>

namespace MedWare
{
  public class DrugNamesDblCls
    {
       MySqlConnection mysqlcon=new MySqlConnection
(System.Configuration.ConfigurationManager.AppSettings
["strDrugs"]);
       MySqlCommand mysqlcmd;
       DrugNamesDalCls objdrugnames = new DrugNamesDalCls();
        public DrugNamesDblCls()
        {
            //
            // TODO: Add constructor logic here
            //
        }
       public int InsDelUpdate(string strQuery)
       {
           int rec=0;
           try
           {
               mysqlcon.Open();
               mysqlcmd = new MySqlCommand(strQuery, 
mysqlcon);
               mysqlcmd.CommandType = CommandType.Text;
               rec = mysqlcmd.ExecuteNonQuery();
           }
           catch (Exception ex)
           {
               objdrugnames.ErrorMsg(ex.Message);
           }
           finally
           {
               mysqlcon.Close();
           }
           return rec;
       }
       
    }
}