コード例 #1
0
 public static ConnSingleton getDbInstance()
 {
     if (dbInstance == null)
     {
         dbInstance = new ConnSingleton();
     }
     return(dbInstance);
 }
コード例 #2
0
        public override void display(DataGridView dv)
        {
            ConnSingleton cs  = ConnSingleton.getDbInstance();
            SqlCommand    cmd = new SqlCommand("Select * from patient_ ORDER BY Name", cs.GetDBConnection());

            cmd.CommandType = CommandType.Text;
            SqlDataReader reader = cmd.ExecuteReader();
            DataTable     info   = new DataTable();

            info.Columns.Add("ID");
            info.Columns.Add("Name");
            info.Columns.Add("Address");
            info.Columns.Add("Age");
            info.Columns.Add("sex");
            info.Columns.Add("Date");

            info.Columns.Add("Doctor_Name");
            info.Columns.Add("Disease_description");
            info.Columns.Add("Room_Number");

            DataRow row;

            while (reader.Read())
            {
                if (reader["Room_Number"].ToString() != "NULL      ")
                {
                    row                        = info.NewRow();
                    row["ID"]                  = reader["ID"];
                    row["Name"]                = reader["Name"];
                    row["Address"]             = reader["Address"];
                    row["Age"]                 = reader["Age"];
                    row["sex"]                 = reader["Sex"];
                    row["Doctor_Name"]         = reader["Doctor_Name"];
                    row["Disease_description"] = reader["Disease_description"];
                    row["Date"]                = reader["Date"];
                    row["Room_Number"]         = reader["Room_Number"];

                    info.Rows.Add(row);
                }
            }
            reader.Close();
            cs.CloseConnection();
            dv.DataSource = info;// <-------
        }