<div>
Even a DataAdapter and DataSet may be a bit overkill. If you're just reading the data and not updating it, a DataReader should do the job.<br />
<br />
string col1, col2, col3;<br />
SqlCommand cmd = new SqlCommand(&quot;storedProcedur<wbr />e&quot;, connectionObject);<br />
cmd.CommandType = CommandType.StoredProcedur<wbr />e;<br />
connectionObject.Open();<br />
SqlDataReader dr = cmd.ExecuteReader();<br />
dr.Read();<br />
col1 = dr.GetString(0);<br />
col2 = dr.GetString(1);<br />
col3 = dr.GetString(2);<br />
dr.Close();<br />
connectionObject.Close();
</div>


Even a DataAdapter and DataSet may be a bit overkill. If you're just reading the data and not updating it, a DataReader should do the job.

string col1, col2, col3;
SqlCommand cmd = new SqlCommand("storedProcedure", connectionObject);
cmd.CommandType = CommandType.StoredProcedure;
connectionObject.Open();
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
col1 = dr.GetString(0);
col2 = dr.GetString(1);
col3 = dr.GetString(2);
dr.Close();
connectionObject.Close();

<div>
check<br />
<a href="https://www.experts-exchange.com/questions/21079562/C-Accessing-single-row-within-recordset.html" rel="ugc">https://www.experts-exchange.com/questions/21079562/C-Accessing-single-row-within-recordset.html</a><br />

</div>


check
https://www.experts-exchange.com/questions/21079562/C-Accessing-single-row-within-recordset.html [https://www.experts-exchange.com/questions/21079562/C-Accessing-single-row-within-recordset.html]


<div>
Anytime. Glad to help.<br />
<br />
Cheers,<br />
<br />
Greg
</div>


<div>
<div class="content wysiwyg-content">
Hi, if I have a stored procedure that when executed will return one row, with three columns, what is the best way to get the data from this. At the mo I have a sqldataadapter filling a dataset, but ho do I get the data from there, I want three vars say v1,v2 and v3 to be populated with the string vals in the row?<br />
<br />
Thanks Kieran.<br />

</div>
</div>


Hi, if I have a stored procedure that when executed will return one row, with three columns, what is the best way to get the data from this. At the mo I have a sqldataadapter filling a dataset, but ho do I get the data from there, I want three vars say v1,v2 and v3 to be populated with the string vals in the row?

Thanks Kieran.


Best way to get a single row

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).