{filelink=16139}

using System;
using System.Data;
using System.Data.SqlClient;
namespace Base_de_Données
{

public class MetaData
{    

    public static DataSet GetTableSchema(string nomTable)
  {
    String chaineConnexion = "server=(local);database=MesExemples.com;Integrated Security=SSPI";
    string query = string.Format("SELECT  * FROM {0}", nomTable);

    using (SqlConnection localSqlConn = new SqlConnection(chaineConnexion))
    {
        DataSet ds = new DataSet();

        SqlCommand sqlCmd = new SqlCommand(query, localSqlConn);
        SqlDataAdapter AdaptateurSQL = new SqlDataAdapter(sqlCmd);

        AdaptateurSQL.FillSchema(ds, SchemaType.Source, nomTable);
        AdaptateurSQL.Fill(ds, nomTable);

        AdaptateurSQL.Dispose();

        return ds;
    }
    }
  }

 }