Total number of columns in current row

Question

How can I get the total number of columns in the current row of a SqlDataReader instance?

MuthuMari M · Answer

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 "

Senthilkumar · Answer

Hi Richa, There is an property called FieldCount, which gets the number of columns in the current row. SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Proc_RetrieveEmployees"; SqlDataReader reader = cmd.ExecuteReader(); while(reader.Read()) { int columns = reader.FieldCount; } Hope this will help you.

Ilkin East · Answer

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

Vulpes · Answer

You can use the FieldCount property: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.fieldcount.aspx