Dataset finding and value assign

[Wilson Wu]

Hi,

How can I find the field value in the dataset and then assign one of the
field value to a variable ?

Thanks
Wilson

[Nicholas Paldino [.NET/C# MVP]]

Wilson,

Well, if you have a dataset, there are a few pieces of information you
need to know:

- The name of the table
- Which row the data is in
- Which column the data is in

If you know that, you can get/set the information like this:

// Assume pobjDataSet is the data set.
pobjDataSet.Tables[<table name or index>].Rows[<row index>][<column name or
index>] = <value>;

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Wilson Wu" <wi******@myrealbox.com> wrote in message
news:en**************@TK2MSFTNGP11.phx.gbl...

Hi,

How can I find the field value in the dataset and then assign one of the
field value to a variable ?

Thanks
Wilson

[Nicholas Paldino [.NET/C# MVP]]

Wilson,

Well, if you have a dataset, there are a few pieces of information you
need to know:

- The name of the table
- Which row the data is in
- Which column the data is in

If you know that, you can get/set the information like this:

// Assume pobjDataSet is the data set.
pobjDataSet.Tables[<table name or index>].Rows[<row index>][<column name or
index>] = <value>;

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Wilson Wu" <wi******@myrealbox.com> wrote in message
news:en**************@TK2MSFTNGP11.phx.gbl...

Hi,

How can I find the field value in the dataset and then assign one of the
field value to a variable ?

Thanks
Wilson

[Wilson Wu]

Hi,

I cannot read the value from the cell. Pls help.
The program should read data from an XML file(without schema) and find value
from one cell.

Here is my code :

DataSet dsLogon = new DataSet();
dsLogon.ReadXML(Server.MapPath("XMLFile.XML");

DataView dvServer = new DataView(dsLogon.Tables["Server"];
dvServer.Sort = "Name";
dvServer.RowFilter = "Name = '" + this.Server.Text + "'";

this.AppHost = dvServer.Table.Rows["ServerIP"].ToString();
Thanks
Wilson


"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:uT**************@TK2MSFTNGP11.phx.gbl...

Wilson,

Well, if you have a dataset, there are a few pieces of information you
need to know:

- The name of the table
- Which row the data is in
- Which column the data is in

If you know that, you can get/set the information like this:

// Assume pobjDataSet is the data set.
pobjDataSet.Tables[<table name or index>].Rows[<row index>][<column name or index>] = <value>;

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Wilson Wu" <wi******@myrealbox.com> wrote in message
news:en**************@TK2MSFTNGP11.phx.gbl...

Hi,

How can I find the field value in the dataset and then assign one of the
field value to a variable ?

Thanks
Wilson