Database

SELECT * FROM SomeWhere WHERE Something = 'SomeCondition' LIMIT 5

sr = SQLBindCol(hstmt,6,SQL_TYPE_TIMESTAMP,date,sizeof(date),&ld);<br />
if(sr != SQL_SUCCESS && sr != SQL_SUCCESS_WITH_INFO)<br />
{<br />
    displayError(sr, "Error in binding 6");<br />
}

<br />
this.dataSetLog.Log.AddLogRow(System.DateTime.Now, NewExp, ID, SN ); <br />
try<br />
{				                              <br />
   this.DataAdapterLog.Update( this.dataSetLog );		<br />
}<br />

public DataSet GetData()
{
    // Create DataSet
    DataSet ds = new DataSet(datasetName);
    OdbcDataAdapter adapter = new OdbcDataAdapter();
    adapter.SelectCommand = GetSelectAllCmd();  // Generates Query: "SELECT * FROM " + tableName
 
    // Get schema from database
    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
 
    // Rename table
    adapter.TableMappings.Add("Table", tableName);
 
    // Get data
    adapter.Fill(ds);
 
    // Do we have errors?
    if(ds.HasErrors)
        ds.RejectChanges();
    else
        ds.AcceptChanges();
 
    // Free resources
    adapter.Dispose();
 
    return ds;
}

ds.Tables[tableName].Columns["name"].MaxLength = 100;