public static void GetPlusInformation(string tablename, string columnname, ref string labelName, ref bool isSearch, ref int searchPosition, ref bool isDetail, ref int detailPosition)
{
SQLBaseDataReader reader = GetReaderInformationPlus(tablename, columnname);
string information = string.Empty;
if (reader != null)
{
while (reader.Read())
{
information = reader["DescriptionPlus"].ToString().Trim();
if (information.Equals(string.Empty))
{
if (information.IndexOf("*") != -1)
{
}
else
{
columnname = reader["DescriptionPlus"].ToString();
}
}
else
{
labelName = information;
labelName = columnname;
}
}
reader.Close();
}
}
private static SQLBaseDataReader GetReaderInformationPlus(string tableName, string columnName)
{
string sqlDatabase = string.Format("SELECT value as DescriptionPlus FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', '{0}', 'column', '{1}')", tableName, columnName);
SQLBaseConnection connection = new SQLBaseConnection(Session.ConnectionString);
try
{
if (connection == null)
{
return(null);
}
SQLBaseDataReader dr = SqlHelperSqlBase.ExecuteReader(connection, CommandType.Text, sqlDatabase);
// if (dr.HasRows)
// return dr;
// else
return(null);
}
catch
{
return(null);
}
}
public static ArrayList GetSchemaWebControls(SQLBaseDataReader dr)
{
ArrayList lobjTables = new ArrayList();
ArrayList tables = new ArrayList();
if (dr != null)
{
string oldTableName = string.Empty;
DataTable table = GetDatatableSchemaPlus();
int j = 0;
while (dr.Read())
{
if (!dr.GetString(0).Equals("dtproperties"))
{
string newTableName = dr.GetString(0);
string columnsName = dr.GetString(1);
int columnsMaxLength = dr[3].ToString().Equals(string.Empty) ? 0 : Int32.Parse(dr[3].ToString());
bool columnsNullable = dr.GetString(4).ToUpper().Equals("YES") ? true : false;
string columnsType = GetSqlBaseType(columnsName, dr.GetString(2), columnsMaxLength, columnsNullable);
string columnsDBType = dr.GetString(2);
string labelName = string.Empty;
bool isSearch = false;
int searchPosition = 0;
bool isDetail = false;
int detailPosition = 0;
if (oldTableName != newTableName)
{
if (oldTableName != string.Empty)
{
tables.Add(table);
j++;
table = GetDatatableSchemaWebControls();
}
}
GetPlusInformation(newTableName, columnsName, ref labelName, ref isSearch, ref searchPosition, ref isDetail, ref detailPosition);
DataRow row = table.NewRow();
row["Name"] = columnsName;
row["Type"] = columnsType;
row["DbType"] = columnsDBType;
row["Length"] = columnsMaxLength;
row["Nullable"] = columnsNullable;
row["LabelName"] = labelName;
row["isSearch"] = isSearch;
row["SearchPosition"] = searchPosition;
row["isDetail"] = isSearch;
row["DetailPosition"] = searchPosition;
row["Table"] = newTableName;
table.Rows.Add(row);
oldTableName = newTableName;
}
}
tables.Add(table);
return(tables);
}
return(null);
}