Get Values from DataTable by row and column name
smr5
I'm typically used to traditional table in SQL where I have multiple columns with rows populated. I execute a stored procedure and store all the data in DataTable and loop through the table to get the results I need. For example,
public static DataTable getInfo (string sessionID)
{
try
{
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["SandBox"].ConnectionString);
SqlCommand cmd = new SqlCommand("GetSessionInfo", conn);
cmd.Parameters.AddWithValue("SessionGUID", sessionID);
cmd.CommandType = CommandType.StoredProcedure;
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
return dt;
}
catch (Exception)
{
throw;
}
}
I would load the DataTable:
DataTable infoTbl = new DataTable();
infoTbl = getInfo(lbldatabasesessionID.Text);
And I would use foreach loop to loop through the DataTable.
foreach (DataRow row in infoTbl.Rows)
{
string x = col.ToString();
}
The issue I run into is the database guy gave me a stored procedure that returns a different output (different from what I'm used to). It's a row based.
The only way I can access for example the First Name is if I hard code the position like:
string firstName = infoTbl.Rows[16][2].ToString();
I don't feel comfortable doing this since the position could potentially change. How would I access ElementValue by knowing the name knowing ElementType and ElementName?
Any suggestions?
Mike Burdick
Using DataSet:
string firstName = string.Empty;
DataRow row = table.Select("ElementType = 'Demographics' AND ElementName = 'FirstName'").FirstOrDefault();
if (row != null)
{
firstName = (string)row["ElementValue"];
}
Using Linq:
string firstName = table.AsEnumerable()
.Where(f => f.Field<string>("ElementType") == "Demographics" &&
f.Field<string>("ElementName") == "FirstName")
.Select(f => f.Field<string>("ElementValue")).FirstOrDefault();
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Current ES6 module syntax
- Next: Opencv3.0.0 beta , building from source do not include ml package And The dlls sizes are different
Related
Related Related
- 1
datatable get specific column from row
- 2
Get MAX from row with column name (SQL)
- 3
WPF: Get column name from selected row
- 4
How to get name of datatable column?
- 5
How to get list of one column values from DataTable?
- 6
Get distinct values from a column of DataTable in .NET 2.0
- 7
How to get list of one column values from DataTable?
- 8
How to get values in a column of a DataTable?
- 9
R: Get column name based on row values in R
- 10
How to store column name as first row in datatable?
- 11
Mark Selected Datatable Row based on Column Values
- 12
How to get a subset DataTable from another DataTable filtered by few column values?
- 13
How to get a subset DataTable from another DataTable filtered by few column values?
- 14
Get specific value from table with table name, row and column index
- 15
Copy DataTable Column's values into another DataTable row C#
- 16
Get specific column foreach row in DataTable
- 17
sql query get multiple values from same column for one row
- 18
SQL query to get computed values from the same column in one row
- 19
Remove row from datatable if column is not numeric
- 20
Get values from SQL table along with column name as list in Python
- 21
Get values from SQL table along with column name as list in Python
- 22
extract values from DataTable with single row
- 23
C# - How can i get header row from datatable and arrange it vertically down a column?
- 24
Pandas check row list values with column name
- 25
count row values as column name mysql
- 26
Replacing row values by column name in R
- 27
Sql mapping with column name and first row values
- 28
Sql mapping with column name and first row values
- 29
Get Selected Row From DataTable in Shiny App
Comments