我如何从数据集中仅向前读取流数据 [英] how do i read forward stream only data from a datset

问题描述

我想将输入的数据集用作应用程序的主要数据源.有点像断开连接的数据源.有了这个，我想从该数据集中读取数据到文本框和其他控件中.

i want to use my typed dataset as a the main datasource for the application. Sort of like a disconnected datasource. With this in place i want to read data from this dataset into text boxes and other controls.

推荐答案

SADS = StockManager.StockFindSymbol(Symbol.Text).DataSet;
GridStock.DataSource = SADS;
GridStock.DataBind();
Symbol.Text ="
/***************
公共静态数据表StockFindSymbol(string sasymbol)
{
返回StockDBManager.StockFindSymbol(sasymbol);
}

/*********

公共静态数据表StockFindSymbol(string sasymbol)
{
OracleCommand SACommand = SADataHelper.CreateCommand();
//打开连接

SACommand.CommandText ="SA_FIND_STOCKP.SAFINDSYMBOL";
SACommand.Connection.Open();
SACommand.Parameters.Add("sasymbol"，OracleDbType.Varchar2，55).Value = sasymbol;
SACommand.Parameters.Add("sa_errorcode"，OracleDbType.Int16，0，ParameterDirection.Output);
SACommand.Parameters.Add("sa_cursor"，OracleDbType.RefCursor，ParameterDirection.Output);

DataSet ds = new DataSet();
OracleDataAdapter da =新的OracleDataAdapter(SACommand);
da.Fill(ds);
SACommand.Connection.Close();
返回ds.Tables [0];
}

/**************
如果(SADS.Tables [0] .Rows.Count> 0)
{
sasymbol = SADS.Tables [0] .Rows [0] .ItemArray [1] .ToString();
saexch = SADS.Tables [0] .Rows [0] .ItemArray [2] .ToString();

?????????
这就是您要找的东西吗?
如果是这样
问题
SADS.Tables [0] .Rows [0] .ItemArray [1] .ToString()=值;
这不会更新数据集.

表格[0].行[0] .ItemArray [1] .ToString()

SADS = StockManager.StockFindSymbol(Symbol.Text).DataSet;
GridStock.DataSource = SADS;
GridStock.DataBind();
Symbol.Text = ""
/***************
public static DataTable StockFindSymbol(string sasymbol)
{
return StockDBManager.StockFindSymbol(sasymbol);
}

/*********

public static DataTable StockFindSymbol(string sasymbol)
{
OracleCommand SACommand = SADataHelper.CreateCommand();
// open connection

SACommand.CommandText = "SA_FIND_STOCKP.SAFINDSYMBOL";
SACommand.Connection.Open();
SACommand.Parameters.Add("sasymbol", OracleDbType.Varchar2, 55).Value = sasymbol;
SACommand.Parameters.Add("sa_errorcode", OracleDbType.Int16, 0, ParameterDirection.Output);
SACommand.Parameters.Add("sa_cursor", OracleDbType.RefCursor, ParameterDirection.Output);

DataSet ds = new DataSet();
OracleDataAdapter da = new OracleDataAdapter(SACommand);
da.Fill(ds);
SACommand.Connection.Close();
return ds.Tables[0];
}

/**************
if (SADS.Tables[0].Rows.Count > 0)
{
sasymbol = SADS.Tables[0].Rows[0].ItemArray[1].ToString();
saexch = SADS.Tables[0].Rows[0].ItemArray[2].ToString();

?????????
is this what you were looking for?
if so
Problem
SADS.Tables[0].Rows[0].ItemArray[1].ToString() = value;
this will not update the dataset.

Tables[0].Rows[0].ItemArray[1].ToString()

这篇关于我如何从数据集中仅向前读取流数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！