Ejemplo n.º 1
0
 internal void GetSqlSpInfo()
 {
     SqlCommand selectCommand = new SqlCommand("sp_stored_procedures", this.SqlConn);
     selectCommand.CommandType = CommandType.StoredProcedure;
     DataSet dataSet = new DataSet();
     new SqlDataAdapter(selectCommand).Fill(dataSet, "StoredProcs");
     this.m_StoredProcs = new SqlSpInfoArray();
     foreach (DataRow row in dataSet.Tables[0].Rows)
     {
       SqlSpInfo sqlSpInfo = new SqlSpInfo(this, row);
       this.m_StoredProcs.Add(sqlSpInfo);
     }
 }
Ejemplo n.º 2
0
 public void Reload()
 {
     this.m_AllTables = null;
     this.m_SystemTables = null;
     this.m_UserTables = null;
     this.m_Views = null;
     this.m_StoredProcs = null;
 }