Can I transmit data from Database to List<>?

[meomap0z1]

Firstly, I connect Database and I wanna transmit data to my public List<Product> GetProductList. Can I do this?

public DataTable GetBooks()
        {
            string SQL = "Select * From Products";
            SqlConnection cnn = new SqlConnection(strConnection);
            SqlCommand cmd = new SqlCommand(SQL, cnn);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dtProduct = new DataTable();
            try
            {
                if (cnn.State == ConnectionState.Closed)
                {
                    cnn.Open();
                }
                da.Fill(dtProduct);
            }
            catch (SqlException se)
            {
                throw new Exception(se.Message);
            }
            finally
            {
                cnn.Close();
 
            }
            return dtProduct;
        }
 

Have a nice day, guys.

[AjayGohil]

Hi meomap0z1,

Yes,you can pass data from database to List.

Firstly create a list and fetch data from row of dataTable and store it through Add command which store data in List.

Add Following code to your program.

List<Product> GetProductList =new List<Product>();
    foreach (GetProductList  p in dtProduct.Rows)
    {
            GetProductList .Add(p);
    }

and you can also use