本文整理汇总了C#中System.Data.Common.DbDataReader.GetName方法的典型用法代码示例。如果您正苦于以下问题:C# DbDataReader.GetName方法的具体用法?C# DbDataReader.GetName怎么用?C# DbDataReader.GetName使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Common.DbDataReader
的用法示例。
在下文中一共展示了DbDataReader.GetName方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Contato
// criar instancia a partir dos dados obtidos do banco
public Contato(DbDataReader r)
{
for (int i=0; i < r.FieldCount; i++)
{
switch (r.GetName(i))
{
case "nome":
nome = Convert.ToString(r[i]);
break;
case "telefones":
telefones = Convert.ToString(r[i]);
break;
case "endereco":
endereco = Convert.ToString(r[i]);
break;
case "aniversario":
DateTime niverDt = Convert.ToDateTime(r[i]);
aniversario = String.Format("{0:dd/MM/yyyy}", niverDt);
break;
case "outros":
outros = Convert.ToString(r[i]);
break;
}
}
}
示例2: FluxoCaixa
// criar instancia a partir dos dados obtidos do banco
public FluxoCaixa(DbDataReader r)
{
for (int i = 0; i < r.FieldCount; i++)
{
switch (r.GetName(i))
{
case "flc_id":
id = Convert.ToInt16(r[i]);
break;
case "flc_data":
data = Convert.ToDateTime(r[i]);
break;
case "flc_descricao":
descricao = Convert.ToString(r[i]);
break;
case "flc_tipo":
tipo = new TipoFluxo(r);
break;
case "flc_valor":
valor = Convert.ToDouble(r[i]);
break;
}
}
}
示例3: Print
public static void Print(string sql, DbDataReader reader)
{
log.Info("Results of [" + sql + "]");
string results = "\n";
if (reader.HasRows)
{
for (int j = 0; j < reader.FieldCount; j++)
{
results += reader.GetName(j);
if (j < reader.FieldCount - 1)
{
results += "|";
}
}
results += "\n";
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
results += reader.GetValue(i);
if (i < reader.FieldCount - 1)
{
results += "|";
}
}
results += "\n";
}
results = results.Substring(0, results.Length - 1);
log.Info(results);
}
}
示例4: DisplayRows
public void DisplayRows(DbDataReader nt)
{
this.listView1.Clear();
for (int i = 0; i < nt.FieldCount; i++)
{
listView1.Columns.Add(nt.GetName(i));
}
int rowCount = 0;
while (nt.NextResult())
{
rowCount++;
string contents = "";
if (nt[0] != null)
{
contents = nt[0].ToString();
}
ListViewItem lvi = new ListViewItem(contents);
for (int i = 1; i < nt.FieldCount; i++)
{
contents = "";
if (nt[i] != null)
{
contents = nt[i].ToString();
}
lvi.SubItems.Add(contents);
}
this.listView1.Items.Add(lvi);
}
this.toolStripStatusLabel1.Text = rowCount.ToString() + " row(s) returned.";
}
示例5: DynamicEntityValue
public DynamicEntityValue(DbDataReader reader)
{
for(int i = 0; i < reader.FieldCount; i++)
{
this._nameValues.Add(reader.GetName(i), reader.GetValue(i));
}
}
示例6: Write
public static void Write(XmlDocument target, DbDataReader source )
{
/*
Style:
<root>
<raw><name>name1</name><index>name2</index></raw>
<raw><name>name1</name><index>name2</index></raw>
<raw><name>name1</name><index>name2</index></raw>
</root>
*/
XmlNode head = target.CreateNode(XmlNodeType.Element, "head", "");
XmlNode body = target.CreateNode(XmlNodeType.Element, "body", "");
for (int i = 0; i < source.FieldCount; ++i)
{
string vl = source.GetName(i);
string local = (string)HttpContext.GetGlobalResourceObject("local", vl);
if (local != null) vl = local;
Util.AddNodedText(head, "column", vl, false);
}
while (source.Read())
{
XmlNode raw = target.CreateNode(XmlNodeType.Element, "raw", "");
for (int i = 0; i < source.FieldCount; ++i) Util.AddNodedText(raw, "value", Util.GetString( source, i ), false);
body.AppendChild(raw);
}
target.FirstChild.AppendChild(head);
target.FirstChild.AppendChild(body);
}
示例7: GetColumnNames
private static string[] GetColumnNames(DbDataReader dr, int numberOfColumns) {
var colNames = new List<string>();
for (int i = 0; i < numberOfColumns; i++) {
colNames.Add(dr.GetName(i));
}
return colNames.ToArray();
}
示例8: ConvertDataReaderToDataTable
public static DataTable ConvertDataReaderToDataTable(DbDataReader reader)
{
try
{
DataTable table = new DataTable();
int fieldCount = reader.FieldCount;
for (int fieldIndex = 0; fieldIndex < fieldCount; ++fieldIndex)
{
table.Columns.Add(reader.GetName(fieldIndex), reader.GetFieldType(fieldIndex));
}
table.BeginLoadData();
object[] rowValues = new object[fieldCount];
while (reader.Read())
{
reader.GetValues(rowValues);
table.LoadDataRow(rowValues, true);
}
reader.Close();
table.EndLoadData();
return table;
}
catch (Exception ex)
{
throw new Exception("DataReader转换为DataTable时出错!", ex);
}
}
示例9: Table
public Table(DbDataReader reader)
{
Headers = Enumerable.Range(0, reader.FieldCount).Select(column => reader.GetName(column)).ToList();
Rows = new List<List<string>>();
while (reader.Read())
Rows.Add(Enumerable.Range(0, reader.FieldCount).Select(column => reader[column]).Select(value => GetDBValue(value)).ToList());
}
示例10: ImportDataReader
public static DataRow ImportDataReader(this DataTable table, DbDataReader dr)
{
var row = table.NewRow();
for (var i = 0; i < dr.FieldCount; i++) {
var columnName = dr.GetName(i);
row[columnName] = dr[i];
}
table.Rows.Add(row);
return row;
}
示例11: BasicFieldNameLookup
public BasicFieldNameLookup(DbDataReader reader)
{
int length = reader.FieldCount;
string[] fieldNames = new string[length];
for (int i = 0; i < length; ++i)
{
fieldNames[i] = reader.GetName(i);
}
_fieldNames = fieldNames;
}
示例12: EFCachingDataReaderCacheWriter
/// <summary>
/// Initializes a new instance of the EFCachingDataReaderCacheWriter class.
/// </summary>
/// <param name="wrappedReader">The wrapped reader.</param>
/// <param name="maxRows">The maximum number of rows which can be cached.</param>
/// <param name="addToCache">The delegate used to add the result to the cache when the reader finishes.</param>
public EFCachingDataReaderCacheWriter(DbDataReader wrappedReader, int maxRows, Action<DbQueryResults> addToCache)
{
this.wrappedReader = wrappedReader;
this.addToCache = addToCache;
this.maxRows = maxRows;
for (int i = 0; i < wrappedReader.FieldCount; ++i)
{
this.queryResults.ColumnNames.Add(wrappedReader.GetName(i));
}
}
示例13: FieldNameLookup
public FieldNameLookup(DbDataReader reader, int defaultLocaleID)
{
int length = reader.FieldCount;
string[] fieldNames = new string[length];
for (int i = 0; i < length; ++i)
{
fieldNames[i] = reader.GetName(i);
}
_fieldNames = fieldNames;
_defaultLocaleID = defaultLocaleID;
}
示例14: CreateTable
public static DataTable CreateTable(DbDataReader reader)
{
DataTable table = new DataTable();
for (int i = 0; i < reader.FieldCount; i++)
{
DataColumn column = new DataColumn(reader.GetName(i), reader.GetFieldType(i));
table.Columns.Add(column);
}
table.AcceptChanges();
return table;
}
示例15: ExportExcel
public static void ExportExcel(DbDataReader dataReader, string strTitle, string fileFullPath, bool isAutoFit)
{
Workbook workbook = new Workbook();
workbook.Worksheets.Add();
object[] header = new object[dataReader.FieldCount];
bool first = true;
int rowIndex = 0;
Style style = new Style();
while (dataReader.Read())
{
for (int i = 0; i < dataReader.FieldCount; i++)
{
if (first)
{
style.Custom = "@";
style.Font.IsBold = true;
workbook.Worksheets[0].Cells[rowIndex, i].SetStyle(style);
workbook.Worksheets[0].Cells[rowIndex, i].Value = dataReader.GetName(i);
}
style.Font.IsBold = false; if (dataReader[i] is string)
{
style.Custom = "@";
}
else if (dataReader[i] is DateTime)
{
style.Custom = "yyyy-MM-dd";
}
else if (dataReader[i] is decimal)
{
style.Custom = "####.#####";
style.ShrinkToFit = true;
}
workbook.Worksheets[0].Cells[rowIndex + 1, i].SetStyle(style);
workbook.Worksheets[0].Cells[rowIndex + 1, i].Value = dataReader[i];
}
first = false;
rowIndex++;
}
if (isAutoFit)
{
workbook.Worksheets[0].AutoFitColumns();
workbook.Worksheets[0].AutoFitRows(true);
}
if (fileFullPath.ToLower().EndsWith(".xlsx"))
workbook.Save(fileFullPath, FileFormatType.Excel2007Xlsx);
else
workbook.Save(fileFullPath, FileFormatType.Default);
}