C#

Mody_2004 wrote:

I want open-source project to manage super market .
Is there any one help me?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Member 11567959 wrote:

please help me

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand cmd = new SqlCommand("SELECT Id, description FROM myTable", con))
        {
        using (SqlDataReader reader = cmd.ExecuteReader())
            {
            while (reader.Read())
                {
                int id = (int) reader["Id"];
                string desc = (string) reader["description"];
                Console.WriteLine("ID: {0}\n    {1}", id, desc);
                }
            }
        }
    }

public abstract class Car
    {
    public int InCar { get; set; }
    }
public class Porche : Car
    {
    public string InPorche { get; set; }
    }
public class Toyota: Car
    {
    public int InToyota { get; set; }
    }

Porche p = new Porche();
p.InCar = 111;
p.InPorche = "ppp";
Toyota t = new Toyota();
t.InCar = 222;
t.InToyota = 666;
List<Car> cars = new List<Car>() { p, t };
JsonSerializerSettings settings = new JsonSerializerSettings { TypeNameHandling = TypeNameHandling.All };
string json = JsonConvert.SerializeObject(cars, settings);
List<Car> result =JsonConvert.DeserializeObject<List<Car>>(json, settings);

devvvy wrote:

var carTypes = (from type in types
                where type.IsClass && type == typeof(Car)
                select type);

var carTypes = (from type in types
                where type.IsClass && !type.IsAbstract && type.IsAssignableFrom(typeof(Car))
                select type);

var listType = typeof(List<>).MakeGenericType(carType);
var cars = (IReadOnlyList<Car>)Newtonsoft.Json.JsonConvert.DeserializeObject(json, listType);