예제 #1
0
        private string LoadObjectDetail(string ConnectionString, string DBName, string DBOwner, string ObjectName)
        {
            string DateModified = string.Empty;

            try
            {
                using (DataStuff sn = new DataStuff())
                {
                    DataTable dt = sn.GetObjectDetail(ConnectionString, DBName, DBOwner, ObjectName);

                    if (dt.Rows.Count > 0)
                    {
                        foreach (DataRow row in dt.Rows)
                        {
                            DateModified = row["modify_date"].ToString();
                        }
                    }
                    else
                    {
                        DateModified = "";
                    }
                }

                return(DateModified);
            }

            catch
            {
                return("");
            }
        }
예제 #2
0
        private void LoadObjectDetail()
        {
            try
            {
                using (DataStuff sn = new DataStuff())
                {
                    DataTable dt = sn.GetObjectDetail(ConnectionString, DatabaseName, DBOwner, ObjectName);

                    if (dt.Rows.Count > 0)
                    {
                        foreach (DataRow row in dt.Rows)
                        {
                            tDateCreated.Text  = row["create_date"].ToString();
                            tDateModified.Text = row["modify_date"].ToString();
                        }

                        if (ModifiedDateChanged != null)
                        {
                            ModifiedDate = tDateModified.Text;
                            ModifiedDateChanged(this, null);
                        }

                        if (CreateDateChanged != null)
                        {
                            CreateDate = tDateCreated.Text;
                            CreateDateChanged(this, null);
                        }
                    }
                    else
                    {
                        tDateCreated.Text  = "Not Found";
                        tDateModified.Text = "";
                    }
                }
            }

            catch
            {
            }
        }