本文整理汇总了C#中System.Data.SQLite.SQLiteDataReader.GetDecimal方法的典型用法代码示例。如果您正苦于以下问题:C# SQLiteDataReader.GetDecimal方法的具体用法?C# SQLiteDataReader.GetDecimal怎么用?C# SQLiteDataReader.GetDecimal使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SQLite.SQLiteDataReader
的用法示例。
在下文中一共展示了SQLiteDataReader.GetDecimal方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Report
public Report()
{
InitializeComponent();
// Connect to database file
sql_con = new SQLiteConnection("Data Source=" + applicationPath + "\\ExpenseTracker.db;Version=3;New=False;Compress=True;");
sql_cmd = new SQLiteCommand();
sql_con.Open();
sql_cmd.Connection = sql_con;
sql_cmd.CommandText = "SELECT * FROM Month";
sql_reader = sql_cmd.ExecuteReader();
while (sql_reader.Read())
{
dataGridView.Rows.Add(
sql_reader.GetInt32(0),
CustomDate.GetThaiMonth(sql_reader.GetInt32(1)),
sql_reader.GetDecimal(2).ToString("#,#0.00#"),
sql_reader.GetDecimal(3).ToString("#,#0.00#"),
sql_reader.GetDecimal(4).ToString("#,#0.00#")
);
}
sql_reader.Close();
dataGridView.ClearSelection();
}
示例2: OutputRmlTable
//.........这里部分代码省略.........
}
string strText = "";
if (column.ColumnNumber != -1)
{
if (string.IsNullOrEmpty(column.Eval) == false)
{
// engine.SetGlobalValue("cell", line.GetObject(column.ColumnNumber));
strText = engine.Evaluate(column.Eval).ToString();
}
else if (column.DataType == DataType.PriceDouble)
{
if (table.IsDBNull(column.ColumnNumber /**/) == true)
strText = column.DefaultValue;
else
{
double v = table.GetDouble(column.ColumnNumber);
/*
NumberFormatInfo provider = new NumberFormatInfo();
provider.NumberDecimalDigits = 2;
provider.NumberGroupSeparator = ".";
provider.NumberGroupSizes = new int[] { 3 };
strText = Convert.ToString(v, provider);
* */
strText = v.ToString("N", nfi);
}
}
else if (column.DataType == DataType.PriceDecimal)
{
if (table.IsDBNull(column.ColumnNumber) == true)
strText = column.DefaultValue;
else
{
decimal v = table.GetDecimal(column.ColumnNumber);
strText = v.ToString("N", nfi);
}
}
else if (column.DataType == DataType.PriceDecimal)
{
if (table.IsDBNull(column.ColumnNumber) == true)
strText = column.DefaultValue;
else
{
decimal v = table.GetDecimal(column.ColumnNumber);
strText = v.ToString("N", nfi);
}
}
else if (column.DataType == DataType.Price)
{
// Debug.Assert(false, "");
if (table.IsDBNull(column.ColumnNumber) == true)
strText = column.DefaultValue; // 2005/5/26
else
strText = table.GetString(column.ColumnNumber); //
}
else
strText = table.GetString(column.ColumnNumber/*, column.DefaultValue*/);
}
else
{
strText = table.GetString(0); // line.Entry;
}
writer.WriteStartElement(j == 0 ? "th" : "td");
if (string.IsNullOrEmpty(column.CssClass) == false)
writer.WriteAttributeString("class", column.CssClass);
示例3: LoadHistory
private void LoadHistory()
{
toolStripHeader.Text = "บัญชีรับ-จ่าย ประจำเดือน " + cmbMonth.SelectedItem +" พ.ศ. " + cmbYear.SelectedItem;
ClearTable();
sql_cmd.CommandText = "SELECT Date, Description, Type, Amount FROM Detail WHERE Year = '" + cmbYear.SelectedItem + "' AND Month = '" + cmbMonth.SelectedItem + "'";
sql_reader = sql_cmd.ExecuteReader();
while (sql_reader.Read())
{
dataGridView.Rows.Add(new Object[] {
sql_reader.GetString(0),
sql_reader.GetString(1),
sql_reader.GetString(2),
(sql_reader.GetString(2) == "รับ")? Properties.Resources._in : Properties.Resources._out,
sql_reader.GetDecimal(3)
});
}
sql_reader.Close();
dataGridView.Sort(dataGridView.Columns[0], System.ComponentModel.ListSortDirection.Ascending);
dataGridView.ClearSelection();
}
示例4: LoadCurrentMonth
private void LoadCurrentMonth()
{
toolStripHeader.Text = "บัญชีรับ-จ่าย ประจำเดือน " + CustomDate.GetThaiMonth(DateTime.Today.Month) + " พ.ศ. " + CustomDate.GetThaiYear(DateTime.Today.Year);
ClearTable();
// Load data for this month
sql_cmd.CommandText = "SELECT Date, Description, Type, Amount FROM Detail WHERE Year = '" + CustomDate.GetThaiYear(DateTime.Today.Year) + "' AND Month = '" + DateTime.Today.Month + "'";
sql_reader = sql_cmd.ExecuteReader();
while (sql_reader.Read())
{
dataGridView.Rows.Add(new Object[] {
sql_reader.GetString(0),
sql_reader.GetString(1),
sql_reader.GetString(2),
(sql_reader.GetString(2) == "รับ")? Properties.Resources._in : Properties.Resources._out,
sql_reader.GetDecimal(3)
});
}
sql_reader.Close();
dataGridView.Sort(dataGridView.Columns[0], System.ComponentModel.ListSortDirection.Ascending);
dataGridView.ClearSelection();
}
示例5: ReadQueryResult
private static void ReadQueryResult(QueryResolution resolution, SQLiteDataReader reader, List<KeyValuePair<DateTime, decimal>> values)
{
switch (resolution)
{
case QueryResolution.All:
var date = reader.GetDateTime(0);
var value = reader.GetDecimal(1);
values.Add(new KeyValuePair<DateTime, decimal>(date, value));
break;
default:
var rawDate = Convert.ToString(reader["GroupedDate"]);
// Partial time resolutions will cause the raw date to have a minute value
// of :0 instead of :00, which will cause parsing errors, so try and fix that
if (rawDate.EndsWith(":0"))
rawDate += "0";
var resolutionDate = DateTime.Parse(rawDate);
var resolutionValue = reader.GetDecimal(reader.GetOrdinal("Value"));
values.Add(new KeyValuePair<DateTime, decimal>(resolutionDate, resolutionValue));
break;
}
}