SqldataReader get row count

// Namespaces, variables, and constants
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

// . . . 

// Batch query to retrieve the COUNT of records and
// all of the records in the Orders table as two result sets.
String sqlText = "SELECT COUNT(*) FROM Orders; " +
 "SELECT * FROM Orders;";

// Create the connection.
SqlConnection conn = new SqlConnection(
 ConfigurationSettings.AppSettings["Sql_ConnectString"]);
SqlCommand cmd = new SqlCommand(sqlText, conn);
conn.Open( );

// Create a DataReader on the first result set.
SqlDataReader dr = cmd.ExecuteReader( );
// Get the count of records from the select count(*) statement.
dr.Read( );
resultTextBox.Text = "Orders table record count, using COUNT(*)= " +
 dr.GetInt32(0) + Environment.NewLine;

// Move to the data result set.
dr.NextResult( );
int count = 0;
// Iterate over the records in the DataReader.
while(dr.Read( ))
{
 count++;

 // . . . Do something interesting with the data here.
}

// Close the DataReader and the connection.
dr.Close( );

resultTextBox.Text += "Orders table record count, " +
 "iterating over result set = " + count +
 Environment.NewLine;

// Create the stored procedure to use in the DataReader.
cmd = new SqlCommand("SP0207_GetOrders", conn);
cmd.CommandType = CommandType.StoredProcedure;
// Create the output paramter to return @@ROWCOUNT.
cmd.Parameters.Add("@RowCount", SqlDbType.Int).Direction =
 ParameterDirection.Output;

// Create a DataReader for the result set returned by
// the stored procedure.
dr = cmd.ExecuteReader( );

// . . . Process the data in the DataReader.

// Close the DataReader.
dr.Close( );
// The output parameter containing the row count is now available.

resultTextBox.Text += "Orders table record count, " +
 "returning @@ROWCOUNT from stored procedure = " + cmd.Parameters["@RowCount"].Value;

conn.Close( );

Source: flylib.com

Similar codes

0 vote191 views1 answer
C# usermanager update user
C#
10 votes193 views1 answer
Set width of rect transform unity
C#
0 vote197 views1 answer
Textbox gotfocus wpf
C#
0 vote190 views1 answer
Conncet oracle database in c# visual studio
C#
0 vote187 views1 answer
System.InvalidOperationException: The AuthorizationPolicy named: 'View All Roles' was not found.
C#
1 vote264 views1 answer
How to convert nullable datetime datarow to datetime in c#
C#
0 vote191 views2 answers
RadioButton IsChecked mapped to ENum xmal
C#
3 votes208 views2 answers
Unity Make a 2D object look at the mouse position
C#
2 votes182 views1 answer
Pass parameter to thread c#
C#
0 vote287 views1 answer
'Using a Hub instance not created by the HubPipeline is unsupported.'
C#