Do you really need a list, or would IEnumerable be good enough? I know you want it to be generic, but a much more common pattern is to have a static Factory method on the target object type that accepts a datarow (or IDataRecord). That would look something like this: public class Employee { public … Read more
Try as given below: while (MyReader.Read()) { TextBox1.Text = Convert.ToDateTime(MyReader[“DateField”]).ToString(“dd/MM/yyyy”); } in ToString() method you can change data format as per your requirement.
The shortest (IMHO) is: int stockvalue = (reader[“StockValue”] as int?) ?? 0; Explanation: If reader[“StockValue”] is of type int, the value will be returned, and the “??” operator will return the result If reader[“StockValue”] is NOT of type int (e.g. DBNull), null will be returned, and the “??” operator will return the value 0 (zero).
Try this because this will close connection ,data reader and command once task get over , so that this will not give datareader close exception Also do check like this if(reader.NextResult()) to check there is next result, using (SqlConnection connection = new SqlConnection(“connection string here”)) { using (SqlCommand command = new SqlCommand (“SELECT Column1 FROM … Read more
I would suggest writing an extension method for this: public static IEnumerable<T> Select<T>(this IDataReader reader, Func<IDataReader, T> projection) { while (reader.Read()) { yield return projection(reader); } } You can then use LINQ’s ToList() method to convert that into a List<T> if you want, like this: using (IDataReader reader = …) { List<Customer> customers = reader.Select(r … Read more