C#

<br />
namespace DBWrapper<br />
{<br />
    public class FieldInfo<br />
    {<br />
        private string strField = string.Empty;<br />
        private string strType = string.Empty;<br />
        private int nLen = 0;<br />
<br />
        public string FieldName<br />
        {<br />
            get { return strField; }<br />
            set { strField = value; }<br />
        }<br />
<br />
        public string FieldType<br />
        {<br />
            get { return strType; }<br />
            set { strType = value; }<br />
        }<br />
<br />
        public int FieldLen<br />
        {<br />
            get { return nLen; }<br />
            set { nLen = value; }<br />
        }<br />
    }<br />
<br />
    public class TableData : List<FieldInfo><br />
    {<br />
        /// <summary><br />
        /// Returns a FieldInfo Struct based on the provided field name.<br />
        /// </summary><br />
        /// <param name="strFieldName"></param><br />
        /// <returns>null on failure</returns><br />
        public FieldInfo Get(string strFieldName)<br />
        {<br />
            FieldInfo retFieldInfo = new FieldInfo();<br />
<br />
            foreach (FieldInfo fiInfo in this)<br />
            {<br />
                if (string.Compare(fiInfo.FieldName, strFieldName, true) == 0)<br />
                    return fiInfo;<br />
            }<br />
<br />
            return new FieldInfo();<br />
        }<br />
<br />
    }<br />
}

<br />
To get the schema info I use this (I think this is half my code and half somebody elses but it's been so long since I touched it I don't remember)<br />
<br />
		protected bool GetTableSchema(out DataTable dtSchema)<br />
		{<br />
			dtSchema = new DataTable();<br />
			SqlCommand dbCommand = new SqlCommand();<br />
			SqlDataReader dbReader;<br />
			bool bRetValue;<br />
<br />
			if (!OpenDatabase())<br />
				return false;<br />
<br />
			try<br />
			{<br />
				dbCommand.CommandText = "SELECT * FROM " + m_strTableName;<br />
                dbCommand.Connection = m_DBConnection;<br />
				dbReader = dbCommand.ExecuteReader(CommandBehavior.KeyInfo);<br />
				dtSchema = dbReader.GetSchemaTable();<br />
				bRetValue = true;<br />
			}<br />
			catch (Exception ex)<br />
			{<br />
                string strErrorMessage = "Error Getting Table Schema " + dbCommand.CommandText + "\r\nMsg: " +<br />
					ex.Message;<br />
#if DEBUG<br />
                Console.WriteLine(strErrorMessage);<br />
#else<br />
                m_LogHandler.WriteLogLine(strErrorMessage);<br />
#endif<br />
				bRetValue = false;<br />
			}<br />
			finally<br />
			{<br />
				CloseDatabase();<br />
                dbCommand.Dispose();<br />
			}<br />
<br />
			return bRetValue;<br />
		}

Green Fuze wrote:

I thought about it...

I tried to prevent it using Thread.sleep(1000)

Green Fuze wrote:

thus making it look like it is a human

Khoramdin wrote:

the Standard Edition should have a Trial Edition.