private void btnFetch_Click(object sender, EventArgs e)
{
TAIGFields.PopulateGridWithData(txtConnectionString.Text, SQLStatement.Text);
string SQLQuerySchema = "sp_describe_first_result_set N'" + SQLStatement.Text.Replace("'", "''") + "'";
TaigQuerySchema.PopulateGridWithData(txtConnectionString.Text, SQLQuerySchema);
ParseIntoTheFieldsList();
ParseIntoTheFieldsGrid();
}
private void ParseIntoTheFieldsGrid()
{
taigFieldDataTypes.Rows = 0;
taigFieldDataTypes.Cols = 2;
taigFieldDataTypes.set_HeaderLabel(0, "Field Name");
taigFieldDataTypes.set_HeaderLabel(1, "Field Type");
for (int i = 0; i < TAIGFields.Cols; i++)
{
TAIGridControl.TaiGridColContentTypes ii = TAIGFields.GetColumnType(i);
string FieldTypeName = TAIGFields.get_HeaderLabel(i);
switch (ii)
{
case TAIGridControl.TaiGridColContentTypes._String:
FieldTypeName += "|String";
break;
case TAIGridControl.TaiGridColContentTypes._Date:
FieldTypeName += "|Date";
break;
case TAIGridControl.TaiGridColContentTypes._WholeNumber:
FieldTypeName += "|WholeNumber";
break;
case TAIGridControl.TaiGridColContentTypes._FloatingPointNumber:
FieldTypeName += "|FloatingPointNumber";
break;
default:
FieldTypeName += "|Bool";
break;
}
taigFieldDataTypes.AddRowToGrid(FieldTypeName, "|");
}
}
