private string GetColumnList(string connectionString, string tableName)
{
SqlConnection connection = null;
try
{
connection = new SqlConnection(connectionString);
connection.Open();
var adpater = new SqlDataAdapter("select C.name as columnname from sys.columns C inner join sys.objects O ON C.object_id = O.object_id where O.name = '" + tableName + "' order by C.column_id", connection);
DataSet ds = new DataSet();
adpater.Fill(ds);
var l = new List<string>();
foreach (DataRow row in ds.Tables[0].Rows)
{
l.Add((string)row[0]);
}
return string.Join(", ", l.ToArray());
}
catch (Exception ex)
{
}
finally
{
if (connection != null)
connection.Close();
}
return string.Empty;
}