1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:

        public static Article GetArticleDetailsEdit(long ware)
        {
            Article myArticle = new Article();
            strSQl = "Select * from bestand where bestandid=?bestandid";

            using (MySqlConnection conn = new MySqlConnection(connStr))
            {
                using (MySqlCommand cmd = new MySqlCommand(strSQl, conn))
                {
                    conn.Open();

                    cmd.Parameters.AddWithValue("?bestandid", ware);

                    MySqlDataReader dr = cmd.ExecuteReader();

                    while (dr.Read())
                    {

                        myArticle.Id = dr.GetInt64("bestandid");
                        myArticle.Customer = dr.GetInt64("kundeid");
                        myArticle.CustomerTp = dr.GetInt64("kundetpid");
                        myArticle.CustomerUnit = dr.GetInt64("kundeunitid");
                        myArticle.CustomerCrap = dr.GetInt64("schrottartid");
                        myArticle.Container = dr.GetInt64("behaelterid");
                        myArticle.ContainerNumber = Convert.ToString(dr["behaelternummer"]);
                        myArticle.CrapBrutto = Convert.ToDecimal(dr["bgewicht"]);
                        myArticle.CrapNetto = Convert.ToDecimal(dr["ngewicht"]);
                        myArticle.StockPlace = Convert.ToInt64(dr["lagerplatzid"]);
                        myArticle.CrapColor = dr.GetString("farbe");
                        //myArticle.ContainerWithout = Convert.ToInt64(dr["behaelterohneid"]);
                        myArticle.ContainerWithout = dr.GetInt64("behaelterohneid");
                    }

                    conn.Close();
                }
            }
            
            return myArticle;
        }                    

1:
2:

if(dr["schrottartid"] != DBNull.Value)
    myArticle.CustomerCrap = dr.GetInt64("schrottartid");