Case information includes all data entry completed by the 
close of business the previous day, so the most up-to-date 
information may not have been added when you look up a 
case. The best way to determine the most recent action in a 
file that is disclosable is to go to the clerk?s office and 
review the file. 
Scheduled court dates for civil and family cases are 
available through the case lookup section. 
Where can I get an individual?s entire criminal history?
The official source for an individual?s full criminal 
history is the State Department of Public Safety, Division 
of State Police, Bureau of Investigation.

/*DrugNames DalCls.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;
using System.Windows.Forms;
using System.IO;
using MedWare;

/// <summary>
/// Summary description for DrugNamesDalCls
/// </summary>
public class DrugNamesDalCls
{
    MySqlConnection mysqlcon = new MySqlConnection
(System.Configuration.ConfigurationManager.AppSettings
["strDrugs"].ToString());
    
    public DrugNamesDalCls()
    {
        //
        // TODO: Add constructor logic here
        //
    }
    public void ErrorMsg(string strError)
    {
        string strErrorPath = 
HttpContext.Current.Server.MapPath("Errordetails.txt");
        using (FileStream fs = File.Open(strErrorPath, 
FileMode.Append, FileAccess.Write))
        {
            using (StreamWriter sw = new StreamWriter(fs))
            {
                sw.WriteLine
("..........................................................
............................");
                //sw.WriteLine("ApplicationName:" + 
strAppUrl);
                sw.WriteLine("Error:" + strError);
                sw.WriteLine("Creation Date:" + 
DateTime.Now);
                sw.WriteLine
("..........................................................
............................");
            }

        }
    }

    //FUNCTION FOR INSERT TRANSACTION.
    public int InsertDrugName(string pstrDrugName)
    {
        int irec = 0;
        string strDate=DateTime.Now.ToString();
        //string strIns = "INSERT INTO DRUGNAME VALUES('" + 
pstrDrugName + "')";
        string strIns = "INSERT INTO DRUGNAME (DrugName) 
values('" + pstrDrugName + "')";
        try
        {
            irec = new DrugNamesDblCls().InsDelUpdate
(strIns);
        }
        catch (Exception ex)
        {
            ErrorMsg(ex.Message); 
        }
        return irec;
    }

    //FUNCTION FOR UPDATE TRANSACTION.
    public int UpdateDrugName(string strDrugName, string 
DrugNameID)
    {
        int irec = 0;
        string strUpdate = "UPDATE drugname SET DRUGNAME='" 
+ strDrugName + "' WHERE DRUGNAMEID=" + DrugNameID;
        try
        {
            irec = new DrugNamesDblCls().InsDelUpdate
(strUpdate);
        }
        catch (Exception ex)
        {
            ErrorMsg(ex.Message);
        }
        return irec;
    }

    // FUNCTION FOR DELETE TRANSACTION.
    public int DeleteDrugName(string strDrugNameID)
    {
        int irec = 0;
        string strDel = "DELETE FROM drugname WHERE 
drugname='" + strDrugNameID + "'"; 
        try
        {
            irec = new DrugNamesDblCls().InsDelUpdate
(strDel);
        }
        catch (Exception ex)
        {
            ErrorMsg(ex.Message);
        }
        return irec;
    }
   
}