Beispiel #1
0
        private mytable GetTable(string table)
        {
            mytable       mtable = new mytable(table);
            SqlConnection conn   = new SqlConnection("Server=dmmlenovo1;Database=TheSingingClub;Integrated Security=true");
            SqlCommand    cmd    = conn.CreateCommand();

            cmd.CommandType = System.Data.CommandType.Text;
            cmd.CommandText = "Select COLUMN_NAME, DATA_TYPE from information_schema.COLUMNS where Table_name = '" + table + "' FOR XML Path('Data'), ROOT('Root')";

            conn.Open();
            SqlDataReader sdr = cmd.ExecuteReader();

            while (sdr.Read())
            {
                object o = sdr.GetValue(0);
                if (o != null)
                {
                    mtable.xml_column += o.ToString();
                }
            }

            conn.Close();
            cmd.CommandText = "Select COLUMN_NAME from information_schema.KEY_COLUMN_USAGE where Table_name = '" + table + "' FOR XML Path('Data'), ROOT('Root')";
            conn.Open();
            sdr = cmd.ExecuteReader();
            while (sdr.Read())
            {
                object o = sdr.GetValue(0);
                if (o != null)
                {
                    mtable.xml_index += o.ToString();
                }
            }
            conn.Close();
            return(mtable);
        }