// creates a control of appropriate type for the parameter.
// note: parameter values are stored as invariant strings.
private Control GetControl(OleDbParameter p)
{
var value = p.Value as string;
var type = OleDbSchema.GetType(p.OleDbType);
if (OleDbSchema.IsNumeric(type))
{
var num = new Altaxo.Gui.Common.DecimalUpDown
{
Minimum = decimal.MinValue,
Maximum = decimal.MaxValue
};
decimal dec = 0;
if (!string.IsNullOrEmpty(value))
{
decimal.TryParse(value, _numberStyle, _invariant, out dec);
}
num.Value = dec;
return(num);
}
if (type == typeof(DateTime))
{
var dtp = new DatePicker
{
SelectedDateFormat = p.OleDbType == OleDbType.Filetime
? DatePickerFormat.Long
: DatePickerFormat.Short
};
DateTime dt = DateTime.Now;
if (!string.IsNullOrEmpty(value))
{
DateTime.TryParse(value, _invariant, _dateStyle, out dt);
}
dtp.SelectedDate = dt;
return(dtp);
}
if (type == typeof(bool))
{
var chk = new CheckBox();
bool b = false;
if (!string.IsNullOrEmpty(value))
{
bool.TryParse(value as string, out b);
}
chk.IsChecked = b;
return(chk);
}
// default: textbox
var tb = new TextBox
{
Text = value
};
return(tb);
}
// creates a control of appropriate type for the parameter.
// note: parameter values are stored as invariant strings.
private Control GetControl(OleDbParameter p)
{
var value = p.Value as string;
var type = OleDbSchema.GetType(p.OleDbType);
if (OleDbSchema.IsNumeric(type))
{
var num = new Altaxo.Gui.Common.DecimalUpDown();
num.Minimum = decimal.MinValue;
num.Maximum = decimal.MaxValue;
decimal dec = 0;
if (!string.IsNullOrEmpty(value))
{
decimal.TryParse(value, _numberStyle, _invariant, out dec);
}
num.Value = dec;
return num;
}
if (type == typeof(DateTime))
{
var dtp = new DatePicker();
dtp.SelectedDateFormat = p.OleDbType == OleDbType.Filetime
? DatePickerFormat.Long
: DatePickerFormat.Short;
DateTime dt = DateTime.Now;
if (!string.IsNullOrEmpty(value))
{
DateTime.TryParse(value, _invariant, _dateStyle, out dt);
}
dtp.SelectedDate = dt;
return dtp;
}
if (type == typeof(bool))
{
var chk = new CheckBox();
bool b = false;
if (!string.IsNullOrEmpty(value))
{
bool.TryParse(value as string, out b);
}
chk.IsChecked = b;
return chk;
}
// default: textbox
var tb = new TextBox();
tb.Text = value;
return tb;
}
