生成自己想要的sql语句

 System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection();
        con.ConnectionString="Data Source=1111111;Initial Catalog=1111111;Persist Security Info=True;User ID=sa;Password=sa";
        con.Open();
        System.Data.SqlClient.SqlDataAdapter adp = new System.Data.SqlClient.SqlDataAdapter(string.Format("EXEC sp_columns @table_name='order'"), con);
        DataTable dt=new DataTable() ;
        adp.Fill(dt);

        foreach (DataRow row in dt.Rows)
        {
            Response.Write(string.Format("[Order].[{0}],",row["COLUMN_NAME"]));
        }