Total number of columns in current row

Hi,

use fieldcount property.

private void orderIDsList_SelectedIndexChanged
                   (object sender, System.EventArgs e)
        {
                SqlCommand storedProcCommand =
               new SqlCommand ("CustOrdersDetail", con);
           
            storedProcCommand.CommandType = CommandType.StoredProcedure;
           
            storedProcCommand.Parameters.Add("@OrderID",orderID);
           
            con.Open ();
           
            ArrayList rowList = new ArrayList();
          
            SqlDataReader reader = storedProcCommand.ExecuteReader();

            while (reader.Read())
            {
                // Create an array big enough to hold the column values
                object[] values = new object[reader.FieldCount];

                // Get the column values into the array
                reader.GetValues(values);

                // Add the array to the ArrayList
                rowList.Add(values);
        }
}

if you want more pls visit this url

http://www.akadia.com/services/dotnet_data_reader.html

thanks.

	If this post is useful then mark it as "Accepted Answer"

Hi Richa,

There is an property called FieldCount, which gets the number of columns in the current row.

Hello,
You can do your problem with below code.

DataTable dt = new DataTable();
dt.Columns.Add("Test", typeof(String));
dt.Rows.Add(10);
dt.Rows.Add(20);
dt.Rows.Add(30);

// Loop
int sum = 0;
foreach (DataRow dr in dt.Rows)
{
if (dr.RowState != DataRowState.Deleted)
sum += Convert.ToInt32(dr["Test"]);
}
Console.WriteLine("Sum is {0}.", sum); // Prints 60

Thanks

You can use the FieldCount property:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.fieldcount.aspx