C#

public void getColumnNames(string col)<br />
    {<br />
        string constr = System.Configuration.ConfigurationManager.AppSettings["conskypak"];<br />
        String cmdstr = "SELECT columnname FROM TableDescription where RecordCode=' " + col + " ' ";<br />
        SqlConnection cn = new SqlConnection(constr);<br />
        SqlCommand cmd = new SqlCommand(cmdstr,cn);<br />
        SqlDataReader dr;<br />
        cn.Open();<br />
        dr = cmd.ExecuteReader();<br />
        while (!dr.Read())<br />
        {<br />
            string name = "";<br />
            name =(string)dr[0];<br />
        }<br />
        cn.Close();<br />
<br />
<br />
    }